 How to configure listener.ora [message #170571] |
Thu, 04 May 2006 06:57  |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
Hi,
Iam using oracle 9i on windows. when started the listener iam getting the error that "The listener supports no services"
As per the oracle documentation i configured my listener.ora file with values,
newDB = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.46)(PORT = 1521))))
SID_LIST_newDB = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = newDB)(ORACLE_HOME = c:\orahome1)(SID_NAME = newDB)))
When i start the listener i am getting the following message
=============================================================
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 04-MAY-2006 17:25:
15
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is c:\OraHome1\network\admin\listener.ora
Log messages written to c:\OraHome1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=krishna2)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Produc
tion
Start Date 04-MAY-2006 17:25:17
Uptime 0 days 0 hr. 0 min. 2 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File c:\OraHome1\network\admin\listener.ora
Listener Log File c:\OraHome1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=krishna2)(PORT=1521)))
The listener supports no services
The command completed successfully
================================================================
Is anything wrong in the listener.ora ?
With regards
Prasad
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to configure listener.ora [message #171026 is a reply to message #170571] |
Mon, 08 May 2006 00:27  |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
I got the answer,i started the listener like this
"lsnrctl start newDB"
This started the TNSListener for newDB. It has also created a new service.
"lsnrctl start newDB" has given the following result
================================================================
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-MAY-2006 10:51:39
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
Failed to open service <OracleHome1TNSListenernewDB>, error 1060.
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
System parameter file is c:\OraHome1\network\admin\listener.ora
Log messages written to c:\OraHome1\network\log\newdb.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.45)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias newDB
Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
Start Date 08-MAY-2006 10:51:43
Uptime 0 days 0 hr. 0 min. 3 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File c:\OraHome1\network\admin\listener.ora
Listener Log File c:\OraHome1\network\log\newdb.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.45)(PORT=1521)))
Services Summary...
Service "newDB" has 1 instance(s).
Instance "newDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
================================================================
In the above command output i got the error,
Failed to open service <OracleHome1TNSListenernewDB>, error 1060.,
but the listener started successfully and it created the service "OracleHome1TNSListenernewDB".
This occured for the first time only!
Is there is any method to register a service for a listener prior to start of the listener (in Windows and in Unix flavoured operating systems)?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
