Sunday, November 15, 2015

Connected to an idle instance. ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

SQL> conn sys as sysdba
Enter password:
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_ORCL'



SQL> create pfile from spfile;

File created.

SQL> create spfile from pfile;

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 6396977152 bytes
Fixed Size                  2416968 bytes
Variable Size            1207963320 bytes
Database Buffers         5167382528 bytes
Redo Buffers               19214336 bytes
Database mounted.
Database opened.
SQL> conn sys as sysdba
Enter password:
Connected.

SQL>





No comments:

Post a Comment