Home » Infrastructure » Linux » [Service "orcl" has 1 instance(s)] - Not appearing in lsnrctl status
[Service "orcl" has 1 instance(s)] - Not appearing in lsnrctl status [message #235924] Tue, 08 May 2007 07:31 Go to next message
root_oracle
Messages: 2
Registered: May 2007
Junior Member
Hi,

My listener.ora file is set up as below:

_________________________________________________________________
# tnsnames.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/db_5/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.0.208)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

_________________________________________________________________


I ran "lsnrctl". The lsnrctl status is given below:

_________________________________________________________________

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 08-MAY-2007 17:18:47
Uptime 0 days 0 hr. 34 min. 3 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/oracle/product/10.2.0/db_5/network/admin/listener.ora
Listener Log File /home/oracle/oracle/product/10.2.0/db_5/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.0.208)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


_________________________________________________________________

In the Services Summary there is no Service "orcl"(but orcl is defined in tnsnames.ora given ablove).

I want to have output of lsnrctl status like this:

Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...



Can anyone please help me on this of how to get that in the lsnrctl status?

- Sankar

[Updated on: Tue, 08 May 2007 07:36]

Report message to a moderator

Re: [Service "orcl" has 1 instance(s)] - Not appearing in lsnrctl status [message #242414 is a reply to message #235924] Fri, 01 June 2007 18:18 Go to previous message
Thagor
Messages: 9
Registered: April 2007
Junior Member
Hi,

Can you connect via tcp? What does the sqlnet.ora say?

Did you tell your database to register to this listener? Otherwise try to tell it to do so with (as user system):
alter system register;

Hope this helps a little.

Greetings,
Thagor
Previous Topic: logout command
Next Topic: installing oracle 9i and devloper6i for linux x86 on same PC
Goto Forum:
  


Current Time: Thu Mar 28 02:57:42 CDT 2024