Tuesday, January 27, 2015

FIX- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name

Establish Connection with sqlplus and then create pfile from spfile.

[oracle@primary ~]$ sqlplus /  as sysdba

SQL> create spfile from pfile='/home/oracle/pfile.ora';

Edit pfile.

[oracle@primary ~]$ vim /home/oracle/pfile.ora

Delete LISTENER entry from pfile.
*.local_listener

and re-create spfile from pfile and start database.

 

No comments:

Post a Comment