ORA-12541: TNS:no listener - help plz
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-12541: TNS:no listener - help plz

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    ORA-12541: TNS:no listener - help plz

    I installed oracle 10.2.0.1.0 in windows xp machine.
    using sql*plus I am able to connect using scott/tiger.
    if give scott/tiger@local ( local is the tnsname i have given in tnsnames)
    it is showing the above error ORA-12541: TNS:no listener.
    If I try to start the listner from command prompt
    using lsnrctl start --- it is showing

    " TNS-12560 : PROTOCAL ADAPTER ERROR" FAILED TO START THE SERVICE.

    PLZ GIVE SUGGESTION. FOLLOWING ARE THE DETAILED INFO.

    # tnsnames.ora Network Configuration File:

    D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

    # Generated by Oracle configuration tools.

    LOCAL =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = madhu)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = orcl)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    # listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
    (PROGRAM = extproc)
    )
    )

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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Connect to the database as dba and post the results of...
    show parameter listener
    show parameter service
    ...then go back to operating system and post content of environmental variables below:
    ORACLE_HOME
    ORACLE_SID
    TNS_ADMIN
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2006
    Posts
    96

    ORA-012541-listener problem - reply

    I checked the environment variables in the path
    my compuer - properties - advanced - environment variables - system variables.

    in that regarding oracle only path variable is available its values is

    D:\oracle\product\10.2.0\db_1\bin;E:\DevSuiteHome_1\jdk\jre\bin\classic;E:\DevSuiteHome_1\jdk\jre\bi n;E:\DevSuiteHome_1\jdk\jre\bin\client;E:\DevSuiteHome_1\jlib;E:\DevSuiteHome_1\bin;E:\DevSuiteHome_ 1\jre\1.4.2\bin\client;E:\DevSuiteHome_1\jre\1.4.2\bin;C:\orant\bin;%SystemRoot%\system32;%SystemRoo t%;%SystemRoot%\System32\Wbem;C:\orant\jdk\bin;C:\Program Files\Samsung\Samsung PC Studio 5\

    there are no ORACLE _HOME,ORACLE_SID,TNS_ADMIN etc..
    in either user variables or system variables.

    But i found one thing in
    administrative tools - services - Oracleoradbg10_home1TnsListener
    - path to executable is still the old path.
    d:\oracle\product\10.1.0\db_1\BIN\TNSLSNR - here 10.1.0 is older version
    which was available before. I dont know how to change this path.


    with thanks

    by madhu





    with thanks

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    stop the listener which is running from 10.1.0 home and create new listener from 10.2.0 home.

    Regards,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

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



Click Here to Expand Forum to Full Width