VCS 4.1 with Oracle 11g R1 on SLES 10
We have the following setup:-
Basic oracle database failover from one node to another
DB : Oracle 10.2.0.4
VCS : 4.1
We upgraded the database to 11g R1 and and modified the cluster configuration path to 11g. When we tested the failover, DB failed over properly from one node to another whereas the listener was not failing over to another node.
What could be the problem, Please suggest a solution to fix it without performing any cluster software upgrade. We do not want any new features of the latest cluster software but we want the basic DB failover.
The problem is that Oracle 11g is not supported on VCS 4.1.
From the VERITAS Cluster Server Enterprise Agent 4.1 for Oracle Installation and Configuration Guide Linux - Supported Software (p8)
( https://sort.symantec.com/public/documents/sf/4.1/linux/pdf/vcs_oracle_install.pdf )
- Oracle 8.0.x, Oracle 8.1.x, Oracle9i, and Oracle 10g, including 64-bit versions
Although you mentioned you did not want to upgrade the cluster software, unfortunately there is no alternative if you want to run Oracle 11g, as the old version of VCS you are using does not support that version.
It appears support for Oracle 11gR1 was introduced in 5.0MP3
https://sort.symantec.com/public/documents/sf/5.0MP3/linux/html/vcs_oracle_install/ch01s03.htm
--------------------
Supported software
The Veritas Cluster Server agent for Oracle 5.2 supports the following software versions in a Veritas Cluster Server (VCS) environment:
Oracle Oracle9i, Oracle 10g R1, Oracle 10g R2, and Oracle 11g R1 (including 64-bit versions)
--------------------See also: Table: Supported software for the VCS agents for enterprise applications (from VCS 5.0MP3 (Linux) Release notes):
https://sort.symantec.com/public/documents/sf/5.0MP3/linux/html/vcs_notes/ch01s07s05.htm
The following tech doc may also be helpful for future releases:
TECH74389: Supported Database versions for Storage Foundations(HA) and Storage Foundations for Databases(SFDB) tools
http://www.symantec.com/business/support/index?page=content&id=TECH74389Note: have moved this thread to the Cluster Server forum instead of SFHA (VOM, VOS, SORT) as Cluster Server is more relevant/appropriate)