- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 8.1.7 on HP-UX 11.00
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
тАО09-09-2003 08:31 AM
тАО09-09-2003 08:31 AM
Could you please advice/help me following issues.
I would like to explain first my Production Environment.
Hardware: HP 9000/800 Series HP-UX
OS : HP-UX B.11.00 (64-bit)
RDBMS : Oracle 8.1.7.0.0 (64-bit)
Number of Servers: TWO
Number of Processors: each server has two CPUs
Cluster : HP Cluster
Status of Servers = Active/Passive
Transaction Rate per Hour: 50,000 hits
Records in Database : 16 Millions.
Raid level : 5
System type : Call Center (OLTP)
Problems.
1. I want to re-install Oracle Application on the both servers. Will be any problem on my Database after startup Oracle Server. Why I am doing this, Because on both server's has diffirent oracle binaries. I mean both servers are not identical. I am trying to do identical both. This is production server and we don't have any testing server, and half phase is live.
2. Could you please tell me names of Patches bundle for HP-UX 11.00, Critical FC and VxFs file system. Have not seen any patche on the system.
3. Could you please tell me name of Oracle 8.1.7.0.0 patches bundle. Have not seen any patch on the system.
Thanks
Ghulam Shabir Mallah
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2003 08:49 AM
тАО09-09-2003 08:49 AM
SolutionProblems:
1. Yes. Even if hyou are isntalling the exact same database version, you may have issues with 32/64 bit data conversion. I'm attaching a doc on the subject.
2. Patches:
go here.
http://www2.itrc.hp.com/service/patch/search.do
put in jfs
search, pick patches.
put in vxfs
search, pick patches
http://software.hp.com
jfs
search, pick and download software.
3. Patches. You'll want to patch the database to 8.1.7.4.0
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=43507.1
This doc lists OS patches REQUIRED. Most of them have been superseded. You will want to run them through the patch search link above and get the latest version.
java.
http://www.hp.com/go/java
Pick a version of java 1.3, make sure it and all its patches are installed.
regards and great luck to you.
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
тАО09-09-2003 09:17 AM
тАО09-09-2003 09:17 AM
Re: Oracle 8.1.7 on HP-UX 11.00
I have HP9000 L-Class Enterprise Server.
Database already have installed on the 64-bit.
Could you please recomended some Kernal parameters as well. also I am using sqlldr insert new data in the database. There are about 14 Crontab job running and all are insert data in to database every hour, some of them two files contains about 3 million records to insert into Database.
Basiclly Currently I have HP-UX OS 64-bit
Oracle enterprise edition 64-bit. Will be problem. Is there any chgance for crash database. I'll install first ORacle application on the Passive server then I'll do failover active machine. What do you think am I right. Please find attached my Plan to do this action.
thanks
Ghulam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-09-2003 09:33 AM
тАО09-09-2003 09:33 AM
Re: Oracle 8.1.7 on HP-UX 11.00
My business analysis is that it looks okay.
I am attaching my production kmtune output for my 11.00 system.
Variances:
D380 2 Way, 1 GB of RAM (which among other things, limits shmmax
2 GB of swap.
This is a 32 bit 11.00 system, so you'll get no help with 64 bit parameters.
I'll actually attach a file with two kmtune outputs. The 11.11 file is probably closer to your situation.
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
тАО09-09-2003 08:32 PM
тАО09-09-2003 08:32 PM
Re: Oracle 8.1.7 on HP-UX 11.00
Please refer to the attachment. It provides a central source for the primary installation settings for HP-UX (11.0 and 11i).
It has the Oracle requirements and the Hp-UX 11.0 patches and KERNEL params requirement.
For Oracle 8i the laterst patchset is 8.1.7.4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2003 01:56 AM
тАО09-10-2003 01:56 AM
Re: Oracle 8.1.7 on HP-UX 11.00
Thanks a lot to provide me usefull information. i am little bit confuse about kernal parameter ("nflock" = 200 + SUM of the VALUES of INIT.ORA parameter db_files for all instances of oracle on the machine.)
If you don't mind can you check my INIT.ORA file and tell me suggested values for kernal parameter. And if you suggest some value for init.ora as well for Database performance. You can read all details about my system in first post message.
Thanks and lot.
Ghulam Shabir Mallah
GSM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2003 02:14 AM
тАО09-10-2003 02:14 AM
Re: Oracle 8.1.7 on HP-UX 11.00
I suppose you should go to the latest version available of Oracle binaries 8.1.7.4
You can run SQL query for the version :
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for HPUX: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
Rgds,
JL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2003 02:24 AM
тАО09-10-2003 02:24 AM
Re: Oracle 8.1.7 on HP-UX 11.00
I looked at your ini file :
1) Do you use Java ? if not not reduce your Java pool
2) you have cursor_space_for_time = true
Did you check other parameters related to cursors such as session_cached_cursors ?
Rgds
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2003 05:05 AM
тАО09-10-2003 05:05 AM
Re: Oracle 8.1.7 on HP-UX 11.00
I have installed Oracle Enterprise Edition 8.1.7.0.0 (64-bit).
Will I required these patched 8.1.7.1/8.1.7.2/8.1.7.3. to install Oracle 8.1.7.4 Patch.
I am not using JAVA. I have not check other cursor parameter. Would you like to check me all.
Thanks
GSM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-10-2003 05:25 AM
тАО09-10-2003 05:25 AM
Re: Oracle 8.1.7 on HP-UX 11.00
you can download the patch from Metalink.
But I never succeeded. I had to open a TAR and order the CD. The patch is cumulative on 8.1.7.0.0
(size ~300Mb)
The patch comes with a self explain README file.
Rgds,
Jean-Luc