This discussion is archived
10 Replies Latest reply: Jul 22, 2012 10:11 PM by Prabodh RSS

ORA-12541: no listener

949630 Newbie
Currently Being Moderated
hii brothers and sisters
i have problem with forms builder when i try to connect to tha database it show me this

"ORA-12541: no listener

i run all services and because i used loopback i changed the name of the pc with address ip i don't khow how to configure these file .ora to allows me to connect to database ..... plz help



*********************************** tnsnames.ora ******************************************
# tnsnames.ora Network Configuration File: C:\DevSuite10g\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Shippuden-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
*********************************** listener.ora ******************************************
# listener.ora Network Configuration File: C:\DevSuite10g\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = C:\DevSuite10g)
(PROGRAM = orcl)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.160.1.1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
  • 1. Re: ORA-12541: no listener
    Prabodh Guru
    Currently Being Moderated
    Hi,
    This is the Oracle Forms forum.

    Have you started your instance and listener? Are you able to connect to your instance in SQLPlus?

    If not, then please post there {forum:id=61}

    Regards,
  • 2. Re: ORA-12541: no listener
    949630 Newbie
    Currently Being Moderated
    yes i have start my listener and i can connect to my database in sql plus with "hr" ...
  • 3. Re: ORA-12541: no listener
    Prabodh Guru
    Currently Being Moderated
    Hi,
    >
    yes i have start my listener and i can connect to my database in sql plus with "hr" ...
    >

    And you are trying to connect in Form Builder (Ctrl J) with the same "hr"....? With SID ORCL?

    Cheers,
  • 4. Re: ORA-12541: no listener
    ShankarViji Pro
    Currently Being Moderated
    Hi Toto,

    Just add the database entry to the Host File entry..

    C:\WINDOWS\system32\drivers\etc

    The entry Should be something like this,

    For Example:

    In the etc host file give your Database Name followed by the IP address of the Database as like this,

    10.9.23.171 ORCL

    Use, the TNSPing Utility from Command Prompt as,
    C:\Documents and Settings\s0891811>tnsping orcd
    
    TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 - Production on 19-JUL-20
    12 15:32:12
    
    Copyright (c) 1997 Oracle Corporation.  All rights reserved.
    
    Used parameter files:
    C:\OraDevSuite\network\admin\sqlnet.ora
    C:\OraDevSuite\network\admin\tnsnames.ora
    
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = 10.9.23.171)(PORT = 1521))) (CONNECT_DATA = (SID = orcl)))
    OK (20 msec)
    Thanks,
    Shankar
  • 5. Re: ORA-12541: no listener
    949630 Newbie
    Currently Being Moderated
    yes this is my prb when i try to connect with forms developer to database it show me this ORA-12541: no listener .
  • 6. Re: ORA-12541: no listener
    Prabodh Guru
    Currently Being Moderated
    Hi,
    Where is you DB located? On the same machine as the devsuite 10g or some other machine?

    The SID that you use in the connect string in Form Builder must be accessible on TNSPING from the machine where you are running Devsuite.
    Use the following command from the command prompt to check if it is accessible.
    CMD> TNSPING ORCL

    If TNSPING fails then replace the line below in tnsnames.ora file
    >
    <s>(ADDRESS = (PROTOCOL = TCP)(HOST = Shippuden-PC)(PORT = 1521))</s>
    (ADDRESS = (PROTOCOL = TCP)(HOST = <IP ADDRESS OF DB SERVER>)(PORT = 1521))
    >

    If that too fails change the line in tnsname.ora as shown below

    >
    (CONNECT_DATA =
    <s>(SERVICE_NAME = orcl)</s>
    (SID = orcl)
    >

    Cheers,
  • 7. Re: ORA-12541: no listener
    949630 Newbie
    Currently Being Moderated
    hii Shankar Viji

    i have added my static ip with orcl to host ....when i connect with tnsping this error msg is appeared :

    it show me the same msg that u have presented ......but in my case it show this msg in the last

    *****************************
    Used parameter files:
    C:\OraDevSuite\network\admin\sqlnet.ora
    TNS-03505:Echek de la résolution du nom

    ********************************

    not this

    ********************************************
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
    (HOST = 10.9.23.171)(PORT = 1521))) (CONNECT_DATA = (SID = orcl)))
    OK (20 msec)
  • 8. Re: ORA-12541: no listener
    Prabodh Guru
    Currently Being Moderated
    >
    it show me the same msg that u have presented ......but in my case it show this msg in the last

    *****************************
    Used parameter files:
    C:\OraDevSuite\network\admin\sqlnet.ora
    TNS-03505:Echek de la résolution du nom

    ********************************

    >

    You either have an incorrect tnsnames.ora or are using incorrect SID in your connect string.

    Post your tnsnames.ora in the C:\OraDevSuite\network\admin\ folder AND the connect string that you use when connection to SQLPlus as well as Forms Builder.
  • 9. Re: ORA-12541: no listener
    949630 Newbie
    Currently Being Moderated
    hi;
    this is my tnsnames.ora

    # tnsnames.ora Network Configuration File: C:\DevSuiteHome_1\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    ORCL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.160.1.1)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = orcl)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.160.1.1)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = orcl)
    )
    )
  • 10. Re: ORA-12541: no listener
    Prabodh Guru
    Currently Being Moderated
    >
    AND the connect string that you use when connection to SQLPlus as well as Forms Builder.

Legend

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