Oracle – database link

pts.
Tags:
Development
I've: -DB "D7" on Oracle 7.3, WinNT4 , Server "S7" -DB "D9" on Oracle 9i, Win2003, Server "S9" -A DB link "DL" in D7 to connect to D9 -Issued "desc TblEmp@DL" from sqlplus in D7 on S7 (TblEmp is a table in D9) When server S9 is UP: Output displayed within a second...so no problem. When server S9 is DOWN: Error displayed "Unable to connect..." after about 45 sec. (Note: Error is not a problem for me) Question : I think it takes about 45 sec for server S7 (or D7) to realise server S9 (or Database D9) is down. *** Is there anyway this time (45 sec) can be reduced (to say 1 or 2 sec) or eliminated ?? ( Is this possible thru Oracle itself ? E.g. parameter setting or command ) *** (I've tried tnsping - It returns the error result very fast but I don't know how to issue & trap this from SQL, specifically trigger). (Please note my actual requirement is quite complex - I've put a simplified one here - hence it will be difficult for me to elaborate the same now, though i can elaborate if need be).

Answer Wiki

Thanks. We'll let you know when a new response is added.

Here is an interesting remark from a metalink forum:

From: Oracle, Dagmar Thompson 04-Sep-02 22:14
Subject: Re : Database links between Oracle 9.2 and 8.0.5.2.1

It is not a supported configuration. You need to be using at least 8.0.6 to be able to link between the two instance.

(end of remark).

Personally, I have not seen Oracle 7.3 for a decade or so I can’t take it any further.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following