URGENT!!! Ora: Target Host Or Object Does not EXIST

[gooftrap]

the listener is supporting services and there are no errors in the status either.
Mohit.

[bill_lee]

Did you use MTS setting ?

[truma1]

Unistall and reinstall the networking software.

[gooftrap]

not using mts ...

Mohit.

[mageri]

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?

[bill_lee]

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.

[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.

[gooftrap]

sqlnet content
names.directory_path=(tnsnames,hostnames)

both places.

Mohit.

[mageri]

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?

[Shestakov]

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.