Hi,
I am facing problems in remote monitoring of Oracle listener service in Solaris.
I want to get the output of 'lsnrctl status' by connecting through SSH from my Windows machine. But I am getting empty result. Same command when i execute in the local machine (command prompt), I get the desired result.
All other commands I am able to execute from the remote machine except 'lsnrctl status'.
I am using the administrative username and password to connect.
Also I have configured the "listener.ora" configuration file. The current file looks like this :
-------------------------------------
# listener.ora Network Configuration File: /home/oracle/u01/app/oracle/product/10.2.0/Db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LOCAL_OS_AUTHENTICATION_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/oracle/u01/app/oracle/product/10.2.0/Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = colluat)
(ORACLE_HOME = /home/oracle/u01/app/oracle/product/10.2.0/Db_1)
(SID_NAME = colluat)
)
)
LOCAL_OS_AUTHENTICATION_LISTENER = OFF
ADMIN_RESTRICTIONS_LISTENER = OFF
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = INKOLCOLSBYDB39)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
LOCAL_OS_AUTHENTICATION_LISTENER = OFF
ADMIN_RESTRICTIONS_LISTENER = OFF
LISTENER1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = INKOLEVMPRDDB50.familycreditindia.com= 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
------------------------
Hostname of the Windows machine from which I am trying to do the remote connection :
INKOLEVMPRDDB50.familycreditindia.com
Please help if possible.