10gr1 ora-00201, ora-01103 error Solution

When I first arrived at the company today, a network friend sent an IP address and password to ask me to help you start the database. After going in, I found that the database was installed in a mess. When I started the database, I reported a 00201 error, I haven't touched on these installation things for a long time. I'm a little new. I 've been busy with some routine work, and I just got down and tested, so I started the database soon.

 

[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,200 4, Oracle. All rights reserved.

Connected:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0-Production
With 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> startup
Oracle instance started.

Total system global area 88080384 bytes
Fixed size 777812 bytes
Variable Size 87040428 bytes
Database buffers 0 bytes
Redo buffers 262144 bytes
ORA-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> startup
Oracle instance started.

Total system global area 88080384 bytes
Fixed size 777812 bytes
Variable Size 87040428 bytes
Database buffers 0 bytes
Redo buffers 262144 bytes
ORA-00201: controlfile version 10.1.0.2.0 incompatible with Oracle version
10.0.0.0.0
ORA-00202: controlfile: '/opt/APP/Oracle/oradata/orcl/control01.ctl'

SQL> show parameter com

Name type value
-----------------------------------------------------------------------------
Commit_point_strength integer 1
Compatible string 10.0.0
Max_commit_propagation_delay integer 700
Nls_comp string
Plsql_compiler_flags string interpreted, non_debug
Plsql_v2_compatibility Boolean false
SQL> 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> startup
Oracle instance started.

Total system global area 88080384 bytes
Fixed size 777812 bytes
Variable Size 87040428 bytes
Database buffers 0 bytes
Redo buffers 262144 bytes
ORA-01103: Database Name 'orcl 'in controlfile is not 'default'

SQL> oerr ora 1103
SP2-0734: Unknown command beginning "oerr ora 1..."-rest of line ignored.
SQL> host oerr ora 1103
01103,000 00, "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 default
SQL> 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 immediate
ORA-01507: Database not mounted

Oracle instance shut down.
SQL> startup
Oracle instance started.

Total system global area 88080384 bytes
Fixed size 777812 bytes
Variable Size 87040428 bytes
Database buffers 0 bytes
Redo buffers 262144 bytes
Database mounted.
Database opened.
SQL> exit

 

From: http://xzh2000.itpub.net/post/96/47739