topic Re: Oracle problem when startup in Operating System - HP-UX

Oracle problem when startup

meng_1 — Fri, 05 Apr 2002 17:18:03 GMT

Hi all,
I install ora8.1.7 64bit on N4000 HP-UX 11.0. No any error when install. Before install ora I have change the kernel params as oracle request.
But when I stratup oracle with'sql> startup nomount'

after a while the error comes ' ORA-00445: background process "PMON" did not start after 120 seconds'
and the oracle didnot startup.
I check udump log show that:
--------------start-----------
/oracle/app/oracle/product/8.1.7/admin/beiche
Oracle8i Enterprise Edition Release 8.1.7.0.0
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production
ORACLE_HOME = /oracle/app/oracle/product/8.1.
System name: HP-UX
Node name: n4000
Release: B.11.00
Version: U
Machine: 9000/800
Instance name: dev
Redo thread mounted by this instance: 0 Oracle process number: 0
1353

Ioctl ASYNC_CONFIG error, errno = 1

------------end-------------

please give me commens.
thanks in advance

Re: Oracle problem when startup

pap — Fri, 05 Apr 2002 17:21:55 GMT

You need to add the oracle group to the privledges required for locking memory. I guess you've recently loaded some kernel patches and one of the changes to was force the locking of shared memory to obey the same rules and non-shared memory.

have a read of the setprivgrp command. The oracle group will need to be given the MLOCK priviledge.

-pap

Re: Oracle problem when startup

Francois Bariselle_3 — Fri, 05 Apr 2002 18:21:35 GMT

Re: Oracle problem when startup

Andreas D. Skjervold — Fri, 05 Apr 2002 20:43:46 GMT

Hi

Been there done that!

I had this after I configured the async disk driver into the system.
But can also be a result of missing MLOCK priviliges or patch PHKL_22126 or newer.

To correct follow the special instructions following the PHKL_22126 patch:

Special Installation Instructions:
The effective user ID of the process calling async driver, typically called by a process for database applications such
as Oracle and Sybase, must be a superuser or the user must
be a member of a group that has the MLOCK privilege.

To check the privilege capabilities for a group, issue the command:

/usr/bin/getprivgrp

If the output of getprivgrp does not indicate that the
group has the MLOCK privilege, it can be set by issuing the following command as root:

/usr/bin/setprivgrp MLOCK

NOTES: setprivgrp is found in /usr/sbin

To ensure changes are available on reboot, create the /etc/privgroup file with a line in the format:
[groupname] [privilege]
For example:
dba MLOCK

rgds
Andreas

Re: Oracle problem when startup

Andreas D. Skjervold — Fri, 05 Apr 2002 20:45:59 GMT

Forgot to give you the Metalink reference to the Alert on this issue:

Note:133007.1
Subject: ALERT:HP-UX: 8.1.7 RDBMS will not start if the async disk driver is configured

Andreas

Re: Oracle problem when startup

meng_1 — Sat, 06 Apr 2002 17:52:58 GMT

HI all,
Thanks a lot, after I change
MLOCK to group dba, the oracle can startup normally.
Thank again and I have assign the point to all of U.

regards,
MENG