Pre-requisites :
Window | Task |
Download Software Updates | Select Skip software updates, and then Next. |
Select Skip software updates, and then Next.Select Installation Option | Confirm the default selection Install database software only and then choose Next. |
Grid Installation Options | Confirm the default selection Single instance database installation and then choose Next. |
Select Product Languages | Confirm the default option English and then choose Next. |
Select Database Edition | Confirm the default option Enterprise Edition and then choose Next. |
Specify Installation Location | This window displays the value for ORACLE_BASE, which must be set in the environment to <drive_containing_oracle_home>:\oracle. It also displays the value for ORACLE_HOME, which is\oracle\<DBSID>\1120<x> (where 1120<x> is the Oracle version number, for example, 11202 for Oracle 11.2.0.2, 11203 for Oracle 11.2.0.3, and so on). Choose Next. |
Perform Prerequisite Checks | This window checks if all the required system prerequisites for the installation of the database software have been met. If some of the checks are displayed as Failed, you can fix these problems and run the check again by choosing Check Again. RECOMMENDATION We strongly recommend you to make sure that there are no failed checks before starting the software installation. |
Summary | Review the information displayed in this window and choose Finish or Install. |
Install Product | This window shows the progress of the installation. You can monitor the installation progress details in an additional window. |
Finish | After the installation has finished successfully, choose Finish and close the Oracle Universal Installer. |
Installing Required Patches ( not necessary )
After the database software installation, you need to install all required Oracle database patches, which on Windows include one patch collections and one or more additional (generic) patches.
For Oracle 11.2.0.3, check SAP Note 1631931 for the patches to be installed.
You can download the patches from:http://service.sap.com/oracle-downloadOracle 11.2.0.<x>
Prerequisites
Use an up-to-date version of OPatch to install the patches. Check SAP Note 839182 for instructions on how to use OPatch.
Copying and Adapting the SQL*Net Files
Note that this is the same value as set in the database profile parameter diagnostic_dest.
Since your database is still running in the old environment, do not start the listener with the new listener.ora file at this point.
Backing Up the Oracle Database
You must have a complete and usable database backup otherwise you might lose data
Procedure
Changing the Environment for User <dbsid>adm
EXAMPLE
Rrename ORACLE_HOME into ORACLE_HOME_before_upgrade, and TNS_ADMIN into TNS_ADMIN_before_upgrade.
Run the Pre-upgrade script…. one by one as below...
create_restore_point.sql
pre_upgrade_checks.sql
pre_upgrade_status.sql
pre_upgrade_tasks.sql
utlu112i_sap.sql
Performing the Database Upgrade
Note:
Note that if you use this method, you do not automatically run the SAP-specific DBUA upgrade scripts, and you have to run them after the upgrade manually.
DBUA steps:
SCREEN | Input |
DBUA: Welcome | Start DUBA from 11g home >>Choose Next. |
DBUA: Select Database | 1. Select the database that you want to upgrade. 2. Choose Next. The DBUA analyzes the database to be upgraded and performs pre-upgrade checks. 3. If the DBUA warns you of issues that need to be fixed before the upgrade, you need to analyze and act on these warnings. The most common warning or information messages are as follows:=W�Q& Database is using an old timezone file version Upgrade of TSTZ data is done automatically if the DBUA was started using dbua.sap.ps1. Database contains schemas with stale optimizer statistics See SAP Note 1431793, section 4. Running the Pre-Upgrade Scripts.Database contains INVALID objects prior to upgrade See SAP Note 1431793, section 4. Running the Pre-Upgrade Scripts. If there is not enough space for the SYSTEM tablespace, increase the space.˘EóÈv° If you are prompted to resize the rollback segment SYSTEM, choose Continue. 4.Choose Yes to continue with the upgrade. |
DBUA: Upgrade Options | The following options are available: Recompile invalid objects at the end of the upgrade Leave this selection unchanged. The option lets you choose whether the DBUA has to automatically recompile all PL/SQL modules after the upgrade. If the database server has multiple CPUs, the DBUA automatically proposes the number of parallel processes to be used for the recompilation. Backup database Since you have already performed the Oracle database backup [page 23], you do not need to select this option. Choose Next. |
DBUA: Move Database Files | Leave the default setting Do Not Move Database Files as Part of Upgrade and choose Next. |
DBUA: Recovery and Diagnostic Location | 1.Do not select Specify Flash Recovery Area. 2.If you opened the DBUA with the Start menu, in the Diagnostic Destination field you have to specify the location of the saptrace directory using the Browse button. 3.Choose Next. |
DBUA: Management Options | Deselect Configure the Database with Enterprise Manager, if selected, and choose Next. |
DBUA: Summary | Review the summary of changes to be made. This includes the warnings that you ignored or did not fix, components to be upgraded, parameters to be added, removed, and changed after the upgrade. Choose Back to make any final adjustments, if required. Otherwise, leave the default settings and choose Finish to start the upgrade. The upgrade process itself runs for some time, depending mainly on the size of the database and the capacity of the hardware. You can ignore the warning ORA-32004 obsolete or deprecated parameter(s) specified for RDBMS instance. When the DBUA has completed successfully, the results of the |
Screen shot of DBUA
If you started the DBUA from the Start menu, you must perform additional steps to perform the post-upgrade script (see below).
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 ”
Post-Upgrade Steps
After the Oracle database upgrade, you need to perform the steps described here.
When you modify the user environment, you must be logged on as the corresponding <DBSID>adm user.
Set TNS_ADMIN on all ABAP application servers.
Create New listener service use command prompt or run commad:
<complete_path_to_new_Oracle_Home>\bin\lsnrctl start
This will start the listener from the new Oracle home. As the listener service does not yet exist, you will get the following error message: Failed to open service <Oracle<SID>11202TNSListener>, error 1060. Then the service will be created and started.
Change the registry value of ORA_<DBSID>_AUTOSTART. Open a command prompt and enter the following command:<new_Oracle_Home>\bin\oradim -edit -sid <dbsid> -startmode manual
Ignore the error message: Unable to start service, OS Error 1056.
Alternatively, use regedit.exe to change the registry key to value FALSE. The registry key is available at HKLM:\Sofware\Oracle\KEY_<DBSID>11202
Checking the Start Up Type of the Oracle Services
Also, if not yet started, start the Distributed Transaction Coordinator Service.
In a standard configuration, set the startup type of OracleService<DBSID> and Oracle<ORACLE_HOME_NAME>TNSListener to automatic to ensure that they are automatically restarted after booting.
Example :Open a command prompt and change to the directory <new_oracle_home>\sap\ora_upgrade\post_ugprade.
From this directory start sqlplus.exe and enter the following commands:SQL>connect / as sysdbaSQL>@post_upgrade_status.sql
This provides an overview of the status of the upgraded database.
Run the below scripts one by one
brconnect -u / -c -f stats -t all -f collect -p 4
Above Details will help only for the standalone SAP on Oracle upgrade . And I did the upgraded as per above mentioned steps .For Cluster environment download the standard document from sap. Database Upgrade Guide
Thanks
Yoonus
Visit.. WrongCodes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
53 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |