- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: how to configure IPs for ServiceGuard with RAC
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 06:12 AM
тАО04-14-2005 06:12 AM
They run a 9.2 Oracle RAC database used for Oracle Portal
So I've 1 package per node running 1 RAC instance with it's associated IP and of course those packages do not failover
Our DBA has just shown me a metalink note explaining that the IP address of each RAC instance must failover on the other node and keep answering !!!!
Of course I can do another actual failover package just for the IP address but I wanted to ask you how you've configured it ?
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-14-2005 12:51 PM
тАО04-14-2005 12:51 PM
SolutionIf you read Using Serviguard Extension for RAC, page 23, you will see a picture talking about using a package for just starting up the listener in each box and in case of node failure, this package with the listener will start up in the other node and all clients will re-connect in this node, using the other instance.
I├В┬┤ve never used this kind of configuration, I prefer to use TAF in client, because, when you reconnect in the listener, you will lose your session, right? And in TAF mode, depending on the type of session that your are running, you will not.
But, in both cases, you must have two ip addresses to the listeners...
And you must configure a lan to the Oracle RAC heartbeat (cache fusion), because the traffic between this two nodes will be high.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-15-2005 02:10 AM
тАО04-15-2005 02:10 AM
Re: how to configure IPs for ServiceGuard with RAC
However I'm surprised to see that TAF is working for you because our DBA has shown me that TAF doesn't really work if 1 IP is down.
So now I wonder if the problem is to associate IP to another listener package that actually failover or if the problem comes from TAF.
I've checked tnsnames.ora & listener.ora (see file in attachment) but I'm not dba
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-15-2005 11:57 AM
тАО04-15-2005 11:57 AM
Re: how to configure IPs for ServiceGuard with RAC
Why are you surprised for TAF to work with one ip down?
TAF works even without RAC, you can setup this for "normal" instances.
By the way, your tnsnames seems to be ok.
This is a sql to verify what connections you have and what kind these are:
. connect in sqlplus as system
> column machine format a20
> select machine,failover_type,failover_method,failed_over,count(*) from v$session
> group by machine,failover_type,failover_method,failed_over;
The column count(*) will show you how many times this session was failed over.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2005 01:21 AM
тАО04-18-2005 01:21 AM
Re: how to configure IPs for ServiceGuard with RAC
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=284716.1
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=97926.1 (par 4.1)
I think, that's why HP has added that note you was talking about Julio
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2005 01:32 AM
тАО04-18-2005 01:32 AM
Re: how to configure IPs for ServiceGuard with RAC
75 seconds is an unacceptable time...
My configuration is not using that a package with a listener and the failover time is about instantaneous (less than 2 seconds, in fact).
Probably you have some issue in configuration.
That tnsnames.ora that you send is from your servers or from your client?
What about your rac heartbeat (not SG heartbeat), how is this configured?
What kind of servers are you using?
About the lan cards, what type of interfaces are you using?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2005 03:17 AM
тАО04-18-2005 03:17 AM
Re: how to configure IPs for ServiceGuard with RAC
This is not the failover time of any package. 75 sec is the time the client (tnsping or sql select) takes before answering as soon as 1 of the 2 IPs is down.
Here's another metalink note that explains very well the issue :
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=249213.1
Here's a small extract :
"What is happening is that the TCP Protocol is timing out at the OS / Network layer.
It can be shown that it is not only Oracle that is experiencing this failover slowness,
but other tools as well."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-18-2005 11:46 AM
тАО04-18-2005 11:46 AM
Re: how to configure IPs for ServiceGuard with RAC
I read this metalink notes, but, see:
1. This timeout is only when you have a single ip address, no TAF
2. If you have TAF, oracle client won├В┬┤t wait for this timeout and try to reconnect to the other(s) nodes of the tnsnames.ora configuration
So, TCP/IPC timeout doesn├В┬┤t explain this long time.
I say again that you have some issue in your client configurati
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-19-2005 05:05 AM
тАО04-19-2005 05:05 AM
Re: how to configure IPs for ServiceGuard with RAC
Thank's a lot for your help. I'm putting the listeners and their VIP in packages as quoted in HP doc