Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    26

    Exclamation Unanswered: TNS-12541: TNS:no listener

    I have installed oracle 9i and forms6i on the same machine, when i try to connect to oracle database using forms 6i i get this error ORA-12203: TNS:unable to connect to destination. When i try to issue tnsping80 i get this error TNS-12538: TNS:no such protocol adapter.

    The listener of the database is running ok, i can shut it down and start it up without any problems. I have tried changing hostname in tnsname.ora by putting an ip address but still iam getting the same error. Firewall i have even turned it off.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have installed oracle 9i and forms6i on the same machine,
    WHY? Both are obsoleted.

    What is Operating System name & version?

    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.
    12538, 00000, "TNS:no such protocol adapter"
    // *Cause: The protocol adapter requested (by way of the "(PROTOCOL=..)"
    // keyword-value pair in a TNS address) is unknown. If the supplied address
    // is typographically correct then the protocol adapter is not installed.
    // *Action: Install the protocol adapter or correct typographically error,
    // as appropriate.  Note: if the supplied address was derived from
    // resolving the service name, check the address in the appropriate file
    // (TNSNAMES.ORA, LISTENER.ORA or SQLNET.ORA).
    I suspect you have multiple $ORACLE_HOME folders & more than 1 tnsnames.ora files and are using an invalid copy.
    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.

Posting Permissions

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