Skip to Content
0
Former Member
May 13, 2008 at 10:34 AM

Skipping the pre-requiste while oracle upgrade

279 Views

hi

we are upgrading our SAP database from Oracle 9.2.0.8 to oracle10g. last month we had done the premilinary steps and completed the upgrade. but due to some unavoidable circumstances we reverted the oracle database to 9.2.0.8. now again we are started the upgrade activity so our instruction is to delete all the files in 102_64 directory and all related files and fresh installation

so we deleted the files nad directories inside /oracle/SID/102_64. andwe started the installation on the starting scrren usually it will run the pre requiste and scan the OS and kernel parameters,env parameters and so on. since last month it showed some check parameters and we have applied the patches and tuned the parameters . but starting the fresh installation it skipping that step and go to next step install all the components and we go to back it shows the OS and all th pre-requiste is progresss and remaining pending. we want to have the check list again so we have cleared the oraInventory directory , tmp directory . then also it skips. is there any file to be deleted or cleaned to check the ptrerequiste. i am giving the last month prerequiste check which is not scanning now.

Checking operating system requirements ...

Expected result: One of 11.23

Actual Result: 11.23

Check complete. The overall result of this check is: Passed

=======================================================================

Checking recommended operating system patches

Checking for PHSS_31850; found Not found. Failed <<<<

Checking for PHSS_31851; found Not found. Failed <<<<

Checking for PHSS_31854; found Not found. Failed <<<<

Checking for PHSS_31855; found Not found. Failed <<<<

Checking for PHSS_33275; found Not found. Failed <<<<

Checking for PHSS_33276; found Not found. Failed <<<<

Checking for PHSS_33278; found Not found. Failed <<<<

Checking for PHSS_33279; found Not found. Failed <<<<

Checking for PHSS_33277; found Not found. Failed <<<<

Checking for PHSS_33279; found Not found. Failed <<<<

Checking for PHSS_32213; found Not found. Failed <<<<

Checking for PHCO_32426; found Not found. Failed <<<<

Checking for PHCO_31553; found PHCO_31553. Passed

Check complete. The overall result of this check is: Failed <<<<

Problem: Some recommended patches are missing (see above).

Recommendation: You may actually have installed patches which have obsoleted these, in which case you can successfully continue with the install. If you have not, it is recommended that you do not continue. Refer to the readme to find out how to get the missing patches.

=======================================================================

Checking security kernel parameters

Checking for ksi_alloc_max=32768; found ksi_alloc_max=33600. Passed

Checking for max_thread_proc=256; found max_thread_proc=256. Passed

Checking for maxdsiz=1073741824; found maxdsiz=1073741824. Passed

Checking for maxdsiz_64bit=2147483648; found maxdsiz_64bit=4294967296. Passed

Checking for maxssiz=134217728; found maxssiz=8388608. Failed <<<<

Checking for maxssiz_64bit=1073741824; found maxssiz_64bit=268435456. Failed <<<<

Checking for maxswapchunks=16384; found no entry. Failed <<<<

Checking for maxuprc=3687; found maxuprc=4195. Passed

.

.

.

.

Problem: The security parameters in the kernel do not meet the minimum requirements (see above).

Recommendation: Perform operating system specific instructions to update the kernel parameters, namely BIT_SIZE and noexec_user_stack.

=======================================================================

Validating ORACLE_BASE location (if set) ...

Check complete. The overall result of this check is: Passed

=======================================================================

NOW this steps skips and then proceed to the install step.

please guide me to retrive the step and proceed

regards

balaji