- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Help , can not start database instance!
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2002 05:52 PM
тАО12-08-2002 05:52 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-08-2002 08:11 PM
тАО12-08-2002 08:11 PM
SolutionFor 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2002 03:29 AM
тАО12-09-2002 03:29 AM
Re: Help , can not start database instance!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2002 10:18 AM
тАО12-09-2002 10:18 AM
Re: Help , can not start database instance!
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-09-2002 05:58 PM
тАО12-09-2002 05:58 PM
Re: Help , can not start database instance!
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.