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

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\Sindhu>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\Sindhu\product\12.1.0\dbhome_1\network\admin\lis
tener.ora
Log messages written to E:\app\Sindhu\diag\tnslsnr\lucky\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521
ipc)))
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 - Produ
ction
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\Sindhu\product\12.1.0\dbhome_1\network\admin\li
stener.ora
Listener Log File         E:\app\Sindhu\diag\tnslsnr\lucky\listener\alert\log.xm
l
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)(PO
RT=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\Sindhu\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\Sindhu\admin\orcl\pfile\init.ora.513201514
4713';

File created.

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>

ODI 12.2.1 Latest version is available for download.

ODI 12.2.1 Latest version is available for download.


http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

OBIEE 12.2.1 latest version available for download

OBIEE 12.2.1 latest version available for download


http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html