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

Hi,

Please help me out to solve TNS problem in the client machine.

We have 2 instance Oracle RAC db on AIX 5L. When we are trying to tnsping its throught out the error, see below
C:\Documents and Settings\muzammil>tnsping ARIEPDB_RAC

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 14-OCT-2
008 15:51:37

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

TNSNAMES.ORA
ARIEPDB_RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.53.50.13)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.53.50.14)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(DATABASE_NAME = ariepdb)
(SERVER = DEDICATED)
(SERVICE_NAME = ariepdb_rac.world.com)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

Thanks in advance.

Regards,
dba

Do you have ORACLE_HOME and ORACLE_SID properly set in the client station?

Does that exactly TNSNAMES.ora file works when connecting from other client stations?

Please show us output of
type sqlnet.ora

type tnsnames.ora

Please see the output.

C:\Documents and Settings\muzammil>type sqlnet.ora
The system cannot find the file specified.

C:\Documents and Settings\muzammil>
C:\Documents and Settings\muzammil>
C:\Documents and Settings\muzammil>sqlnet.ora
'sqlnet.ora' is not recognized as an internal or external command,
operable program or batch file.

C:\Documents and Settings\muzammil>
C:\Documents and Settings\muzammil>tnsnames.ora
'tnsnames.ora' is not recognized as an internal or external command,
operable program or batch file.

C:\Documents and Settings\muzammil>
C:\Documents and Settings\muzammil>
C:\Documents and Settings\muzammil>type tnsnames.ora
The system cannot find the file specified.

Regards,
dba

Please set your ORACLE_HOME and ORACLE_SID properly

Quote:

---

Originally Posted by PAVB

Please set your ORACLE_HOME and ORACLE_SID properly

---

Hmm my advise would be please HIRE a oracle DBA.

regards
Hrishy

Quote:

---

Originally Posted by hrishy

Hmm my advise would be please HIRE a oracle DBA.

regards
Hrishy

---

Just because poster attempted to "run" tnsnames.ora? wasn't that cute?

Dear all,

I have add new clinet ORACLE_HOME & prod db ORACLE_SID in the client machine, but still same error.

Please help me out.

Regards,

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,

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,