SQL> conn sys/123456 as sysdba;
Connected to an idle instance.
SQL> startup;
ORA-00371: not enough shared pool memory, should be atleast 168530636 bytes
SQL> startup;
ORACLE instance started.
Total System Global Area 566231040 bytes
Fixed Size 2022112 bytes
Variable Size 528483616 bytes
Database Buffers 33554432 bytes
Redo Buffers 2170880 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> select name from v$controlfile;
no rows selected
SQL> alter system set control_files='/opt/oracle/oradata/ATYU30/control01.ctl',
2 '/opt/oracle/oradata/ATYU30/control02.ctl',
3 '/opt/oracle/oradata/ATYU30/control03.ctl'
4 scope=spfile;
alter system set control_files='/opt/oracle/oradata/ATYU30/control01.ctl',
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup
SQL> select name from v$controlfile;
no rows selected
SQL> quit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@wx_db_01 backup]$ ls
alert_ATYU30.log hc_ATYU30.dat init.ora lkATYU30 orapwATYU30 spfileATYU30.ora
hc_orcl.dat initdw.ora lkORCL orapworcl spfileorcl.ora
[oracle@wx_db_01 backup]$ vi init
[oracle@wx_db_01 backup]$ cd ..
[oracle@wx_db_01 dbs]$ vi initATYU30.ora
[oracle@wx_db_01 dbs]$ vi initATYU30.ora
[oracle@wx_db_01 dbs]$ !sql
sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 15 19:00:22 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/123456 as sysdba;
Connected.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00111: no closing quote for value '/opt/oracl'
SQL> quit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@wx_db_01 dbs]$ vi initATYU30.ora
[oracle@wx_db_01 dbs]$ !sql
sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 15 19:01:22 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/123456 as sysdba;
Connected.
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 566231040 bytes
Fixed Size 2022112 bytes
Variable Size 528483616 bytes
Database Buffers 33554432 bytes
Redo Buffers 2170880 bytes
ORA-00201: control file version 10.2.0.1.0 incompatible with ORACLE version
10.2.0.0.0
ORA-00202: control file: '/opt/oracle/oradata/ATYU30/control01.ctl'
SQL>
阅读(3651) | 评论(0) | 转发(0) |