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 'grac4-scan.grid4.example.com:1521'

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

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 *