8.1.7.0.4 Patch

[netbar]

I have to patch from 8.1.7.0.0 to 8.1.7.0.4, has anyone applied this patch, If so are they any problems when applying it. I must be honest I haven't patched a DB before and would like to find out how to perform this task?

Thanking you advance

[SANJAY_G]

Patches usually come with installation instrunctions in readme file read it carefully, it also lists all restrictions, implications etc.
And yes always take a backup before applying the patch.

[dknight]

8.1.7.0.4 or 8.1.7.4?

I had some problems with a memory leak in 8.1.7.0 until i patched it to level 8.1.7.4.

Have a look at metalink for instructions.

Good luck.

[shashikumar]

Follow the steps given below. Go through with patch readme document also.

1. Shutdown the database in normal mode.
2. Perform a physical backup of the database, if possible oracle software also.
3. Stop all the other services of the oracle that are running on the server. Issue the command and check.

$ ps -ef |grep oracle

ensure that there are no services of oracle are running.

4. Unzip the tar file, untar the patch bundle.

5. Start the oracle Universal installer.

6. Give the path of the product.jar file of the patch bundle. Continue as the screen progress. Ensure that, there is no errors will the patch is linking.
7. After the installation is successfull then start the database and run the following scripts.
1. Catalog.sql
2. Catproc.sql
3. Catexp.sql
if u r running replication feature run Catrep.sql

[pvnad1]

Hi,

Is it required to patch 8.1.7.0.0 to (8.1.7.0.4 or 8.1.7.4 or anything else) to upgrade to 10g?

Thanks in advance

[Axr2]

This might be a good time to read the upgrade document available on technet.