1 I think in your previous post of listener.ora file, you have skipped
some entries.
2. Run services command and paste the result.
Printable View
1 I think in your previous post of listener.ora file, you have skipped
some entries.
2. Run services command and paste the result.
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol 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: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
engiri where are u based i mean country
Answer for the question 1 is posted.
show your /etc/hosts file
also how can you have DHCP in a server?
this is the entry in the /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.1.35 oracle10g.pdcindscape.com oracle10g
DHCP i mean the ip address to this server is private IP.
It is not having a public IP ie 216 or 64 series.
we have a dhcp server that issues the IP address.
but for this server we have kept the IP address fixed.
while installing linux we gave this ip address.
clean up your listener.log
lsnrctl status LISTENER
post listener.log
post listener.ora again
and add this in your hosts
Code:127.0.0.1 localhost.pdcindscape.com localhost
pando i added the entry in /etc/hosts
root@oracle10g etc]# cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.1.35 oracle10g.pdcindscape.com oracle10g
127.0.0.1 localhost.pdcindscape.com loaclhost
to have change effect i did
[root@oracle10g etc]# service network restart
it restarted
but still no luck
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol 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: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
LSNRCTL> services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol 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: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
=====================================================
LSNRCTL> start
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=1521)))
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 01-JUN-2005 14:46:33
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=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
=========================================
LISTENER .LOG
TNSLSNR for Linux: Version 10.1.0.3.0 - Production on 01-JUN-2005 14:42:48
Copyright (c) 1991, 2004, Oracle. All rights reserved.
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
Trace information written to /u01/app/oracle/product/10.1.0/db_1/network/trace/listener.trc
Trace level is currently 0
Started with pid=19453
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g.pdcindscape.com)(PORT=1521)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
01-JUN-2005 14:42:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=oracle10g)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LI STENER)(VERSION=168821504)) * status * 0
you have spelling mistakes in your hosts file
yes dave - i corrected it
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.1.35 oracle10g.pdcindscape.com oracle10g
127.0.0.1 localhost.pdcindscape.com localhost
i restarted the network service
[root@oracle10g etc]# service network restart
Shutting down interface eth0: [ OK ]
Setting network parameters: [ OK ]
Bringing up interface lo: [ OK ]
Bringing up interface eth0: [ OK ]
still no luck
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol 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: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
i tried RELOAD ALSO
============================
LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol 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: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
and the worst part is when i log in to lsnrctl and do start it starts
it doesnt say listener already started.
it starts as if i am starting the listener first time.
no clue - why is this happening,