topic Re: Oracle 9i installation on hpux 11. in Operating System - HP-UX

Oracle 9i installation on hpux 11.

Giel Smits — Wed, 12 Jun 2002 06:59:25 GMT

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.

Re: Oracle 9i installation on hpux 11.

Praveen Bezawada — Wed, 12 Jun 2002 07:41:33 GMT

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

...BPK...

Re: Oracle 9i installation on hpux 11.

T G Manikandan — Wed, 12 Jun 2002 07:54:09 GMT

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

Re: Oracle 9i installation on hpux 11.

Giel Smits — Wed, 12 Jun 2002 07:54:57 GMT

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)

Re: Oracle 9i installation on hpux 11.

Giel Smits — Wed, 12 Jun 2002 08:02:51 GMT

Additional information:

syslog.log info -->

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

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

Re: Oracle 9i installation on hpux 11.

Gnananandhan — Wed, 12 Jun 2002 08:25:40 GMT

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.

Re: Oracle 9i installation on hpux 11.

Giel Smits — Wed, 12 Jun 2002 08:41:28 GMT

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.

Re: Oracle 9i installation on hpux 11.

T G Manikandan — Wed, 12 Jun 2002 11:34:28 GMT

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

Re: Oracle 9i installation on hpux 11.

Giel Smits — Thu, 13 Jun 2002 07:45:31 GMT

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.

Re: Oracle 9i installation on hpux 11.

Jeanine Kone — Thu, 13 Jun 2002 16:37:03 GMT

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.

Re: Oracle 9i installation on hpux 11.

Yogeeraj_1 — Sat, 15 Jun 2002 08:44:09 GMT

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

Re: Oracle 9i installation on hpux 11.

T G Manikandan — Sat, 15 Jun 2002 10:03:59 GMT

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

Re: Oracle 9i installation on hpux 11.

Giel Smits — Mon, 17 Jun 2002 06:51:04 GMT

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

I'll check the above suggestions..

Re: Oracle 9i installation on hpux 11.

Bill Hassell — Mon, 17 Jun 2002 09:56:01 GMT

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.