Re: Oracle 9i refuses to allow client connection -- I need

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 25 Jul 2003 10:02:57 -0400
Message-Id: <26013.339607@fatcity.com>

Stephen,
  I also would like to extend a warm welcome to the world of Oracle. I hope that you find it interesting and challenging and rewarding.   I would suggest that you get a head start on your training so you won't be overwhelmed when you attend, by acquiring some of the "Oracle 101" books that are available on the market. They are a valuable resource that I refer to constantly as I can't remember as much as I use to.
  I don't mean to slight any of the excellent authors that are on this list by not listing their works here. I am sure that if you asked for references you will be supplied with a list that will be quite complete and up to date.
Again,
Welcome.
Ron mª¿ªm

>>> wisernet100_at_yahoo.com 07/25/03 08:59AM >>> there are a number of logs that could help:

first, does the application itself generate a log? If so, does that log
reflect the actual error returned? It might look something like "ORA-nnnnnn"

Second, on the Windows Box itself, look for a file name "alert<sid>.log" (I'm not that familiar with Oracle's configuration on Windows as I run Unix but it should look something like that). Look to see if there are any error messages in that file at the time the connections are refused.

If increasing memory on the box itself helped, it's likely that what's happening is that users are connecting to the box, never dropping or closing the connections so that memory stays allocated. The box runs out of memory, you reboot (closing the connections and releasing the memory) and you are good for another week or so.

if that's what's happening -- you either have to get the users to LOG OFF (yeah, right) or find a way of closing/killing the connections after x amount of time (look into the online docs -- technet.oracle.com, specifically look at the network manuals).

and welcome! It's always nice to see a new face here, especially one who is willing to LEARN

• Wolfe Stephen S GS-11 6 MDSS/SGSI <Stephen.Wolfe_at_macdill.af.mil> wrote:
  > I'm an Oracle administrator-To-Be, I'm awaiting funding for the
  basic
  > Oracle DBA courses, the
  > training has been approved, just hasn't been funded.
  >
  > Anyway, the only things I do are add, modify, and reset application
  > users' password via EM and run
  > patching scripts via SQL-Plus. The application I have running on
  > this
  > particular 9i server is TPOCS,
  > Third Party Outpatient Collection System -- a billing system for the
  > DoD's Military Health System (MHS).
  > Oracle 9i is running on a Windows 2000 server.
  >
  > Anyway, the TPOCS client is a PowerBuilder client and connects via
  > SQL-Net -- I'm still learning about that
  > mechanism. Here's my problem. Occasionally, Oracle refuses to let
  > any
  > client connect to it -- it does this about
  > every 7 to 8 days. It use to do it every 2 days, but the Tier 3
  > TPOCS
  > helpdesk recommended we increase the
  > ram on the server from 512MB to 1GB. Then the problem started
  > occurring
  > every 7 to 8 days. To make the problem
  > go away I reboot the server -- it only takes 10 minutes, however, I
  > feel
  > this a very poor work-around.
  >
  > Which logs could I look in that would give you guys more information
  > (like an error code) on why Oracle refuses
  > client connections and then how would we make this problem go away.
  > it
  > is becoming a PITA.
  >
  >
  >
  >
  >
  > v/r
  >
  > Stephen S. Wolfe, GS-11, DAFC
  > Data Services Manager
  > stephen.wolfe_at_macdill.af.mil
  > (813) 827-9974 DSN 651-9974
  >
  >
  

  ---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Fri Jul 25 2003 - 09:02:57 CDT