cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle problem when startup

SOLVED
Go to solution
meng_1
Advisor

Oracle problem when startup

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
5 REPLIES
pap
Respected Contributor
Solution

Re: Oracle problem when startup

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
"Winners don't do different things , they do things differently"
Francois Bariselle_3
Regular Advisor

Re: Oracle problem when startup

Andreas D. Skjervold
Honored Contributor

Re: Oracle problem when startup

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

Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Andreas D. Skjervold
Honored Contributor

Re: Oracle problem when startup

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
meng_1
Advisor

Re: Oracle problem when startup

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