| Mandalika's scratchpad | [ Work blog @Oracle | My Music Compositions ] |
Old Posts: 09.04 10.04 11.04 12.04 01.05 02.05 03.05 04.05 05.05 06.05 07.05 08.05 09.05 10.05 11.05 12.05 01.06 02.06 03.06 04.06 05.06 06.06 07.06 08.06 09.06 10.06 11.06 12.06 01.07 02.07 03.07 04.07 05.07 06.07 08.07 09.07 10.07 11.07 12.07 01.08 02.08 03.08 04.08 05.08 06.08 07.08 08.08 09.08 10.08 11.08 12.08 01.09 02.09 03.09 04.09 05.09 06.09 07.09 08.09 09.09 10.09 11.09 12.09 01.10 02.10 03.10 04.10 05.10 06.10 07.10 08.10 09.10 10.10 11.10 12.10 01.11 02.11 03.11 04.11 05.11 07.11 08.11 09.11 10.11 11.11 12.11 01.12 02.12 03.12 04.12 05.12 06.12 07.12 08.12 09.12 10.12 11.12 12.12 01.13 02.13 03.13 04.13 05.13 06.13 07.13 08.13 09.13 10.13 11.13 12.13 01.14 02.14 03.14 04.14 05.14 06.14 07.14 09.14 10.14 11.14 12.14 01.15 02.15 03.15 04.15 06.15 09.15 12.15 01.16 03.16 04.16 05.16 06.16 07.16 08.16 09.16 12.16 01.17 02.17 03.17 04.17 06.17 07.17 08.17 09.17 10.17 12.17 01.18 02.18 03.18 04.18 05.18 06.18 07.18 08.18 09.18 11.18 12.18 01.19 02.19 05.19 06.19 08.19 10.19 11.19 05.20 10.20 11.20 12.20 09.21 11.21 12.22
- First of all, Oracle wouldn't let you start the database up after simply installing the latest patch set on top of an existing Oracle RDBMS environment. The following steps must be followed before it starts up successfully. Otherwise, during startup Oracle throws errors like:
ORA-01092: ORACLE instance terminated.
ORA-39700: database must be opened with UPGRADE option. - In order to install 10.2.0.3 patch set, download the patch 5337014 from metalink.oracle.com for your OS; and install it on top of 10.2.0.1. Make sure the listener and the database are down before you apply the patch.
- Set
SHARED_POOL_SIZEandJAVA_POOL_SIZEparameters to at least 150M {in the DB initialization file}, if they are either not set or the existing value is < 150M. - Start up the database in upgrade mode.
SQL> STARTUP UPGRADE
ORACLE instance started.
Total System Global Area 1.0385E+10 bytes
Fixed Size 2047256 bytes
Variable Size 1241514728 bytes
Database Buffers 9126805504 bytes
Redo Buffers 14729216 bytes
Database mounted.
Note:
If you see an error likeORA-01589: must use RESETLOGS or NORESETLOGS option for database openwithSTARTUP UPGRADE, clear the logs as shown below:SQL> ALTER DATABASE OPEN RESETLOGS: <- NORESETLOGS doesn't work here.
SQL> SHUTDOWN
SQL> STARTUP UPGRADE
ORACLE instance started.
Total System Global Area 5553258496 bytes
Fixed Size 2038008 bytes
Variable Size 1241515784 bytes
Database Buffers 4294967296 bytes
Redo Buffers 14737408 bytes
Database mounted.
Database opened. - Finally run the command line database upgrade assistant tool,
dbua, to do pre upgrade checks, to upgrade the Oracle server and to perform any post upgrade activity. Here is the syntax:% dbua -silent -dbname $ORACLE_SID -oracleHome $ORACLE_HOME -sysDBAUserName sys
-sysDBAPassword change_on_install -recompile_invalid_objects true
You may have to slightly modify the above command esp. the password part to make it work in your environment. Thedbuashould return a status message likeDatabase upgrade has been completed successfully, and the database is ready to use.. Otherwise review the log file (usually $ORACLE_HOME/cfgtoollogs/dbua/logs/silent*.log), make the changes as necessary and re-run thedbuatool until it succeeds.
Usingdbuais only one way of upgrading the database to the latest patch set. You can also upgrade it with the help ofdbua's graphical interface or by manually executing few SQL scripts. Check the README file that is bundled with the patch for detailed steps on using thedbuaGUI or the manual execution of the required SQL scripts.
____________________
Oracle | 
RDBMS |
| 2004-2019 |
|
