Oracle 10g upgrade to 11g Training Project

Oracle 10g UPDATE 11g Training Project

1. Project Process:
1. Install 11.2.0.3 database software on the server where the Oracle 10.2.0.5 database is located
2. Execute dbua in the environment variable 11.2.0.3 and upgrade the Graphical Database.
3. Subsequent work: Modify compatible and other operations in spfile
2. Modify Linux Kernel Parameters and necessary installation packages (you can check the storage, specific parameters, and packages before installing the software)
Net. core. rmen_dafault = 4194304
Net. core. rmen_max = 4194304
Net. core. wmen_dafault = 1048675
Net. core. wmen_max = 1048675
Fs. aio-max-nr = 1048576

3. Install software
It's no longer cumbersome here
4. Execute dbua in the environment variable 11.2.0.3 and upgrade the Graphical Database.
1) Vim/home/oracle/. bash_profile (modify ORACLE_HOME)
2) copy the following files from Oracle Home in 11gR2 to a Temporary Folder:
$ ORACLE_HOME/rdbms/admin/utluw. I. SQL
3) log on to the database and run:
$ Sqlplus '/as sysdba'
SQL> @ utlu112i. SQL
SQL> spool off
SQL>

4) Check the Timezone version. For details, refer:
Actions For DST Updates When Upgrading To Or Applying The 11.2.0.2 Patchset [ID 1201253.1]
Note: The 11g software has a Timezone of version 1-14.
Check the current timezone version first:
SQL> conn/as sysdba
Connected.
SQL> SELECT version FROM v $ timezone_file;
According to the current timezone version, there are three more situations:
1) equal to 14: This version is already required for the 11g version, so there is no need to do anything before and after the upgrade. This situation is rare.
2) higher than 14: prior to the upgrade, the 11g software must be installed with the DST patch of the timezone version, which is rare.
3) less than 14: this is the case in most cases. You do not need to patch the 11g software before the upgrade. After the upgrade, You need to upgrade the Timezone to 14 at the database level. For details, refer to the subsequent steps.

Step 7.
Check whether the national character set is UTF8 or AL16UTF16:
Select value from NLS_DATABASE_PARAMETERS where parameter = 'nls _ NCHAR_CHARACTERSET ';

5) Stop listener:
$ Lsnrctl stop
Stop other executable programs, such as dbconsole and isqlplus.
$ Emctl stop dbconsole
$ Isqlplusctl stop
Close the database:
$ Sqlplus "/as sysdba"
SQL> shutdown immediate;
Then perform a cold backup for the entire database.

6) Create a New pfile for 11g based on the suggestions in upgrade_info.log generated by Step 2.

7) The pre-upgrade check steps are basically completed. Before running the upgrade script, you need to change the relevant parameters to the new 11g software:
$ Export ORACLE_HOME = <location of Oracle 11.2>
$ Export PATH = $ ORACLE_HOME/bin: $ PATH
$ Export ORACLE_BASE = <Oracle_Base set during installation>

1 2 Next Page