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

Printable View

10-14-2008, 08:05 AM
muzammil.dba

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
10-14-2008, 10:46 AM
PAVB

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?
10-17-2008, 03:05 AM
dmdunyan

Please show us output of
type sqlnet.ora

type tnsnames.ora
10-19-2008, 12:54 AM
muzammil.dba

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
10-19-2008, 03:56 AM
PAVB

Please set your ORACLE_HOME and ORACLE_SID properly
10-19-2008, 05:08 AM
hrishy

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
10-19-2008, 05:51 AM
PAVB

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?
10-19-2008, 07:22 AM
muzammil.dba

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,
10-19-2008, 08:44 AM
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,
10-19-2008, 08:44 AM
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,
10-19-2008, 08:59 AM
davey23uk

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
10-20-2008, 02:16 AM
hrishy

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
10-20-2008, 02:42 AM
PAVB

Hrishy, I have to agrre you have a point there.
10-20-2008, 09:11 AM
snipes88

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"
10-27-2008, 07:45 AM
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