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-nn
Second, on the Windows Box itself, look for a file name
alertsid.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 [EMAIL PROTECTED]
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
[EMAIL PROTECTED]
(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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).