-
the listener is supporting services and there are no errors in the status either.
Mohit.
It's easy as long as you are on the RIGHT Track of MIND...
-
Did you use MTS setting ?
-
Unistall and reinstall the networking software.
-
It's easy as long as you are on the RIGHT Track of MIND...
-
What kind of option do you use for resolving the service name? Localnaming, hostnaming or what? How does your
NAMES.DIRECTORY_PATH looks like in your SQLNET.ORA file
on the client and on the server?
-
1) stop and restart the listener, try conection again.
2) If you use MTS (shared connection), try to use dedicated server. Listener sometime stop response to remote shared connection.
-
I think a point was overlooked.
THe TNSPING took 1300+, but worked.
Best guess is a network issue. The network is so slow the signin is timing out and assuming the server is not there.
Possible causes: 100MB network card on at 10MB network (packet loss), too many switch hops so routing slows response unacceptably..
We have seen similar problems on our network.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
sqlnet content
names.directory_path=(tnsnames,hostnames)
both places.
Mohit.
It's easy as long as you are on the RIGHT Track of MIND...
-
Originally posted by jrpm
I think a point was overlooked.
THe TNSPING took 1300+, but worked.
Best guess is a network issue. The network is so slow the signin is timing out and assuming the server is not there.
Possible causes: 100MB network card on at 10MB network (packet loss), too many switch hops so routing slows response unacceptably..
We have seen similar problems on our network.
Yes, it can be a network issue as jrpm poined out. Increase the CONNECT_TIMEOUT parameter in LISTENER.ORA. Would it help?
-
You may have a couple of problems with tnsnames.ora:
- 1. What client software you use (if old version, that use Net8 , not from 8.1.5 then you should have 2 tnsnames.ora files
- 1 in .../network/admin/tnsnames.ora
- 2 in .../net8/admin/tnsnames.ora
- 2. you may try to use 2 aliases in tnsnames.ora
- 1) db_alias1 = ... (service_name = ...)
- 2) db_alias2 = ... (sid = ...)
- 3. if you use alias with oracle domain name:
for example some client software want
full alias name:
user/pwd@aaa.bbb.ccc.db_alias
Try.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|