OraFAQ Forum: Linux » [Service "orcl" has 1 instance(s)]

Home » Infrastructure » Linux » [Service "orcl" has 1 instance(s)] - Not appearing in lsnrctl status

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

[Service "orcl" has 1 instance(s)] - Not appearing in lsnrctl status [message #235924]

Tue, 08 May 2007 07:31

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

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

Report message to a moderator

Previous Topic:	logout command
Next Topic:	installing oracle 9i and devloper6i for linux x86 on same PC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 06:54:38 CST 2025