Tns 12154

Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Could not resolve. Hi, I have a problem with my oracle 10g instalation over win 2003, each time a setup a new database I works fine the first time, but when I restart the win 2003, the next time oracle throws a error: ORA-12154: TNS:could not resolve the connect identifier specified. Can anybody help me with it!!!!! Thanks for you help.

Whenever I try to login or connect into SQL command line or SQL*Plus (11g Standard Edition Win64) I get an error
ORA-12154: TNS:could not resolve the connect identifier specified.
I have tried to solve this problem with google help but I can't.
so please help me out of this!

Vicky PatelVicky Patel

1 Answer

You are trying to connect to a database v. 'v' is the connect identifier. However, your Oracle client does not know of v. This is what the error message is trying to tell you.

Try

Hopefully this will give you something like this:

What you can extract from this is the location:

Oracle ora 12154 connect identifier

This is where your tnsnames.ora file resides. Edit this file and add the correct information for your database v. Substitute servername for the machine your Oracle database is on.

ReneRene
8,8974 gold badges22 silver badges42 bronze badges
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Not the answer you're looking for? Browse other questions tagged oracleoracle11gsqlplus or ask your own question.

Hi Experts

We are facing this error 'ORA 12154 tns could not resolve the connect identifier specified' in alert log file while shipping logs to standby database. We have checked tnsping from both the servers (prim and stndby) are successful. If we are trying to connect standby database from primary database with command 'sqlplus sys/password@standby as sysdba', it is successful.

tnsping result in secondary: SOL_DR

Ora-12154: Tns:could Not Resolve The Connect Identifier Specified Sap

orasol> tnsping SOL

TNS Ping Utility for Solaris: Version 12.1.0.2.0 - Production on 23-JAN-2019 14:56:44

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:

/oracle/SOL/121/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ERPSOL) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SOL)))

OK (0 msec)

orasol>

tnsping result in primary: SOL

ERPSOL:orasol 1% tnsping SOL_DR

Ora-12154: Tns:could Not Resolve The Connect Identifier Specified Ssrs

TNS Ping Utility for Solaris: Version 12.1.0.2.0 - Production on 23-JAN-2019 14:55:43

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:

/oracle/SOL/121/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

The

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ERPSOL-CL) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SOL_DR)))

OK (0 msec)

ERPSOL:orasol 2%

Getting no idea then how it is showing error while log shipping

Coments are closed
Scroll to top