Home » Other » General » Oracle DBA - Daily Activities (Oracle - 10G,11G,12C - Daily Activity)
Oracle DBA - Daily Activities [message #640275] Sun, 26 July 2015 04:10 Go to next message
Udhayakumar - DBA
Messages: 10
Registered: July 2015
Location: RAK Ceramics, Sudan
Junior Member

Big Hi to everyone in this forum,

I am Udhaya Kumar working in rak ceramics Sudan as a IT Executive.My duties are to check all our Oracle Databases, Application and Database server,Backup and recovery, maintenance of ERP.

Recently, I visited one blog of Mr. Halim and read article about DBA daily activities.
http://halimdba.blogspot.com/2015/07/daily-oracle-dba-checklist-for.html#uds-search-results

I have a one doubt on the first point...Suppose if i have more than 20 Databases...Should i login to every databases to check all the databases are up and running???.
1) is there any other script to check all the databases are up in my environment???.
2) or else is there any other possible way and easiest way to check all the databases are running???

Because, It is taking more time to login to all databases and checking the instances are up and running.
So, i will appreciate, if anybody will give the solution???...
Re: Oracle DBA - Daily Activities [message #640276 is a reply to message #640275] Sun, 26 July 2015 04:36 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Moderator comment:

Use of Oracle products in Sudan is illegal under US law. Responders may wish to bear this in mind.
Re: Oracle DBA - Daily Activities [message #640277 is a reply to message #640276] Sun, 26 July 2015 04:44 Go to previous messageGo to next message
Udhayakumar - DBA
Messages: 10
Registered: July 2015
Location: RAK Ceramics, Sudan
Junior Member

Hi Mr. John,

I am working in sudan. My company has headquarters in Ras Al Khaimah, United arab emirates... All our licenses are under in the name of RAK Ceramics, UAE.FYI...


Thanks,

V. Udhaya Kumar

[Updated on: Sun, 26 July 2015 04:44]

Report message to a moderator

Re: Oracle DBA - Daily Activities [message #640332 is a reply to message #640277] Mon, 27 July 2015 06:48 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
You could use monitoring software that does those checks reguraly or script it yourself. (EM, SCOM, Nagios, ...)
Oracle recommends enterprise-manager
Re: Oracle DBA - Daily Activities [message #640345 is a reply to message #640332] Mon, 27 July 2015 08:12 Go to previous messageGo to next message
Udhayakumar - DBA
Messages: 10
Registered: July 2015
Location: RAK Ceramics, Sudan
Junior Member

Hi flyby,

Is it OEM (Oracle Enterprise manager...Right?...)
Thanks FYI...

Thanks..,

V. Udhaya Kumar
Re: Oracle DBA - Daily Activities [message #643518 is a reply to message #640345] Fri, 09 October 2015 11:32 Go to previous message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
It is Oracle Enterprise Manager 12c
Previous Topic: Oracle vs Sequel - question
Next Topic: Advice for design tables
Goto Forum:
  


Current Time: Thu Mar 28 17:37:51 CDT 2024