- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Database Related
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
тАО11-30-2002 05:32 AM
тАО11-30-2002 05:32 AM
Database Related
The Scenario,
The HP Vclass system has the following Oracle Production Systems running.
3 Instances of Oracle 8 databases
2 Instances of Oracle 8i databases
2 instances of Oracle Financials 11.5.7
Server Configuration
Memory : 4gb Swap Space 8gb Operating System HPUX11.0
4 cpus @240Mhz
The available memory when these systems are running is approximately 650MB
Problem:
When we issue the command to start the 3rd Instance of the Oracle8i Production database we get the following error message
HPUX Error: 12 'Not Enough Space'
Please help ....
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2002 06:39 AM
тАО11-30-2002 06:39 AM
Re: Database Related
Take a quick look at following link.
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x90c153921f1ad5118fef0090279cd0f9,00.html
Hope it helps.
Robert-Jan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2002 07:42 AM
тАО11-30-2002 07:42 AM
Re: Database Related
Do a swapinfo -ta
to check the amount of memory used and the amount of swap space used on the system.
Probably the new instance does not enough memory to startup.
What is the SGA size of the new instance?
What is the shmmax parameter value on the system?
What is the size of the buffer cache on the system?
dbc_max_pct and dbc_min_pct.
My approach would be like,
1.check the amount of buffer cache on the system.
Your machine has 4GB.Then the value of dbc_max_pct=8 and dbc_min_pct=4 should be fine.
By default the value is 50 i.e.half of the memory is allocated for buffer cache.
Also with Oracle running it has its own buffer cache.
2.What is the value of the shmmax parameter?
Try increasing it.
check this size.
3.What is the value of SGA for the new instance.YOu can reduce the size of SGA for the new instance and try starting up.
If all the above does not work.
Then try using Glance to check the processes memory usage.
You can also use
UNIX95= ps -e -o ruser,pid,vsz=Kbytes|more
to check the process memory usage and stop the unwanted processes running.
4.YOu can also go for a multithreaded (MTS) instead of dedicated instance for the Oracle.
This should reduce the existing database memory usage.
Because the 8i version,each client connection takes around 30MB incase if you are running under dedicated server model.
check things out and revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2002 11:36 AM
тАО11-30-2002 11:36 AM
Re: Database Related
what I cannot see in your posting is wether your Oracle instances are 32bit or 64bit?
With 32bits they can only use a SHARED 1GB maximum memory segment all together :-(
Or do you use "memory windows", i.e. the command "set_memwindow(1M)"?
Then be careful that all your LISTENERs must be prefixed with the appropriate "set_memwindow(1M)" command, too...
FWIW,
Wodisch
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2002 08:10 PM
тАО11-30-2002 08:10 PM
Re: Database Related
Did I hear someone say "superdome" ??
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2002 01:13 AM
тАО12-01-2002 01:13 AM
Re: Database Related
I am also attaching an output from swapinfo and kmtune -l .
In addition the Oracle installation is a 32 bit application
The SGA is 256000
Shared pool size = 300000000
Hope by perusing these it would clear the requirements to provide me a solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2002 01:15 AM
тАО12-01-2002 01:15 AM
Re: Database Related
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2002 04:29 AM
тАО12-01-2002 04:29 AM
Re: Database Related
First thing: you need to change Parameter: dbc_max_pct to 8% (it's 20% now) and dbc_min_pct to 4% (which is 5% now).
live free or die
harry
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2002 06:56 PM
тАО12-01-2002 06:56 PM
Re: Database Related
shmmax
maxdsiz
maxdsiz_64
kernel parameters.
These parameters are definitely very small.
Increase them to 1GB.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2002 10:21 PM
тАО12-01-2002 10:21 PM
Re: Database Related
I was facing the same problem with 3 oracle instances, after increasing the swap the database was working satisfactorily