User`s guide

Upgrading a Database
4-8 Oracle Database Installation and Administration Guide
4.1.3.9 Installing Oracle Text
Usage and installation of Oracle Text is summarized in the "Oracle Text" chapter of this
book.
4.1.3.10 Installing Java
Using and installing of Java is summarized in the chapter "Java in the Database" in this
book.
4.2 Upgrading a Database
This section contains information about upgrading your Oracle database that are
described in the following:
■ Upgrade from Version 9
■ Upgrade from Version 10
■ Postupgrade Activities
4.2.1 Upgrade from Version 9
For upgrading from version 9 refer to "Upgrading to the New Release of Oracle
Database" in Oracle Database Upgrade Guide.
4.2.2 Upgrade from Version 10
This section explains the BS2000 specific steps of the upgrade path. We assume the
reader to be familiar with Oracle Database 11g Release 2 upgrade documentation
about upgrade preparation, space and backup requirements, release differences, and
so on. Refer to Oracle Database Upgrade Guide for further information regarding
database upgrades. Oracle recommends reading the appropriate section in the generic
documentation, especially when you are using
TIMESTAMP WITH TIME ZONE data type.
We further assume your Oracle Database 10g is set up and the Oracle Database 11g
Release 2 software is properly installed as explained in
Chapter 3, "Oracle Database
Installation and Deinstallation". Thereafter, complete the following steps:
1. Run the Pre-Upgrade Information Tool utlu112i.sql from Oracle Database 11g
installation id with SQL*Plus in your Oracle Database 10g environment to analyze
required parameters as follows (assuming the database is running):
/START-PROGRAM $ORACL1020.sqlplus
* /nolog
SQL> connect / as sysdba
SQL> SPOOL info.log
SQL> @$ORAC1120.rdbms.admin.utlu112i.sql;
SQL> SPOOL off
2. Check the sections in the spoolfile for Logfiles, Tablespaces, and Rollback
Segments, and change the appropriate values of your database.
3. Shutdown the database and exit SQL*Plus
SQL> SHUTDOWN IMMEDIATE
SQL> exit