Home » SQL & PL/SQL » SQL & PL/SQL » Getting ora-02085 fort Database Link
Getting ora-02085 fort Database Link [message #216212] Thu, 25 January 2007 11:03 Go to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
In Intialization Parameters
Global_Names = TRUE


create database link prime30.us.oracle.com
connect to Prime3 identified by prime3
using 'ALAMDATA';


Definition of ALAMDATA is defined in TNSNAMES
ALAMDATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Nic)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PRIME30)
)
)


Database Link is created.

But its gving an error:
ora-02085
Re: Getting ora-02085 fort Database Link [message #216214 is a reply to message #216212] Thu, 25 January 2007 11:24 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
02085, 00000, "database link %s connects to %s"
// *Cause: a database link connected to a database with a different name.
// The connection is rejected.
// *Action: create a database link with the same name as the database it
// connects to, or set global_names=false.
//
Re: Getting ora-02085 fort Database Link [message #216278 is a reply to message #216212] Fri, 26 January 2007 01:31 Go to previous message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Its working.
Thanks for your guidelines.
Previous Topic: sql help
Next Topic: SP2-0552 Bind variable not declared ERROR
Goto Forum:
  


Current Time: Wed Dec 07 22:37:24 CST 2016

Total time taken to generate the page: 0.11646 seconds