| data base link [message #61537] |
Tue, 04 May 2004 08:51  |
Gesner
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
I have tow data base in oracle 8i, they have a link betewen them, i don't know what happen, the link it's woking anymore, i try to create another link it's the same thing, it's not working
the message is
"ora-12640 database link it's not active"
thank 's for any help
|
|
|
|
| Re: data base link [message #61563 is a reply to message #61537] |
Wed, 05 May 2004 09:37  |
croca
Messages: 50
Registered: January 2004
|
Member |
|
|
12640, 00000, "Authentication adapter initialization failed"
// *Cause: The function specified in the authentication table entry for the
// service failed.
// *Action: Enable tracing to determine the exact error.
hope it helps.
www.otools.com.ar
|
|
|
|
| Re: data base link [message #61637 is a reply to message #61537] |
Tue, 11 May 2004 22:59 |
gugan
Messages: 8
Registered: January 2002
|
Junior Member |
|
|
check your database link with select count(*) from tab@dblink if it is not working then look for sqlnet.ora file with entry sqlnet.authentication_services=(NTS) if it is there then remove it. There may be some other causes like sid could not be resolved and network is down so resolve those errors accordingly and also make sure your init parameter is reflecting no of active db links
such as OPEN_LINKS, OPEN_LINKS_PER_INSTANCE.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
