Oracle not accepting new connections Post: 87121

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

10-20-2005

Registered User

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

mat_cottrell

View Public Profile for mat_cottrell

Find all posts by mat_cottrell

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...

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. 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.:)

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. 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 )

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.

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 #...

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...

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...

LEARN ABOUT DEBIAN

jifty::dbi::handle::oracle

Jifty::DBI::Handle::Oracle(3pm) 			User Contributed Perl Documentation			   Jifty::DBI::Handle::Oracle(3pm)

NAME

	 Jifty::DBI::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   database_version
       Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.

   insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   build_dsn PARAMHASH
       Takes a bunch of parameters:

       Required: Driver, Database or Host/SID, Optional: Port and RequireSSL

       Builds a dsn suitable for an Oracle DBI connection

   blob_params column_NAME column_type
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   distinct_query STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle

perl v5.14.2							    2011-04-26					   Jifty::DBI::Handle::Oracle(3pm)