RE: Alert Log file.

From: Vinod Gopinath BMMI IS <vinodg_at_BMMI.com.bh>
Date: Wed, 12 Jan 2005 17:39:08 +0300
Message-ID: <C9239A40098E1B47815F48965A7D0BF13E8958@BMMIXCH.BMMIHQ.Root.AD>

Thank you all. I just renamed the old file and executed this statement. <<<
exec dbms_system.ksdwrt(2,'test writing in alert log');=20 >>>
Thank you very much.
Rd/s
Vinod.
-----Original Message-----
From: Jaffar_DBA [mailto:sjaffarhussain_at_gmail.com]=20 Sent: Wednesday, January 12, 2005 5:20 PM To: Vinod Gopinath BMMI IS
Cc: oracle-l_at_freelists.org
Subject: Re: Alert Log file.

vinod,

check your bdump file location in the init parameter file. why dont you do the following.

from sql prompt, try the following as dba user

exec dbms_system.ksdwrt(2,'test writing in alert log');=20

if you dont see anything written in your alert log, try to rename your existing alert log fiel and do the same command and check in your bdump whether a new alter log file created or not.

Jaffar

On Wed, 12 Jan 2005 16:52:30 +0300, Vinod Gopinath BMMI IS <vinodg_at_bmmi.com.bh> wrote:
> Content-Type: text/plain;
> charset=3D"us-ascii"
> Content-Transfer-Encoding: quoted-printable
> Group.
> Oracle 8.2 on Win2K
> There is no entry happening on alert log file for past 2 days. This is

> an retial system, so lot of transaction happenes daily. There is=20
> enough space in the disk. My worry is that all of a sudden the system=20
> shouldn't stop and throw some vague error.
> Can some one help me on as to why there is no entry is alert log file.
I
> even bounced the db once still no luck.
> Rd/s
> Vinod.

>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Best Regards,
Jaffar, OCP DBA
Banque Saudi Fransi
Saudi Arabia

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 12 2005 - 08:32:52 CST