June 2013
Beginner
404 pages
9h 40m
English
We will now see a step-by-step approach to upgrade a database from 11.2.0.1 to 11.2.0.3.
SQL> select * from v$version; BANNER -----------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production SQL> select protection_mode from v$database; PROTECTION_MODE -------------------- MAXIMUM PERFORMANCE
The COMPATIBLE initialization ...