Sponsored Content
Operating Systems HP-UX Oracle not accepting new connections Post 87121 by mat_cottrell on Thursday 20th of October 2005 07:11:37 AM
Old 10-20-2005
Network Oracle not accepting new connections

Hi UNIX guru's,

Have recently upgraded Oracle from 8i to 10g on an HP-UX (RISC) 11.11 box.

At least twice a day the database stops accepting incoming connections and the following errors are observed in the various logs.

The box needs to be rebooted to get everything going again.

The box has 6GB of physical ram and I belive 2 x 2GB swap files.

Does anyone one know what the HPUX Error: 12: Not enough space
error is referring to.

The kernel parameters have been configured according to the Oracle upgrade guide.

Also referring to the last error log which was observed when rebooting, what is aux swap space, is it a problem that we havn't got any?

Any help would be appreciated.

Cheers Mat

after upgrade from 816 to 10G:
the database stops accepting new connections.
Network log
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12549: TNS:operating system resource quota exceeded
TNS-12560: TNS:proto adapter error
TNS-00519: Operating system resource quota exceeded
HPUX Error: 12: Not enough space

Error log :- from alert log :-
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3
skgpspawn failed:category = 27142, depinfo = 12, op = fork, loc = skgpspawn3.


Enable auxiliary swap space
Output from "/sbin/rc1.d/S500swap_start start":
----------------------------
Enabling device paging on /dev/vg00/lvolswap.
/usr/sbin/swapon: /dev/vg00/lvolswap: No such file or directory
Enabling device paging on /dev/vg00/lvol1swap.
/usr/sbin/swapon: /dev/vg00/lvol1swap: No such file or directory
Enabling device paging on /dev/vg00/lvol2swap.
/usr/sbin/swapon: /dev/vg00/lvol2swap: No such file or directory
Enabling device paging on /dev/vg00/lvol9.
Warning: swapon returned exit code: 3
"/sbin/rc1.d/S500swap_start start" FAILED

Last edited by Perderabo; 10-20-2005 at 08:57 AM.. Reason: Disable smilies for readability
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Accepting User Input

I'm just starting out with UNIX and have figured some stuff out. I just need some help with accepting user input on the command line. For instance, I created a number counter that counts down from any positive hard coded number. But, I want the commnad line line to read "Countdown 20" where 20... (1 Reply)
Discussion started by: scott78
1 Replies

2. Shell Programming and Scripting

Not able to display the value I am accepting as an argument

Hi, I am new to UNIX. I am facing some problem here. #! /usr/bin/ksh currDate = $1 export currDate; echo " Date is $currDate" when I run this script, it says : currDate not found. Can anybody point out the mistake please. --mahek (3 Replies)
Discussion started by: mahek_bedi
3 Replies

3. UNIX for Dummies Questions & Answers

accepting input date

I how do i accept a input date in script which is lesser than a specified day? ex: to accept a date less than or equal to 100 days(from today).?:( Thanks for the help in advance.:) (1 Reply)
Discussion started by: abhi_123
1 Replies

4. Shell Programming and Scripting

How to check if a Port is accepting connections.

Hi, I need to create a script which checks the availability of a particular service on a particular Port on HP-Unix. Is there any command in unix wherein we can check if any port is accepting the connections now. Thanks, Vihang. (5 Replies)
Discussion started by: vikings.svnit
5 Replies

5. Shell Programming and Scripting

Accepting A-Za-Z

Is there a way accept A-Za-z0-9 from the user from a parameter? EX. I want to take the parameter from the user even if its hEu or H3y and store it as a parameter ( $1 ) (18 Replies)
Discussion started by: puttster
18 Replies

6. Shell Programming and Scripting

Help with Accepting Directories as an Argument

I'm doing a script where you are suppose to start off in accepting one or more directory as an argument. How do i do this? Sorry for the nub question. (2 Replies)
Discussion started by: LinuxUser232331
2 Replies

7. Shell Programming and Scripting

Accepting Input regardless of Case

Hi I am trying to get my script to accept input regardless if the person enters a or A. here is the portion of the code where I get the input. echo -n 'Please enter your choice:' # prompt user for input. read reply # read input echo case $reply in #... (2 Replies)
Discussion started by: DualPandas
2 Replies

8. Shell Programming and Scripting

script accepting password

Hi friends, I am very new to Unix scripting and having some difficulty in my first shell script. I have written a simple shell script to upload an artifact to a remote machine on the network. echo "Uploading the artifact" scp app.war username@remotemochine.domainname.net:/home/deployables... (3 Replies)
Discussion started by: prashdeep
3 Replies

9. Shell Programming and Scripting

Parameter not accepting in awk

In below script parameterwhich i am passing to awk function is not working.Not sure why its not accepting parameter.Please tell me how to pass parameter to the awk function.Please check the below script. #!/bin/ksh dummy_file=/etlapps/dev/data/sub_servicer_data/ScriptLogs/emp.txt fields=5... (2 Replies)
Discussion started by: katakamvivek
2 Replies
SWAPON(8)						     Linux Programmer's Manual							 SWAPON(8)

NAME
swapon, swapoff - enable/disable devices and files for paging and swapping SYNOPSIS
Get info: swapon -s [-h] [-V] Enable/disable: swapon [-f] [-p priority] [-v] specialfile... swapoff [-v] specialfile... Enable/disable all: swapon -a [-e] [-f] [-v] swapoff -a [-v] DESCRIPTION
swapon is used to specify devices on which paging and swapping are to take place. The device or file used is given by the specialfile parameter. It may be of the form -L label or -U uuid to indicate a device by label or uuid. Calls to swapon normally occur in the system boot scripts making all swap devices available, so that the paging and swapping activity is interleaved across several devices and files. swapoff disables swapping on the specified devices and files. When the -a flag is given, swapping is disabled on all known swap devices and files (as found in /proc/swaps or /etc/fstab). -a, --all All devices marked as ``swap'' in /etc/fstab are made available, except for those with the ``noauto'' option. Devices that are already being used as swap are silently skipped. -e, --ifexists Silently skip devices that do not exist. -f, --fixpgsz Reinitialize (exec /sbin/mkswap) the swap space if its page size does not match that of the the current running kernel. mkswap(2) initializes the whole device and does not check for bad blocks. -h, --help Provide help. -L label Use the partition that has the specified label. (For this, access to /proc/partitions is needed.) -p, --priority priority Specify the priority of the swap device. priority is a value between 0 and 32767. Higher numbers indicate higher priority. See swapon(2) for a full description of swap priorities. Add pri=value to the option field of /etc/fstab for use with swapon -a. -s, --summary Display swap usage summary by device. Equivalent to "cat /proc/swaps". Not available before Linux 2.1.25. -U uuid Use the partition that has the specified uuid. -v, --verbose Be verbose. -V, --version Display version. NOTES
You should not use swapon on a file with holes. Swap over NFS may not work. swapon automatically detects and rewrites swap space signature with old software suspend data (e.g S1SUSPEND, S2SUSPEND, ...). The problem is that if we don't do it, then we get data corruption the next time an attempt at unsuspending is made. swapon may not work correctly when using a swap file with some versions of btrfs. This is due to the swap file implementation in the ker- nel expecting to be able to write to the file directly, without the assistance of the file system. Since btrfs is a copy-on-write file system, the file location may not be static and corruption can result. Btrfs actively disallows the use of files on its file systems by refusing to map the file. This can be seen in the system log as "swapon: swapfile has holes." One possible workaround is to map the file to a loopback device. This will allow the file system to determine the mapping properly but may come with a performance impact. SEE ALSO
swapon(2), swapoff(2), fstab(5), init(8), mkswap(8), rc(8), mount(8) FILES
/dev/sd?? standard paging devices /etc/fstab ascii filesystem description table HISTORY
The swapon command appeared in 4.0BSD. AVAILABILITY
The swapon command is part of the util-linux-ng package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux-ng/. Linux 1.x 25 September 1995 SWAPON(8)
All times are GMT -4. The time now is 08:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy