Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    42

    Unanswered: could not start OracleOraHome92TNSListener

    i get a error saying ORA-12541: TNS:no listener hence tried to start OracleOraHome92TNSListener.
    whn i did i get a error saying.
    "could not start OracleOraHome92TNSListener on Local Computer"
    "Error 3 The system cannot find the path specified"
    in my home PC (installed oracle9i)

    tnsnames.ora file is as follows
    ARVIND =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = arvind)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = arvind)
    )
    )

    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = arvind)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )
    i v other databases also in my system created thru manual database creation.

    listener.ora is as follows
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = arvind)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = c:\oracle\ora92)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = arvind)
    (ORACLE_HOME = c:\oracle\ora92)
    (SID_NAME = arvind)
    )
    )

    plz help.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Hmmm.......
    Code:
    12541, 00000, "TNS:no listener"
    // *Cause: The connection request could not be completed because the listener
    // is not running.
    // *Action: Ensure that the supplied destination address matches one of
    // the addresses used by the listener - compare the TNSNAMES.ORA entry with
    // the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
    // go by way of an Interchange). Start the listener on the remote machine.
    Something is amiss with the content of your post.
    My error code & text do not match what you report.
    Too bad for all concerned that you tried to tell us what happened, rather
    than simply using CUT & PASTE so we could all see EXACTLY what transpired.

    Therefore, I am not going to waste any more time trying to guess about your reality.

    You're On Your Own (YOYO)!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2006
    Posts
    42
    ^^^

    cud someone plz tell me wat this is abt?

    thanks
    Last edited by iinfi; 05-09-08 at 14:03.

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    What are you typing that causes the error message?
    Is the Listener service up & running?
    Where is the TNSNames.ora file?
    Where is the Listener.ora file?

    Do as Anacedent suggests - show us what you're doing, rather than telling us.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    May 2006
    Posts
    42
    well i didnt understand a word of wat the other gentleman was trying to say.
    btw ... i dont have the issue as of now as i had to format the system and install everything agian.

    i was using windows @ home and whn i tried to goto services.msc and start the listener service i was getting a message saying
    "ORA-12541: TNS:no listener hence tried to start OracleOraHome92TNSListener".

    Any way, all is well now ...thanks for your concern.
    Last edited by iinfi; 05-12-08 at 12:02.

Posting Permissions

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