Oracle 8.0.5 installation problem on HPUX 11i

[DESMOND KOH]

Hi,

I am having problem installing new Oracle 8.0.5 32-bit on HPUX 11i. The error occurs while it's trying to create the Database instance. From the installation log, i observed that the installation script failed to connect to "svrmgrl" and it got error message "ORA-3113: end-of-file on communication channel" (pls see the attached file for details log messages.).

I have tried to relink by executing the following command:
# cd /opt/oracle/product/8.0.5/rdbms/lib
# make -f ins_rdbms.mk
and also re-configure the kernel parameter "shmmax" to lower, e.g: 1024MB. It's still the same.

I tried also to install the oracle without creating any database instance and I am getting the same error message when I try to connect to "svrmgrl".

Is oracle 8.0.5 supported on HPUX 11i? Do I need to apply any patch for that to work?

Appreciate you help in advance.

Thanks!
Desmond

[Steven E. Protter]

This error is caused when shmmax or other kernel parameters are set too low.

shmmax can be as large as 25% of total memory which is defined as swap plus physial memory. It should be set generously.

You are going to need an adequate number of shared memory segments and messge queues. How much depends on what else you are running on your box. shmmax is dynamic and can be changed without booting the box.

A few useful commmands.

swapinfo -tam
determines total memory

ipcs
shows ipc use. You will be surprised who is using it.

There are no special patches above and beyond this:

metalink.oracle.com lists a half dozen patches for the OS required for Oracle. They must be installed prior to database installation.

If 8.0.5 uses java, all required java OS patches at http://www.hp.com/go/java must be installed along with java 1.2 or java 1.3 prior to database installation.

All of the above steps with the possible exception of java should be completed and the database software should be reinstalled.

The install log should also be examined for additional information. The Ignore option on any install complaints should NEVER be used.

SEP

[DESMOND KOH]

Hi Steven,

Currently I have set the shmmax to 1024MB. Previously it was set to 2048MB. It was still giving the error.

May I know what is the recommended kernel parameter setting for "shmmax" and also others related parameters?

From the swapinfo -tam command, the total memory is 5084MB.

Below are the result from ipcs command which I do not know how to interpret it:

# ipcs
IPC status from /dev/kmem as of Wed Jul 23 20:47:40 2003
T ID KEY MODE OWNER GROUP
Message Queues:
q 0 0x3c1c0731 -Rrw--w--w- root root
q 1 0x3e1c0731 --rw-r--r-- root root
Shared Memory:
m 0 0x411c07a8 --rw-rw-rw- root root
m 1 0x4e0c0002 --rw-rw-rw- root root
m 2 0x41200880 --rw-rw-rw- root root
m 9219 0x5e44591e --rw------- root root
m 1028 0x00000000 D-rw------- root root
m 7173 0x00000000 D-rw------- www other
m 7174 0x2f445918 --rw------- root root
Semaphores:
s 0 0x411c07a8 --ra-ra-ra- root root
s 1 0x4e0c0002 --ra-ra-ra- root root
s 2 0x41200880 --ra-ra-ra- root root
s 3 0x00446f6e --ra-r--r-- root root
s 4 0x00446f6d --ra-r--r-- root root
s 5 0x01090522 --ra-r--r-- root root
s 6 0x612007db --ra-ra-ra- root root
s 7 0x732007db --ra-ra-ra- root root
s 8 0x702007db --ra-ra-ra- root root
s 9 0x692007db --ra-ra-ra- root root
s 10 0x752007db --ra-ra-ra- root root
s 11 0x632007db --ra-ra-ra- root root
s 12 0x642007db --ra-ra-ra- root root
s 13 0x662007db --ra-ra-ra- root root
s 14 0x6c2007db --ra-ra-ra- root root
s 15 0x6d2007db --ra-ra-ra- root root
s 16 0x6f2007db --ra-ra-ra- root root
s 17 0x410c01e5 --ra-ra-ra- root root
s 18 0x00000001 --ra-ra-ra- root root
s 19 0x2f445918 --ra-ra-ra- root root
s 20 0x522007db --ra-ra-ra- root root


I have no access to the metalink.oracle.com. Can you give me the list of patches required to be installed so that I can check which patches are missing?

Thanks.
Desmond

[twang]

You may try the following and see if it works:
1) Check that the environment variable PATH has /usr/ccs/bin prefacing all other bin locations for the OS.

% echo $PATH
PATH=/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/perf/bin:/opt/langtools/bin:.:/apps/app/oracle/product/8.0.5/bin

% setenv PATH $ORACLE_HOME/bin:/usr/ccs/bin:$PATH

2) Relink Oracle's primary executable.

% cd $ORACLE_HOME/rdbms/lib
% make -f ins_rdbms.mk ioracle

[T G Manikandan]

What are your kernel parameter values?

check up your shared memory and semaphore kernel parameter values?


Thanks

[twang]

The attached is from Oracle metalink's certification and availability.

[Andreas D. Skjervold]

Hi Desmond

Belive this is the maxdsiz kernel parameter. For 8.0.5 this needs to be at least 256M.
Increase this value end relink.

rgds
Andreas

[Jeff Schussele]

Hi Desmond,

Twang is on the right track here.
I don't believe Oracle 8.0.5 was ever certified for HP-UX 11i - your suspicion was correct.
I believe the minimum Oracle version certified for 11i is 8.1.7.4
If you must run 8.0.5, you'll have to run it on HP-UX 11.0 to run reliably.
Also the important item in Twang's attachment is the simple fact that 8.0.5 is now an *unsupported* Oracle version.

HTH,
Jeff

[Martin Johnson]

Jeff,

I believe 8.0.6 is support on 11.x. Oracle 8.0.5 was supported on 10.20 and 11.0. So, unless some patch broke something, 8.0.5 should be able to install on these systems.

HTH
Marty

[Jeff Schussele]

Hi Marty,

Yes, 8.0.5/8.0.6 & even 8.1.6 will all run and were/are supported on HP-UX 11.0 - just NOT HP-UX 11i (11.11).
Of course I'm not a DBA & don't even play one on TV, but this is what all my DBAs tell me.
We've even learned the lesson the hard way that 8.1.7.3 has trouble on 11i whereas 8.1.7.4 runs fine.

Rgds,
Jeff

[DESMOND KOH]

Hi guys,

I have tried the recommendation by Twang, e.g: set the /usr/ccs/bin prefacing all other bin location and also did a relink oracle's primary executable and these are my kernel params setting:

maxfiles 2000
maxfiles_lim 2048
maxtsiz 0x10000000 (268MB)
shmmni 1024
shmseg 240
shmmax 0x40000000 (1073MB)
maxdsize 0x10000000 (268MB)
semmni 1024
semmns 8192
shmem 1

Still couldn't work. :(

Any idea, guys?

Thanks.
Desmond

[Sunil Sharma_1]

HI,

In my knowledge Oracle 8.0 is not supported on HP UX 11i.

But you error indicate problem with kernel parameters. You try to change value of maxtsize parameter(incrase by 50 % and try.

It may work
i faced similer problem with 8.0 with HP UX 11.0

Sunil