Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
Oracle 10g Pre Installation Validation for AIX 5L | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Oracle 10g Pre Installation Validation for AIX 5L

  • Posted by Gavin Soorma
  • On June 18, 2009
  • 1 Comments

Oracle has provided a utility which we can run before doing an installation on AIX – it will check quite a few things for us and enable us to fix those before proceeding with an installation which could fail at a later stage.

There is a tar file validate.tar located in the $HOME directory on HQIBM102 – copy this file to the required machine and after extracting the files execute as shown below :

perl validate.pl <Output file>.txt

Example:

coekd:/opt1/oracle> perl validate.pl 10gr2_rdbms_aix_hcve_100705.txt

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Health Check/Validation (V 01.07.00)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

“Validation Rule Engine” will be run in following environment:

HOSTNAME    :
USERNAME    : oracle
ORACLE_SID  : coekd
ORACLE_HOME : /devdb02/ORACLE/product10gp

If this is not correct environment
Please set correct env parameters and rerun the program
Would you like to continue [Y]es/[N]o (Hit return for [Y]es) : Y
Executing Rules
~~~~~~~~~~~~~~~

Executing Rule: OS Certified?        – completed successfully.
Executing Rule: User in /etc/passwd? – completed successfully.
Executing Rule: Group in /etc/group? – completed successfully.
Executing Rule: Input ORACLE_HOME    – user INPUT Required.

Enter value for < Planned ORACLE_HOME location or if set >
(Hit return for [$ORACLE_HOME]) :

                                     – completed successfully.
Executing Rule: ORACLE_HOME valid?   – completed successfully.
Executing Rule: O_H perms OK?        – completed successfully.
Executing Rule: Umask set to 022?    – completed successfully.
Executing Rule: LDLIBRARYPATH unset? – completed successfully.
Executing Rule: LIBPATH unset?       – completed successfully.
Executing Rule: Other O_Hs in PATH?  – completed successfully.
Executing Rule: oraInventory perms   – completed successfully.
Executing Rule: /tmp adequate?       – completed successfully.
Executing Rule: Swap (in Mb)         – completed successfully.
Executing Rule: RAM (in Mb)          – completed successfully.
Executing Rule: SwapToRAM OK?        – completed successfully.
Executing Rule: Disk Space OK?       – completed successfully.
Executing Rule: AIXTHREAD_SCOPE=S?   – completed successfully.
Executing Rule: LINK_CNTRL is unset? – completed successfully.
Executing Rule: Got ld,nm,ar,make?   – completed successfully.
Executing Rule: ulimits OK?          – completed successfully.
Executing Rule: Got OS packages?     – completed successfully.
Executing Rule: Got OS patches?      – completed successfully.
Executing Rule: other OUI up?        – completed successfully.
Test “10gr2_rdbms_aix_hcve_100705” executed at Wed Jan 16 10:30:57 2008
Test Results
~~~~~~~~~~~~

   ID NAME                 RESULT C VALUE
===== ==================== ====== = ========================================
   10 OS Certified?        PASSED = Certified with 10g RDBMS
   20 User in /etc/passwd? PASSED = userOK
   30 Group in /etc/group? PASSED = GroupOK
   40 Input ORACLE_HOME    RECORD   $ORACLE_HOME
   50 ORACLE_HOME valid?   PASSED = OHexists
   60 O_H perms OK?        PASSED = CorrectPerms
   70 Umask set to 022?    FAILED = UmaskNotOK
   80 LDLIBRARYPATH unset? FAILED = IsSet
   90 LIBPATH unset?       PASSED = UnSet
  100 Other O_Hs in PATH?  PASSED = NoneFound
  110 oraInventory perms   PASSED = oraInventoryOK
  120 /tmp adequate?       PASSED = TempSpaceOK
  130 Swap (in Mb)         RECORD   16384
  140 RAM (in Mb)          PASSED > 12288
  150 SwapToRAM OK?        PASSED = SwapToRAMOK
  160 Disk Space OK?       FAILED = NoSpace
  170 AIXTHREAD_SCOPE=S?   FAILED = AIXTHREAD_SCOPEBad
  175 LINK_CNTRL is unset? PASSED = LINK_CNTRLunset
  180 Got ld,nm,ar,make?   PASSED = ld_nm_ar_make_found
  190 ulimits OK?          PASSED = ulimitOK
  200 Got OS packages?     PASSED = All required OS packages are installed
  210 Got OS patches?      PASSED = PatchesFound
  220 other OUI up?        PASSED = NoOtherOUI

Please see the log file for detailed results and recommendations
Log FileName: 10gr2_rdbms_aix_hcve_100705_run_2580534/validate_result_10gr2_rdbms_aix_hcve_100705.log

 

1 Comments

monto
  • Feb 19 2010
Gavin, Great post!can you please let me know where i can download validate.pl script from?I looked into metalink but can't find one for 10gr2 on RHEL4. Thanks

Leave Reply

Your email address will not be published. Required fields are marked *