Solution : https://service.sap.com/sap/support/notes/1431797 (SAP Service marketplace login required)
Summary :
This SAP Note discusses solutions for common issues encountered during Oracle Database upgrades to version 11.2, including releases 11.2.0.1 to 11.2.0.4. Key tools like the Database Upgrade Assistant (DBUA), and pre- and post-upgrade scripts (utlu112i.sql and utlu112s.sql) are highlighted. It gives detailed instructions on using these tools and addresses specific bugs such as in the dbua.sap.ps1 script with troubleshooting steps and permanent fixes. Additionally, the note covers general upgrade recommendations, minimum source release versions needed for upgrades from earlier versions, and steps to handle observed symptoms and errors during the upgrade process.
Key words :
set heading offset timing offset pagesize 0set feedback offset linesize 4000set sqlprompt 'sql_engine_end_of_sql'show sqlpromptset sqlprompt 'sql>'trace, customer component bc-db-ora oracle priority recommendations / additional info category consulting validity, log showsshow sqlpromptset sqlprompt 'sql>'select count, __%pdfstyle%__ / } symptom troubleshooting oracle database upgrades release 11, file $oracle_home/assistants/dbma/logs/welcome_$oracle_sid, dbuatroubleshooting manual database upgrades troubleshooting oracle database upgrades, base directory#adr_base_listener=/oracle/${db_sid}/saptracethe parameter, dbua log directory /oracle/cfgtoollogs/dbua/<sid>/upgrade<, unix platforms install recommended sap bundle patch, troubleshooting manual database upgrades releases affected
Related Notes :
| 1431793 | Oracle 11.2.0: Upgrade Scripts |
| 1431800 | Oracle 11.2.0: Central Technical Note |