Re: MMNL absent message in alert log

From: eAddict <eAddict_at_gmail.com>
Date: Fri, 14 Dec 2007 12:06:50 -0800 (PST)
Message-ID: <bd6b0d8b-f5ba-48a4-ab0b-e3e6d457d178@s8g2000prg.googlegroups.com>

On Dec 14, 8:36 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> This raises the question, have you hit a maximum specified size for a
> tablespace, or run out of room on the disk for a tablespace to
> autoextend?

Nope. Nothing set to autoexent and there was nothing screaming for more space.

> Are the redo logs failing to be archived due to lack of disk space?

No again. Have a 6G area that calls the cabkup area when it gets 10% full...
just in case the tape drive is busy and has to wait.

> Are you able to connect as the internal user, which should be able to
> connect even when SYS cannot (for instance, if all online redo logs
> are full and insufficient space is available in the archived redo
> location)?

Could not connect as anyone.

> If you bounce the listener, are you able to connect as the
> internal user?

Tried that still could not connect.

What I ended up doing:

1. stopped SAP (not oracle)
2. stopped the listener
3. waited about 45 minutes.  The three processes eventually went away
4. shutdown immediate
5. startup - came up qucikly and without problems.
6. shutdown immeidate

7 startsap (which starts SAP and Oracle).

Everything is happy now... now to try to figure out what happened!

Vince Received on Fri Dec 14 2007 - 14:06:50 CST