Home » RDBMS Server » Networking and Gateways » Unable to start listener (Oracle 11g Release 11.1.0.6.0, RHEL 5.0)
Unable to start listener [message #496682] Tue, 01 March 2011 22:38 Go to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
Greetings to all.

I am having a problem getting my listner to start. I need help and it is a learning opportunity.

[oracle@jhlinux ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 01-MAR-2011 23:26:30

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

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

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
[oracle@jhlinux ~]$ 


Contents of listener.ora

[oracle@jhlinux admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = jhlinux.home.com)(PORT = 1521))
    )
  )

[oracle@jhlinux admin]$ 


Please let me know what other information you need me to post. I am thinking that oracle is the victime of networking setup but I am not sure why. Thanks to all in advance.
Re: Unable to start listener [message #496690 is a reply to message #496682] Tue, 01 March 2011 23:24 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
post results from following OS commands

id
env | sort
uname -a
cat /etc/hosts
Re: Unable to start listener [message #496776 is a reply to message #496690] Wed, 02 March 2011 07:02 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ [b]id[/b]
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)



[oracle@jhlinux ~]$ [b]env | sort[/b]
COLORTERM=gnome-terminal
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-REtUdnNsVD,guid=8cc16d4d0ee299ffcd8ccc7dd55ab400
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=Default
GNOME_KEYRING_SOCKET=/tmp/keyring-KEmc6i/socket
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=jhlinux
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
OLDPWD=/u01/app/oracle/product/11.1.0/db_1/network/admin
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
ORACLE_SID=orcl
PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/sbin:/u01/app/oracle/product/11.1.0/db_1/bin:/home/oracle/bin
PWD=/home/oracle
SESSION_MANAGER=local/jhlinux:/tmp/.ICE-unix/2687
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=2746
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-LzBgYd2687/agent.2687
TERM=xterm
USERNAME=oracle
USER=oracle
_=/usr/bin/env
WINDOWID=48234577
XAUTHORITY=/tmp/.gdmUBGJRV
XMODIFIERS=@im=none



[oracle@jhlinux ~]$ [b]uname -a[/b]
Linux jhlinux 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:14 EST 2007 x86_64 x86_64 x86_64 GNU/Linux



[oracle@jhlinux ~]$ [b]cat /etc/hosts[/b]
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
192.168.1.1     jhlinux.home.com        jhlinux
127.0.0.1       localhost.localdomain   localhost
197.0.0.1       localhost.domain        localhost

Re: Unable to start listener [message #496807 is a reply to message #496776] Wed, 02 March 2011 08:48 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
much looks OK.
One details caught my attention.
>192.168.1.1 jhlinux.home.com jhlinux
Typically X.Y.1. is gateway/route off the subnet.

post results of command below
/sbin/ifconfig
Re: Unable to start listener [message #496889 is a reply to message #496807] Wed, 02 March 2011 21:13 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ /sbin/ifconfig
eth0      Link encap:Ethernet  HWaddr 00:00:6C:91:4A:91  
          inet addr:192.168.1.207  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::200:6cff:fe91:4a91/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:8402 errors:0 dropped:0 overruns:0 frame:0
          TX packets:4797 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:1825963 (1.7 MiB)  TX bytes:630507 (615.7 KiB)
          Interrupt:209 

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:17622 errors:0 dropped:0 overruns:0 frame:0
          TX packets:17622 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:4141744 (3.9 MiB)  TX bytes:4141744 (3.9 MiB)
Re: Unable to start listener [message #496890 is a reply to message #496889] Wed, 02 March 2011 21:33 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>inet addr:192.168.1.207
when hardware has one IP# & /etc/hosts has a different IP# problems result
192.168.1.207   jhlinux.home.com        jhlinux
127.0.0.1       localhost.localdomain   localhost

above might work better after reboot complete

Re: Unable to start listener [message #497072 is a reply to message #496890] Thu, 03 March 2011 20:49 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
After rebooting the value of the inet addr has changed.

[oracle@jhlinux ~]$ /sbin/ifconfig
eth0      Link encap:Ethernet  HWaddr 00:00:6C:CA:B9:8C  
          inet addr:192.168.1.213  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::200:6cff:feca:b98c/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:5 errors:0 dropped:0 overruns:0 frame:0
          TX packets:39 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:1890 (1.8 KiB)  TX bytes:8584 (8.3 KiB)
          Interrupt:209 

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:1147 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1147 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:3313300 (3.1 MiB)  TX bytes:3313300 (3.1 MiB)

[oracle@jhlinux ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
192.168.1.207   jhlinux.home.com        jhlinux
127.0.0.1       localhost.localdomain   localhost
[oracle@jhlinux ~]$ 

[Updated on: Thu, 03 March 2011 21:06]

Report message to a moderator

Re: Unable to start listener [message #497076 is a reply to message #497072] Thu, 03 March 2011 21:21 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>After rebooting the value of the inet addr has changed.
does system use DHCP to obtain IP#?

will SQL*Net work after changing /etc/hosts?
192.168.1.213 jhlinux.home.com jhlinux
Re: Unable to start listener [message #497080 is a reply to message #497076] Thu, 03 March 2011 21:40 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
Yes the machine uses DHCP to obtain IP#.

Re: Unable to start listener [message #497352 is a reply to message #497080] Fri, 04 March 2011 21:59 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member

This is the only way I am able to login.


[oracle@jhlinux ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Mar 4 23:00:20 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 
Re: Unable to start listener [message #497354 is a reply to message #497352] Fri, 04 March 2011 22:16 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>This is the only way I am able to login.
because it does NOT use SQL*Net.

Below is some what of a long shot
mv $ORACLE_HOME/network/admin/listener.ora $ORACLE_HOME/network/admin/listener.ora.bak
next reboot system & after system boots back up login as OS user oracle & issue follow command
lsnrctl start
COPY results then PASTE all back here
Re: Unable to start listener [message #497952 is a reply to message #497354] Mon, 07 March 2011 22:09 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 07-MAR-2011 23:10:56

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

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

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jhlinux.home.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12532: TNS:invalid argument
 TNS-12560: TNS:protocol adapter error
  TNS-00502: Invalid argument
   Linux Error: 113: No route to host
[oracle@jhlinux ~]$ 
Re: Unable to start listener [message #497953 is a reply to message #497952] Mon, 07 March 2011 22:13 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
change /etc/hosts containing single line below

127.0.0.1 localhost.localdomain localhost

reboot OS then

lsnrctl start
Re: Unable to start listener [message #497956 is a reply to message #497953] Mon, 07 March 2011 22:40 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
#192.168.1.215  jhlinux.home.com        jhlinux
127.0.0.1       localhost.localdomain   localhost
[oracle@jhlinux ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 07-MAR-2011 23:35:47

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

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

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist


Listener failed to start. See the error message(s) above...

[oracle@jhlinux ~]$ 



In log file mentioned above

[oracle@jhlinux ~]$ tail -20 /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
 type='UNKNOWN' level='16' host_id='jhlinux'
 host_addr='UNKNOWN'>
 <txt>Started with pid=2861
 </txt>
</msg>
<msg time='2011-03-07T23:35:47.951-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='jhlinux'
 host_addr='UNKNOWN'>
 <txt>Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
 </txt>
</msg>
<msg time='2011-03-07T23:35:47.972-05:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='jhlinux'
 host_addr='UNKNOWN'>
 <txt>TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist

 </txt>
</msg>


Re: Unable to start listener [message #497958 is a reply to message #497956] Mon, 07 March 2011 22:47 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
turn off the Linux firewall
Run the commands

ping localhost
/sbin/service iptables stop
ping localhost
lsnrctl start
Re: Unable to start listener [message #497960 is a reply to message #497958] Mon, 07 March 2011 23:07 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
If I may ask, what is the commman to turn off the firewall ?
Re: Unable to start listener [message #497961 is a reply to message #497960] Mon, 07 March 2011 23:11 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
/sbin/service iptables stop
Re: Unable to start listener [message #497965 is a reply to message #497961] Mon, 07 March 2011 23:31 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[root@jhlinux ~]# /sbin/service iptables stop
Flushing firewall rules:                                   [  OK  ]
Setting chains to policy ACCEPT: filter                    [  OK  ]
Unloading iptables modules:                                [  OK  ]
[root@jhlinux ~]# /sbin/service iptables start
[root@jhlinux ~]# ping localhost
PING localhost.localdomain (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.020 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=2 ttl=64 time=0.019 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=3 ttl=64 time=0.018 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=4 ttl=64 time=0.019 ms

--- localhost.localdomain ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 2999ms
rtt min/avg/max/mdev = 0.018/0.019/0.020/0.000 ms



[oracle@jhlinux ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 08-MAR-2011 01:06:30

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

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

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist


Listener failed to start. See the error message(s) above...

[Updated on: Tue, 08 March 2011 00:04]

Report message to a moderator

Re: Unable to start listener [message #498139 is a reply to message #497965] Tue, 08 March 2011 21:45 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
Please don't give up on me.
Re: Unable to start listener [message #498142 is a reply to message #498139] Tue, 08 March 2011 22:28 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
During installation I got the following error at the end. Could this be the reason I am failing to start the listener ?

Jan 29, 2011 1:31:19 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
Refer to the log file at /u01/app/oracle/cfgtoollogs/dbca/orcl/emConfig.log for more details.
Jan 29, 2011 1:31:19 AM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace: 
oracle.sysman.emcp.exception.EMConfigException: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]
        at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2480)
        at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:743)
        at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:250)
        at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:177)
        at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:220)
        at oracle.sysman.assistants.util.em.EMConfiguration.run(EMConfiguration.java:460)
        at java.lang.Thread.run(Thread.java:595)

[Updated on: Tue, 08 March 2011 22:30]

Report message to a moderator

Re: Unable to start listener [message #498144 is a reply to message #498142] Tue, 08 March 2011 22:37 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>During installation I got the following error at the end. Could this be the reason I am failing to start the listener ?
I don't think so.
Everything reported depends upon the listener.
OS/Networking is mis-configured, but I can't seem to identify exactly what it is & DHCP complicates everything.
It appears you have root access to OS. Correct?
Just as a test, consider unplugging network cable & configure system with fixed/hardwired IP#.
First need to get SQL*Net working on a standalone system
Re: Unable to start listener [message #498700 is a reply to message #498144] Thu, 10 March 2011 19:55 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
I unplugged my maching from the router (netgear) and connected it directly.
Here is what I am seeing.

[oracle@jhlinux admin]$ /sbin/ifconfig
eth0      Link encap:Ethernet  HWaddr 00:00:6C:1A:E6:79  
          inet addr:71.199.128.153  Bcast:255.255.255.255  Mask:255.255.255.0
          inet6 addr: fe80::200:6cff:fe1a:e679/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:10201 errors:0 dropped:0 overruns:0 frame:0
          TX packets:201 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:739029 (721.7 KiB)  TX bytes:26336 (25.7 KiB)
          Interrupt:209 

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:1264 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1264 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:3412122 (3.2 MiB)  TX bytes:3412122 (3.2 MiB)


then I started the listener and got the following

[oracle@jhlinux admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 20:47:52

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

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

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date                10-MAR-2011 20:47:53
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/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully


So I took this to mean that I need to startup the database. So once I started the database I quickly found out there is no listener.

[oracle@jhlinux ~]$ sqlplus scott@orcl

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Mar 10 20:56:01 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter password: 
ERROR:
ORA-12541: TNS:no listener
Re: Unable to start listener [message #498702 is a reply to message #498700] Thu, 10 March 2011 20:10 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
tnsping orcl
lsnrctl status
lsnrctl stop
mv /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.sav
lsnrctl start

do as above then COPY results and PASTE all back here

[Updated on: Thu, 10 March 2011 20:11]

Report message to a moderator

Re: Unable to start listener [message #498714 is a reply to message #498702] Thu, 10 March 2011 20:57 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:54:39

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jhlinux.home.com)(PORT = null)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12541: TNS:no listener
[oracle@jhlinux ~]$ 


[oracle@jhlinux ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:55:57

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date                10-MAR-2011 20:47:53
Uptime                    0 days 1 hr. 8 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully


[oracle@jhlinux ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:56:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jhlinux.home.com)(PORT=1521)))
The command completed successfully
[oracle@jhlinux ~]$ 


[oracle@jhlinux ~]$ mv /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora.sav


[oracle@jhlinux ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 21:58:19

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

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

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date                10-MAR-2011 21:58:19
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully



Re: Unable to start listener [message #498717 is a reply to message #498714] Thu, 10 March 2011 21:07 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
Notice host name changed from
(HOST=jhlinux.home.com)
to
(HOST=localhost.localdomain)

issue OS commands below
lsnrtcl status
sqlplus scott@orcl
post results from above
Re: Unable to start listener [message #498728 is a reply to message #498717] Thu, 10 March 2011 22:17 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 10-MAR-2011 23:19:04

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 10-MAR-2011 23:17:49
Uptime 0 days 0 hr. 1 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jhlinux ~]$ sqlplus scott@orcl

SQL*Plus: Release 11.1.0.6.0 - Production on Thu Mar 10 23:19:17 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12541: TNS:no listener
Re: Unable to start listener [message #498731 is a reply to message #498728] Thu, 10 March 2011 22:31 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
change /etc/hosts containing single line below

127.0.0.1 localhost jhlinux localhost.localdomain

post results from following OS command

uname -a
Re: Unable to start listener [message #498733 is a reply to message #498731] Thu, 10 March 2011 22:46 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
# ::1 localhost6.localdomain6
#127.0.0.1      localhost.localdomain   localhost
#127.0.0.1      jhlinux.home.com        jhlinux
127.0.0.1       localhost jhlinux localhost.localdomain
[oracle@jhlinux ~]$ uname -a
Linux jhlinux 2.6.18-8.el5 #1 SMP Fri Jan 26 14:15:14 EST 2007 x86_64 x86_64 x86_64 GNU/Linux
[oracle@jhlinux ~]$
Re: Unable to start listener [message #498741 is a reply to message #498733] Thu, 10 March 2011 23:08 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
restart OS
after it is back do as below

lsnrctl start
sqlplus
/ as sysdba
startup
exit
lsnrctl status

COPY commands above & results then PASTE all back here
Re: Unable to start listener [message #499243 is a reply to message #498741] Mon, 14 March 2011 04:50 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
1. Makes sure the host entry in /etc/hosts is as below
Quote:
127.0.0.1 localhost.localdomain localhost

2. Makes sure the tns entry is as below.
Quote:
orcl=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = null)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))

3. ping localhost.localdomain
4. tnsping orcl
5. sqlplus scott@orcl

Re: Unable to start listener [message #499437 is a reply to message #499243] Mon, 14 March 2011 21:47 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
--- localhost.localdomain ping statistics ---
8 packets transmitted, 8 received, 0% packet loss, time 6999ms
rtt min/avg/max/mdev = 0.018/0.019/0.020/0.003 ms


[oracle@jhlinux admin]$ tnsping orcl

TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 14-MAR-2011 22:45:34

Copyright (c) 1997, 2007, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = null)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12541: TNS:no listener


[oracle@jhlinux admin]$ sqlplus scott@orcl

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 14 22:46:50 2011

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Enter password: 
ERROR:
ORA-12541: TNS:no listener


[oracle@jhlinux admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 14-MAR-2011 23:00:29

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

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

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date                14-MAR-2011 23:00:29
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/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jhlinux admin]$ 

[Updated on: Mon, 14 March 2011 21:59]

Report message to a moderator

Re: Unable to start listener [message #499441 is a reply to message #499437] Mon, 14 March 2011 22:17 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
lsnrctl status
lsnrctl service
ps -ef | grep -i pmon

COPY commands & results then PASTE all back here
Re: Unable to start listener [message #499456 is a reply to message #499441] Mon, 14 March 2011 23:46 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
[oracle@jhlinux ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 15-MAR-2011 00:45:14

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date                14-MAR-2011 23:00:29
Uptime                    0 days 1 hr. 44 min. 44 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/jhlinux/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully



[oracle@jhlinux ~]$ lsnrctl service

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 15-MAR-2011 00:46:46

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully



[oracle@jhlinux ~]$ ps -ef | grep -i pmon
oracle    2971     1  0 Mar14 ?        00:00:00 ora_pmon_orcl
oracle    3515  2876  0 00:47 pts/1    00:00:00 grep -i pmon
[oracle@jhlinux ~]$ 


Re: Unable to start listener [message #499953 is a reply to message #499456] Wed, 16 March 2011 22:45 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
Black Swan, I appreciate the effort you have put forth trying to help me. I do not know what is wrong here.
In the past I was able to install Oracle 10g on RHEL 4 and I did not get this problem.

My isp is Comcast and they have this modem they use to hook the phone line and internet. Since it does not
work as a router, I had to plug the internet outlet to a netgear router to make it accessible. Could it be
that my problem is router related ?
Re: Unable to start listener [message #499954 is a reply to message #499953] Wed, 16 March 2011 23:01 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>Could it be that my problem is router related ?
I doubt it.
I have my laptop configured to only use localhost, so I can't be hacked into regardless of where I take my laptop.
So SQL*Net "works" even when I don't have an actual network connection as shown below.
oracle@bcm-laptop:~$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-MAR-2011 20:58:20

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                16-MAR-2011 20:58:22
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/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "mysql" has 1 instance(s).
  Instance "mysql", status UNKNOWN, has 1 handler(s) for this service...
Service "v112" has 1 instance(s).
  Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@bcm-laptop:~$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-MAR-2011 20:58:36

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                16-MAR-2011 20:58:22
Uptime                    0 days 0 hr. 0 min. 14 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/bcm-laptop/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "mysql" has 1 instance(s).
  Instance "mysql", status UNKNOWN, has 1 handler(s) for this service...
Service "v112" has 2 instance(s).
  Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
  Instance "v112", status READY, has 1 handler(s) for this service...
Service "v112XDB" has 1 instance(s).
  Instance "v112", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@bcm-laptop:~$ lsnrctl service

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-MAR-2011 20:58:53

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "mysql" has 1 instance(s).
  Instance "mysql", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "v112" has 2 instance(s).
  Instance "v112", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
  Instance "v112", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "v112XDB" has 1 instance(s).
  Instance "v112", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:972 state:ready
         DISPATCHER <machine: bcm-laptop, pid: 2045>
         (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=11067))
The command completed successfully

Re: Unable to start listener [message #499957 is a reply to message #499954] Wed, 16 March 2011 23:46 Go to previous messageGo to next message
jxh461
Messages: 177
Registered: March 2005
Senior Member
I will wait and see if someone has additional ideas on what I can do.
Re: Unable to start listener [message #499959 is a reply to message #499957] Wed, 16 March 2011 23:58 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
>I will wait and see if someone has additional ideas on what I can do.
I am out of ideas.
My gut says that the root cause is local to your system.
It is as though the DB & listener are on different systems.
Re: Unable to start listener [message #617788 is a reply to message #499959] Thu, 03 July 2014 11:17 Go to previous messageGo to next message
dancko
Messages: 51
Registered: June 2013
Location: italy
Member
Hi Smile

I have the exactly same problem.

Prompting lsnrctl status command, I get:

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



Is it possible that there not exist any solution to the problem?

I think that in my case the problem is due to a bad network configuration. I modified hosts file and network adapter ip address many times before and after installation.

BlackSwan only you can help us. You are the best here!

[Updated on: Thu, 03 July 2014 11:21]

Report message to a moderator

Re: Unable to start listener [message #617791 is a reply to message #617788] Thu, 03 July 2014 12:07 Go to previous messageGo to next message
Michel Cadot
Messages: 59149
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ What is the result of ping the hostname?
2/ What is the result of "lsnrctl start <your listener name>"
3/ What is the content of your listener.ora

Sorry I'm not BlackSwan but I think I can be helpful, if you don't think so, please, tell me and I'll leave this topic and no more try to help you.

Re: Unable to start listener [message #617794 is a reply to message #617791] Thu, 03 July 2014 12:57 Go to previous messageGo to previous message
dancko
Messages: 51
Registered: June 2013
Location: italy
Member
Sorry Michel Cadot, I said that only BlackSwan can be helpful because only him has answered this post/topic. But I think that many of you are very expert.

P.S.: I'm not from remote machine... I'm on local machine.

1) Result of the ping the hosname:

[oracle@VMCentOS ~]$ ping VMCentOS
PING VMCentOS (192.168.0.80) 56(84) bytes of data.
64 bytes from VMCentOS (192.168.0.80): icmp_seq=1 ttl=64 time=0.061 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=2 ttl=64 time=0.096 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=3 ttl=64 time=0.080 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=4 ttl=64 time=0.445 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=5 ttl=64 time=0.095 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=6 ttl=64 time=0.078 ms
64 bytes from VMCentOS (192.168.0.80): icmp_seq=7 ttl=64 time=0.086 ms


2) result of "lsnrctl start <your listener name>"

[oracle@VMCentOS ~]$ lsnrctl start LISTENER

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-JUL-2014 10:53:15

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

Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/VMCentOS/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMCentOS)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VMCentOS)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                03-JUL-2014 10:53:15
Uptime                    0 days 0 hr. 0 min. 10 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/VMCentOS/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMCentOS)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@VMCentOS ~]$ 


3)Content of my listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = VMCentOS)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle


3)Content of my tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORACLEDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = VMCentOS)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = oracledb)
    )
  )

[Updated on: Thu, 03 July 2014 13:07]

Report message to a moderator

Previous Topic: Not able to connect with database
Next Topic: " Tracing not turned on" SQLNET.ora
Goto Forum:
  


Current Time: Sun Sep 21 19:52:43 CDT 2014

Total time taken to generate the page: 0.04752 seconds