Help , can not start database instance!

[violin_1]

Dear All,

We have a new HP-UX server version 11.11
# uname -a
HP-UX tperp B.11.11 U 9000/800 4217835225 unlimited-user license
#
I try to clone database from PROD server ,
After tar command run completely,tried to startup instance , but I got the following errors:

oraerp> sqlplus internal/oracle

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Dec 9 09:25:11 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile=$ORACLE_HOME/dbs/initPROD.ora
ORA-24323: value not allowed
ORA-27146: post/wait initialization failed
SQL> exit
Disconnected
oraerp> oerr ora 24323
24323, 00000, "value not allowed"
// *Cause: A null value or a bogus value was passed in for a mandatory
// parameter.
// *Action: Verify that all mandatory parameters are properly initialized.
oraerp> oerr ora 27146
27146, 0000, "post/wait initialization failed"
// *Cause: OS system call failed
// *Action: check errno and contact Oracle Support
oraerp>

I don't know what's wrong with it?
The initPROD.ora is running normally in PROD site.

Need help and Thanks!!!

Violin.

[Yogeeraj_1 · Accepted solution]

hi,

For the ORA-24323 error, it is normally a database startup/initialisation parameter problem. Please review which parameters(if any) were modified and refer to the Oracle8i Reference manual and/or port-specific Installation/Users guide for a valid range of values.

For the ORA-27146, the modifications you made may have caused you to exceed the amount of OS semaphores. You must make sure there are sufficient semaphores for each Oracle process. Therefore, you either need to decrease the init.ora parameters or increase the semaphores.

Do an "ipcs -s" to find out what semaphores are hold by oracle
If no oracle processes are running then no semaphores should be hold
by the owner oracle. To remove the semaphores do an "ipcrm -s ID" where ID is the semaphore identifier.

Also if you are still on 8.1.7.0, consider applying patchset 8.1.7.4.

And finally, why don't you just reinstall the Oracle Database! It won't take you much time.

then,
I would shutdown
I would backup
I would restore
I would startup

downtime = very little.

I would then move objects around as needed. alter index rebuild online to
minimize downtime -- alter table move ....

hope this helps!

Best Regards
Yogeeraj

[Ian Lochray]

Check the value of the Oracle initialisation parameter "processes" and ensure that this does not exceed the values of the kernel parameters maxuprc and nproc.

[Volker Borowski]

Violin,

it might simply be that sqlplus is not evaluating your shell-variable $ORACLE_HOME.

Either type the entire path to your init.ora file or use "?/dbs/initPROD.ora".

? stands for ORACLE_HOME in SQLPLUS.

Hope this helps
Volker

[violin_1]

Dear All,

Thanks for all replies, I found a doc in Oracle Meatalink(note id : 15566.1)
It means that shared memory and semaphore didn't tune well, so instance startup failed.

I check the following parameters:
shmmax , shmmni , shmseg , semmns , semmni
Tuned the values the same as PROD site ,
then reboot. Now it runs smooooooothly.

Thanks!!!

Violin.