- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 9i installation on hpux 11.
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
тАО06-11-2002 11:59 PM
тАО06-11-2002 11:59 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2002 12:41 AM
тАО06-12-2002 12:41 AM
Re: Oracle 9i installation on hpux 11.
How are the CPU utilisation and disk IO rates.
Can you post your kernel setting and database initialisation setting.
...BPK...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2002 12:54 AM
тАО06-12-2002 12:54 AM
Re: Oracle 9i installation on hpux 11.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2002 12:54 AM
тАО06-12-2002 12:54 AM
Re: Oracle 9i installation on hpux 11.
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2002 01:02 AM
тАО06-12-2002 01:02 AM
Re: Oracle 9i installation on hpux 11.
syslog.log info -->
physical page size = 4096 bytes, logical page size = 4096 bytes.
Physical: 524288 Kbytes, lockable: 314496 Kbytes, available 381444 Kbytes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2002 01:25 AM
тАО06-12-2002 01:25 AM
Re: Oracle 9i installation on hpux 11.
Regards,
Gnana A.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2002 01:41 AM
тАО06-12-2002 01:41 AM
Re: Oracle 9i installation on hpux 11.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-12-2002 04:34 AM
тАО06-12-2002 04:34 AM
SolutionOne 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-13-2002 12:45 AM
тАО06-13-2002 12:45 AM
Re: Oracle 9i installation on hpux 11.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-13-2002 09:37 AM
тАО06-13-2002 09:37 AM
Re: Oracle 9i installation on hpux 11.
As far as good settings, size is relative. I have my small instances set to a total of 75 Megs.