OraFAQ Forum: Server Administration » Database down but database missing

Home » RDBMS Server » Server Administration » Database down but database missing (Oracle 10.2.0.3.0 , HP-UX )

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

Database down but database missing [message #621821]

Mon, 18 August 2014 12:02

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,

Report message to a moderator

Re: Database down but database missing [message #621824 is a reply to message #621821]

Mon, 18 August 2014 12:45

Michel Cadot
Messages: 67640
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?

Report message to a moderator

Re: Database down but database missing [message #621839 is a reply to message #621824]

Tue, 19 August 2014 00:55

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,

Report message to a moderator

Re: Database down but database missing [message #621841 is a reply to message #621839]

Tue, 19 August 2014 01:22

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Does this database exist?

Report message to a moderator

Re: Database down but database missing [message #621862 is a reply to message #621841]

Tue, 19 August 2014 04:15

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

Report message to a moderator

Re: Database down but database missing [message #621863 is a reply to message #621862]

Tue, 19 August 2014 04:27

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: Database down but database missing [message #621866 is a reply to message #621863]

Tue, 19 August 2014 04:31

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Database down but database missing [message #621881 is a reply to message #621866]

Tue, 19 August 2014 07:02

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

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Or someone has whipped the storage out from under you Wink

Report message to a moderator

Re: Database down but database missing [message #621884 is a reply to message #621883]

Tue, 19 August 2014 07:23

Srijesh
Messages: 24
Registered: August 2014
Location: Berlin

Junior Member

could be

Report message to a moderator

Re: Database down but database missing [message #621898 is a reply to message #621884]

Tue, 19 August 2014 09:06

Lalit Kumar B
Messages: 3171
Registered: May 2013
Location: World Wide on the Web

Senior Member

Srijesh wrote on Tue, 19 August 2014 17:53

could be

There is nothing as "could be" in IT, unless you don't have the skills to find out.

Report message to a moderator

Re: Database down but database missing [message #621900 is a reply to message #621898]

Tue, 19 August 2014 09:09

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

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

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.

Report message to a moderator

Re: Database down but database missing [message #622154 is a reply to message #622152]

Thu, 21 August 2014 11:23

Lalit Kumar B
Messages: 3171
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 16 17:44:43 CST 2021