oracle-12c-rac 報:ORA-01078

haoge0205發表於2013-11-28

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.orainityoon1.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中不行.

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-1061470/,如需轉載,請註明出處,否則將追究法律責任。

相關文章