Skip Headers

Oracle9i Database Certified Configuration Installation Guide
Release 2 (9.2.0.2) for Solaris Operating Environment (SPARC 64-bit)
Part No. B12103-02
  Go To Table Of Contents
Contents
Go To Index
Index

Previous Next  

B Sample Output Files

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

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

Hardware and Software Compliance with Oracle9i Database Certified Configuration for Real Application Clusters

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

Oracle9i Database Certified Configuration Single-instance Prior to Image Restoration

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

Oracle9i Database Certified Configuration Real Application Clusters Prior to Image Restoration

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

Oracle9i Database Certified Configuration Single-instance after Reconfiguration

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

Oracle9i Database Certified Configuration Real Application Clusters after Reconfiguration

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

Oracle9i Database Certified Configuration Single-instance Cloning Log

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