Completed the Configuring Linux for the Installation of Oracle Database 10g lesson

Completed the Installing Oracle Database 10g on Linux lesson

Completed the Installing Oracle9i Database, Release 2 on Linux lesson
(or have access to an Oracle9i Database)

Open your browser and enter the following URL:

http://<hostname>:5500/em

Log in as sys/<password> as sysdba and click Login.

Click the Administration tab.

Under Storage, click the Tablespaces link

Click the SYSTEM tablespace.

In the Datafiles section, click Add.

Enter system02.dbf for the file name, select the Automatically extend datafile when full (AUTOEXTEND) check box, and enter 10 KB as the increment. Then click Continue.

Click Apply.

Your SYSTEM tablespace now has more space in it for your upgrade.

Open a terminal window and execute the following commands:

cd $ORACLE_BASE/product/10.1.0/db_1/bin
dbua

At the Welcome window, click Next.

Select your Oracle9i Database from the list, and then click Next.

You may see a screen asking you if you want to automatically extend the SYSTEM tablespace. Click Continue.

You need to create a SYSAUX tablespace. Accept the default and click Next.

You want to recompile invalid objects at the end of the upgrade. Accept the default and click Next.

You will not make a backup of your Oracle9i Database during the upgrade process. Click Next.

Select Use Database Control for Database Management, and then click Next.

Enter and confirm a password, and then click Next.

Review the summary information. Then click Finish.

You see the progress window.

When your upgrade is complete, click OK.

You see the summary of the upgrade. Scroll down to see the output. When done, click Close.