| Not able to connect to Oracle [message #122263] |
Sat, 04 June 2005 08:35  |
abc123
Messages: 24
Registered: March 2005
Location: sa
|
Junior Member |
|
|
I am able to connect to local oracle database using sqlplus,but not with T.O.A.D.Although T.O.A.D. does connect to other remote DB.
Also my VB application is giving same error:
ORA-12535TNS:TNS:operation timed out
My sqlnet.log file reads:
Fatal NI connect error 12203, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROT OCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Toad\TOAD.exe)(HOST=ABC-KQ0C05GD3R4)(USER=XYZ))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.0.6.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.6.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.0.6.0.0 - Production
Time: 01-JAN-05 19:21:20
Tracing not turned on.
Tns error struct:
nr err code: 12203
TNS-12203: TNS:unable to connect to destination
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
Why is this odd behaviour.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
