Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Join Date
    Oct 2003
    Posts
    10

    Unanswered: ORA-12541: TNS no Listener

    hi there,

    I have a problem starting the Listener,
    I guest if this is something related with DBA

    Successfully installed the Personal Oracle , configured the Listener and the Service Name

    From Net8 Congif- Test for the connection is not successful
    Message ORA-12541 no Listener.

    When I start the Listener from the Administrative tools-Services, gives a message.

    "Couldn't start the listener service on local computer. the service didn't return an error. This could be an internal windows error or an internal service error. If the problem persists, contact your system administrator."

    I am able to connect to db with user/pwd, but if I use the Service name it errors out.

    Help me in resolving this problem.


    Thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    post your listener.ora and tnsnames.ora files
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Oct 2003
    Posts
    10

    listener.ora and tnsnames.ora

    # Listener.ora network confiuration File: C:\Orant_new\network\admin\listener.ora
    # Generated by oracle configuration tools:

    listener_ora=
    (description=
    (address=(protocol=tcp)(host=aarthi-vv5tz8i5)(port=1521))
    (portocol_stack=
    (presentation=giop0
    (session=raw)
    )
    )
    trace_level_listener_ora=user


    TNSnames.ora network confiuration File: C:\Orant_new\network\admin\tnsnames.ora
    # Generated by oracle configuration tools:

    adb=
    (description=
    (address_list=
    (address = (protocol=tcp)(host=aarthi-vv5tz8i5)(port=1521))
    )
    (connect_data=
    (sid=ora8i)
    )
    )

    adb=
    (description=
    (address_list=
    (address = (protocol=tcp)(host=aarthi-vv5tz8i5)(port=1521))
    )
    (connect_data=
    (sid=ora8i)
    )
    )

    extpproc_connection_data=
    (description=
    (address_list=
    (address = (protocol=icp)(key = extproc3))
    (address = (protocol=tcp)(host=aarthi-vv5tz8i5)(port=1521))
    )
    (connect_data =
    (sid = plsextproc)
    (presentation =ro)
    )
    )

  4. #4
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Ensure your PATH contains c:\oracle_new\bin

    What happens if you run listener control and try to start it that way??

    c:\> lsnrctl
    lsnrctl> start

    Gregg

  5. #5
    Join Date
    Oct 2003
    Posts
    10

    listener

    LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 20-SEP-2004 11:57:
    08

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Welcome to LSNRCTL, type "help" for information.

    LSNRCTL> start
    Starting tnslsnr: please wait...

    Failed to open service <OracleORACLE_HOME_NEWTNSListener>, error 1060.
    TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Production
    System parameter file is C:\ORANT_new\network\admin\listener.ora
    Log messages written to C:\ORANT_new\network\log\listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\ pipe\PNPKEYipc))
    )
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aarthi-vv5tz8i5)(PORT=15
    21)))

    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 - Produc
    tion
    Start Date 20-SEP-2004 11:57:16
    Uptime 0 days 0 hr. 0 min. 2 sec
    Trace Level off
    Security OFF
    SNMP OFF
    Listener Parameter File C:\ORANT_new\network\admin\listener.ora
    Listener Log File C:\ORANT_new\network\log\listener.log
    The listener supports no services
    The command completed successfully
    LSNRCTL> start
    TNS-01106: Listener using listener name LISTENER has already been started
    LSNRCTL>

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    In net8 configuration, ADD DATABASE to the listener ...
    You're service is not defined in the listener...

    HTH
    Gregg

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    where is the SID_LIST_LISTENER = portion of the listener.ora?


    also, why do you have duplicate entries for adb in your
    tnsnames.ora?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Just an observation... did you cut and paste or type the listener.ora into your post? I ask because of this part....

    # Listener.ora network confiuration File: C:\Orant_new\network\admin\listener.ora
    # Generated by oracle configuration tools:

    listener_ora=
    (description=
    (address=(protocol=tcp)(host=aarthi-vv5tz8i5)(port=1521))
    (portocol_stack=
    (presentation=giop0
    (session=raw)
    )
    )
    trace_level_listener_ora=user
    Note the entry PORTOCOL STACK rather than PROTOCOL

    Hth
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  9. #9
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    LISTENER:

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = aarthi-vv5tz8i5)(PORT = 1521))
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = aarthi-vv5tz8i5)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME = sidname)
    (ORACLE_HOME = C:\Orant_new)
    (SID_NAME = sid)

    ----------------- tnsnames.ora ---------------------

    adb=
    (description=
    (address_list=
    (address = (protocol=tcp)(host=aarthi-vv5tz8i5)(port=1521))
    )
    (connect_data=
    (sid=ora8i) <-- Is the SID really ora8i or is it adb ???
    )
    )

    Also ensure that the sqlnet.ora does not have authentication services set to nt

    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    If you change the listener.ora, you need to run lsnrctl and stop/start
    the listener process.

    HTH
    Gregg

  10. #10
    Join Date
    Oct 2003
    Posts
    10

    listener

    configured database service to the listener(listener_ora)

    when I log on as system/manager@ADB

    Errors out

    ora-12154 tns couldn't resolve service name

  11. #11
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    AS NOTED ON PRIOR POST...

    Check tnsnames.ora for the proper service

    abd =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = aarthi-vv5tz8i5)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = adb) <--- ????
    )
    )

    HTH
    Gregg

  12. #12
    Join Date
    Oct 2003
    Posts
    10

    listener

    though changed the sid = ADB in the tnsnames.ora,

    it's the same error ora-12154

  13. #13
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    There is still a problem with the TNSNAMES.ORA or the AUTHENTICATION
    in SQLNET.ORA


    adb=
    (description=
    (address_list=
    (address = (protocol=tcp)(host=aarthi-vv5tz8i5)(port=1521))
    )
    (connect_data=
    (sid=ora8i) <-------- DID you change this or oracle_service = adb ??
    )
    )

    Gregg

  14. #14
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    What happens when you tnsping <sid> ???

    You may have to play with the tnsnames and/or listener to get the right
    combination ... You may have to put the global name after the service_name
    on your connect string ...

    tnsping abd.globalname

    HTH
    Gregg

  15. #15
    Join Date
    Jul 2003
    Posts
    2,296
    please repost your edited listener.ora and tnsnames.ora as you have them now.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •