lsnrctl stop , status , log_status throws error

[gajananpkini]

hi

Using 10g on advance server linux 2.1
10.1

Ip address is issued by DHCP SERVER.

LISTENER is up and running BUT I AM getting these errors while i am executing.

LSNRCTL> STOP
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.35)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

LSNRCTL > STATUS
LSNRCTL> STATUS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.35)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

ENTRY IN TNSNAMES.ORA
====================================

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

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

ENTRY IN LISTENER.ORA FILE
========================================
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.35)(PORT = 1521))
)
)
)

[davey23uk]

try lsnrctl start then.

by the way, DHCP belongs nowhere near a database (or any other) server

[engiri]

Set tnsadmin before opening lsnrctl and try.

Or go to the oracle home bin and then start lsnrctl.

Regards

[gajananpkini]

I am able to start the server no issues in that.

my question is
when the listener is started and when i want to see the status it throws error.
[oracle@oracle10g bin]$ pwd
/u01/app/oracle/product/10.1.0/db_1/bin

[oracle@oracle10g bin]$ lsnrctl status

LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 31-MAY-2005 14:18:59

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.35)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused


why so.

I am at bin directory too.

[davey23uk]

humour us, what does lsnrctl start do when you type it (post the output) also is that ip address correct

[gajananpkini]

LISTNER STARTED


[oracle@oracle10g admin]$ pwd
/u01/app/oracle/product/10.1.0/db_1/network/admin
[oracle@oracle10g admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 31-MAY-2005 15:22:20

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.3.0 - Production
System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g.pdcindscape.com)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Start Date 31-MAY-2005 15:22:20
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.1.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g.pdcindscape.com)(PORT=1522)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

where there is HOST word mentioned i gace both IP address ie ( 192.168.1.135) and also hostname ie oracle10g.pdcindscape.com
but no luck

[davey23uk]

that listener is running on port 1522, the stuff before was looking on port 1521.

So whats the deal here?

[gajananpkini]

Dave

yes i tired all things here

i tried port 1521 didnt work on - lsnrctl status & stop

then i changed to
port 1522 still didnt work - lsnrctl status & stop

now back to 1521 still no luck.

[engiri]

I think listener is not set.

Lsnrctl> set current_listener LISTENER
Lsnrctl> status

Give the result now.

Regards

[gajananpkini]

i did as per u per no luck. Listener is up and running.
but when i want to see the status - it throws error.



oracle@oracle10g oracle]$ lsnrctl

LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 01-JUN-2005 08:42:43

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> set current_listener LISTENER
Current Listener is LISTENER



LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle10g.pdcindscape.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused