-
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?
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.
-
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
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.
-
 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
-
 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?
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.
-
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|