This discussion is archived
1 2 3 4 Previous Next 52 Replies Latest reply: Dec 28, 2012 4:33 AM by EdStevens RSS

NOt able to start the listener..

981853 Newbie
Currently Being Moderated
After Indtalling oracle 11g .. i am not able to start the listener

dbstart $ORACLE_HOME
lsnrctl start
ORACLE_SID=orcl
export ORACLE_SID
lsnrctl start
[oracle@test1 bin]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-DEC-2012 15:35:36

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/test1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
Start Date 27-DEC-2012 15:35:37
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/test1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.com)(PORT=1521)))
**The listener supports no services**The command completed successfully


tried all posibalaties as here
Oracle 11g Listener Supports No services

Please help me beacuse of which my work is struck for whole day
  • 1. Re: NOt able to start the listener..
    Niket Kumar Pro
    Currently Being Moderated
    your listener is started....

    check your service

    post result of below:

    ps -ef|grep pmon
  • 2. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    [oracle@test1 bin]$ ps -ef | grep pmon
    oracle 10900 1 0 13:59 ? 00:00:03 ora_pmon_orcl
    oracle 13431 11176 0 16:28 pts/5 00:00:00 grep pmon

    Please see this

    [oracle@test1 bin]$ lsnrctl status

    LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-DEC-2012 16:29:29

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    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=test1.com)(PORT=1521)))
    TNS-12541: TNS:no listener
    TNS-12560: TNS:protocol adapter error
    TNS-00511: No listener
    Linux Error: 111: Connection refused
  • 3. Re: NOt able to start the listener..
    Niket Kumar Pro
    Currently Being Moderated
    now try

    ps -ef|grep tns

    if no result came then

    [oracle@test1 bin]$ lsnrctl start

    it will start the listener.
  • 4. Re: NOt able to start the listener..
    Jairam Explorer
    Currently Being Moderated
    Hi,

    Check your environment variables.,

    echo $ORACLE_SID
    echo $ORACLE_HOME

    and also post your listener.ora entry..,




    Regards,
    Jai
  • 5. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    [oracle@test1 bin]$ ps -ef|grep tns
    oracle 13498 11176 0 16:41 pts/5 00:00:00 grep tns
    [oracle@test1 bin]$
    [oracle@test1 bin]$ lsnrctl start

    LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 27-DEC-2012 16:41:08

    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/test1/listener/alert/log.xml
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.com)(PORT=1521)))

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 11.1.0.6.0 - Production
    Start Date 27-DEC-2012 16:41:10
    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/test1/listener/alert/log.xml
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.com)(PORT=1521)))
    The listener supports no services+The command completed successfully
    [oracle@test1 bin]$
    [oracle@test1 bin]$ echo $ORACLE_SID
    orcl
    [oracle@test1 bin]$ echo $ORACLE_HOME
    /u01/app/oracle/product/11.1.0/db_1
    [oracle@test1 bin]$
    [oracle@test1 bin]$
  • 6. Re: NOt able to start the listener..
    Niket Kumar Pro
    Currently Being Moderated
    post listener.ora file


    /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
  • 7. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    # 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 = IPC)(KEY = EXTPROC1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = test1.com)(PORT = 1521))
    )
  • 8. Re: NOt able to start the listener..
    Jairam Explorer
    Currently Being Moderated
    Hi,


    There is no problem with your listener. Try the below command and If it will return error then check
    with your tnsnames.ora file whether is having entry for your db or not..

    Example:

    $tnsping orcl

    ORCL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = orcl)
    )
    )



    Regards,
    Jai
  • 9. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    [oracle@test1 bin]$ tnsping orcl

    TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 27-DEC-2012 16:51:05

    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)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
    TNS-12541: TNS:no listener[oracle@test1 bin]$ cat /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
    # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
    # Generated by Oracle configuration tools.

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

    [oracle@test1 bin]$
  • 10. Re: NOt able to start the listener..
    Niket Kumar Pro
    Currently Being Moderated
    use your machine ip instead of local host in

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = machine_IP)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )
  • 11. Re: NOt able to start the listener..
    Niket Kumar Pro
    Currently Being Moderated
    your listener machine is test1.com
    you should use ip of test1.com in tnsname.ora or host as test1.com
  • 12. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    tried both ...
    I have changed after your last reply ...

    still get this

    [oracle@test1 bin]$ tnsping orcl

    TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 27-DEC-2012 16:55: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 = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
    TNS-12541: TNS:no listener
  • 13. Re: NOt able to start the listener..
    Niket Kumar Pro
    Currently Being Moderated
    still shwoing your tnsping

    (HOST = localhost)

    it should be (HOST=database_machine_ip)
  • 14. Re: NOt able to start the listener..
    981853 Newbie
    Currently Being Moderated
    after changing to test1.com
    oracle@test1 bin]$ tnsping orcl

    TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 27-DEC-2012 16:58:28

    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 = test1.com**)(_PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
    TNS-12541: TNS:no listener
1 2 3 4 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points