Solved

Oracle Manage/Monitor Databases

Posted on 2014-04-23
7
540 Views
Last Modified: 2014-05-20
Need your assistance/guidance, in managing/monitoring my 6 databases, any sql, script, doc or weblink will be much appreciated.

Where needs some help, along with some emailing functionality too:

1. alert log: monitor/log all ora- errors.
2. tablespaces; monitor/log for any crossing the decided threshold
3. hanged or locked sessions
4. long running quires
5. space management: eaten by trace + audit file

Please feel free to add, if I'm missing anything over here, just a FYI, was trying to install OEM for 11g & 12c too, but struggling big time and for last 3 weeks, working with Oracle Support ... and nothing yet, as expected, they can't even able to assist to cleanup/unistall and then reinstall.

Any way, please share/assist, if you are already monitoring/managing these, but in a proactive manner, getting alerts/emails, before hand.

Thanks in advance.
0
Comment
Question by:mkhandba
  • 3
  • 2
  • 2
7 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 167 total points
ID: 40019174
This is a pretty tall order for a Q&A site like this.

I'm not sure what else I can offer that I haven't already posted in your previous question:
http://www.experts-exchange.com/Database/Oracle/Q_28408009.html

Not all DBA's monitor the same things.  No two situations are the same.  What is important for one system/database may not be important to others.

For overall metrics I would still suggest Enterprise Manager.  Sorry you still haven't been able to get it set up correctly.

You haven't posted back in your other previous question on installing OEM in a couple of days:
http://www.experts-exchange.com/Database/Oracle/Q_28408557.html

As for the specific questions you posted:
I've not looked in my alert log in months.
I've not looked at tablespace metrics in months and have no idea what "for any crossing the decided threshold" is.
Long running queries is the least of my worries.
Trace files?  If disk space is that tight, time to invest in new hardware.

Email?  As I've mentioned before my databases email me every morning on things I feel are important for my specific databases.  I use UTL_MAIL.  Other's here don't like that and wrote their own using UTL_SMTP.
0
 
LVL 36

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 333 total points
ID: 40019427
there is some tools like application manager from manage engine
which have defaults for oracle monitoring
http://www.manageengine.com/products/applications_manager/oracle-management.html
installing and setup can be done in 30 minutes.
it's a very basic package


here we have our own custom built monitoring tool
it generates nightly performance reports (with amongst other things ... the long running queries based on time, cpu, io, ...)
0
 

Author Comment

by:mkhandba
ID: 40020437
thanks Geert Gruwez for sharing, can you share some of your sql scripts that you used to monitor your dbs or any hint/link/doc will be highly appreciated.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 40020461
I'm not Geert Gruwez but until he posts, I would start here:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/diag007.htm
0
 

Author Comment

by:mkhandba
ID: 40057624
Hi Geert Gruwez, is there any possibility to assist?
0
 
LVL 36

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 333 total points
ID: 40059042
> proactive manner
it's always reactive, i've yet to see a tool which can look into the future and foresee what query will be coming or need tuning
if you do find one, let me know ...

here is a presentation of what the custom built monitor can do:
ITSS-overview.zip
0
 

Author Comment

by:mkhandba
ID: 40067837
thanks Greet, will have a look and update soon.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
null value 15 62
Edit linux file using python 4 20
Sendmail STARTTLS error 37 40
What is the version of ojdbc6.jar 2 23
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now