Home » RDBMS Server » Server Administration » Database Link Not working
Database Link Not working [message #61288] Mon, 12 April 2004 05:01 Go to next message
krishanughosh@hotmail.com
Messages: 1
Registered: April 2004
Junior Member
Hi,

I have 2 Oracle8i databases , one running in IBM AIX
and another in Windows2000 server.I am tring to create a Databse Link in Win2000 database for a Schema in AIX database.The database Link is created succesfully but when I am tring to get Data through this DBLINK SQL*Plus is hanging. Also In OEM it is showing that Database Link is not Active.

Did anyone experianced this problem ? What is the reason behind it.

Thanks in Advance
Krishanu
Re: Database Link Not working [message #61342 is a reply to message #61288] Thu, 15 April 2004 11:32 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

I had the same problem a while back, but cannot
remember exactly how we've fixed it. Try to play with
different values for the following parameters in your
client's sqlnet.ora file:

DISABLE_OOB = true/false
SQLNET.AUTHENTICATION_SERVICES = (none)

It it doesn't work, seek help in the sqlnet forum.

Best of luck!

Frank
Previous Topic: Re: data block corruption
Next Topic: SUBSTR and number datatype.
Goto Forum:
  


Current Time: Fri Sep 20 12:25:28 CDT 2024