oracle-12c-rac 报:ORA-01078

OS:

Oracle Linux Server release 5.7

 

DB:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/inityoon1.ora'

 

1、到/u01/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/

[root@rac1 ~]#cd /u01/oracle/app/oracle/product/11.2.0/dbhome_1/dbs

[root@rac1 dbs]# ls
hc_yoon_1.dat hc_yoon_2.dat init.ora inityoon_1.ora

 

2、inityoon_1.ora和inityoon1.ora文件不同

 

3、查看SID:

[root@rac1 dbs]# su - oracle
[oracle@rac1 ~]$ more .bash_profile

ORACLE_BASE=/u01
ORACLE_HOME=/u01/oracle/app/oracle/product/11.2.0/dbhome_1
ORACLE_SID=yoon1


PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH:$HOME/bin

export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID

 

4、将ORACLE_SID=yoon1改成ORACLE_SID=yoon_1

 

5、启动数据库OK:

SQL> startup
ORACLE instance started.

Total System Global Area 1419685888 bytes
Fixed Size 2288344 bytes
Variable Size 536872232 bytes
Database Buffers 872415232 bytes
Redo Buffers 8110080 bytes
Database mounted.
Database opened.
SQL>

 

6、在oracle-11g-rac的SID设置yoon1没问题,在oracle-12c-rac中不行.

posted @ 2016-02-01 09:30  __Yoon  阅读(1124)  评论(0编辑  收藏  举报