Sunday, September 03, 2006
Configuring Listeners
My Listener files seems quite messed up. Here are the extracts:
# Start of : D:\Oracle\ora90\network\ADMIN\LISTENER.ORA
# LISTENER.ORA Network Configuration File: d:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
####################################################################
#### portions added for HTTP & HTTPS ####
####################################################################
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = SK-LAPTOP)(PORT = 2482))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = d:\oracle\ora90)
(SID_NAME = TEST)
)
(SID_DESC =
(GLOBAL_DBNAME = CHIK)
(ORACLE_HOME = d:\oracle\ora90)
(SID_NAME = CHIK)
)
(SID_DESC =
(GLOBAL_DBNAME = SKDB)
(ORACLE_HOME = d:\oracle\ora90)
(SID_NAME = SKDB)
)
)
-------------------------------------------------------------------------------------
# Start of : File:d:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
-------------------------------------------------------------------------------------
# do i really need all these entries? Is not this file meant for non-default Port (1521)
# configured LISTENERS?
####################################
# TNSNAMES.ORA Configuration File:d:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Sun Sep 03 21:08:11 GMT+05:30 2006
####################################
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = TEST))
)
SKDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SID = SKDB)(SERVER = DEDICATED))
)
CHIK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SID = CHIK)(SERVER = DEDICATED))
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = MODOSE)(PRESENTATION = http://HRService))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
)
(CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
)
------
# End
------
-------------------------------------------------------------------------------------
# Start of : File:d:\oracle\ora90\network\admin\sqlnet.ora
-------------------------------------------------------------------------------------
# SQLNET.ORA Network Configuration File: d:\oracle\ora90\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-------------------------------------------------------------------------------------
# End of : File:d:\oracle\ora90\network\admin\sqlnet.ora
-------------------------------------------------------------------------------------
Checking status with LSNRCTL:
------------------------------------
Dos prompt: LSNRCTL
LSNRCTL> status skdb
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Produc
tion
Start Date 03-SEP-2006 22:49:40
Uptime 0 days 0 hr. 20 min. 26 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File d:\oracle\ora90\network\admin\listener.ora
Listener Log File d:\oracle\ora90\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SK-LAPTOP)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SK-LAPTOP)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=SK-LAPTOP)(PORT=2482))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=169.254.58.224)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=169.254.58.224)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=169.254.58.224)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=169.254.58.224)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))
Services Summary...
Service "CHIK" has 2 instance(s).
Instance "CHIK", status UNKNOWN, has 1 handler(s) for this service...
Instance "chik", status READY, has 3 handler(s) for this service...
Service "MODOSE" has 3 instance(s).
Instance "SKDB", status READY, has 1 handler(s) for this service...
Instance "TEST", status READY, has 1 handler(s) for this service...
Instance "chik", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SKDB" has 2 instance(s).
Instance "SKDB", status UNKNOWN, has 1 handler(s) for this service...
Instance "SKDB", status READY, has 3 handler(s) for this service...
Service "TEST" has 2 instance(s).
Instance "TEST", status UNKNOWN, has 1 handler(s) for this service...
Instance "TEST", status READY, has 3 handler(s) for this service...
The command completed successfully
# Start of : D:\Oracle\ora90\network\ADMIN\LISTENER.ORA
# LISTENER.ORA Network Configuration File: d:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
####################################################################
#### portions added for HTTP & HTTPS ####
####################################################################
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCPS)(HOST = SK-LAPTOP)(PORT = 2482))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = d:\oracle\ora90)
(SID_NAME = TEST)
)
(SID_DESC =
(GLOBAL_DBNAME = CHIK)
(ORACLE_HOME = d:\oracle\ora90)
(SID_NAME = CHIK)
)
(SID_DESC =
(GLOBAL_DBNAME = SKDB)
(ORACLE_HOME = d:\oracle\ora90)
(SID_NAME = SKDB)
)
)
-------------------------------------------------------------------------------------
# Start of : File:d:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
-------------------------------------------------------------------------------------
# do i really need all these entries? Is not this file meant for non-default Port (1521)
# configured LISTENERS?
####################################
# TNSNAMES.ORA Configuration File:d:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Enterprise Manager V2
# Date..........: Sun Sep 03 21:08:11 GMT+05:30 2006
####################################
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = TEST))
)
SKDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SID = SKDB)(SERVER = DEDICATED))
)
CHIK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SID = CHIK)(SERVER = DEDICATED))
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SK-LAPTOP)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = MODOSE)(PRESENTATION = http://HRService))
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC0))
)
(CONNECT_DATA = (SID = PLSExtProc)(PRESENTATION = RO))
)
------
# End
------
-------------------------------------------------------------------------------------
# Start of : File:d:\oracle\ora90\network\admin\sqlnet.ora
-------------------------------------------------------------------------------------
# SQLNET.ORA Network Configuration File: d:\oracle\ora90\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
-------------------------------------------------------------------------------------
# End of : File:d:\oracle\ora90\network\admin\sqlnet.ora
-------------------------------------------------------------------------------------
Checking status with LSNRCTL:
------------------------------------
Dos prompt: LSNRCTL
LSNRCTL> status skdb
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Produc
tion
Start Date 03-SEP-2006 22:49:40
Uptime 0 days 0 hr. 20 min. 26 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File d:\oracle\ora90\network\admin\listener.ora
Listener Log File d:\oracle\ora90\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SK-LAPTOP)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SK-LAPTOP)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=SK-LAPTOP)(PORT=2482))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=169.254.58.224)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=169.254.58.224)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=169.254.58.224)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=169.254.58.224)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))
Services Summary...
Service "CHIK" has 2 instance(s).
Instance "CHIK", status UNKNOWN, has 1 handler(s) for this service...
Instance "chik", status READY, has 3 handler(s) for this service...
Service "MODOSE" has 3 instance(s).
Instance "SKDB", status READY, has 1 handler(s) for this service...
Instance "TEST", status READY, has 1 handler(s) for this service...
Instance "chik", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SKDB" has 2 instance(s).
Instance "SKDB", status UNKNOWN, has 1 handler(s) for this service...
Instance "SKDB", status READY, has 3 handler(s) for this service...
Service "TEST" has 2 instance(s).
Instance "TEST", status UNKNOWN, has 1 handler(s) for this service...
Instance "TEST", status READY, has 3 handler(s) for this service...
The command completed successfully
