Shared buffer and alert file

[adonis547]

Hello,

I'm running Oracle 8i on a linux box. Recently, I've been seeing the following error, when logging with sqlplus:
-----
oracle@mybox ~> sqlplus user@DB/pw

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jun 10 11:03:40 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN
DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
-----

Also, the /oracle/admin/DB/bdump/alert_DB.log is almost 1GB in size. Can I truncate/delete it ?


The box has an uptime of ~200 days, perhaps I should restart - will a restart of oracle only suffice ?


Many thanks.

 

[stefanhei]

Hi.
Bouncing your box would fix the symptom but not the cause, and 200 days is not that long uptime for oracle on linux.
You may have hit bug 1397603, which should be fixed in 8.1.7.4.
You can truncate the alert_DB.log any time you wish (DB may be up and running).

Stefan