10-20-2005
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
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
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
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
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
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
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
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
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
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)