Category Archives: Uncategorized

Receiving “ORA-01078: failure in processing system parameters” error while starting database on 11gR2 ASM non-RAC environment

Receiving below error while starting up the database in 11gR2 ASM non-RAC environment:

“ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file ‘+DATA/orcl/spfileorcl.ora’
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora
ORA-29701: unable to connect to Cluster Synchronization Service”

To fix this issue, I started the ASM instance and database using SRVCTL command:

$ srvctl start asm
$ srvctl start database -d databasename

E.g:

$ srvctl start asm
$ srvctl start database -d orcl

Advertisements

Leave a comment

Filed under Uncategorized

How to get port number list of Enterprise manager in Oracle 11g?

To determine the port number, check the portlist.ini file. Ports for some oracle database applications are listed in the portlist.ini file, it can be located in the $ORACLE_HOME/install directory

Leave a comment

Filed under Uncategorized