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

I try to startup the instance but does not come up due to local listener parameter set improperly in spfile

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup;
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCLDGP'

Check the local listener name in pfile and modify it manually to blank

[oracle@orcldg ~]$ cat /oracle/base/product/12.1.0/dbhome_1/dbs/initorcldgp.ora|grep 'local_listener'
*.local_listener='LISTENER_ORCLDGP'

After making changes , the pfile local listener parameter looks like this

[oracle@orcldg ~]$ cat /oracle/base/product/12.1.0/dbhome_1/dbs/initorcldgp.ora|grep 'local_listener'
*.local_listener=''

Now startup the instance using pfile

SQL> startup nomount pfile='/oracle/base/product/12.1.0/dbhome_1/dbs/initorcldgp.ora';
ORACLE instance started.

Total System Global Area 1509949440 bytes
Fixed Size                  2924640 bytes
Variable Size             956305312 bytes
Database Buffers          536870912 bytes
Redo Buffers               13848576 bytes

Check the local listener

SQL> show parameter local_listener

Create spfile from pfile

SQL> create spfile from pfile;

File created.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s