URGENT!!! Ora: Target Host Or Object Does not EXIST - Page 4
DBAsupport.com Forums - Powered by vBulletin
Page 4 of 4 FirstFirst ... 234
Results 31 to 35 of 35

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

  1. #31
    Join Date
    Nov 2000
    Posts
    21
    hi,

    you should also enter a value for SID and GLOBAL_NAME, otherwise you can't connect. If in doubt
    login to METALINK and search for tnsnames.
    regards Giddy

  2. #32
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Hi, sorry I have not read everythink but the problem do you have is , if I understood everythink correct:
    1) server machine has OS unix
    2) client machin has OS Windows
    NEVER apply configuration files from UNIX to WINDOWs and forward as they have absolutly different coding, you can't see all characters in your file but they are here, for example you cant see chr(0), chr(10), chr(13).
    So solution is: remove tnsnames.ora from your client and create new one. Using Windows tools or manualy, I had the same problem .
    Best wishes.

    Originally posted by gooftrap
    Gurus,
    i have set up my listener at client side and tnsnames.ora at client side. I am using oracle 8.1.5. Clients are installed on the client machines. When i try to connect on the server with the same instructions in tnsnames.ora as in client side, it connects. But from the client's machine, it refuses...
    Please Advice...
    Thanks,
    Mohit.
    [Edited by kgb on 09-26-2001 at 12:35 PM]

  3. #33
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    To better find the point of failure, could you check the following:

    File-name: sqlnet.ora

    Check what was your

    NAMES.DEFAULT_DOMAIN=
    SQLNET.EXPIRE_TIME=

    If you have the DOMAIN name set as world then you have to use the NAME.WORLD as a service name in your tnsnames.ora file (eg: SID.WORLD)

    Sample tnsnames.ora file on the client machine:

    SID.WORLD=
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SID = your_sid)
    )
    )

    Then try connecting as from the command prompt/dos prompt:

    sqlplus user_name/password@sid.world

    Looking forward to hear from you...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #34
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    (1)if it is nt/w2k server there can be control characters which can cause problem and they are not seen. Look for them and
    edit suitably.
    (2)the peranthesis are to be verified.. i doubt you have one right peranthesis extra.
    (3)if you have multiple listener services stop all and start the correct one.
    sonofsita
    http://www.ordba.net

  5. #35
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    havent read whole thread but check you hosts file in windows

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