OraFAQ Forum: Server Administration » Location of Oracle alert log in diferent versions

Home » RDBMS Server » Server Administration » Location of Oracle alert log in diferent versions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Location of Oracle alert log in diferent versions [message #63757]

Fri, 05 November 2004 01:04

Vasco Saavedra
Messages: 3
Registered: October 2004

Junior Member

In Oracle 9i, the alert log is in

/home/oracle/OraHome1/admin/<SID>/bdump/alert_<SID>.log

�

I cant find this file in oracle 8i !!!

Is it in another place and with another name?

�

Thanks in advance !!!

Report message to a moderator

Re: Location of Oracle alert log in diferent versions [message #63762 is a reply to message #63757]

Fri, 05 November 2004 03:27

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it depends your init.sid.ora settings.

mag@mutation_mutation > show parameter dump_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      /u01/app/oracle/admin/mutation
                                                 /bdump
core_dump_dest                       string      /u01/app/oracle/admin/mutation
                                                 /cdump
user_dump_dest                       string      /u01/app/oracle/admin/mutation
                                                 /udump

Report message to a moderator

Re: Location of Oracle alert log in diferent versions [message #63773 is a reply to message #63757]

Fri, 05 November 2004 05:37

croK
Messages: 170
Registered: April 2002

Senior Member

select name,value from v$parameter
where name='background_dump_dest';

Best luck.
Remote DBA looking for remote job.

Report message to a moderator

Previous Topic:	Space Quota
Next Topic:	SIDs and ORATAB doubts !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 06:20:50 CDT 2024