search ML on "db hang states"
they recommend taking system and process state dumps
in such situations.
did not work in our case one time where we had a
situation where even internal connection was refused.
no freakin error in alert or bdump. finally ended up
having to kill pmon and other oracle processes at unix
level.
the bad part is we never found what hit us, the good
part is it has not happened again so far;
Deepak
PS: and this was the main customer database that
allows access to our site;
- "Bellows, Bambi" <BBellows_at_usg.com> wrote:
> The error is that the database login failed. There
> is nothing in the bdump
> alert log of any interest and no entries whatsoever
> in the tns alert log or
> in $APPLLOG. No clue where to look for Apache
> stuff...
>
> Bambi.
>
> -----Original Message-----
> Sent: Wednesday, October 31, 2001 4:41 PM
> To: Multiple recipients of list ORACLE-L
>
> What exactly happens? What is the problem? Anything
> in the log files
> for Oracle, listener, OS, Apache?
>
> -----Original Message-----
> Sent: Wednesday, October 31, 2001 4:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Friends --
>
> Our pesky users are having problems logging on from
> the Web front end of
> Oracle Financials. This was working just fine 10/25
> when the last pesky
> user successfully logged in. Since then, the box
> (Tru64 v5.1) has been
> bounced, and we have started the following scripts
> successfully...
>
> 1) addbctl.sh (database startup)
> 2) addlnctl.sh (listener startup... you'd think
> Oracle would use its own
> conventions, wouldn't you?)
> 3) adalnctl.sh (applications listener)
> 4) adcmctl.sh (concurrent manager startup)
> 5) adrepctl.sh (reports server)
> 6) adfrmctl.sh (forms server)
> 7) adtcfctl.start (tcf sockets)
> 8) adapcctl.sh (Apache web process)
> 9) adfmsctl.sh (forms metric server)
> 10) adfmcctl.sh (forms metric client)
>
> I figure if the database is up, the listeners are up
> and concurrent manager
> is up, everything should be fine. What am I
> missing?
>
> TIA!
> Bambi.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Bellows, Bambi
> INET: BBellows_at_usg.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Gogala, Mladen
> INET: MGogala_at_oxhp.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Bellows, Bambi
> INET: BBellows_at_usg.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: deepakthapliyal_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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
also send the HELP command for other information (like subscribing).
Received on Wed Oct 31 2001 - 17:29:12 CST