Home » RDBMS Server » Server Administration » Database down but database missing (Oracle 10.2.0.3.0 , HP-UX )
Database down but database missing [message #621821] Mon, 18 August 2014 12:02 Go to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Hi ,

There is one alert came DEMO database is down in 'A' server.

I couldn't find the database in server.
Quote:
A 34: ps -ef|grep pmon
root 846 1 0 Mar 15 ? 20:32 ipmon -sD
ora 10389 1 0 Mar 15 ? 119:52 ora_pmon_MTP
ora 12098 1 0 Mar 15 ? 110:08 ora_pmon_TMP
ora 14556 8037 1 19:57:54 pts/0 0:00 grep pmon

Quote:
A 37: cat /etc/oratab
*:/opt/oem/agent11g:N


Could this be a false alert ?

Regards,
Re: Database down but database missing [message #621824 is a reply to message #621821] Mon, 18 August 2014 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 59421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Balaji/Ajit/Jack/Mohan/Mathew/Suhas/Srini/william/Srikanth/david/Srijesh,

Then now you know how to use "ps", I don't think you ever feedback with the solution in the other topic you created about that.

Quote:
Could this be a false alert ?


What false alert?

Re: Database down but database missing [message #621839 is a reply to message #621824] Tue, 19 August 2014 00:55 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Hi Michel,
Quote:
What false alert?

I got alert stating that database is down.When i went and checked in the server using ps command, i found database was not there.
It was not found even in oratab file.

I suspect this could be a false alert.What is your comment on this ?

Regards,
Re: Database down but database missing [message #621841 is a reply to message #621839] Tue, 19 August 2014 01:22 Go to previous messageGo to next message
Michel Cadot
Messages: 59421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Does this database exist?

Re: Database down but database missing [message #621862 is a reply to message #621841] Tue, 19 August 2014 04:15 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Quote:
Does this database exist?

How to check that ? I have used ps -ef|grep pmon and and also checked in /etc/oratab, i could not able to find the database
in either of it.But it is visible in grid control.

Regards,
Srijesh

Re: Database down but database missing [message #621863 is a reply to message #621862] Tue, 19 August 2014 04:27 Go to previous messageGo to next message
ThomasG
Messages: 3101
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
* pmon is only running when the database is running.
* a database *might* be in /etc/oratab, but it is not required.

The next thing I would check if there is a init-file for the database present.

Then I would try to start the database and see what happens.
Re: Database down but database missing [message #621866 is a reply to message #621863] Tue, 19 August 2014 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 59421
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

init.ora file which *might* not be on the server. Smile

Re: Database down but database missing [message #621881 is a reply to message #621866] Tue, 19 August 2014 07:02 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Thomas/Michel,

yes it is not there on the server.I guess the database would have been ramp down.

[Updated on: Tue, 19 August 2014 07:04]

Report message to a moderator

Re: Database down but database missing [message #621883 is a reply to message #621881] Tue, 19 August 2014 07:20 Go to previous messageGo to next message
Roachcoach
Messages: 1219
Registered: May 2010
Location: UK
Senior Member
Or someone has whipped the storage out from under you Wink
Re: Database down but database missing [message #621884 is a reply to message #621883] Tue, 19 August 2014 07:23 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
could be Very Happy
Re: Database down but database missing [message #621898 is a reply to message #621884] Tue, 19 August 2014 09:06 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2444
Registered: May 2013
Location: World Wide on the Web
Senior Member
Srijesh wrote on Tue, 19 August 2014 17:53
could be Very Happy


There is nothing as "could be" in IT, unless you don't have the skills to find out.
Re: Database down but database missing [message #621900 is a reply to message #621898] Tue, 19 August 2014 09:09 Go to previous messageGo to next message
Srijesh
Messages: 24
Registered: August 2014
Location: Berlin
Junior Member
Quote:
There is nothing as "could be" in IT, unless you don't have the skills to find out.


It shows that you are expert in Oracle DBA and troubleshooting database issues?? Keep it up and keep the momentum!!!

[Updated on: Wed, 20 August 2014 03:21]

Report message to a moderator

Re: Database down but database missing [message #622152 is a reply to message #621900] Thu, 21 August 2014 11:14 Go to previous messageGo to next message
babuknb
Messages: 1732
Registered: December 2005
Location: NJ
Senior Member

Smile DBA should able to find what was wrong.. We believe you can do this.

Do you know when was the last modified date in /etc/oratab ?

Are you sure you don't have any entry's in /var/opt/oracle ? Is Oracle Inventory logs tell you something ? do you know the location of oraInst.loc ?

If you don't see init.ora or alert log file.. do you know file system status ? like your database mounted in NFS or DNFS file system ? Have you validated your /etc/fstab ? Is anyone modified

Without your knowledge is anyone decommissioned your database ?

If you have answer for all question you should able to figure out what was wrong.. Again you own your environment.. Do some home work before your next update.
Re: Database down but database missing [message #622154 is a reply to message #622152] Thu, 21 August 2014 11:23 Go to previous message
Lalit Kumar B
Messages: 2444
Registered: May 2013
Location: World Wide on the Web
Senior Member
PDNFTT, as it would just give another chance to the tr**l.

@babuknb,
Do you think a DBA with 8+ years of experience can't even understand such trivialities?

[Updated on: Thu, 21 August 2014 11:26]

Report message to a moderator

Previous Topic: what is the procedure to select mysql database data from oracle 11g
Next Topic: Blocking sessions
Goto Forum:
  


Current Time: Wed Oct 22 22:27:07 CDT 2014

Total time taken to generate the page: 0.11719 seconds