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-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!