Please enter search query.
Search <book_title>...
Cluster Server 8.0.2 Agent for Oracle Installation and Configuration Guide - Solaris
Last Published:
2024-01-09
Product(s):
InfoScale & Storage Foundation (8.0.2)
Platform: Solaris
- Introducing the Cluster Server agent for Oracle
- About the Cluster Server agent for Oracle
- About the agent for Oracle ASM
- Supported software for VCS agent for Oracle
- How the agent makes Oracle highly available
- About Cluster Server agent functions for Oracle
- Oracle agent functions
- Startup and shutdown options for the Oracle agent
- Monitor options for the Oracle agent in traditional database and container database
- Startup and shutdown options for the pluggable database (PDB)
- Monitor for the pluggable database
- Recommended startup modes for pluggable database (PDB) based on container database (CDB) startup modes
- How the agent handles Oracle error codes during detail monitoring
- Info entry point for Cluster Server agent for Oracle
- Action entry point for Cluster Server agent for Oracle
- How the Oracle agent supports health check monitoring
- Netlsnr agent functions
- ASMInst agent functions
- ASMDG agent functions
- Oracle agent functions
- Typical Oracle configuration in a VCS cluster
- About setting up Oracle in a VCS cluster
- Installing and configuring Oracle
- About installing Oracle in a VCS environment
- Before you install Oracle in a VCS environment
- About VCS requirements for installing Oracle
- About Oracle installation tasks for VCS
- Installing ASM binaries in a VCS environment
- Configuring Oracle ASM on the first node of the cluster
- Configuring and starting up ASM on remaining nodes
- Installing Oracle binaries on the first node of the cluster
- Configuring the Oracle database
- Copying the $ORACLE_BASE/admin/SID directory
- Copying the Oracle ASM initialization parameter file
- Verifying access to the Oracle database
- Installing and removing the agent for Oracle
- Configuring VCS service groups for Oracle
- About configuring a service group for Oracle
- Configuring Oracle instances in VCS
- Before you configure the VCS service group for Oracle
- Configuring the VCS service group for Oracle
- Administering VCS service groups for Oracle
- Pluggable database (PDB) migration
- Troubleshooting Cluster Server agent for Oracle
- About troubleshooting Cluster Server agent for Oracle
- Error messages common to the Oracle and Netlsnr agents
- Error messages specific to the Oracle agent
- Error messages specific to the Netlsnr agent
- Error messages specific to the ASMInst agent
- Error messages specific to the ASMDG agent
- Troubleshooting issues specific to Oracle in a VCS environment
- Verifying the Oracle health check binaries and intentional offline for an instance of Oracle
- Disabling IMF for a PDB resource
- Appendix A. Resource type definitions
- Appendix B. Sample configurations
- About the sample configurations for Oracle enterprise agent
- Sample single Oracle instance configuration
- Sample multiple Oracle instances (single listener) configuration
- Sample multiple instance (multiple listeners) configuration
- Sample Oracle configuration with shared server support
- Sample Oracle ASM configurations
- Sample configuration of Oracle pluggable database (PDB) resource in main.cf
- Sample configuration of migratable Oracle pluggable database (PDB) resource in main.cf
- Sample Configuration of Oracle supported by systemD
- Sample configuration of ASMInst supported by systemD
- Appendix C. Best practices
- Appendix D. Using the SPFILE in a VCS cluster for Oracle
- Appendix E. OHASD in a single instance database environment
Sample VCS configuration file for single Oracle instance
Review the sample configuration with a resource of type Oracle that is configured as follows in main.cf file.
Note:
The following sample main.cf uses Solaris SPARC examples for NIC devices. For example, replace the example NIC device from hme0 to bge0 on Solaris x64.
include "types.cf"
include "OracleTypes.cf"
cluster vcs (
)
system sys1 (
)
system sys2 (
)
group ORA_PROD_Group (
SystemList = { sys1 = 0, sys2 = 1 }
AutoStartList = { sys1 }
)
DiskGroup DG_oraprod (
DiskGroup = ora_prod_dg
StartVolumes = 0
StopVolumes = 0
)
IP IP_oraprod (
Device = hme0
Address = "192.168.1.22"
Netmask = "255.255.255.0"
)
Mount Mount_oraprod_u01 (
MountPoint = "/prod/u01"
BlockDevice = "/dev/vx/dsk/ora_prod_dg/u01-vol"
FSType = vxfs
FsckOpt = "-n"
)
Mount Mount_oraprod_u02 (
MountPoint = "/prod/u02"
BlockDevice = "/dev/vx/dsk/ora_prod_dg/u02-vol"
FSType = vxfs
FsckOpt = "-n"
)
NIC NIC_oraprod (
Device = hme0
NetworkHosts = {"192.168.1.1"}
)
Netlsnr LSNR_oraprod_lsnr (
Owner = oraprod
Home = "/orahome/Oracle"
TnsAdmin = "/orahome/Oracle/network/admin"
Listener = LISTENER_PROD
MonScript = "./bin/Netlsnr/LsnrTest.pl"
LsnrPwd = cqfOdoOolOo
)
Oracle ORA_oraprod (
Sid = PROD
Owner = oraprod
Home = "/orahome/Oracle"
EnvFile = "/tmp/env.sh"
MonScript = "./bin/Oracle/SqlTest.pl"
User = thor
Pword = hvlTptWvj DBAUser = "orauser"
DBAPword = "DPSrFPeRIrGPiRF" Table = thor
MonitorOption = 0
)
Volume Vol_oraprod_vol1 (
Volume = u01-vol
DiskGroup = ora_prod_dg
)
Volume Vol_oraprod_vol2 (
Volume = u02-vol
DiskGroup = ora_prod_dg
)
IP_oraprod requires NIC_oraprod
LSNR_oraprod_lsnr requires IP_oraprod
LSNR_oraprod_lsnr requires ORA_oraprod
Mount_oraprod_u01 requires Vol_oraprod_vol1
Mount_oraprod_u02 requires Vol_oraprod_vol2
ORA_oraprod requires Mount_oraprod_u01
ORA_oraprod requires Mount_oraprod_u02
Vol_oraprod_vol1 requires DG_oraprod
Vol_oraprod_vol2 requires DG_oraprod