| 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 #170763 is a reply to message #170571] |
Fri, 05 May 2006 01:48  |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
when i give the command, sqlplus "sys/prasad@newDB as sysdba", iam getting the following error
SQL*Plus: Release 9.2.0.1.0 - Production on Fri May 5 10:04:27 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
Enter user-name:
--
With Regards
Prasad
|
|
|
|
|
|
| Re: How to configure listener.ora [message #170768 is a reply to message #170571] |
Fri, 05 May 2006 01:59 |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
tnsnames.ora entry is
newDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.46)(PORT = 1521)))(CONNECT_DATA = (SID = newDB)(SERVER = DEDICATED)))
when started the listener, iam getting the message
The listener supports no services
I guess this is the root cause of the error.
Is anything wrong with my listener.ora and tnsnames.ora ?
With Regards
Vara Prasad
|
|
|
|
|
|
|
|
| Re: How to configure listener.ora [message #170774 is a reply to message #170571] |
Fri, 05 May 2006 02:21 |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
192.168.1.46 and krishna2 are the same.
i changed SID to SERVICE_NAME in tnsnames.ora tnsping is working fine. before changing SID to SERVICE_NAME also tnsping is working fine.
tnsping newDB has given the following result
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 05-MAY-20
06 12:48:58
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
c:\OraHome1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.46)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = newDB)(SERVE
R = DEDICATED)))
OK (20 msec)
Event after changing the SID to SERVICE_NAME
logging through sqlplus is giving error
The error is
SQL*Plus: Release 9.2.0.1.0 - Production on Fri May 5 12:48:37 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor.
While starting the listener itself it is unable to register
the service and its corresponding instance.
---
With Regards
Prasad
|
|
|
|
|
|
| Re: How to configure listener.ora [message #170785 is a reply to message #170571] |
Fri, 05 May 2006 02:51 |
varaprasad_1261
Messages: 34
Registered: September 2005
|
Member |
|
|
Relaced SERVICE_NAME with SID
1)replaced SERVER with SRVR
2)deleted SERVER entry in tnsnames.ora
For both of the above cases getting the same error.
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
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
