Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2008
    Posts
    4

    Unanswered: TNS: protocol adapter error

    Greetings.
    I'm currently working on a project that makes use of Oracle 10g Express Edition version, it is installed in a virtual machine running Windows Server 2003 and out of the domain we work on.
    The application we are developing is a asp.net application and when we try to launch it, it gives us the error:

    System.Data.OracleClient.OracleException: ORA-12560: TNS: protocol adapter error.

    We are able to execute tnsping, we are able to connect via sqldeveloper and toad, even with a .udl file we are able to successfully establish a connection.
    We are not using tnsnames.ora to make the connection, we have it all specified in the web.config file, like this:

    <add name="SiteOracle" connectionString="User Id=eap;Password=EAP123;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1 0.50.8.38)(PORT=1521))(CONNECT_DATA=(SID=XE)));"/>

    We've already doubled checked everything, and apparently cannot find a reason why this is happening.
    So we are asking for your help to identify the problem and possibly fix it.

    Thank you.
    Kind regards.

    César Lourenço

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    http://www.orafaq.com/forum/m/378258/74940/#page_top

    post the contents of listener.ora file
    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.

  4. #4
    Join Date
    Dec 2008
    Posts
    4
    Thank you for the hint but permissions are set full control to everyone because of the error.
    We've tried this in a effort to get rid of the error.

  5. #5
    Join Date
    Dec 2008
    Posts
    4
    Here are the contents of listener.ora:

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (SID_NAME = CLRExtProc)
    (ORACLE_HOME = D:\oraclexe\app\oracle\product\10.2.0\server)
    (PROGRAM = extproc)
    )
    )

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    (ADDRESS = (PROTOCOL = TCP)(HOST = psitagmvm112)(PORT = 1521))
    )
    )

    DEFAULT_SERVICE_LISTENER = (XE)

    Thank you.

  6. #6
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    Not sure if this is a typo or cut and paste error in the posting, but there is an extra space in the HOST section copied below, but, this could cause problems if it is this way in the web.config file.:

    (HOST=1 0.50.8.38)
    ^ I believe that should be '10' and not '1 0'.

    HTH

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    please post contents of sqlnet.ora; if one exists
    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.

  8. #8
    Join Date
    Dec 2008
    Posts
    4
    sqlnet.ora content:

    # This file is actually generated by netca. But if customers choose to
    # install "Software Only", this file wont exist and without the native
    # authentication, they will not be able to connect to the database on NT.

    SQLNET.AUTHENTICATION_SERVICES = (NTS)

  9. #9
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    Can you try changing the connection string definition to the following:

    <add name="SiteOracle" connectionString="eap/EAP123@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1 0.50.8.38)(PORT=1521))(CONNECT_DATA=(SID=XE)))"/>

    I haven't worked with asp.net, but if everything inside the " " in the connection string definition gets passed to the Oracle client software, this should work. It's only a guess though, because I can't test it.


    edited to remove the ';' after the last ')'
    Last edited by buckeye234; 12-30-08 at 10:23.

Posting Permissions

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