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

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

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

Hrishy, I have to agrre you have a point there.

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"

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