Pre-Install checks for 10gR2 RDBMS (10.2.x) – Verify.tar

This rule collection is designed for an Oracle Service Engineer, or any Web Server Administrator who needs to perform Pre-Install checks for 10gR2 RDBMS (10.2.x) – HPUX PA-RISC and Itanium Platforms.
Instructions
The easiest way to run this set of rules is to download [Save file as validate.tar] and execute the validation engine. The download is a small “tar” file, which consists of the following:

* validate – Shell script that executes the engine – Unix platforms
* validate.pl – Actual rule engine
* 10gr2_rdbms_hpux_hcve_022506.txt – Rule text file. This file will be different for each rule set

To run the rules:

1. Click Here to download the file to your system.
2. Save the file as “validate.tar”.
3. Untar the files to a local directory. i.e tar xvf validate.tar
4. Set your environment to the one you want the validate.
5. Execute perl validate.pl 10gr2_rdbms_hpux_hcve_022506.txt from the command line, as in the following examples:

# perl validate.pl 10gr2_rdbms_hpux_hcve_022506.txt

OR

# validate 10gr2_rdbms_hpux_hcve_022506.txt

6. When prompted, confirm the environment.

NOTE: “Problems with not finding Perl”

Perl 5.6.1 is usually installed by default with MOST UNIX OS’s. Please consult your System Administrator on where to find the Perl installation. The Perl software is usually installed in /opt/perl directory, please verify this. If it exist, do the following to set your environment:
export PATH=/opt/perl/bin:$PATH
export PERL5LIB=/opt/perl/lib

Execute the following command to verify that the Perl program is in your PATH:
which perl —–> should return /opt/perl/bin

perl -v ——> should return “This is perl, v5.6.1

If the version is correct or at least v5.x.x, try to run :

# validate 10gr2_rdbms_hpux_hcve_022506.txt

If it does not work, you can download Perl 5.6.1 for free from http://www.perl.com/CPAN/ports/index.html. Then setup your PATH and PERL5LIB environment variables to where you installed Perl.

The engine executes all rules and prints a summary page. An example of the run session is below, output from your run session will be different:

“Health Check Rule Engine” will be run in following environment:

ORACLE_HOME: /oracle/9.0.1
ORACLE_SID : V901

If this is not correct environment
Please set correct env parameters and rerun program
Would you like to continue [Y]es/[N]o (Default Yes) :

Executing Rules
~~~~~~~~~~~~~~~

Executing Rule: sysdate – completed successfully.
Executing Rule: ulimit – completed successfully.
Executing Rule: free_oracle_home – completed successfully.
Executing Rule: free_shared_pool – completed successfully.

Tests executed at Mon Jan 20 13:07:18 2003

Test Results
~~~~~~~~~~~~

ID NAME RESULT CON VALUE
===== ==================== ======= === ==============================
1 sysdate RECORD NA Mon Jan 20 13:07:17 EST 2003
2 ulimit PASSED = unlimited
3 free_oracle_home FAILED B 5087768
4 free_shared_pool PASSED > 33531748

After the execution is complete you can see a detailed output and advise on the outcome in the log file. The log file will have the same name as the rules file, but with the .log extention. The engine will prompt you the correct log file name.

Note: You can also run each individual rule manually. Although this is the less preferable choice, if you would like to execute the rules manually, follow the instructions below. It is important that you understand that the %#% in a particular rule represents the value of the output from a previous Test. i.e. (if %40% eq True then) in rule is interpreted as if the value from the output of rule 40 is true, then futher process current rule. The Rule number is the second line after Rule description and can be seen in 10gr2_rdbms_hpux_hcve_022506.txt.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: