Skipping the pre-requiste while oracle upgrade

[Former Member]

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

[former_member265710]

Hi Bala,

You could refer the Oracle Metalink note 169706.1 which will guide you

the required OS patches for Oracle 10g upgrade on HP-UX.

169706.1 - Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris Tru64

Operating Systems Installation and Configuration Requirements Quick

Reference (8.0.5 to 10.2)

Please also refer the metalink note

43507.1 - HP-UX: Patch Levels Advised

Mostly you can ignore the following messages.

PHSS_33278 s700_800 11.23 aC++ Compiler (A.06.02)

PHSS_33279 s700_800 11.23 u2comp/be/plugin library patch

PHSS_33277 s700_800 11.23 HP C Compiler (A.06.02)

PHSS_33279 s700_800 11.23 u2comp/be/plugin library patch

Please refer the following note for Oracle Metalink Logon details.

758563: Oracle Metalink access for SAP customers

start the RunInstaller with ./runInstaller

-ignoreSysPrereqs

Hope this helps

Regards

Arun

[Former Member]

hi

isther any one to help

bala

[hl_4]

Hi,

what OS you are using? Check, in the RUNINSTALLER script if the Oracle Installer is called with -ignoreSysPrereqs.

Check sapnote 980426

Excecute runInstaller not RUNINSTLLER on SAP directory

./oracle/stage/102_64/database/runInstaller

-executeSysPrereqs

Regards

Heike

[Former Member]

Hi

I have checked with ur command then also the same things happen. as i have attached in the link. have check the link document where i have attached snap shots of the eeror and the expected one which i have done last month.

please check that link which i have provided

regarda

bala

[Former Member]

Hi Bala. I'm don't know your issue. Try to ask in Oracle forums, not sap on oracle. Also read about

Running the Prerequisite Check in Standalone Mode , with "-prereqchecker" flag. Regards.

[Former Member]

hi

i have attached the error snapshots to u

and also send to ur mail id

please check it

and refer the link which i have uploaded the fi,le

Download-Link #1: http://rapidshare.com/files/114600002/err_upg1_doc.doc.html

[http://rapidshare.com/files/114600002/err_upg1_doc.doc.html ]

please refer this link

regards

bala

[Former Member]

Hi Bala.Yes i have understood you, but also you understand me.

You are execute the ./RUNINSTALLER command, try Instead of this :

./RUNINSTALLER -executeSysPrereqs

Are you try execute this ? If yes, what do you see? Regards.

[Former Member]

hi

this is os level command to give it. the same will also come gui application thro RUNINSTALLER

bala

[Former Member]

May be i'm nor understand you... read this : http://www.stanford.edu/dept/itss/docs/oracle/10g/em.101/b12140/2_oui_using.htm

Command Line Parameters for Pre-Requisite Checks . Regards.

[Former Member]

hi

r u asking about the os level patches and kernel parameters. if it is no. we did not revert the OS level patches and kernel parameters. but have cleared the 102_64 diretory, tmp orainstall directories , oraInventory directories.

since the RUNINSTALLER is an OUI which picks the response file and necessary files from the system to proceed for the installation of 10.2.0. softwwrae.

We are installing the Oracle 10.2.0 software where when u run the RUNINSTALLER command it skips the prerequiste step whch was happened last activity.

i am asking which file to be cleared so that the RUNINSTALLER picks and scan the as required patches.

regards

bala

[Former Member]

Read about this flag in RUNINSTALLER :

-executeSysPrereqs

May be it's helps. Regards.

[Former Member]

Hi

We have successfully upgraded atleast 8 systems. this is the last system and the question is to retrieve the prequiste check tis happens when u run the ./RUNINSTALLER from the database / SAP directory. i am not asking any query based command. while running the RUNINSTALLER from the SAP directory of oracle Upgrade

please check it

regards

balaji

[Former Member]

Hm. As i can understand you are upgrade to 10.2 after go back to 9.2. Are you have returned back the Kernel parameters and operating system patches ? If you tunning it 1 time why you need to view checklist again ? Or some thing that goes not correctly? Regards.

[Former Member]

Hi. Go to http://service.sap.com/instguides --> Other Documentation --> Database Upgrades --> Oracle . Download the Upgrade Guide for your release. Regards.