Home » RDBMS Server » Networking and Gateways » Not able to login (Oracle 12c, Windows)
Not able to login [message #634974] Wed, 18 March 2015 09:16 Go to next message
nmdivya@gmail.com
Messages: 12
Registered: September 2014
Junior Member
I wasn't using SQL*Plus for past 2-3 months. When I tried to login using the old username and pwd its showing

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

I created a pluggable DB and all my tables are present in it. I have created a common user too. tht as well not wrking.

I have chked tsnnames.ora and listener.ora i cudnt find any errors.is there any other way to chk the tables which I created already.

[Updated on: Wed, 18 March 2015 09:18]

Report message to a moderator

Re: Not able to login [message #634979 is a reply to message #634974] Wed, 18 March 2015 09:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
TNS-03505 is thrown by tnsping & is same error as ORA-12154 thrown by sqlplus or others.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
Re: Not able to login [message #635128 is a reply to message #634979] Sat, 21 March 2015 12:20 Go to previous message
nmdivya@gmail.com
Messages: 12
Registered: September 2014
Junior Member
Thanks for supporting.

I referred the below link as well.

http://stackoverflow.com/questions/6894558/ora-12560-tnsprotocol-adaptor-error.

I just started the Oracle services in services.msc as mentioned in this link. updated my tsnnames.ora file.[the alias name is case sensitive it seems, i just changed it from upper case to lowercase and it wrked fine Cool ]. Smile
Previous Topic: Resource leak problem
Next Topic: moving table by using db links
Goto Forum:
  


Current Time: Fri Mar 29 03:23:24 CDT 2024