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

[davey23uk]

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

[hrishy]

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

[PAVB]

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

[snipes88]

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"

[muzammil.dba]

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