- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Can start or stop Oracle DB.
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
тАО08-25-2003 09:05 AM
тАО08-25-2003 09:05 AM
HP-UX 11.0 Oracle 8.1.7.3 VPO 6.15 MC/sg 11.09
There were numerous sqlplus calls/processes being made in VPO which slowed the system down
so I decided to stop VPO and Oracle.
However on the primary node Oracle will not start up now, it lists these errors:
08/25/03 12:02:56 ERROR ovoareqsdr (Request Sender)(6932) [dcesec.c:925]: Can't
bind to DCE security service: No currently establish
ed network identity for which context exists (dce / sec). (OpC20-2645)
Database: ORA-00020: maximum number of processes (50) exceeded
(OpC50-15)
Could not connect to database ov_net.
Please look if the database processes are running. (OpC50-2)
Connect to database failed. (OpC40-410)
I can start up the "listener" manually but when I run SVRMGRL> startup
it gets these errors:
ORA 01081 "cannot start already-running ORACLE - shut it down first"
If I try to startup Oracle says it needs to be
running. Note: Our database is not in archive mode.
Any ideas as to how to fix this problem?
10 points to any good answer.
Thank you
Gino
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-25-2003 09:12 AM
тАО08-25-2003 09:12 AM
Re: Can start or stop Oracle DB.
# ps -ef |grep "ora_" |grep -v grep |grep $ORACLE_SUD |awk '{print $2}' |xargs -i kill -9 {}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-25-2003 09:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-25-2003 09:19 AM
тАО08-25-2003 09:19 AM
Re: Can start or stop Oracle DB.
ORA-00020: Maximum number of processes (600) exceeded. This error may occur when workload testing is invoked. Make sure to increase the parameter of ???processes??? in ???init.tmp??? at setup time or in ???run_init.pops??? at run time. The original script set the value of 200 for version 8.1.5. It is recommended to set the value to 300 at setup time and 400 at runtime for Oracle version 8.1.6 and 8.1.7.
http://www1.itrc.hp.com/service/cki/cache/200000061824906.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-25-2003 09:22 AM
тАО08-25-2003 09:22 AM
Re: Can start or stop Oracle DB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-25-2003 10:30 AM
тАО08-25-2003 10:30 AM
Re: Can start or stop Oracle DB.
Since we are running on a two node cluster I failed VPO over to the fail-over node and VPO started right up.
We checked shared memory/semaphores on the primary node where Oracle has the issues and VPO won't start and there are shared memory segments and semaphores still allocated.
On the fail-over secondary node there were no segments allocated so that's why VPO started up fine.
We're thinking that shared memory, etc, is still allocated on the primary node and that's why Oracle thinks it's still running.
10 points to any good answer.
Thank you
Gino
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-25-2003 11:13 AM
тАО08-25-2003 11:13 AM
Re: Can start or stop Oracle DB.
This message can still occur even after you
nuked the oracle processes. It means there is still ipcs context around (the SGA!).
To clear that use: svrmgrl> shutdown abort
If it is still unwilling (and a reboot is not
possible), you can try playing with ipcrm and you want to check for a stray file: $ORACLE_HOME/dbs/lk
hth,
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-26-2003 12:45 AM
тАО08-26-2003 12:45 AM
Re: Can start or stop Oracle DB.
Please try the following:-
1. Edit the database init.ora file
2. Locate and increase the processes parameter to a higher value.
3. Save the init.ora file
4. Stop and restart the database
5. Re-connect to the database instance
To set the value for process use this proc.
SESSIONS
Default value: Derived: 1.1 * PROCESSES + 5
TRANSACTIONS
Default value: Derived (1.1 * SESSIONS)
And remember always to check kernel parameters for process limit (maxuproc/maxusers).
You can add the following to your code.SET TRANSACTION READ ONLY and COMMIT WORK RELEASE statements to avoide maxprocess exceeded.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-26-2003 12:45 AM
тАО08-26-2003 12:45 AM
Re: Can start or stop Oracle DB.
To remove a held semaphore after a crash,
# ipcs -sa |grep oracle
s 403021 0xc9d9cb2c --ra-r----- oradb dba oracle dba 204 12:17:36 5:00:38
to release semaphore sets 204,
# ipcrm -s 204