Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Install patch - Oracle 8.1.7.4 any issues?

SOLVED
Go to solution
Gino Castoldi_2
Honored Contributor

Install patch - Oracle 8.1.7.4 any issues?

Hi,

HPUX 11.11 MC/SG 11.15 Oracle 8.1.7.0 OVO 7.1

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

10 points to any good answer.
Thank you
Gino
7 REPLIES
Helen French
Honored Contributor
Solution

Re: Install patch - Oracle 8.1.7.4 any issues?

What do you mean by installing patch Oracle 8.1.7.0 using 8.1.7.4? If you have version 8.1.7.0, 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 8.1.7.4 any issues?

Hi,

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

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

Re: Install patch - Oracle 8.1.7.4 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 8.1.7.0 to 8.1.7.2 and then step up to 8.1.7.4.0

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.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Yogeeraj_1
Honored Contributor

Re: Install patch - Oracle 8.1.7.4 any issues?

hi,

Upgrade to 8.1.7.4 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.

regards
Yogeeraj
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 8.1.7.4 any issues?

I had upgraded oracle 8.1.7.0 to 8.1.7.4 on HP-UX 11i and did not encounter any issues. The only problem I had was while installing the patchset 8.1.7.4, one of the oracle process (listener process) that is dynamically linked to libwtc8.sl 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 8.1.7.0 when installing patchset.

Here is the checklist for upgrading from 8.1.7.0 to 8.1.7.4

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('');
Commit;

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

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

IA


Never give up, Keep Trying

Re: Install patch - Oracle 8.1.7.4 any issues?

Gino,

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.

Thanks
Raju
Jeff Ohlhausen
Frequent Advisor

Re: Install patch - Oracle 8.1.7.4 any issues?

Gino,
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.

Jeff
Do or do not - there is no try.