Home » RDBMS Server » Networking and Gateways » TNS 12560 : Problems between NT and AIX
TNS 12560 : Problems between NT and AIX [message #66095] Fri, 09 November 2001 03:39 Go to next message
Alejandro Strickler
Messages: 1
Registered: November 2001
Junior Member
Hi

We experience DB-Connection problems between NT services that run on a NT4 server and a Oracle DB that runs on an AIX server. Network and DB have been checked and are OK. The problem seems to be at the NT-side. The NT services run all day long, and only once a day (sometimes) they can't build a conection or loss it. Trace files have been studied, but without luck.
Can anybody suggest anything ?
Very thanks !

Alejandro

P.S.: In the NT servers also runs CLick Shedule, a standard software that uses mtx.exe to do his work. The connections between NT services and the DB use Micorosft for Oracle ODBC Driver and Oracle ODBC driver.

(Log file extract follows)

Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:Program FilesAUDIBinAUDI_Service_WOR.exe)(HOST=SBE5492)(USER=SVR_AUDI_SERVICE))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 - Production
Time: 09-NOV-01 08:06:50
Tracing to file: F:OracleOra81NETWORKTRACEsqltrace.trc
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: 0
nt OS err code: 0

----------------------------------------------------------------------
Re: TNS 12560 : Problems between NT and AIX [message #66100 is a reply to message #66095] Sat, 10 November 2001 00:48 Go to previous message
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
Senior Member
sir,

right click the my computer --properties--
environments--
set the following variable
in the environments there are two text boxes.
type the following

oralce_sid(type in the first text box)
orcl(type in the first text box)
click the set command button.then press ok

(orcl is the sid of your database)

that's all.
k.sreenivasan

----------------------------------------------------------------------
Previous Topic: Error while executing database link
Next Topic: Re: Oracle Networking through proxy server
Goto Forum:
  


Current Time: Tue Feb 27 20:55:29 CST 2024