remote Listener [message #53121] |
Wed, 28 August 2002 11:08 |
Mal
Messages: 8 Registered: August 2002
|
Junior Member |
|
|
What is the way for a DBA, who is monitoring a remote database, to know if the listener on the remote server is running or not?
|
|
|
Re: remote Listener [message #53123 is a reply to message #53121] |
Wed, 28 August 2002 11:22 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
There are two ways:
1. Oracle Entreprise Manager with agent installed on the remote host could be configured to send such alerts.
2. You create shell(UNIX) or batch(Windows) scripts to do that. Ready to use scripts and examples could be found Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
Re: remote Listener [message #53139 is a reply to message #53121] |
Thu, 29 August 2002 00:28 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
hi,
we use a tool called as Radmin (Freeware) / Net meeting / PC Anywhere , to virtually connect to a remote machine, access their command prompt/Services and we will check it..
Regards
SAI
|
|
|
Re: remote Listener [message #53152 is a reply to message #53121] |
Thu, 29 August 2002 06:31 |
Grant
Messages: 578 Registered: January 2002
|
Senior Member |
|
|
You can't connect. It will tell you there is no listener.
$ <edge> /export/home/oracle> sqlplus sys@edgetest
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Aug 29 10:24:46 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12541: TNS:no listener
|
|
|