Solution : https://service.sap.com/sap/support/notes/1915315 (SAP Service marketplace login required)
Summary :
This SAP note provides detailed guidance on upgrading SAP systems to Oracle Database 12c Release 12.1.0.2. It outlines the use of SAP-specific scripts for automating pre-upgrade and post-upgrade tasks, aiming to streamline the upgrade process. Key steps include preparation via the SAP and Oracle-specific methods, installation of Oracle software, and the actual database upgrade, which can be performed either manually or using DBUA. Post-upgrade tasks involve both Oracle-related and SAP-specific activities to ensure system integrity and performance. The guide is available on the SAP Service Marketplace.
Key words :
patch deinstallation procedure platform commands unix / linux os> export oracle_home=<oracle_home>os> $oracle_home/opatch/opatch rollback -id 9584028 windows os> set oracle_home=<oracle_home>os> %oracle_home%\opatch\opatch rollback -id 9584028, components bc-db-ora-sec oracle security messages priority recommendations / additional info category installation information validity, pre-upgrade scripts os> cd <new_oracle_home>/sap/ora_upgrade/pre_upgrade os> cd <new_oracle_home>\sap\ora_upgrade\pre_upgrade running pre-upgrade scripts os> sqlplus /, os> cd <patch_location>os> export oracle_home=<new_oracle_home>os> $oracle_home/opatch/opatch napply <patch_location> installation, sid_list_<listener_name> adr_base_<listener_name> examples <listener_name>=listener_<dbsid> adr_base_<listener_name>=/oracle/<dbsid>/saptracesid_list_<listener_name> =, zipos> cd 9584028os> export oracle_home=<new_oracle_home>os> $oracle_home/opatch/opatch apply installation, patch fileos> cd <patch_location>os> set oracle_home=<new_oracle_home>os> %oracle_home%\opatch\opatch napply, os> sqlplus secadmin sql> @dv_policy policy upgrade enable dvos> sqlplus secadmin sql> exec dbms_macadm, zipos> cd 9584028os> set oracle_home=<new_oracle_home>os> %oracle_home%\opatch\opatch apply installation, cleanup / remove oracle software stage windows cleanup / remove oracle software stage post-upgrade
Related Notes :
| 706927 | Oracle DB-Mon: Installation script for ST04N/DBA Cockpit |
| 1915323 | OS User Concept for Oracle Database 12c Release 1 |
| 1915317 | Migrating Software Owner to 'oracle' |
| 1915301 | Database Software 12.1.0.2 Installation on Unix |
| 1915302 | Database Software 12.1.0.2 Installation on Windows |
| 1519872 | SAP Database User Profile SAPUPROF |
| 2199300 | |
| 1915316 | Database: Patches for 12.1.0.2 |
| 1677978 | Administration of mixed SAP/Non-SAP Environments on Exadata |
| 527843 | Oracle RAC support in the SAP environment |
| 839182 | Installing patches using OPatch |
| 2218115 | Oracle Database Vault 12c |
| 1554661 | Configuration of environment for 'oracle' user |
| 2064206 | Database Upgrade to 12.1.0.2 with Grid Infrastructure |
| 1888485 | Database Parameter for 12.1.0.2 |
| 1739274 | Database Parameter COMPATIBLE |
| 1590515 | SAP Software and Oracle Exadata |