Oracle 8.1.7 on HP-UX 11.00

[Ghulam Shabir Mallah_1]

Hi Gurus,

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

[Steven E. Protter · Accepted solution]

What kind of HP 9000/800 Series box. this has impact, though almost any modern box will run the application you've laid out.

Problems:
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

[Ghulam Shabir Mallah_1]

Hi Steven,

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

[Steven E. Protter]

I'm not qualified to judge your implementation plan becasue I'm not using HP clusters.

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

[Indira Aramandla]

Hi Ghulam,

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

[Ghulam Shabir Mallah_1]

Hi Indira,

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

[Jean-Luc Oudart]

Hi Ghulam,

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

[Jean-Luc Oudart]

Hi again,

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

[Ghulam Shabir Mallah_1]

HI All,

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

[Jean-Luc Oudart]

Ghulam,

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

[Steven E. Protter]

The database uses java, so I hope that's installed.

I just had a conference call with Oracle and the noted that support for 8.1.7 is being pulled 12/31/2003.

I'd plan an upgrade path.

I'm not exactly sure what support expiration means in the oracle world. It means no more big patches except for security fixes. I'm not sure what a call to the support center will garner in terms of a response 1/1/2004.

SEP

[Jean-Luc Oudart]

The extended support is available until 31/12/2006.

From my understanding, you will not have bug fixes after 31/12/2003, but they will still answer your questions and try to help you with workaround (if any !).
unless you have EMS !

JL

[Ghulam Shabir Mallah_1]

Hi Jean,

Can u do me favor. Can you burn cd and send it me. I'll pay all cost what ever come.

But make sure I have HP-UX 64 Bit and Oracle Enterprise Edition 64-bit.

And I am looking for Oracle 8.1.7.4

I'll appreciate you.


Thanks

GSM

[Jean-Luc Oudart]

Ghulam,

The best for you is to open a TAR.
I assume you are an Oracle customer and know all about Metalink.

Rgds,
Jean-Luc

[Ghulam Shabir Mallah_1]

Jean,

How long they will take to send it me. My base is in Dubai - UAE Middle East


Thanks

GSM

[Jean-Luc Oudart]

A far as I can remember it takes only a few working days.

Rgds,
JL

[Indira Aramandla]

Hi Ghulam,

Sorry for the late reply. I was out of office for the last two days.

Well when you installed Oracle RDBMS 8.1.7 then go for the latest pathcset which is 8.1.7.4. You can try to dowmload from Oracle Metalink, or log a TAR with oracle and they will send the patchset in a CD in about 3 - 4 working days.

Attached are the documents, which provides brief description about the init.ora parameters relating to performance, and KERNEL parameters setting for oracle 8i (8.1.7) rdbms. It give3s few examples of different configurations.

[Indira Aramandla]

Hi Ghulam,

Forgot the oher attachment.