Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i installation on hpux 11.

SOLVED
Go to solution
Giel Smits
Occasional Advisor

Oracle 9i installation on hpux 11.

Hi There,

I have the following problem. I've installed Oracle 9i on a Hpux 11 system (c3000).
When I leave the system running (with DB running) the next day when I do "top -s1" I have 4mb left of the +/- 225 the day before.
Could this be a memory leak??

But now even worse.. If I create a new DB with the DBCA utility.. at the moment it starts creating it.. the VHAND process is very busy (normal I think) but after a few seconds the systems "hangs" ==> a load above 9 (the display reads FA1F) and telnetting isn't possible anymore.. So I have to reset the system or wait 3 days to let the process finisch.

I already did everything with the kernel parameters (there are a lot of 9i install docs), but I can send them.

What could be the problem?

Thanx in advance
Jorg.

13 REPLIES
Praveen Bezawada
Respected Contributor

Re: Oracle 9i installation on hpux 11.

Hi Smits
How are the CPU utilisation and disk IO rates.
Can you post your kernel setting and database initialisation setting.

...BPK...
T G Manikandan
Honored Contributor

Re: Oracle 9i installation on hpux 11.

Hello,
The VHAND process is the process which is used for paging.I assume there is a shortage of memory on the machine.
What is the size of the memory in the machine.
What is the amount of available memory and lockable memory?
You can get the information from syslog.log file.
Might be you can tune some kernel parameters to make a difference.Please post the values of the kernel parameters.

Thanks
G Manikandan
Giel Smits
Occasional Advisor

Re: Oracle 9i installation on hpux 11.

Hi, Here's /stand/system.. hope that's okay.

Note : is is a C3000 machine with 512mb memory.

Kernel parms:
---------------------* Tunable parameters

STRMSGSZ 65535
bufpages (NPROC*3)
dbc_min_pct 20
default_disk_ir 1
max_thread_proc 256
maxdsiz 1073741824
maxdsiz_64bit (MAXDSIZ*2)
maxfiles 2048
maxfiles_lim 2048
maxssiz 134217728
maxssiz_64bit 0X040000000
maxswapchunks 4096
maxuprc 3686
maxusers 300
maxvgs 80
msgmap (NPROC+2)
msgmax 32768
msgmnb 65535
msgmni (NPROC)
msgseg (NPROC*4)
msgssz 128
msgtql (NPROC)
ncdnode 200
ncsize ((8*NPROC+2048)+VX_NCSIZE)
nfile 34816
nflocks 4096
nhtbl_scale 1
ninode 40000
nproc 4096
npty 400
nstrpty 400
nstrtel (MAXUSERS)
nswapdev 25
semmap ((NPROC*2)+2)
semmni (NPROC*2)
semmns 16384
semmnu (NPROC-4)
semume 64
semvmx 32768
shmmax (0X40000000/2)
shmmni 512
shmseg 32
swapmem_on 0
timeslice 1
vps_ceiling 64


-----------------

Swlist -l bundle

64-bitDevLibs B.11.00 Cross Platform Development Kit
A3495A B.11.00.06 HP-PB 100BT LAN/9000
A3739B B.11.00.16 PCI FDDI/9000 Media
A4926A B.11.00.11 1000Base-SX PCI Gigabit Ethernet Driver
A4929A B.11.00.11 1000Base-T PCI Gigabit Ethernet Driver
A5230A B.11.00.05 100BT/9000 PCI
B6835AA B.11.00.05 Netscape 6.2.1
B6848AB 1.1.2 GTK+ Support Libraries for HP-UX 11.00
HPUXEng64RT B.11.00.01 English HP-UX 64-bit Runtime Environment
HWE1100 B.11.00.0112.7 Hardware Enablement Patches for HP-UX 11.00, December 2001
J3515A B.11.00.05 100BT/9000 GSC for B, C, D, and J Series
J3516A B.11.00.05 100BT/9000 GSC for B, C, D, and J Series
OnlineDiag B.11.00.19.10 HPUX 11.0 Support Tools Bundle, Dec 2001
QPK1100 B.11.00.54.7 Quality Pack for HP-UX 11.00, September 2001
UXCoreMedia B.11.00.02 HP-UX Media Kit (Reference Only. See Description)
UnlimUserLic B.11.00.02 HP-UX Unlimited-User License
XSWGR1100 B.11.00.47.08 General Release Patches, November 1999 (ACE)




Giel Smits
Occasional Advisor

Re: Oracle 9i installation on hpux 11.

Additional information:

syslog.log info -->

physical page size = 4096 bytes, logical page size = 4096 bytes.

Physical: 524288 Kbytes, lockable: 314496 Kbytes, available 381444 Kbytes.



Gnananandhan
Frequent Advisor

Re: Oracle 9i installation on hpux 11.

Use swapinfo, top and sar commands to check the system and memory utilization, May be you have to configure some more swap space.

Regards,
Gnana A.
If there is a better way to do it, find it !
Giel Smits
Occasional Advisor

Re: Oracle 9i installation on hpux 11.

there is 1 gig swap configured.
swapinfo -t says: 0% PCT USED
Total 1048576, Kb Free = 879884, 16% PCT USED.

I cannot run sar, or top, because when I create the database, and thats the moment you want to see whats happening, the system get a load of 10.. so the sar process isn't reponding anymore.

T G Manikandan
Honored Contributor
Solution

Re: Oracle 9i installation on hpux 11.

I assume your database is not a big one.
One thing I could see is that the nproc value is 4096 which can be
reduced.
I think the value of nproc is
nproc=(20+8*MAXUSERS)
You can reduce the no.of processes on the system to around 2500.
nproc=20+8*300=2420.
which should reduce some of the memory related tunable parameters.

Also check the size of the SGA for oracle.
Keep it at optimum and then you can increase once it crosses the limits.


Thanks
Giel Smits
Occasional Advisor

Re: Oracle 9i installation on hpux 11.

Hi,

I'm very new to Oracle..
To make thing clear..

Is SGA global to Oracle or is it a setting for
each Database seperate..

2) Where can I change this...

3) It is a tiny database... With my problem .. what settings should I try...


Kind regards.
Jeanine Kone
Trusted Contributor

Re: Oracle 9i installation on hpux 11.

SGA is per database instance. It is determined by the settings in the init.ora file (db_block_buffers, shared_pool_size).

As far as good settings, size is relative. I have my small instances set to a total of 75 Megs.
Yogeeraj_1
Honored Contributor

Re: Oracle 9i installation on hpux 11.

hi Jorg,

i think your SGA is not properly sized.

I would recommend you to edit your configuration file and use the settings for a small database. (configuration file is $ORACLE_HOME/dbs/init.ora)

To start with the main parameters that you should look into are:
large_pool_size, shared_pool_size and java_pool_size

Are you using MTS or Dedicated?
Dedicated processes take more memory.

are you using java?
If not, you can use a lower value for your JAVA_POOL_SIZE

Most Important of all: Check you OS setting as per the pre-installation tasks. If you did not go through it before the installatio, go through it again.

Hope this helps.
Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
T G Manikandan
Honored Contributor

Re: Oracle 9i installation on hpux 11.

Hello,
The SGA is per instance.
check your SGA size.

go to server manager
$svrmgrl
svrmgrl>connect internal
svrmgrl>show sga
to find the size of the database.

Thanks
Giel Smits
Occasional Advisor

Re: Oracle 9i installation on hpux 11.

Thanx guys..
I think I have the appropriate information..

I'll check the above suggestions..
Bill Hassell
Honored Contributor

Re: Oracle 9i installation on hpux 11.

Just a note about RAM and Oracle. 512 megs is crippling Oracle. Think a minimum of 2 Gbytes, (4 Gbytes is much better) so that SGA can be increased to a useful value without massive swapping. You can verify swapping with vmstat. If the "po" column is more than 1 digit for long periods (minutes) then your system is swapping and performance will be awful (more than 100 and people will have problems logging in).

The fact that it takes 3 days to create a new database seems to confirm that RAM is way too small.


Bill Hassell, sysadmin