oralce 测试2

[oracle@demo ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 3 00:07:37 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/123456 as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0/db_1/dbs/initdbcl.ora'
SQL>

处理过程:
1.
[oracle@demo dbs]$ cd /opt/oracle/product/10.2.0/db_1/dbs/
[oracle@demo dbs]$ cp init.ora initdbcl.ora
[oracle@demo dbs]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 3 00:22:31 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/123456 as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
SQL>

2.没有足够的共享池,调整shared_spool_size 值
[oracle@demo dbs]$ vi initdbcl.ora
shared_pool_size = 90000000                                         # SMALL

SQL> startup;
ORACLE instance started.

Total System Global Area  125829120 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            4194304 bytes
Redo Buffers                2973696 bytes
ORA-00205: error in identifying control file, check alert log for more info


SQL>