本文共 3335 字，大约阅读时间需要 11 分钟。

今天刚到公司,有个网友发了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 immediate

ORA-01507: database not mounted

ORACLE instance shut down.SQL> startupORACLE instance started.

Total System Global Area 88080384 bytes

Fixed 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 immediate

ORA-01507: database not mounted

ORACLE instance shut down.SQL> startupORACLE instance started.

Total System Global Area 88080384 bytes

Fixed 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 immediate

ORA-01507: database not mounted

ORACLE instance shut down.SQL> startupORACLE instance started.

Total System Global Area 88080384 bytes

Fixed 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 bytes

Fixed Size 777812 bytesVariable Size 87040428 bytesDatabase Buffers 0 bytesRedo Buffers 262144 bytesDatabase mounted.Database opened.SQL> exit

 

FROM:

转载地址：http://lutai.baihongyu.com/