OraFAQ Forum: Server Administration » Login in DATABASE From Server

Home » RDBMS Server » Server Administration » Login in DATABASE From Server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fri, 26 August 2016 09:10

HZAA
Messages: 13
Registered: November 2014

Junior Member

I have Installed ORACLE Databases Server 11G on server.
when I try to login to Database from inside the server and connect with any users without writing host string(database name) it connect successfully.
but when i write database name like SYSTEM@ORCL it gives Error ora-12154 :TNS.
can anyone help me.

[Edit MC: remove size 4]

[Updated on: Fri, 26 August 2016 09:52] by Moderator

Report message to a moderator

Re: Login in DATABASE From Server [message #655307 is a reply to message #655305]

Fri, 26 August 2016 09:11

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/

Report message to a moderator

Re: Login in DATABASE From Server [message #655320 is a reply to message #655307]

Sat, 27 August 2016 06:17

HZAA
Messages: 13
Registered: November 2014

Junior Member

Can you Clarify more

Report message to a moderator

Re: Login in DATABASE From Server [message #655322 is a reply to message #655320]

Sat, 27 August 2016 07:42

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

HZAA wrote on Sat, 27 August 2016 06:17

Can you Clarify more

Did you bother following the link? http://edstevensdba.com/oracle-tns/ora-12154tns-03505/

Report message to a moderator

Re: Login in DATABASE From Server [message #655323 is a reply to message #655307]

Sat, 27 August 2016 07:44

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

Blackswan - please note the all of the primary content of edstevensdba.wordpress.com has been relocated to edstevensdba.com. The specific article for ora-12154 is now at http://edstevensdba.com/oracle-tns/ora-12154tns-03505/

Report message to a moderator

Previous Topic:	ORA-00959: While dropping tablespace.
Next Topic:	ORA-01466 - but no one changed the table in question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 01 15:29:09 CDT 2023