Shulou(Shulou.com)06/01 Report--

The RAC test environment built a few days ago: oel6.7 grid and database are both 11.2.0.4.0

After rebooting today, one of the node databases can not start up, but the cluster can start normally.

Manual startup error:

SQL > startup

ORA-01078: failure in processing system parameters

ORA-01565: error in identifying file'+ DATA_VG/sldb/spfilesldb.ora'

ORA-17503: ksfdopn:2 Failed to open file + DATA_VG/slcard/spfilesldb.ora

ORA-12547: TNS:lost contact

The search by google is caused by the permissions of oracle files in the grid software directory bin directory

Normal node sldb2:

[grid@sldb2 bin] $ll oracle*

-rwsr-s--x. 1 grid oinstall 209914479 October 28 17:30 oracle

-rwxr-x---. 1 grid oinstall 0 October 28 17:30 oracleO

Failure Node sldb1:

[grid@sldb1 bin] $ll oracle*

-rwxrwxr-x 1 grid oinstall 209914479 October 28 17:28 oracle

-rwxrwxr-x 1 grid oinstall 0 August 24 2013 oracleO

Modify oracle file permissions

[grid@sldb1 bin] $chmod 6751 oracle

After that, the database can start normally.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.