Warnings while running post upgrade scripts post_upgrade_checks.sql

[former_member209962]

Dear All,

While running the post upgrade scripts

post_upgrade_checks.sql

post_upgrade_status.sql

we are getting below warnings.

WARNING: ----> The retention time for the Automatic Workload Repository (AWR)

               is not configured as recommended.

               Current AWR retention is set to 7 days.

               Recommended AWR retention is 42 or more days.

               See SAP note 1326067.

               .

WARNING: ----> LOG_BUFFER: too small

               See SAP note 1627481.

Upgrade from 10.2.0.4 to 11.2.0.3 is completed without any warnings.

and as per standard document we need to run below post upgrade scripts

post_upgrade_checks.sql

post_upgrade_status.sql

post_upgrade_tasks.sql

set_compatible.sql

sapuprof_profile.sql

upgrade_TSTZ.sql

dbua.sap.ps1

we have executed all the above scripts except
dbua.sap.ps1,
dbua.sap.ps1 this script is not getting executed is there a diffrent way to run this?

Kindly clarify above questions.

Thanks

Tabrez

[Former Member]

Hi Tabrea,

As per the worning 1st one you can ignore and for log buffer please check the note.

I really dont know which upgrade guide you are following. I have done many upgrade from 10g to 11.2.0.3. From my past experiance I can tell you that no need to run

post_upgrade_tasks.sql

set_compatible.sql

sapuprof_profile.sql

upgrade_TSTZ.sql

Oracle upgrade assistance will run these script as upgrade steps.

Please continus and let me know the result.

BR

Rajat

[former_member209962]

Hi Rajat,

Thanks for your inputs, i am following sap standard document on oracle upgarde on windows platform

Database Upgrade Guide

Upgrade to Oracle Database 11 Release 2 (11.2): Windows

Based on Oracle Patch Set Release 11.2.0.2 and 11.2.0.3

In the above guid its mention on page 27 about running post upgarde script.

"Additional Steps When Starting the DBUA from the Start Menu

If you started the DBUA from the Start menu, you have to check the upgraded database and perform the post-upgrade script manually"

To do this perform the following steps of SAP note 1431793:

“6.1 Checking the upgraded database ”

“6.2 Running post-upgrade scripts manually ”

Kindly check and let me know if i am going worng

Thanks

Tabrez

[Former Member]

Hi,

You did not started DBUA through recommended method = using power shell.

You started DBUA from start menu hence need to execute post upgrade script manually.

now come to your query

"dbua.sap.ps1

we have executed all the above scripts except
dbua.sap.ps1,
dbua.sap.ps1 this script is not getting executed is there a diffrent way to run this?"

you have to execute this query opening windows power shell

1. 1. Open a Powershell in elevated mode (run as administrator) and change the working directory to <ora_upgrade>\post_upgrade.
2. 2. From this Powershell start the Database Upgrade Assistant with the wrapper script
3. PS> .\dbua.sap.ps1

Regards,

Nikunj Thaker

[Former Member]

Hi,

I think you can check the below link.

http://www.stechno.net/sap-notes.html?view=sapnote&id=1431797

Thanks and Regards,

Vimal