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

Comments: Post a Comment



<< Home
Advertisements

eBay.in - The World's Online Marketplace

ARCHIVES
  • March 2006
  • April 2006
  • May 2006
  • June 2006
  • July 2006
  • August 2006
  • September 2006

This page is powered by Blogger. Isn't yours?

Recent Postings

Google