OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Listner Config.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Listner Config. [message #236064]

Tue, 08 May 2007 23:09

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi,
Please see the follwing entry in my listener.ora file

SQLNET.AUTHENTICATION_SERVICES = (NONE)

USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF

#LISTENER =
# (ADDRESS = (PROTOCOL = TCP)(HOST = 145.128.44.121)(PORT = 1526))

LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 145.128.44.121)
(Port = 1526)
)
)

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0
#TRACE_LEVEL_LISTENER = 16
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
# (GLOBAL_DBNAME = shah)
(SID_NAME = shah)
(ORACLE_HOME = /opt/app/oracle/product/9.2.0)
(PRESPAWN_MAX = 10)
)
(SID_DESC =
(SID_NAME = asla)
(ORACLE_HOME = /opt/app/oracle/product/9.2.0)
(PROGRAM = asla)
)
)

do we need have name like "SID_LIST_LISTENER " always? and also what is that program and prespawn_max variable?
and also
SQLNET.AUTHENTICATION_SERVICES = (NONE)
USE_PLUG_AND_PLAY_LISTENER = OFF
USE_CKPFILE_LISTENER = OFF

is the value for SQLNET.AUTHENTICATION_SERVICES in this file should be same as sqlnet.ora file?

Thanks.

Report message to a moderator