Fixing RAC database startup problems due to init.ora prameter problems

Startup fails due to init.ora parameter settings 

SQL> startup nomount
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name ''

Find RAC database SPFILE:
[grid@grac41 ~]$  asmcmd ls +DATA/grac4/PARAMETERFILE/

Create Pfile from SPFile
SQL>  create pfile='/tmp/grac41.ora' from spfile='+DATA/grac4/PARAMETERFILE/spfile.267.826111833';
File created.

--> remove the REMOTE_LISTENER entry and start database in mount status 

Startup DB with new PFile
SQL> startup mount pfile='/tmp/grac41.ora'

Leave a Reply

Your email address will not be published. Required fields are marked *