奋战252

Total System Global Area  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 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/product/oradata/orcl/control01.ctl'

===================================
SQL> alter system set compatible='10.2.0.1.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  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/opt/oracle/product/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3

========================
root用户下：
  [root@localhost product]# chown -R oracle.oinstall /opt/oracle
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

SQL> shutdown immediate
ORA-01507: database not mounted

ORACLE instance shut down.
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
SQL> startup
ORACLE instance started.

Total System Global Area  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
ORA-01103: database name 'ORCL' in control file is not 'DEFAULT'
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      DEFAULT

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
SQL> alter system set db_name=ORCL 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  130023424 bytes
Fixed Size                  1218052 bytes
Variable Size             117443068 bytes
Database Buffers            8388608 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.

＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
SQL>

 

 

OK! Yeah!