TNS 12545 urgent !!

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

    TNS 12545 urgent !!

    I have my Oracle 9i database running on my XP box. I can connect to it
    from Solaris 5.8. I am able to connect from sqlplus. But during a
    install, script is not able to establish connection. My sqlnet.log

    Fatal NI connect error 12545, connecting to:
    (DESCRIPTION=(A DDRESS=(PROTOCO L=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=o racle)(ARGS='(D ESCRIPTION=
    (LOCAL=YES)(ADD RESS=(PROTOCOL= beq)))')(DETACH =NO))(CONNECT_D ATA=(CID=(PROGR AM=)(HOST=salvo )(USER=deepak)) ))

    VERSION INFORMATION:
    TNS for Solaris: Version 8.1.5.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for Solaris: Version
    8.1.5.0.0 - Production
    Time: 24-NOV-03 18:41:38
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12545
    TNS-12545: Connect failed because target host or object does not
    exist
    ns secondary err code: 12560
    nt main err code: 515
    TNS-00515: Connect failed because target host or object does not
    exist
    nt secondary err code: 2
    nt OS err code: 0

    I can connect using sqlplus from both XP and solaris. That means ip,
    port, username, password, SID, service name, etc. are correct. Also
    this means my listener and service are running fine on XP. Does the
    log point to any potential problems?
    Tags: tnsnames_admin
    • Frank
      #2
      Re: TNS 12545 urgent !!

      Deepak wrote:
      [color=blue]
      > I have my Oracle 9i database running on my XP box. I can connect to it
      > from Solaris 5.8. I am able to connect from sqlplus. But during a
      > install, script is not able to establish connection. My sqlnet.log
      >
      > Fatal NI connect error 12545, connecting to:
      > (DESCRIPTION=(A DDRESS=(PROTOCO L=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=o racle)(ARGS='(D ESCRIPTION=
      > (LOCAL=YES)(ADD RESS=(PROTOCOL= beq)))')(DETACH =NO))(CONNECT_D ATA=(CID=(PROGR AM=)(HOST=salvo )(USER=deepak)) ))
      >
      > VERSION INFORMATION:
      > TNS for Solaris: Version 8.1.5.0.0 - Production
      > Oracle Bequeath NT Protocol Adapter for Solaris: Version
      > 8.1.5.0.0 - Production
      > Time: 24-NOV-03 18:41:38
      > Tracing not turned on.
      > Tns error struct:
      > nr err code: 0
      > ns main err code: 12545
      > TNS-12545: Connect failed because target host or object does not
      > exist
      > ns secondary err code: 12560
      > nt main err code: 515
      > TNS-00515: Connect failed because target host or object does not
      > exist
      > nt secondary err code: 2
      > nt OS err code: 0
      >
      > I can connect using sqlplus from both XP and solaris. That means ip,
      > port, username, password, SID, service name, etc. are correct. Also
      > this means my listener and service are running fine on XP. Does the
      > log point to any potential problems?[/color]

      You use BEQ - that's a local protocol (e.g. will only work
      on the solaris box).
      Do NOT set the SID in the Solaris environment (which you didn't)
      and use a tns alias in the connect string.

      Your script is wrong, and does a connect or something similar,
      without a connect string
      --
      Regards, Frank van Bortel

        Comment

        • Hans Forbrich
          #3
          Re: TNS 12545 urgent !!

          One common problem - does the ODBC know about the TNSNAMES? In other
          words, are you using the same TNSNAMES file for ODBC as you are for
          SQL*Plus?

          Are there multiple homes? Was the ODBC driver installed into/linked
          with an Oracle_home whose TNSNAMES works? Does that ODBC driver
          undrstand the TNSNAMES_ADMIN variable?

          (I haven't looked at 8.1.5 in a donkey's age. Consider upgrading to one
          that's supported if possible!)

            Comment

            • Frank
              #4
              Re: TNS 12545 urgent !!

              Deepak wrote:
              [color=blue]
              > I have my Oracle 9i database running on my XP box. I can connect to it
              > from Solaris 5.8. I am able to connect from sqlplus. But during a
              > install, script is not able to establish connection. My sqlnet.log
              >
              > Fatal NI connect error 12545, connecting to:
              > (DESCRIPTION=(A DDRESS=(PROTOCO L=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=o racle)(ARGS='(D ESCRIPTION=
              > (LOCAL=YES)(ADD RESS=(PROTOCOL= beq)))')(DETACH =NO))(CONNECT_D ATA=(CID=(PROGR AM=)(HOST=salvo )(USER=deepak)) ))
              >
              > VERSION INFORMATION:
              > TNS for Solaris: Version 8.1.5.0.0 - Production
              > Oracle Bequeath NT Protocol Adapter for Solaris: Version
              > 8.1.5.0.0 - Production
              > Time: 24-NOV-03 18:41:38
              > Tracing not turned on.
              > Tns error struct:
              > nr err code: 0
              > ns main err code: 12545
              > TNS-12545: Connect failed because target host or object does not
              > exist
              > ns secondary err code: 12560
              > nt main err code: 515
              > TNS-00515: Connect failed because target host or object does not
              > exist
              > nt secondary err code: 2
              > nt OS err code: 0
              >
              > I can connect using sqlplus from both XP and solaris. That means ip,
              > port, username, password, SID, service name, etc. are correct. Also
              > this means my listener and service are running fine on XP. Does the
              > log point to any potential problems?[/color]

              You use BEQ - that's a local protocol (e.g. will only work
              on the solaris box).
              Do NOT set the SID in the Solaris environment (which you didn't)
              and use a tns alias in the connect string.

              Your script is wrong, and does a connect or something similar,
              without a connect string
              --
              Regards, Frank van Bortel


                Comment

                Previous template Next
                Working...