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
|
|
|
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))
)
|
|
|
|
|