Re: Oracle logs -- give a hand to a MS SQL DBA ;-)

Oracle DB has a alert_log file in directory $ORACLE_ADMIN/your_Sid/bdump. This kind of info is defined in a parameter file called initSid.ora (Sid is your DB name). For example, my database's parameter file (called initYPD.ora) has something like this:

# define directories to store trace and alert files

background_dump_dest = /oracle/admin/YPD/bdump
core_dump_dest = /oracle/admin/YPD/cdump
user_dump_dest = /oracle/admin/YPD/udump

Hope this helps.

Guang

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<puLkd.395417$D%.150994_at_attbi_s51>...
> "Vladimir" <evesq_at_uk2.net> wrote in message
> news:2vh8cbF2mj0vrU1_at_uni-berlin.de...
> > Hello,
> >
> > I'm a MS SQL DBA, but now have to learn Oracle. There is the only log
> > (ErrorLog) in MS SQL, it stores security events (such as logon/logout),
> > configurations changes and error messages.
> >
> > I'm very confused while I searched for the same log(s) in Oracle. As far
> as
> > I understand there are several logs in Oracle (security, alert, backup,
> > performance...), and they're stored as a tables. Is it right?
> >
> > What kind of logs Oracle DB server manages? Could you recommend a
> documents
> > (url desired) for reading?
> >
> > Thank you for your time,
> > Vladimir.
> >
> >
> otn.oracle.com
> has documentation. Read the Concepts guide and the Administrators Guide.
> Jim
Received on Thu Nov 11 2004 - 13:57:44 CST