Tasks to Complete Only After Upgrading a Release 8.1.7 Database

To upgrade user tables with NCHAR columns, perform. the following steps:

Log in to the system as the owner of the Oracle home directory.
At a system prompt, change to the ORACLE_HOME/rdbms/admin directory.
Start SQL*Plus.
Connect to the database instance as a user with SYSDBA privileges.
If the instance is running, shut it down using SHUTDOWN IMMEDIATE:
```
SQL> SHUTDOWN IMMEDIATE
```
Start up the instance in RESTRICT mode:
```
SQL> STARTUP RESTRICT
```
You may need to use the PFILE option to specify the location of your initialization parameter file.
Run utlnchar.sql:
```
SQL> @utlnchar.sql
```
Alternatively, to override the default upgrade selection, run n_switch.sql:
```
SQL> @n_switch.sql
```
Shut down the instance:
```
SQL> SHUTDOWN IMMEDIATE
```
Exit SQL*Plus.

Table 5-1 The COMPATIBLE Initialization Parameter

Oracle Database Release	Default Value	Minimum Value	Maximum Value
Oracle8i release 8.1.7	8.0.0	8.0.0.0.0	8.1.7.x.x
Oracle9i release 9.0.1	8.1.0	8.1.0.0.0	9.0.1.x.x
Oracle9i release 9.2	8.1.0	8.1.0.0.0	9.2.0.x.x
Oracle Database 10g release 10.1	10.0.0	9.2.0.0.0	10.1.0.x.x
Oracle Database 10g release 10.2	10.2.0	9.2.0.0.0	10.2.0.x.x

ITPub博客