Home » RDBMS Server » Server Administration » Login using global DB name (Oracle 11gr2,Linux 5)
Login using global DB name [message #579354] Mon, 11 March 2013 09:53 Go to next message
Jack14
Messages: 459
Registered: December 2011
Location: INDIA
Senior Member
Hi,

I see we are unable to login to database using global database.
[oracle@sl73usircd01 ~]$ sqlplus DEMO@DB1.COM

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 11 14:47:31 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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


Enter user-name:


May i know why we are unable to login to database using global database name ?

Thank you
Re: Login using global DB name [message #579356 is a reply to message #579354] Mon, 11 March 2013 10:15 Go to previous messageGo to next message
BlackSwan
Messages: 21981
Registered: January 2009
Senior Member
>plus DEMO@DB1.COM
the string to the right of the at sign character ("@") is a TNS_ALIAS; which has NO direct relationship to global name.

post content of appropriate tnsnames.ora file

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Re: Login using global DB name [message #579363 is a reply to message #579354] Mon, 11 March 2013 11:05 Go to previous message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for EZCONNECT in the documentation, or even here.

Regards
Michel

[Updated on: Mon, 11 March 2013 11:06]

Report message to a moderator

Previous Topic: About oracle memory
Next Topic: Moving OMF files in ASM
Goto Forum:
  


Current Time: Thu Apr 24 19:34:51 CDT 2014

Total time taken to generate the page: 0.08847 seconds