How to find the alert log path when database is down. [message #620547] |
Mon, 04 August 2014 04:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/25e2763fee90463b582ec205bece3e6b?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
Re: How to find the alert log path when database is down. [message #620557 is a reply to message #620556] |
Mon, 04 August 2014 05:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/25e2763fee90463b582ec205bece3e6b?s=64&d=mm&r=g) |
srikanth02
Messages: 49 Registered: June 2014 Location: India
|
Member |
|
|
I came to know database was down.
So i used ps -ef|grep pmon to find if database instance was running.It was running
[oracle@cpusir01 ~]$ ps -ef|grep pmon
oracle 19846 1 0 Jul09 ? 00:34:47 ora_pmon_klmno
oracle 27045 24284 0 11:44 pts/2 00:00:00 grep pmon
later when i logged into database and checked i was getting 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
When i try to start the database using startup command, i saw some out of memory error in database.
after that i used ps -ef|grep pmon to check database it was not running
[oracle@cpusir01 rdbms]$ ps -ef|grep pmon
oracle 27715 24284 0 12:39 pts/2 00:00:00 grep pmon
note: -- I could not find alert log path in spfile and alert log file under diagnostic_dest"/diag/rdbms/<base>/<INSTANCE>/alert
Will rebooting the server will resolve this problem ?
Regards,
Srikanth
[Updated on: Mon, 04 August 2014 05:13] Report message to a moderator
|
|
|
|
|
|
Re: How to find the alert log path when database is down. [message #620590 is a reply to message #620567] |
Mon, 04 August 2014 08:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
martijn
Messages: 286 Registered: December 2006 Location: Netherlands
|
Senior Member |
|
|
srikanth02 wrote on Mon, 04 August 2014 13:37Michel,
We have requested Unix team to reboot the server and it is in progress.
Regards,
Srikanth
Out of curiosity : Why reboot?
In the years I'm working with Unix I did not find many cases where a system would benefit from reboot.
A few exceptions are:
- kernel updates (for older unixes)
- Hardware failure (shutdown -> replace -> startup)
|
|
|
|
|
|
|
Re: How to find the alert log path when database is down. [message #620632 is a reply to message #620628] |
Mon, 04 August 2014 11:54 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:When Blackswan can answer my question what the hell happens to you ??
So
1/ You don't know what the command do
2/ If you could think a little bit you'd see that BlackSwan and I answered about the same time and so I didn't see her answer, but this would not change my post
3/ There is no doubt, you don't understand what the command do
I give you 2 hints.
1/ The answer could be /tmp, $HOME, $ORACLE_HOME...
2/ Can you do a "cd $PATH"?
So I ask you once again my question "What does the command do?", answer if you can.
Quote:Are you Blackswan ? Is Blckswan and Michel are same and by mistake you used Michel account to reply my thread ?
No, we are not, in opposite to you we do not use many accounts to post, we have one and only one. Only you are a liar and a fraud here.
Quote:Well there is an option to use "ignore all message " in orafaq .Dont force me to use that button.
I'm scared. Who will be the most embarrassed if you do so, you or me?
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: How to find the alert log path when database is down. [message #621022 is a reply to message #620557] |
Thu, 07 August 2014 14:05 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
tim2boles
Messages: 38 Registered: August 2008 Location: Clarksburg, WV
|
Member |
|
|
Ok...going back to the original topic I would include the following ideas.
1) Documentation : It would be nice to create a document that contains the information you need for "quick" lookup if necessary. I keep one that has information such as server name, databases on server, primary contact for server, backup schedule, location of diagnostic directories, backup strategy, scheduled server reboots and similar information.
2) Generally you can find this information (as stated by others) within the spfile. Normally I will start where most likely I can find the ORACLE_HOME and go from there. If things are setup as "normal" you can look in the oratab. Which for me being on a Linux machine is under /etc/
$cat /etc/oratab
testdb:/code11_16/oracle/product/10.2.0:N
So now I can go to the ORACLE_HOME directory and look under the dbs directory
$cd /code11_16/oracle/product/10.2.0/dbs
$ls -l inittestdb.ora
If I grep for diag and dump depending on the version of oracle. I can find the alert file generally in one of those directory structures. Simple enough to use find to look for it.
Regards
Tim
|
|
|
|