Note: Before doing this activity Pls take a backup of init.ora.5132015144713 and listener.ora files.
C:\Users\VN>lsnrctl start
LSNRCTL for 64-bit Windows: Version 12.1.0.1.0 - Production on 15-NOV-2015 14:01
:13
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting tnslsnr : please wait.
TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
System parameter file is E:\app\VN\product\12.1.0\dbhome_1\network\admin\lis
tener.ora
Log messages written to E:\app\VN\diag\tnslsnr\lucky\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias : LISTENER
Version : TNSLSNR for 64-bit Windows: Version 12.1.0.1.0 - Production
Start Date : 15-NOV-2015 14:01:18
Uptime : 0 days 0 hr. 0 min. 8 sec
Trace Level : off
Security - ON: Local OS Authentication
SNMP - OFF
Default Service - CLRExtProc
Listener Parameter File E:\app\VN\product\12.1.0\dbhome_1\network\admin\li
stener.ora
Listener Log File - E:\app\VN\diag\tnslsnr\lucky\listener\alert\log.xml
Listening Endpoints Summary.
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary.
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Solution:
SQL> alter system set LOCAL_LISTENER='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope=both;
System altered.
SQL> alter system register;
System altered. OR
Comment #local_listener=LISTENER_ORCL line in init.ora.5132015144713 file.
SQL> startup pfile=C:\app\VN\admin\orcl\pfile\init.ora.5132015144713;
ORACLE instance started.
Total System Global Area 2438529024 bytes
Fixed Size - 2405568 bytes
Variable Size - 654314304 bytes
Database Buffers - 1761607680 bytes
Redo Buffers - 20201472 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile='C:\app\VN\admin\orcl\pfile\init.ora.513201514
4713'; File created.
This post first appeared on Oracle Data Integrator | ODI Online Training, please read the originial post: here