Re: ORA-12518, 04030 errors after 9i-10G upgrade.

On Jun 10, 2:21 pm, GS <G...@xxxxxx> wrote:
Database is 10.2.0.4 on Windows 2003 (32 bit)server, upgraded via
exp/imp on new hardware. New server has 6GB ram.

All went ok until users started connecting in 100+ numbers, database is
set up for dedicated server connections, this was never a problem in 9i.

After the upgrade last friday,  I had set up 10G with 1500MB for SGA and
200 PGA size, monday once connections were up around 100+ mark
listener.log started showing out the tns and ora 12518 (TNS:listener
could not hand off client connection) errors, which also showed "32-bit
Windows Error: 233: Unknown error",  nothing in alert log until some
time later when BEQ connections also would not work. Never saw this
happen on 9i,so I did some googling on this error and increased
processes to 300 from the default 150, and increased PGA to 300MB.

This did not solve problems so bounced database and decreased SGA to
1300MB, this worked for awhile, listener made about 2400 connections and
refused 0 until about 8:45 am this morning (20 hours later)started
getting the errors again, this time users were also getting ORA-04030
out of process memory errors. By this time I had opened up severity 2 SR
on metalink, the recommended adding the lines
INBOUND_CONNECT_TIMEOUT_<listener_name> = 0 to listner.ora and
SQLNET.INBOUND_CONNECT_TIMEOUT = 0 to sqlnet.ora on Oracles advice and
bounced database.

This was ok for a few hours then just started to get more connection
errors, so bounced database again, dropped SGA to 1200MB and so far all
is good (fingers crossed)

Havent heard boo from Oracle yet today, even though I updated the SR and
told them to get their database team on it, as currently it is with the
sqlnet guys and they aren't dealing with database parameters. Besides
the lines added to .ora files they have suggested I go to MTS, which is
doable, but why is this giving grief when the identical setup in 9i ran
without these problems?

Server has 6Gb RAM with /PAE switch in boot.ini - but it still seems
that Oracle is having issues with OS resources.

This is one of our bigger databases, but at 30Gb and an average of 100
connections it's relatively small database wise. I have tons of RAM
available and the windows pagefile is barely being touched, so stumped
why it's crapping out like this.

Any other suggestions on what to try while I wait for my SR? So far
their advice has been of little help, as it was my idea to drop the SGA
size, and that seems to have had the most positive impact, but the
problem still persists..

I'm sure the analysts told you to look at Note:233869.1, 371983.1,
342080.1 and 223730.1. 10g works a little differently as far as some
of the hidden parameters are concerned, but it's worth it to look at
how much PGA is being used, are any threads going bonkers with memory,
are sorts spilling over, is your app going bonkers with cursors, do
you have automatic tuning turned on and is it shooting itself in the
foot, are disconnects not releasing memory...

There's always linux <g,d&r>

jg
--
@home.com is bogus.
Control-Alt-SCRAM http://www.washingtonpost.com/wp-dyn/content/article/2008/06/05/AR2008060501958_pf.html
.

Relevant Pages

  • Re: Reducing load for LAMP app?
    ... MySQL: as much as possible, he keeps query results in RAM, but ... His hoster says that Apache server is under significant load. ... Using apc is pretty much transparent, but memcached will require modifying your database abstraction layer using the memcached functions. ... With persistent connections, you must have the maximum number of connections *ever* required allocated *all of the time* - even if no one is using your server. ...
    (comp.lang.php)
  • Re: Slow connections & Select database
    ... we are having problems with slow connections on our informix database. ... I've tried both shm connections and tcp connections on the db server, and the shm are a bit slow but tcp are much worse. ... Changing sqlhosts to include an IP address only helps the client end of things find the server's IP address by avoiding a forward DNS look-up. ...
    (comp.databases.informix)
  • Re: Too Many Client tasks
    ... You are either not closing database connections or there are just too many ... concurrent users for MS Access to accomodate. ... > error until I reboot the server. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Slow connections & Select database
    ... If you want to check for network latency, you can do a series of pingfrom the client to the server and if you want to get fancy, do a traceroute as well. ... Did Rosie try a different database? ... > we are having problems with slow connections on our informix database. ...
    (comp.databases.informix)
  • Re: How can I open an SQL database and be the only one who has access to it?
    ... you can determine how SS permits access to your server. ... SINGLE_USER allows one user at a time to connect to the database. ... controlled by the termination clause of the ALTER DATABASE statement. ... To allow multiple connections, the database must be changed to ...
    (microsoft.public.data.ado)