URGENT!!! Ora: Target Host Or Object Does not EXIST - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 4 FirstFirst 1234 LastLast
Results 21 to 30 of 35

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

  1. #21
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    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...

  2. #22
    Join Date
    Apr 2001
    Posts
    20
    Did you use MTS setting ?

  3. #23
    Join Date
    May 2001
    Location
    Cape Town, South Africa
    Posts
    52
    Unistall and reinstall the networking software.

  4. #24
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    not using mts ...

    Mohit.
    It's easy as long as you are on the RIGHT Track of MIND...

  5. #25
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    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?

  6. #26
    Join Date
    Apr 2001
    Posts
    20
    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.

  7. #27
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    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'

  8. #28
    Join Date
    Aug 2001
    Location
    INDIA
    Posts
    28
    sqlnet content
    names.directory_path=(tnsnames,hostnames)

    both places.

    Mohit.
    It's easy as long as you are on the RIGHT Track of MIND...

  9. #29
    Join Date
    Sep 2001
    Location
    SWEDEN
    Posts
    70
    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?

  10. #30
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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
  •  



Click Here to Expand Forum to Full Width