Database Update 9.2.0.3 Linux

Setup Procedure for a Linux Installation.

Follow the procedure below to run the Oracle patch on the Linux platform:

1) Stop all components individually before the Oracle upgrade patch is applied.

2) Login as "oracle" user on the database server and check that the environment variables ORACLE_HOME and ORACLE_SID are set

3) Insert and mount the operating system dependant CD:
Give root>mount /media/cdrom from root comand to mout the cd.

Linux: Database Update 9.2.0.3 Linux

4) Open two shells one is the root comand shell and another shell wherein login as oracle user (oracle shell).

5) In oracle shell make a directory as patch
usr/oracle> mkdir patch

6) Check the cd i.e thru root comand check the cd
root>cd /media/cdrom
now u will inside the cdrom directory
root/media/cdrom> ls (give this command, it will list the content of the directory)
U will be shown with 2 zip files. Copy these zip files from cdrom to a folder in oracle home. (i.e thru oracle shell)
give the following command:
root/media/cdrom> cp *.zip /usr/oracle/patch
Now the zip files would be copied inside the patch directory.

7) Now go to the oracle logged in shell.
go to patch directory
usr/oracle> cd patch
usr/oracle/patch> ls (give this command and u will see the copied zip files)
Unzip the files:
usr/oracle/patch> unzip *.zip (this command will unzip the files)
Then give ls command and u will see one tar and one jar file.

Untar the file:
usr/oracle/patch> tar -xvf *.tar

Unjar the file:
usr/oracle/patch> jar -xvf *.jar
Change permissions as follows:
usr/oracle/patch> chmod -R +x Disk1

After giving this comands give ls command and check the patch directory u will find a Disk1 directory created in patch directory. Keep a note of it.

The above steps are very important steps, so please do it properly or else u will face problems during installation.


8) Shut down the Oracle Server instance with immediate priority through oracle shell as follows:

usr/oracle> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate;
SQL> exit;

Stop the listener component as follows from root shell:
root> lsnrctl stop

Important Note
There should be no Oracle process left running. If this is a fresh Oracle
installation the dbsnmp process may still be active even with the database
in the shutdown mode. Terminate this process before proceeding to starting
step 5.

9) Now go to the oracle shell into tat patch folder and
/usr/oracle/patch> cd Disk1
/usr/oracle/patch/Disk1> cd install
/usr/oracle/patch/Disk1/install> cd linux
Now run export command:
/usr/oracle/patch/Disk1/install/linux> export DISPLAY=root:0.0

Now run the installer
/usr/oracle/patch/Disk1/install/linux> runInstaller

Now u will see a GUI interface opening on the screen.

10) Follow the steps given below within the installer:
a. On the Welcome screen, click the Next button.
»This will display the File Locations screen.

b. Click the Browse button for the Source... entry field and navigate to the stage directory where you unpacked the Patch Set tar file.
c. Select the products.jar file.
d. Click OK, then click the Next button
»The products to be loaded will be displayed.

For Solaris: select "Oracle 9i R2 Patch Set 9.2.0.3.0",
For Linux: select "Oracle 9i R2 Patch Set 2 9.2.0.3.0".

If the screen in front of you does not show you the above options:
Then you dont have to wory some more steps would be included for you click next and then click on the install button. For you people there are some more steps that have to be followed which are mentioned at the end of the document.

If your screen shows the above options as it is then continue:
e. Click the Next button.
»The products file will be read and the installer will load the product definitions.
f. Verify the products listed and then click on the Install button.

11). Open a new session as a “root” user for the next step.

12) For the one whose screen has not given the option of installing 9.2.0.3 then for them this step is ommited the system is not gona ask you for root.sh command .
When the installer prompts you to run root.sh, run $ORACLE_HOME/root.sh from the above "root" session.
On a Linux system you will be asked to provide a path, take the default given:
/usr/oracle/bin.
It may be possible that u could be asked by the system that do you want to overwrite the bin folder and select yes i.e Y

Once the installation has completed successfully, it will display "End of Installation".

13). Click on Exit and confirm to exit the installer.

14). Exit the root session.
15). To complete the install of this patch set, you should start up the database as an “oracle” user. Change directory to $ORACLE_HOME and run the following commands/scripts as follows:

usr/oracle> sqlplus /nolog

SQL> connect / as sysdba
SQL> startup migrate
SQL> spool patch.log
SQL> @rdbms/admin/catpatch.sql
SQL> spool off

16). Review the patch.log file for errors and re-run the catpatch script after correcting any problems:

SQL> shutdown
SQL> startup
SQL> @rdbms/admin/utlrp.sql
SQL> shutdown

Important On a Linux system you will be asked to provide a path, take the default given:
/usr/local/bin

SQL> startup
14. Start the listener component as follows:

usr/oracle> lsnrctl start

15. Restart all components individually



SOME MORE STEPS:

Here the installation is complete for some, not for those who have not got the option of installing 9.2.0.3

You have to shutdown the database and the listener. Then login as a oracle user and select the directory install
/usr/oracle> cd install
Then run the installer
/usr/oracle/install> runInstaller

Again you will see the GUI interface, here select do as before but during selection of path click on browse button select the path
/usr/oracle/patch/stage/product.jar
As there are two stage directories first is in patch directory and another in Disk1 directory. Previously you would have selected Disk1 stage directory, now you have select patch stage directory.
and then follow the same procedure from Step 11