asked on

Oracle - Db links

Hi,

I have many dblinks to various databases. Each hour one db job is running which
uses these dblinks. But sometimes happens that some changes are made (e.g. IP
address change) and then the dblink is unusable. But the job is hanging with
"SQL*Net message from dblink" wait event for a very long time.
Is there some possibility to set some "dblink timeout" or to simply check the
dblink status before?

Thanks

cdemir

i think the easiest way : "select * from dual@link_db"

anand_2000v

select * from dba_db_links:

you can view the no of db links in the database,
Incase any changes in the ip address,you have to change the tns entry to refer the new ipaddress.

Once you change the ip address and you din change the tns entry then the db link will get invalid and the job will be hanging

expertblr

ASKER

Thanks for reply. Its perfectly clear to me that when some IP address of any
server is changed then the dblink is unusable until the IP in tnsnames is
changed as well. I've just wanted to ask you if is there any possibility to
somehow handle this problem directly in plsql code. Now we are facing the
problem, that something has chaged (IP....) but we don't know it immediatelly.
We can only see after some time, that the session is hanging with wait for
dblink and it's going to hang probably forever. So I would need only either to
perform some quick functionality check of particular dblink in the beginning of
the code or to set some "dblink timeout".

Thanks..

expertblr

ASKER

can anyone suggest an answer to this??? Please.....

expertblr

ASKER

please help me out!!

ASKER CERTIFIED SOLUTION

anand_2000v

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Computer101

Forced accept.

Computer101
EE Admin