Used TNSNAMES adapter to resolve the aliasĪttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.244)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ssps_db3)))Ĭ:\oracle\ora92\network\admin>sqlplus Release 9.2.0.1.0 - Production on Sat Jun 9 11:43:38 2018Ĭopyright (c) 1982, 2002, Oracle Corporation. TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 0 11:43:29Ĭopyright (c) 1997 Oracle Corporation.
C:\oracle\ora92\network\admin>tnsping ssps_db 3 The correctness of the service name is not checked. The utility tnsping diagnoses only the answer of the listener to the address and port. (ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1)ĪDR_BASE_LISTENER = /home/oracle/databaseĮxample the name of the service ssps_db3 is incorrect. (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1525)) (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) "DEDICATED" established:103158 refused:0 state:readyĮxample of a listener.ora admin]$ more listener.ora "D000" established:0 refused:0 current:0 max:1022 state:ready The command completed ~]$ lsnrctl services LISTENER The command completed ~]$ lsnrctl services LISTENER_SSPS Instance "tch8", status UNKNOWN, has 1 handler(s) for this service. Instance "tch7", status UNKNOWN, has 1 handler(s) for this service. Instance "asut", status UNKNOWN, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525))) Listener Log File /home/oracle/database/diag/tnslsnr/krw-ssps-db-02/listener_ssps/alert/log.xml
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 0 06:01:12Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1525))) The command completed ~]$ lsnrctl status LISTENER_SSPS Instance "ssps", status READY, has 1 handler(s) for this service. Instance "ssps", status UNKNOWN, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listener Log File /home/oracle/database/diag/tnslsnr/krw-ssps-db-02/listener/alert/log.xml Listener Parameter File /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production All rights reserved.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Inet addr:127.0.0.1 ~]$ lsnrctl status LISTENER UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 If the variable $TNS_ADMIN is defined, it will override $ORACLE_HOME/network/admin ~]$ env |grep ~]$ env |grep ~]$įor a start you can make a SQL query select * from v$listener_network If you have access to the server, then you can determine how many processes the listener is running, what IP addresses and ports it is listening to.Īn example for Linux.