Showing results for 
Search instead for 
Did you mean: 

Install patch - Oracle any issues?

Go to solution
Gino Castoldi_2
Honored Contributor

Install patch - Oracle any issues?


HPUX 11.11 MC/SG 11.15 Oracle OVO 7.1

We are going to patch Oracle using Are there any issues I should be concerned about. (We are running MC/SG too).

10 points to any good answer.
Thank you
Helen French
Honored Contributor

Re: Install patch - Oracle any issues?

What do you mean by installing patch Oracle using If you have version, find out the patch available for that version and install it. Check the patch descriptions for any warnings or known bugs. If everything looks okay, you don't need to worry.
Life is a promise, fulfill it!
Gino Castoldi_2
Honored Contributor

Re: Install patch - Oracle any issues?


I am checking for any issues or things I should look out for before we install
Oracle patch

10 points to any good answer.
Thank you
Steven E. Protter
Exalted Contributor

Re: Install patch - Oracle any issues?

Metalink has some documentation on this issue.

If you have any issues with java objects not being able to compile or word size conversion, you may actually need to do a incremental change from to and then step up to

The install document is regularly revised, has something like 30 possible steps and should be adhered to strictly.

A full binary and database backup is a must prior to starting.

We're not running with ServiceGuard yet, so I'm not much help there.

Steven E Protter
Owner of ISN Corporation
Honored Contributor

Re: Install patch - Oracle any issues?


Upgrade to is a must.

but before you start any upgrade process, you should ensure that you have a proper backup and a clear procedure about how to revert back (with the least downtime) in case of any problems.

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Indira Aramandla
Honored Contributor

Re: Install patch - Oracle any issues?

I had upgraded oracle to on HP-UX 11i and did not encounter any issues. The only problem I had was while installing the patchset, one of the oracle process (listener process) that is dynamically linked to has locked the file and the installation could not open the file. So you should make sure the oracle listener process is not runing for when installing patchset.

Here is the checklist for upgrading from to

1. PERFORM a Full cold backup
2. Verify all necessary OS patches are installed.
3. Verify the kernel parameters according to the installation guide of the new version
4. Verify characterset of the database:
Select name, substrb(value$,1,40) value from props$;

5. Ensure that all Snapshot refreshes are succesfully completed. And replication is stopped.
Select distinct(trunc(last_refresh)) from dba_snapshot_refresh_times;

6. Stop the listener for the database
$ lsnrctl
Lsnrctl> stop

7. Ensure no files need media recovery:
$ sqlplus SYS/
Select * from v$recover_file;

Ensure no files are in backup mode:
Select * from v$backup where status!='NOT ACTIVE';

8. Resolve any outstanding unresolved distributed transaction:

Select * from dba_2pc_pending;

If this returns rows you should do the following:

Select local_tran_id from dba_2pc_pending;
Execute dbms_transaction.purge_lost_db_entry('');

9. Run the appropriate the script to upgrade form to 8.1.7 4

10. Verify for any invalid objects and re-compile them is any.


Never give up, Keep Trying

Re: Install patch - Oracle any issues?


If you are patching on HP_UX, it will work as desired. If you are patching on Solaris, there is a file corruption issue on exported files. It will not import data and end up nowhere. But there is a patch available for this on metalink. If you need more info, let us know.

Jeff Ohlhausen
Frequent Advisor

Re: Install patch - Oracle any issues?

One more thing - just check any support documentation for any application that resides on the database. For example, if you are upgrading a database that SAP resides upon you may need to change some environment variables.

Do or do not - there is no try.