Home » RDBMS Server » Networking and Gateways » Listner Config.
Listner Config. [message #236064] Tue, 08 May 2007 23:09 Go to next message
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.
Re: Listner Config. [message #236114 is a reply to message #236064] Wed, 09 May 2007 01:15 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Net Services Reference
Search Documentation

Regards
Michel

Previous Topic: connecting to Oracle 10G using SQLPLUS and LDAP from OS390
Next Topic: Client install..Listener or TNSnames??
Goto Forum:
  


Current Time: Sat Dec 10 10:31:00 CST 2016

Total time taken to generate the page: 0.08749 seconds