| 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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
