OraFAQ Forum: Networking and Gateways » unable to register a service to a listener

Home » RDBMS Server » Networking and Gateways » unable to register a service to a listener

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

unable to register a service to a listener [message #162968]

Tue, 14 March 2006 06:41

varaprasad_1261
Messages: 34
Registered: September 2005

Member

Hi ,

Iam having oracle 9i on solaries os.

listener.ora file contents are

vvrDB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = testsys)(PORT = 1521)))))

SID_LIST_vvrDB =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = vvrDB)
(ORACLE_HOME = /oracle/product/920)
(SID_NAME = vvrDB)
)
)

tnsnames.ora file contents are

vvrDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = testsys)(PORT = 1521)))(CONNECT_DATA = (SID =
vvrDB)(SERVER = DEDICATED)))

When i start the listener using "lsnrctl start" iam getting the output as "listener supports no services."

Is anything wrong in listener.ora and tnsnames.ora ?
How to register a service to a listener ?

With Regards,
Vara Prasad

Report message to a moderator

Re: unable to register a service to a listener [message #162970 is a reply to message #162968]

Tue, 14 March 2006 06:43

aciolac
Messages: 242
Registered: February 2006

Senior Member

Try this example of listener.ora(only put Your correct parameters):

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU=8192)
(TDU=8192)
(GLOBAL_DBNAME = sgc.prom)
(SID_NAME = SGC)
(ORACLE_HOME = /software/oracle/product/8.1.7)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prometeu)(PORT = 1521))
)

Report message to a moderator