HP Serviceguard Extension for SAP (SGeSAP) manual Oracle Real Application Clusters

1.The Oracle RDBMS and database tools rely on an ORA_NLS[<nls_version>] setting that refers to NLS files that are compatible to the version of the RDBMS. Oracle 9.x needs NLS files as delivered with Oracle 9.x.

2.The SAP executables rely on an ORA_NLS[<nls_version>] setting that refers to NLS files of the same versions as those that were used during kernel link time by SAP development. This is not necessarily identical to the installed database release.

The Oracle database server and SAP server might need different types of NLS files. The server NLS files are part of the database Serviceguard package. The client NLS files are installed locally on all hosts. Special care has to be taken to not mix the access paths for ORACLE server and client processes.

The discussion of NLS files has no impact on the treatment of other parts of the ORACLE client files. The following directories need to exist locally on all hosts on which an Application Server might run. They can not be relocated to different paths. The content needs to be identical to the content of the corresponding directories that are shared as part of the database SGeSAP package. The setup for these directories follows the "on top" mount approach, i.e., the directories might become hidden beneath identical copies that are part of the package:

$ORACLE_HOME/rdbms/mesg

$ORACLE_HOME/oracore/zoneinfo

$ORACLE_HOME/network/admin

Table 2-8 File System Layout for NFS-based Oracle Clusters

Mount Point	Access	Potential Owning	VG Type	Volume Group	Device Minor
	Point	Packages		Name	Number
$ORACLE_HOME	shared disk	dbci<DBSID>	db instance
/oracle/<SID>/saparch		jdb”<DBSID”	specific

/oracle/<SID>/sapreorgjdbjci<DBSID>

/oracle/<SID>/sapdata1dbcijci<DBSID>

...

/oracle/<SID>/sapdatan

/oracle/<SID>/origlogA

/oracle/<SID>/origlogB

/oracle/<SID>/mirrlogA

/oracle/<SID>/mirrlogB

/oracle/client	local	none	environment
			specific
some local Oracle client files reside in	local	none	db instance
/oracle/<SID> as part of the root			specific
filesystem

Oracle Real Application Clusters

Oracle Real Application Clusters (RAC) is an option to the Single Instance Oracle Database Enterprise Edition. Oracle RAC is a cluster database with shared cache architecture. The SAP certified solution is based on HP Serviceguard Cluster File System for RAC.

Handling of a RAC database is not included in SGeSAP itself. RAC databases are treated by SGeRAC and Oracle tools, which integrate with SGeSAP. The configuration of SGeSAP packages for non-database components is identical to non-RAC environments.

NOTE: The configurations are designed to be compliant to SAP OSS note 830982. The note describes SAP recommendations for Oracle RAC configurations. A support statement from SAP regarding RAC clusters on HP-UX can be found as part of SAP OSS note 527843. A current support statement in note 527843 is required, before any of the described RAC options can be implemented. The note maintenance is done by

28 Planning the Storage Layout