Monday 2 December 2019

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

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



  • oracle@sgdcplm02:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Mon Dec 2 10:34:36 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.


  • SQL> startup nomount;

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

  • SQL> create pfile from spfile;


File created.

SQL> exit
Disconnected
oracle@sgdcplm02:/u01/app/oracle/product/12.1.0/dbhome_1/dbs> ll



oracle@sgdcplm02:> vi initSMRTESTENV.ora

#*.local_listener='LISTENER_SMRTESTENV'

SQL> startup pfile='/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initSMRTESTENV.ora';
ORACLE instance started.

Total System Global Area 3154116608 bytes
Fixed Size                  3715784 bytes
Variable Size            1543507256 bytes
Database Buffers         1593835520 bytes
Redo Buffers               13058048 bytes
Database mounted.
Database opened.

No comments:

Post a Comment