|
Oracle9i Database Certified Configuration Installation Guide
Release 2 (9.2.0.2) for Solaris Operating Environment (SPARC 64-bit) Part No. B12103-02 |
|
|
|
|
This appendix contains single-instance and Real Application Clusters sample output files . The following samples are included:
Hardware and Software Compliance with Oracle9i Database Certified Configuration for Single-instance
Oracle9i Database Certified Configuration Single-instance Prior to Image Restoration
Oracle9i Database Certified Configuration Real Application Clusters Prior to Image Restoration
Oracle9i Database Certified Configuration Single-instance after Reconfiguration
Oracle9i Database Certified Configuration Real Application Clusters after Reconfiguration
Oracle9i Database Certified Configuration Single-instance Cloning Log
This section includes sample output from the ocheck tool for a single-instance using the following command. The command is run by the user to verify the suitability of the system hardware and operating system for installation of Oracle products.
ocheck -product rdbms -system
The following is the output from the command:
ocheck 3.7b (library C313b/S37) 09-Oct-2003 07:15:18 PDT
system: passlod3.us.oracle.com (TEST1) RDBMS "system" check
Check Value Expected Status
Processors and Memory
CPU count 4 >= 2 pass
Processor speed (minimum) 450 MHz >= 400 MHz pass
Processor power factor 1800 >= 800 pass
Physical memory (RAM) 4096 MB >= 2048 MB pass
Operating System and Software Configuration
OS version 5.8 == 5.8,5.9 pass
64-bit applications supported == supported pass
Required OS patch 108528-16 installed == installed pass
-- 108528-22 found
Filesystem size: / 8294 MB >= 8294 MB pass
Filesystem size: /oem 2048 MB >= 921 MB pass
Filesystem size: /admin 4096 MB >= 3686 MB pass
Total swap space 8002 MB >= 4096 MB pass
Available virtual memory 9934 MB >= 4096 MB pass
Executable "/bin/ksh" installed == installed pass
Executable "bc" installed == installed pass
Program "gunzip" version 1.3.5 >= 1.3 pass
-- gunzip 1.3.5 found under /usr/local/bin
Network
Number of network interfaces 4 >= 2 pass
End of Report
This section includes sample log for the ocheck tool using the following command. This command is run by the user to verify the suitability of the system hardware and operating system for installation of Oracle products.
ocheck -product rac -system
The following is the output from the command:
ocheck 3.7b (library C313b/S37) 09-Oct-2003 03:04:25 PDT
system: passlod3.us.oracle.com (TEST) RAC "system" check
Check Value Expected Status
Processors and Memory
CPU count 4 >= 2 pass
Processor speed (minimum) 450 MHz >= 400 MHz pass
Processor power factor 1800 >= 800 pass
Physical memory (RAM) 4096 MB >= 2048 MB pass
Operating System and Software Configuration
OS version 5.8 == 5.8,5.9 pass
64-bit applications supported == supported pass
Required OS patch 108528-16 installed == installed pass
-- 108528-22 found
Required OS patch 110648-20 installed == installed pass
Filesystem size: / 8294 MB >= 8294 MB pass
Filesystem size: /oem 2048 MB >= 921 MB pass
Filesystem size: /admin 4096 MB >= 3686 MB pass
Total swap space 8002 MB >= 4096 MB pass
Available virtual memory 9973 MB >= 4096 MB pass
Executable "/bin/ksh" installed == installed pass
Executable "bc" installed == installed pass
Program "gunzip" version 1.3.5 >= 1.3 pass
-- gunzip 1.3.5 found under /usr/local/bin
Network
Number of network interfaces 4 >= 4 pass
End of Report
This section includes sample output from the ocheck tool for a single-instance using the following command. This command is run by the dbcc_image.sh script prior to an image restoration.
ocheck -product rdbms -preimage -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/S37) 09-Oct-2003 07:14:08 PDT
system: passlod3.us.oracle.com (TEST1) RDBMS "preimg" check
Check Value Expected Status
Processors and Memory
CPU count 4 >= 2 pass
Processor speed (minimum) 450 MHz >= 400 MHz pass
Processor power factor 1800 >= 800 pass
Physical memory (RAM) 4096 MB >= 2048 MB pass
Operating System and Software Configuration
OS version 5.8 == 5.8,5.9 pass
64-bit applications supported == supported pass
Required OS patch 108528-16 installed == installed pass
-- 108528-22 found
Filesystem size: / 8294 MB >= 8294 MB pass
Filesystem size: /oem 2048 MB >= 921 MB pass
Filesystem size: /admin 4096 MB >= 3686 MB pass
Filesystem size: /test1/oracle 9216 MB >= 8294 MB pass
Free disk space in /test1/oracle 5120 MB >= 5120 MB pass
Total swap space 8002 MB >= 4096 MB pass
Available virtual memory 9934 MB >= 4096 MB pass
Filesystem mount options (UFS) logging == logging pass
Executable "/bin/ksh" installed == installed pass
Executable "bc" installed == installed pass
Program "gunzip" version 1.3.5 >= 1.3 pass
-- gunzip 1.3.5 found under /usr/local/bin
Accounts and Groups
Group "dbtest1" configured == configured pass
User account "ortest1" configured == configured pass
Home directory for "ortest1" configured == configured pass
User "ortest1" groups configured == configured pass
Network
Number of network interfaces 4 >= 2 pass
Public network UP == UP pass
Data Storage
Filesystem size: /test1/oradata/ 9216 MB >= 8294 MB pass
-- directory "/test1/oradata/data01" is not a separate filesystem
Filesystem opts: /test1/oradata/ configured == configured pass
End of Report
This section includes sample log from the ocheck tool for a Real Application Clusters using the following command:
ocheck -product rac -preimage -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/S37) 09-Oct-2003 03:03:17 PDT
system: passlod3.us.oracle.com (TEST) RAC "preimg" check
Check Value Expected Status
Processors and Memory
CPU count 4 >= 2 pass
Processor speed (minimum) 450 MHz >= 400 MHz pass
Processor power factor 1800 >= 800 pass
Physical memory (RAM) 4096 MB >= 2048 MB pass
Operating System and Software Configuration
OS version 5.8 == 5.8,5.9 pass
64-bit applications supported == supported pass
Required OS patch 108528-16 installed == installed pass
-- 108528-22 found
Required OS patch 110648-20 installed == installed pass
Filesystem size: / 8294 MB >= 8294 MB pass
Filesystem size: /oem 2048 MB >= 921 MB pass
Filesystem size: /admin 4096 MB >= 3686 MB pass
Filesystem size: /test/oracle 9216 MB >= 8294 MB pass
Free disk space in /test/oracle 6177 MB >= 5120 MB pass
Total swap space 8002 MB >= 4096 MB pass
Available virtual memory 9971 MB >= 4096 MB pass
Filesystem mount options (UFS) logging == logging pass
Executable "/bin/ksh" installed == installed pass
Executable "bc" installed == installed pass
Program "gunzip" version 1.3.5 >= 1.3 pass
-- gunzip 1.3.5 found under /usr/local/bin
Accounts and Groups
Group "dbtest" configured == configured pass
User account "ortest" configured == configured pass
Home directory for "ortest" configured == configured pass
User "ortest" groups configured == configured pass
Network
Number of network interfaces 4 >= 4 pass
Private network UP == UP pass
Public network UP == UP pass
Data Storage
Filesystem size: /test/oradata/ 9216 MB >= 8294 MB pass
-- directory "/test/oradata/data01" is not a separate filesystem
Filesystem opts: /test/oradata/ configured == configured pass
Remote Access
Remote shell access no permission == accessible warn
-- could not check remote access for user root (current user: ortest)
Node time synchronization synchronized == synchronized pass
-- nodes: passlod3.us.oracle.com passlod4.us.oracle.com
Volume manager VRTSvxvm installed == installed pass
-- VERSION: 3.1,REV=07.21.2000.07.59
Package ORCLudlm installed == installed pass
Package SUNWcvm installed == installed pass
Package SUNWcvmr installed == installed pass
Package SUNWscucm installed == installed pass
Package SUNWudlm installed == installed pass
Package SUNWudlmr installed == installed pass
Clusterware running yes == yes pass
-- Version : 3.0
End of Report
This section includes sample log from the ocheck tool for a single-instance using the following command:
ocheck -product rdbms -postconfig -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/S37) 09-Oct-2003 07:13:47 PDT
system: passlod3.us.oracle.com (TEST1) RDBMS "postconf" check
Check Value Expected Status
Oracle services
ORACLE_HOME variable set set pass
-- ORACLE_HOME = /test1/oracle/product/920
ORACLE_SID variable set set pass
-- ORACLE_SID = TEST1
Valid ORACLE_HOME configured configured pass
Oracle Listener running running pass
TNS ping (TEST1) succeeded succeeded pass
SQL*Plus connection succeeded succeeded pass
Oracle SNMP Agent running running pass
End of Report
This section includes sample log from the ocheck tool for a Real Application Clusters using the following command:
ocheck -product rac -postconfig -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/S37) 09-Oct-2003 03:02:35 PDT
system: passlod3.us.oracle.com (TEST) RAC "postconf" check
Check Value Expected Status
Oracle services
ORACLE_HOME variable set set pass
-- ORACLE_HOME = /test/oracle/product/920
ORACLE_SID variable set set pass
-- ORACLE_SID = TEST1
Valid ORACLE_HOME configured configured pass
Oracle Listener running running pass
TNS ping (TEST) succeeded succeeded pass
SQL*Plus connection succeeded succeeded pass
Oracle SNMP Agent running running pass
Global Services Daemon (GSD) running running pass
Active instance check rac enabled (2) rac enabled pass
-- instances: (passlod3.us.oracle.com:TEST1 passlod4.us.oracle.com:TEST2)
End of Report
This section includes a sample log after successfully running the reconfig.sh script for a cold backup.
ocheck 3.7b (library C313b/S37) 09-Oct-2003 07:14:53 PDT
system: passlod3.us.oracle.com (TEST1) RDBMS "reconf" check
Check Value Expected Status
Processors and Memory
CPU count 4 >= 2 pass
Processor speed (minimum) 450 MHz >= 400 MHz pass
Processor power factor 1800 >= 800 pass
Physical memory (RAM) 4096 MB >= 2048 MB pass
Operating System and Software Configuration
OS version 5.8 == 5.8,5.9 pass
64-bit applications supported == supported pass
Required OS patch 108528-16 installed == installed pass
-- 108528-22 found
Total swap space 8002 MB >= 4096 MB pass
Available virtual memory 9934 MB >= 4096 MB pass
Kernel parameter "SHMMAX" 4 GB >= 4 GB pass
Kernel parameter "SHMMIN" 1 >= 1 pass
Kernel parameter "SHMMNI" 512 >= 100 pass
Kernel parameter "SHMSEG" 150 >= 10 pass
Kernel parameter "SEMMNI" 300 >= 100 pass
Kernel parameter "SEMMSL" 300 >= 256 pass
Kernel parameter "SEMMNS" 10000 >= 1024 pass
Kernel parameter "SEMOPM" 110 >= 100 pass
Kernel parameter "SEMVMX" 32767 >= 32767 pass
Filesystem mount options (UFS) logging == logging pass
Executable "/bin/ksh" installed == installed pass
Executable "bc" installed == installed pass
Program "gunzip" version 1.3.5 >= 1.3 pass
-- gunzip 1.3.5 found under /usr/local/bin
Accounts and Groups
Group "dbtest1" configured == configured pass
User account "ortest1" configured == configured pass
Home directory for "ortest1" configured == configured pass
User "ortest1" groups configured == configured pass
Network
Number of network interfaces 4 >= 2 pass
Public network UP == UP pass
Filesystem opts: /test1/oradata/ configured == configured pass
Installer error log no errors == no errors pass
Executable "oracle" installed == installed pass
SQL*Plus login succeeded == succeeded pass
End of Report