| TNS 12560 : Problems between NT and AIX [message #66095] |
Fri, 09 November 2001 03:39  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
