DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: TNS-03505: Failed to resolve name, ORA-12545: Connect failed because target host or

  1. #11
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by muzammil.dba
    Dear all,

    my db is on Oracle 10g RAC. plz. see following SID's.

    ORACLE_SID=arpdb1 (Node1)
    ORACLE_SID=arpdb2 (Node2)

    db_name=aripdb

    please help, hw to set both SID in same invironment.

    Best Regards,
    what?? how to set sid??? you have already done that - hore a dba, you are a danger

  2. #12
    Join Date
    Jan 2001
    Posts
    2,828
    Quote Originally Posted by PAVB
    Just because poster attempted to "run" tnsnames.ora? wasn't that cute?
    Hi Pavb

    No offence but people before asking a question and after receiving a reply should put in some effort from thier end .

    Sometimes i have too dot net and sometimes storeage but i put in more effort as those are not my feilds before asking a question on a forum.

    There are many people here who come and ask on hwo to recover a database or my datafile is lost for such folks i would advise them to HIRE a dba.

    regards
    Hrishy

  3. #13
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Hrishy, I have to agrre you have a point there.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #14
    Join Date
    Oct 2008
    Location
    Johannesburg,South Africa
    Posts
    3

    Talking

    Quote Originally Posted by PAVB
    Just because poster attempted to "run" tnsnames.ora? wasn't that cute?

    hehehehe.... dude, to set your ORACLE_HOME and ORACLE_SID on windows:

    c:\> set ORACLE_SID=
    c:\> set ORACLE_HOME=

    ... to check the environment ...

    c:\> set ora


    ... remember these settings will be lost when you close your command prompt window....


    to set it permanently, set it in the advanced properties on "My Computer"

  5. #15
    Join Date
    May 2008
    Posts
    95

    Thumbs up

    Dear Friends,

    Thanks for support. now my tnsping is working fine on Oracle RAC DB with 2 instance.

    simply I added below path in sqlnet.ora file with same tnsnames.ora.

    NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, EZCONNECT, ONAMES, HOSTNAME)

    Once again thanks for given time.

    Best Regards,
    dba

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