| hello [message #173797] |
Wed, 24 May 2006 08:24  |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
i have 2 winxp systems:
system a has oracle9i database named orcl
from system b i can connect to system a using
isqlplus
hr/hr@orcl
i created i database named orcl1 on the system b
tried to connect using isqlplus from a to b got the error
ora-12535-time out
i created a service on database orcl1 named test
edited the tnsnames on server a no result also
plz help
|
|
|
|
| Re: hello [message #173906 is a reply to message #173797] |
Thu, 25 May 2006 03:52  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
check the content of sqlnet.ora file, if you are using local host naming (i.e. tnsnames.ora) then try to rename that file and then check if it works..also check whether tnsping works..
|
|
|
|
| Re: hello [message #173965 is a reply to message #173906] |
Thu, 25 May 2006 07:14 |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
hello
shall i rename the tnsnames.ora file ? to what..
i checked sqlnet.ora
everything is fine
i even added an entry in the tnsnames.ora for the remote database
no luck
plz help
|
|
|
|
| Re: hello [message #173970 is a reply to message #173797] |
Thu, 25 May 2006 07:26 |
maoro
Messages: 312
Registered: May 2005
|
Senior Member |
|
|
i can ping the remore server, but tnsping (servicename)
returns the same error ora-12535 time out
|
|
|
|
| Re: hello [message #173979 is a reply to message #173970] |
Thu, 25 May 2006 07:48 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
I meant, that try to rename sqlnet.ora --to anything like a.ora and retry...(idea is that sqlnet.ora is not needed )
sorry for not being very clear.
|
|
|
|
| Re: hello [message #173997 is a reply to message #173979] |
Thu, 25 May 2006 08:29 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
|
if you are getting this error , even after renaming sqlnet.ora, then it may be something that I do not know. is the listerner up in both the machines? can u post tnsnames.ora for both the servers and the listerner.ora?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
