- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ORA-27100
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-11-2002 10:18 AM
тАО12-11-2002 10:18 AM
The dba took it down hard and now it won't come back.
ORA-27100: shared memory realm already exists
How can I clear this from the SGA without rebooting the server?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-11-2002 10:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-11-2002 10:45 AM
тАО12-11-2002 10:45 AM
Re: ORA-27100
I see this in the doc: Reducing the size of the SGA allows the instance to start and recover.
But nothing states how to do this. Does modifying the init file like the doc says do this?
What if other instances of the same version of oracle are still running? Does that matter?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-11-2002 10:55 AM
тАО12-11-2002 10:55 AM
Re: ORA-27100
The icps command determines the shared memory and I was able to remove it.
However only after shutting down the other two databases that were run by the same ID.
Is there any way that I could have determined which shared memory ID was for each oracle instance that was running under the same ID?
For example assuming icps -m shows the following:
IPC status from
T ID KEY MODE OWNER GROUP
Shared Memory:
m 0 0x50002cde --rw-r--r-- root root
m 2 0x06347849 --rw-rw-rw- root root
m 3 0x3100e002 --rw-rw-rw- root root
m 6 0xd1ca3da8 --rw-r----- oracle dba
m 604 0xf1cacda8 --rw-r----- oracle dba
m 1205 0x2ba74bdc --rw-r----- oracle dba
m 5007 0x3e6b161c --rw-r----- oracle8i dba
there are three segments owned by oracle. How can I determine which are related to which instance of oracle?
TIA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-11-2002 12:24 PM
тАО12-11-2002 12:24 PM
Re: ORA-27100
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-11-2002 02:48 PM
тАО12-11-2002 02:48 PM
Re: ORA-27100
/usr/sbin/setprivgrp dba MLOCK
As root. I don't seem to need to do this in 11.11, but in 11.00 after the December 2000 patch set, I needed this.
Also, if you have some other product doing asynchronous access like Software AG adabas, it can hose up the shared memroy realm and trigger your Oracle area.
The only solution thus far if the ipcrm -m command fails is punt, as in reboot.
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com