Praxisbericht SAP Datenbank (Oracle) dbua …... Praxisbericht SAP Datenbank (Oracle) dbua Upgrade...
Transcript of Praxisbericht SAP Datenbank (Oracle) dbua …... Praxisbericht SAP Datenbank (Oracle) dbua Upgrade...
www.messe.de
Praxisbericht
SAP Datenbank (Oracle) dbua Upgrade nach 11gR2
Andreas Ellerhoff, DBA Deutsche Messe
Seite: 2Seite: 2
Agenda
• Ablauf des DBUA Upgrades• Bewertung und Ausblick
Selektion der Datenbank
kallisto:oracq3 72> ./dbua.sap.sh
Oracle Database Upgrade Release 11.2.0.2dbua.sap.sh - DBUA wrapper script for SAPCopyright (c) Oracle Corporation 2010. All Rights Reserved.
Source database to be upgraded is >> DQ3 <<Source Oracle Home is >> /oracle/CQ3/102_64 << (release 10.2)Target Oracle Home is >> /oracle/CQ3/112_64 << (release 11.2.0.2)DBUA log directory is >> /oracle/cfgtoollogs/dbua/DQ3/upgrade4 <<dbua.sap.sh log file is >> /oracle/CQ3/112_64/sap/ora_upgrade/post_upgrade/dbua.sap.log <<Diagnostic destination is set to >> /oracle/CQ3/saptrace <<Audit file destination is set to >> /oracle/CQ3/saptrace/audit <<Database Upgrade Assistant is run in non-silent mode.Starting Database Upgrade Assistant with the following command:
/oracle/CQ3/112_64/bin/dbua -sid DQ3 -oracleBase /oracle -oracleHome /oracle/CQ3/102_64 -diagnosticDest /oracle/CQ3/saptrace -recompile_invalid_objects true -initParam audit_file_dest=/oracle/CQ3/saptrace/audit -emConfiguration NONE -upgradeTimezone -postUpgradeScripts /oracle/CQ3/112_64/sap/ora_upgrade/post_upgrade/post_upgrade_tasks.sql,/oracle/CQ3/112_64/sap/ora_upgrade/post_upgrade/set_remote_os_authent.sql,/oracle/CQ3/112_64/sap/ora_upgrade/post_upgrade/set_compatible.sql,/oracle/CQ3/112_64/sap/ora_upgrade/post_upgrade/sapuprof_profile.sql,/oracle/CQ3/112_64/sap/ora_upgrade/post_upgrade/post_upgrade_checks.sql
Database upgrade has been completed successfully, and the database is ready to use.The following document describes important behavioral changes from previous database releases:/oracle/CQ3/112_64/assistants/dbua/doc/DefaultBehaviorChanges.html
Welcome
Schritt1: Upgrade Options
Schritt2: Move DB Files
Schritt3: DIAG + Recovery Einstellungen
Schritt4: Management Optionen (OEM)
Schritt5: Database User Passwörter
Schritt6: Zusammenfassung
Upgrade Ergebnis