10gR2 RAC Database Connectivity Issue
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: 10gR2 RAC Database Connectivity Issue

  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Question 10gR2 RAC Database Connectivity Issue

    Hi,
    I have built a two-node RAC database Cluster on Windows 2003. I set up a number client application servers and installed Oracle Client 10.2 to talk to a database on the cluster. Using an SQL Client connection is OK.

    However when I set up an actual application to use the cluster database I keep losing my connections. Looking at the Sqlnet.log the error it gives is
    'Fatal NI coonect error 12545'
    followed by:
    TNS-12545: Connect failed ......
    TNS-00515: Connect failed because host or object does not exist.
    When I look at the cluster database I see that some of the tables have been created. This problem did not exist with Oracle RAC 10g version 1.

    Can anyone point me in the right direction?
    Thanks
    Paul

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What does your sqlnet.ora look like? Make sure the correct sqlnet.ora file exists at OFSA location

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2006
    Posts
    2
    Quote Originally Posted by sambavan
    What does your sqlnet.ora look like? Make sure the correct sqlnet.ora file exists at OFSA location

    Thanx,
    Sam
    Thanks Sam,

    Problem was in another area.

    Turning on SqlNet trace, pointed to the fact that SQLNET was trying to resolve the other cluster nodes name. But because our DMZ was using external DNS it could not be resolved.
    The solution was to create a hosts file on the server, containing the virtual and phyical IPs.

    Thanks for help

    Regards Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width