OraFAQ Forum: Server Administration » How to find the alert log path when database is down.

Home » RDBMS Server » Server Administration » How to find the alert log path when database is down. (Oracle 11.2.0.4,Linux 2.6)

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

How to find the alert log path when database is down. [message #620547]

Mon, 04 August 2014 04:16

srikanth02
Messages: 49
Registered: June 2014
Location: India

Member

Hi,

How to find alert log file path when database is down.Say for example when try to login to database i got the below error .

Connected.
SQL>
SQL>
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

In this case , how to find the path of alert log file ?

Regards,
Srikanth

[Updated on: Mon, 04 August 2014 04:17]

Report message to a moderator

[Message index]

		How to find the alert log path when database is down. By: srikanth02 on Mon, 04 August 2014 04:16
		Re: How to find the alert log path when database is down. By: Roachcoach on Mon, 04 August 2014 04:27
		Re: How to find the alert log path when database is down. By: Michel Cadot on Mon, 04 August 2014 04:33
		Re: How to find the alert log path when database is down. By: srikanth02 on Mon, 04 August 2014 04:48
		Re: How to find the alert log path when database is down. By: srikanth02 on Mon, 04 August 2014 05:10
		Re: How to find the alert log path when database is down. By: Michel Cadot on Mon, 04 August 2014 05:59
		Re: How to find the alert log path when database is down. By: srikanth02 on Mon, 04 August 2014 06:37
		Re: How to find the alert log path when database is down. By: BlackSwan on Mon, 04 August 2014 08:30
		Re: How to find the alert log path when database is down. By: martijn on Mon, 04 August 2014 08:59
		Re: How to find the alert log path when database is down. By: srikanth02 on Mon, 04 August 2014 10:36
		Re: How to find the alert log path when database is down. By: BlackSwan on Mon, 04 August 2014 11:03
		Re: How to find the alert log path when database is down. By: Michel Cadot on Mon, 04 August 2014 11:05
		Re: How to find the alert log path when database is down. By: srikanth02 on Mon, 04 August 2014 11:42
		Re: How to find the alert log path when database is down. By: Michel Cadot on Mon, 04 August 2014 11:54
		Re: How to find the alert log path when database is down. By: srikanth02 on Mon, 04 August 2014 11:58
		Re: How to find the alert log path when database is down. By: varunvir on Mon, 04 August 2014 22:19
		Re: How to find the alert log path when database is down. By: srikanth02 on Tue, 05 August 2014 03:45
		Re: How to find the alert log path when database is down. By: Michel Cadot on Tue, 05 August 2014 04:19
		Re: How to find the alert log path when database is down. By: srikanth02 on Tue, 05 August 2014 04:28
		Re: How to find the alert log path when database is down. By: Michel Cadot on Tue, 05 August 2014 05:16
		Re: How to find the alert log path when database is down. By: srikanth02 on Tue, 05 August 2014 05:49
		Re: How to find the alert log path when database is down. By: Lalit Kumar B on Tue, 05 August 2014 10:24
		Re: How to find the alert log path when database is down. By: zengmuansha on Wed, 06 August 2014 03:49
		Re: How to find the alert log path when database is down. By: Michel Cadot on Wed, 06 August 2014 04:10
		Re: How to find the alert log path when database is down. By: tim2boles on Thu, 07 August 2014 14:05
		Re: How to find the alert log path when database is down. By: srikanth02 on Sat, 09 August 2014 03:36

Previous Topic:	Unable to move objects from SYSTEM tablespace
Next Topic:	wt is the diff b/w exclusive Lock And Dead Lock?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 04:24:13 CDT 2024