5)建库后监听检查
$lsnrctl status
...
Services Summary...
Service "ORCL.LK" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCLXDB.LK" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully
实例应该被动态注册到监听程序了. 如果未被动态注册到监听程序, 则可以手工注册:
$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Sep 16 11:11:46 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL>alter system register;
6)改为归档模式并重启
$sqlplus/
as sysdba
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter database archivelog;
SQL> alter database flashback on;
(如果要启用数据库闪回功能则执行)
SQL>alter database open;
SQL>execute utl_recomp.recomp_serial();
(重新编译所有可能失效对象)
SQL>alter system archive log current;(手工归档测试)
到此建库完毕!
7)默认安装的数据库:
SQL>set lines 256 pages 500
SQL>select USER_ID,USERNAME,ACCOUNT_STATUS,DEFAULT_TABLESPACE from dba_users order by 1;
USER_ID USERNAME ACCOUNT_STATUS DEFAULT_TABLESPACE
---------- ------------------------------ -------------------------------- ------------------------------
0 SYS OPEN SYSTEM
5 SYSTEM OPEN SYSTEM
9 OUTLN EXPIRED & LOCKED SYSTEM
14 DIP EXPIRED & LOCKED USERS
21 ORACLE_OCM EXPIRED & LOCKED USERS
30 DBSNMP EXPIRED & LOCKED SYSAUX
31 APPQOSSYS EXPIRED & LOCKED SYSAUX
32 WMSYS EXPIRED & LOCKED SYSAUX
42 EXFSYS EXPIRED & LOCKED SYSAUX
43 CTXSYS EXPIRED & LOCKED SYSAUX
45 XDB EXPIRED & LOCKED SYSAUX
46 ANONYMOUS EXPIRED & LOCKED SYSAUX
53 ORDSYS EXPIRED & LOCKED SYSAUX
54 ORDDATA EXPIRED & LOCKED SYSAUX
55 ORDPLUGINS EXPIRED & LOCKED SYSAUX
56 SI_INFORMTN_SCHEMA EXPIRED & LOCKED SYSAUX
57 MDSYS EXPIRED & LOCKED SYSAUX
61 OLAPSYS EXPIRED & LOCKED SYSAUX
65 MDDATA EXPIRED & LOCKED USERS
67 SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED USERS
70 SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED USERS
72 SYSMAN EXPIRED & LOCKED SYSAUX
74 MGMT_VIEW EXPIRED & LOCKED SYSTEM
75 FLOWS_FILES EXPIRED & LOCKED SYSAUX
76 APEX_PUBLIC_USER EXPIRED & LOCKED USERS
78 APEX_030200 EXPIRED & LOCKED SYSAUX
79 OWBSYS EXPIRED & LOCKED SYSAUX
83 OWBSYS_AUDIT EXPIRED & LOCKED SYSAUX
84 SCOTT EXPIRED & LOCKED USERS
2147483638 XS$NULL EXPIRED & LOCKED USERS
30 rows selected.
8)默认安装的组件:
SQL>col COMP_ID format a8
col COMP_NAME format a35
col VERSION format a12
col schema format a12
col OTHER_SCHEMAS format a45
SQL>select comp_id,comp_name,version,schema,other_schemas from dba_registry order by 1;
COMP_ID COMP_NAME VERSION SCHEMA OTHER_SCHEMAS
-------- ----------------------------------- ------------ ------------ ---------------------------------------------
AMD OLAP Catalog 11.2.0.1.0 OLAPSYS
APEX Oracle Application Express 3.2.1.00.10 APEX_030200 FLOWS_FILES
APS OLAP Analytic Workspace 11.2.0.1.0 SYS
CATALOG Oracle Database Catalog Views 11.2.0.1.0 SYS
CATJAVA Oracle Database Java Packages 11.2.0.1.0 SYS
CATPROC Oracle Database Packages and Types 11.2.0.1.0 SYS APPQOSSYS,DBSNMP,DIP,ORACLE_OCM,OUTLN,SYSTEM
CONTEXT Oracle Text 11.2.0.1.0 CTXSYS
EM Oracle Enterprise Manager 11.2.0.1.0 SYSMAN
EXF Oracle Expression Filter 11.2.0.1.0 EXFSYS
JAVAVM JServer JAVA Virtual Machine 11.2.0.1.0 SYS
ORDIM Oracle Multimedia 11.2.0.1.0 ORDSYS MDSYS,ORDDATA,ORDPLUGINS,SI_INFORMTN_SCHEMA
OWB OWB 11.2.0.1.0 OWBSYS
OWM Oracle Workspace Manager 11.2.0.1.0 WMSYS
RUL Oracle Rules Manager 11.2.0.1.0 EXFSYS
SDO Spatial 11.2.0.1.0 MDSYS
XDB Oracle XML Database 11.2.0.1.0 XDB ANONYMOUS,XS$NULL
XML Oracle XDK 11.2.0.1.0 SYS
XOQ Oracle OLAP API 11.2.0.1.0 SYS
18 rows selected.
[本帖最后由 edeed 于 2009-9-17 18:29 编辑]