OraFAQ Forum: Server Administration » Location of alert log file

Home » RDBMS Server » Server Administration » Location of alert log file (Oracle 11g,12c, Unix)

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

Location of alert log file [message #678224]

Tue, 19 November 2019 01:44

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Hi,

Can you please tell me how to find the location of alert log file when the database is down.

Regards,
Balaji

Report message to a moderator

Re: Location of alert log file [message #678225 is a reply to message #678224]

Tue, 19 November 2019 01:47

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

You consult your memory. Or your documentation. Or take a guess. Or search the disc(s). %DIAGNOSTIC_BASE%\rdbms\<db_name>\<instance_name>\trace is a good start.

Report message to a moderator

Re: Location of alert log file [message #678226 is a reply to message #678225]

Tue, 19 November 2019 01:58

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Thanks.I could found more details on

[Updated on: Tue, 19 November 2019 01:59]

Report message to a moderator

Re: Location of alert log file [message #678227 is a reply to message #678226]

Tue, 19 November 2019 02:57

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

You've gone an put DBA in your username and you don't know where the alert log is?
good grief.
Knowing that is one of the absolute most basic things any prospective DBA should know.

You really need to spend some time reading the documentation.

Report message to a moderator

Re: Location of alert log file [message #678228 is a reply to message #678227]

Tue, 19 November 2019 03:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Cookie, John and all, BalajiDBA is just a resurgence of our old Balaji/Ajit/Jack/Mohan/Mathew/Suhas/Srini/JATIN/william/Srikanth/david/Srijesh/kadhirvel/Shiva/Chandra/srijesh/Suha/Robin/samba guy which showed no skill in DBA work not even read the documentation and to abuse multiple accounts (balaji1482, bala14, Database admin, Srini, suhasdba, srikanth02, ora_2014, Srijesh, mc1825263, oracle11, jg5111, robinmalik, sambadba1...)

Report message to a moderator

Re: Location of alert log file [message #678229 is a reply to message #678227]

Tue, 19 November 2019 04:00

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Quote:

You've gone an put DBA in your username and you don't know where the alert log is?

First write good english and then give advise to others.

Quote:

You really need to spend some time reading the documentation.

Thanks for your advise.

Report message to a moderator

Re: Location of alert log file [message #678230 is a reply to message #678228]

Tue, 19 November 2019 04:03

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Michel,

For your information, not all above mentioned accounts are mine, only few.

Report message to a moderator

Re: Location of alert log file [message #678232 is a reply to message #678230]

Tue, 19 November 2019 04:19

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is what the previous guy claimed each time we told him until we showed him he couldn't hide.
If you are not him then you are his twin.

[Updated on: Tue, 19 November 2019 04:27]

Report message to a moderator

Re: Location of alert log file [message #678233 is a reply to message #678232]

Tue, 19 November 2019 04:27

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Michel,

I had used several accounts in this forum and currently using single account. So I have changed.
But you haven't changed yet.

Report message to a moderator

Re: Location of alert log file [message #678234 is a reply to message #678233]

Tue, 19 November 2019 04:30

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Report message to a moderator

Re: Location of alert log file [message #678239 is a reply to message #678229]

Tue, 19 November 2019 05:41

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

BalajiDBA wrote on Tue, 19 November 2019 10:00

Quote:
You've gone an put DBA in your username and you don't know where the alert log is?
First write good english and then give advise to others.

Typo != someone sticking DBA in their user name and not knowing where the alert log is.

Picking on typos is not a good come back in this situation.

Report message to a moderator

Re: Location of alert log file [message #678242 is a reply to message #678239]

Tue, 19 November 2019 06:01

BalajiDBA
Messages: 139
Registered: October 2018
Location: India

Senior Member

Report message to a moderator

Re: Location of alert log file [message #678244 is a reply to message #678229]

Tue, 19 November 2019 07:01

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

BalajiDBA wrote on Tue, 19 November 2019 04:00

Quote:
You've gone an put DBA in your username and you don't know where the alert log is?
First write good english and then give advise to others.

Back at you.

"First write proper English and then give advice to others."

Report message to a moderator

Re: Location of alert log file [message #678245 is a reply to message #678239]

Tue, 19 November 2019 07:02

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

cookiemonster wrote on Tue, 19 November 2019 05:41

BalajiDBA wrote on Tue, 19 November 2019 10:00
Quote:
You've gone an put DBA in your username and you don't know where the alert log is?
First write good english and then give advise to others.

Typo != someone sticking DBA in their user name and not knowing where the alert log is.

Picking on typos is not a good come back in this situation.

Especially when their own "comeback" concerning the use of the English language contains at least three errors in the use of the English language!

Report message to a moderator