+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15
  1. 10-14-2008 08:05 AM #1
    muzammil.dba
    muzammil.dba is offline Junior Member
    Join Date
    May 2008
    Posts
    95

    Exclamation 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
    Reply With Quote Reply With Quote
  2. 10-14-2008 10:46 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,488
    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.
    Reply With Quote Reply With Quote
  3. 10-17-2008 03:05 AM #3
    dmdunyan
    dmdunyan is offline Junior Member
    Join Date
    Oct 2008
    Posts
    6
    Please show us output of
    type sqlnet.ora

    type tnsnames.ora
    Reply With Quote Reply With Quote
  4. 10-19-2008 12:54 AM #4
    muzammil.dba
    muzammil.dba is offline Junior Member
    Join Date
    May 2008
    Posts
    95

    Exclamation

    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
    Reply With Quote Reply With Quote
  5. 10-19-2008 03:56 AM #5
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,488
    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.
    Reply With Quote Reply With Quote
  6. 10-19-2008 05:08 AM #6
    hrishy
    hrishy is offline Super Moderator
    Join Date
    Jan 2001
    Posts
    2,828
    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
    Reply With Quote Reply With Quote
  7. 10-19-2008 05:51 AM #7
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,488
    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?
    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.
    Reply With Quote Reply With Quote
  8. 10-19-2008 07:22 AM #8
    muzammil.dba
    muzammil.dba is offline Junior Member
    Join Date
    May 2008
    Posts
    95

    Exclamation

    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,
    Reply With Quote Reply With Quote
  9. 10-19-2008 08:44 AM #9
    muzammil.dba
    muzammil.dba is offline Junior Member
    Join Date
    May 2008
    Posts
    95

    Exclamation

    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,
    Reply With Quote Reply With Quote
  10. 10-19-2008 08:44 AM #10
    muzammil.dba
    muzammil.dba is offline Junior Member
    Join Date
    May 2008
    Posts
    95

    Exclamation

    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,
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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