ERROR : ORA-12154: TNS:could not resolve the connect identifier specified

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.