| how to test connection [message #135971] |
Mon, 05 September 2005 03:26  |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
hi all
i have connection between oracle database on server and clients at 7 sites
so i want to know if there any way to still test internet connection
so if it disconnected i will turn data to local database and when it reconnect data will be post to general server
|
|
|
|
|
|
|
|
| Re: how to test connection [message #136039 is a reply to message #136038] |
Mon, 05 September 2005 09:31  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>>i asked about oracle built-in to test connection
Where exactly in your posting have you mentioned about an oracle utility?
My response was based on this.
>> if there any way to still test internet connection
If you can ping your REMOTE Host, it means
You have internet connection and the remote machine is alive.
So to answer your question,
There is nothing automatic here.
You can schedule something like dbms_JOB that check for the availablitiy of server.
But if server is down, your DBMS_JOB wil not be working.!.
So, nothing can be scheduled in server side.
You have to make use of Client-side only.
tnsping will check only the availablity of listener.
write a simple sql query ( like select sysdate from dual or name from v$database).
Schedule this to run at intervals from your client side.
If it fails, you have problems ( which may be broken newtork/listner down/database down/ instance issues anything).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
