×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

MTS and Oracle (Again !!!)

MTS and Oracle (Again !!!)

MTS and Oracle (Again !!!)

(OP)
Hello all,

We have the following setup.

NT Server running MTS talking to Oracle 8 on Unix We have followed the Microsoft Technet document to the letter regarding MTS talking to Oracle, including reapplying the service pack and option pack.


Twice a day (at least) we get the following error written to the SQLNET.log on our MTS server. This causes an Oracle process on the Unix box to hit 100% processor utilisation and the only resolution is to kill the process which we have now set up automation to do. No errors are reported to NT event log and all performance monitoring shows normal behaviour.

Fatal NI connect error 12560, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\WINNT\System32\mtx.exe)(HOST=PROCENARCMTS01)(USER=Administrator))))

  VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.7.2.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.2.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.2.0 - Production
  Time: 30-JAN-2002 10:07:13
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error
    ns secondary err code: 0
    nt main err code: 530
    TNS-00530: Protocol adapter error
    nt secondary err code: 126
    nt OS err code: 0

Any ideas/experiences of anything similar would be appreciated especially from Oracle DBAs who have experienced problems getting MTS and Oracle to work.

Thanks

RE: MTS and Oracle (Again !!!)

TNS-00126 Missing Connection Manager name and address in TNSNET.ORA

   Cause: The Interchange name specified in INTCHG.ORA is not defined in the TNSNET.ORA file.

   Action: Define one Connection Manager name and set of addresses for each Interchange in the network. Regenerate the configuration files.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close