ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_SMRTESTENV'
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.
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_SMRTESTENV'
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.
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