今天刚到公司,有个网友发了ip与密码过来让我帮你启动数据库,进去后发现数据库安装的比较乱,启动数据库时报00201的错误,很久不摸这些安装方面的东西啦,有点生,忙完了一些例行工作,然后就静下心来测试,很快就启动数据库啦.
[oracle@rdas3 log]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.3.0 - Production on Tue Dec 6 10:37:26 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - ProductionWith the Partitioning, OLAP and Data Mining options
SQL> alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile;alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile*ERROR at line 1:ORA-32001: write to SPFILE requested but no SPFILE specified at startup
SQL> create spfile from pfile;
File created.
SQL> shutdown immediateORA-01507: database not mounted
ORACLE instance shut down.SQL> startupORACLE instance started.
Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesORA-00205: error in identifying controlfile, check alert log for more info
SQL> alter system set control_files='/opt/app/oracle/oradata/orcl/control01.ctl' scope=spfile;
System altered.
SQL> shutdown immediateORA-01507: database not mounted
ORACLE instance shut down.SQL> startupORACLE instance started.
Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesORA-00201: controlfile version 10.1.0.2.0 incompatible with ORACLE version10.0.0.0.0ORA-00202: controlfile: '/opt/app/oracle/oradata/orcl/control01.ctl'
SQL> show parameter com
NAME TYPE VALUE------------------------------------ ----------- ------------------------------commit_point_strength integer 1compatible string 10.0.0max_commit_propagation_delay integer 700nls_comp stringplsql_compiler_flags string INTERPRETED, NON_DEBUGplsql_v2_compatibility boolean FALSESQL> alter system set compatible='10.1.0.3.0' scope=spfile;
System altered.
SQL> shutdown immediateORA-01507: database not mounted
ORACLE instance shut down.SQL> startupORACLE instance started.
Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesORA-01103: database name 'ORCL' in controlfile is not 'DEFAULT'
SQL> oerr ora 1103SP2-0734: unknown command beginning "oerr ora 1..." - rest of line ignored.SQL> host oerr ora 110301103, 00000, "database name '%s' in controlfile is not '%s'"// *Cause: The database name in the controlfile does not match your// database name.// *Action: Either find the correct controlfile or change your database name.
SQL> show parameter db_name
NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_name string DEFAULTSQL> alter system set db_name=ORCL scope=spfile;
System altered.
SQL> alter database mount;alter database mount*ERROR at line 1:ORA-01103: database name 'ORCL' in controlfile is not 'DEFAULT'
SQL> shutdown immediateORA-01507: database not mounted
ORACLE instance shut down.SQL> startupORACLE instance started.
Total System Global Area 88080384 bytesFixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesDatabase mounted.Database opened.SQL> exit
FROM: http://xzh2000.itpub.net/post/96/47739
