Mir Sayeed Hassan – Oracle Blog

ORA-00119 invalid specification for system parameter REMOTE_LISTENER in RAC 11gR2 Database

Issue occur while startup of the RAC Database.

[oracle(racdb-n1)@racdb-n1 ~]$ srvctl start database -d racdb

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'racdb-scan.rac.shp:1521'

Solution:

Check the location of spfile & then create the pfile from spfile

SQL> create pfile='/tmp/inittest.ora' from spfile='+oradata/racdb/spfileracdb.ora';
File created.

Edit the pfile & remove this paramater

[oracle(racdb-n1)@racdb-n1 ~]$ vi /tmp/inittest.ora'

*.remote_listener='racdb2-scan.rac.shp:1521'
:wq

Then create the spfile from pfile which is modified

SQL> create spfile='+ORADATA' from pfile='/tmp/inittest.ora';
File created.

Now create the pfile from the current spfile.

SQL> create pfile='/tmp/inittest2.ora' from spfile='+oradata/RACDB/PARAMETERFILE/spfile.10918.1043646061';
File created.

Modify the pfile by using the srvctl in any one of the node to use the default location of the spfile

[oracle(racdb-n1)@racdb-n1 ~]$ srvctl modify database -d racdb -p +ORADATA/RACDB/PARAMETERFILE/spfile.10918.1043646061

Stop the database

[oracle(racdb-n1)@racdb-n1 ~]$ srvctl stop database -d racdb

Start the database

[oracle(racdb-n1)@racdb-n1 ~]$ srvctl start database -d racdb

Check the status of database

[oracle(racdb-n1)@racdb-n1 ~]$ srvctl status database -d racdb

Instance racdb-n1 is running on node racdb-n1
Instance racdb-n2 is running on node racdb-n2

Verify the spfile

SQL> show parameter spfile

NAME         TYPE                             VALUE
----------------------------------------------------------------------------
spfile      string      +ORADATA/racdb/parameterfile/spfile.10918.1043646061

=====Hence tested & verified in our test env=====