Strange TNS problem

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Demetris
    #1

    Strange TNS problem

    Hello there.
    I have ORACLE 8.1.7.4 server on AIX 5.1.
    I have another server (BIZTALK) with Oracle client 8.1.7.
    The system is running ok. I can connect from the client on my database
    server just fine.
    However at certain stages we get the error below when it tries to open
    a connection.Plea se note that we are loading 150,000 records currently
    and we open / close a connection for every call.

    ORA-12154: TNS:could not resolve service name
    - at System.Data.Ora cleClient.Oracl eException.Chec k(OciHandle
    errorHandle, Int32 rc)
    at System.Data.Ora cleClient.Oracl eInternalConnec tion.OpenOnLoca lTransaction(St ring
    userName, String password, String serverName, Boolean
    integratedSecur ity, Boolean unicode)
    at System.Data.Ora cleClient.Oracl eInternalConnec tion.Open(Objec t
    transact)
    at System.Data.Ora cleClient.Oracl eConnection.Ope nInternal(Oracl eConnectionStri ng
    parsedConnectio nString, Object transact)
    at System.Data.Ora cleClient.Oracl eConnection.Ope n()
    at BiztalkAIC.Bizt alkAIC.LaikiToB YNXRequest_AIC( XmlDocument doc)
    at BiztalkAIC.Bizt alkAIC.ProcessM essage(String strDocument)
    [0x0159] The server encountered a transport error while processing
    the messaging port "Mainframe To Bynx", which uses a transport
    component with a ProgID of "BiztalkAIC.Biz talkAIC".

    [0x012b] A transmission attempt failed.

    Do you have any idea how to troubleshoot this?

    Thank you
    Tags: None
    • Jim Kennedy
      #2
      Re: Strange TNS problem

      You open and close a connection on every call? Hopefully, you are using
      some sort of connection pooling or you are creating a massive performance
      problem. Try connecting with sqlplus. Looks like your tnsnames.ora file
      does not have the right stuff in it.
      Jim
      "Demetris" <DMina@laiki.co mwrote in message
      news:c5285638.0 312090400.20165 82c@posting.goo gle.com...
      Hello there.
      I have ORACLE 8.1.7.4 server on AIX 5.1.
      I have another server (BIZTALK) with Oracle client 8.1.7.
      The system is running ok. I can connect from the client on my database
      server just fine.
      However at certain stages we get the error below when it tries to open
      a connection.Plea se note that we are loading 150,000 records currently
      and we open / close a connection for every call.
      >
      ORA-12154: TNS:could not resolve service name
      - at System.Data.Ora cleClient.Oracl eException.Chec k(OciHandle
      errorHandle, Int32 rc)
      at
      System.Data.Ora cleClient.Oracl eInternalConnec tion.OpenOnLoca lTransaction(St r
      ing
      userName, String password, String serverName, Boolean
      integratedSecur ity, Boolean unicode)
      at System.Data.Ora cleClient.Oracl eInternalConnec tion.Open(Objec t
      transact)
      at
      System.Data.Ora cleClient.Oracl eConnection.Ope nInternal(Oracl eConnectionStri n
      g
      parsedConnectio nString, Object transact)
      at System.Data.Ora cleClient.Oracl eConnection.Ope n()
      at BiztalkAIC.Bizt alkAIC.LaikiToB YNXRequest_AIC( XmlDocument doc)
      at BiztalkAIC.Bizt alkAIC.ProcessM essage(String strDocument)
      [0x0159] The server encountered a transport error while processing
      the messaging port "Mainframe To Bynx", which uses a transport
      component with a ProgID of "BiztalkAIC.Biz talkAIC".
      >
      [0x012b] A transmission attempt failed.
      >
      Do you have any idea how to troubleshoot this?
      >
      Thank you

        Comment

        • Demetris
          #3
          Re: Strange TNS problem

          "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message news:<VZlBb.346 556$275.1142660 @attbi_s53>...
          You open and close a connection on every call? Hopefully, you are using
          some sort of connection pooling or you are creating a massive performance
          problem. Try connecting with sqlplus. Looks like your tnsnames.ora file
          does not have the right stuff in it.
          Jim
          Connecting through sqlplus is fine. I tried it and it works. Any other ideas?

            Comment

            Previous template Next
            Working...