- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Install patch - Oracle 8.1.7.4 any issues?
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-18-2003 06:25 AM
тАО12-18-2003 06:25 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-18-2003 06:39 AM
тАО12-18-2003 06:39 AM
Solution- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-18-2003 06:53 AM
тАО12-18-2003 06:53 AM
Re: Install patch - Oracle 8.1.7.4 any issues?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-18-2003 06:55 AM
тАО12-18-2003 06:55 AM
Re: Install patch - Oracle 8.1.7.4 any issues?
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-18-2003 03:41 PM
тАО12-18-2003 03:41 PM
Re: Install patch - Oracle 8.1.7.4 any issues?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-18-2003 07:32 PM
тАО12-18-2003 07:32 PM
Re: Install patch - Oracle 8.1.7.4 any issues?
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2003 12:16 AM
тАО12-19-2003 12:16 AM
Re: Install patch - Oracle 8.1.7.4 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.
Thanks
Raju
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2003 12:22 AM
тАО12-19-2003 12:22 AM
Re: Install patch - Oracle 8.1.7.4 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.
Jeff