Database Related

[Faizer Jameel]

Gentlemen;

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 ....

[Robert-Jan Goossens]

Hi,

Take a quick look at following link.

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x90c153921f1ad5118fef0090279cd0f9,00.html

Hope it helps.

Robert-Jan.

[T G Manikandan]

HPUX error 12 not enough space is due to the insufficient memory on the system for the new instance.

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

[Wodisch]

Hi,

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

[harry d brown jr]

4Gb of memory, even 8GB of swap, isn't a lot of memory for the resource pig "ORACLE", especially for 7 Instances! I don't even think 16GB would satisfy that BEAST. Plus, with 4 cpu's, you don't have the horse power to swat a flea. I sure hope you have one hell of a great IO sub-system.

Did I hear someone say "superdome" ??

live free or die
harry

[Faizer Jameel]

Thankyou for the replies;
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.

[Faizer Jameel]

The Kernel paarameter output

[harry d brown jr]

Faizer,

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

[T G Manikandan]

YOu should increase your

shmmax
maxdsiz
maxdsiz_64

kernel parameters.

These parameters are definitely very small.

Increase them to 1GB.


Thanks

[Ravi_8]

Hi, Faizer

I was facing the same problem with 3 oracle instances, after increasing the swap the database was working satisfactorily