automation

As an oracle dba

What are the Automation of administrative tasks.
jcob_lAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alexander Eßer [Alex140181]Software DeveloperCommented:
That question sounds weird to me....

Do you mean something like this?!

http://bradmcgehee.com/2011/12/08/the-day-to-day-tasks-of-the-average-dba/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
The generic answer is:
Create scripts and/or jobs that handle things for you so you don't need to do them manually.

There really isn't a set list since every database is different.

For example:
I have database jobs that run every morning and email me the 'status' of my databases.  The job checks what I feel is important, specific to my system.

I have an email waiting for me every morning that tells me my database is 'happy'.

I don't have to manually do this every day.

Can you provide more information about the context of what you are asking?
0
jcob_lAuthor Commented:
Slightvv

Healthcheck of a database can be achieved by automating certain task..
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

slightwv (䄆 Netminder) Commented:
>>Healthcheck of a database can be achieved by automating certain task.

Agreed.  Now all you need to do is determine what makes your database 'healthy'.  This will likely be different for every DBA and even different across databases for the same DBA.

For example: One database may have a SLA of 99.999% uptime.  Others may have a SLA of a 1 second transaction response time.  What is healthy for the uptime database is likely different from the one based on throughput.

There is a health check script that Oracle provides (Its on Metalink and I believe talked about in the docs).  Personally, I've never run it.  What it monitors really isn't that important to my specific systems.

Can you provide more specifics other than a single sentence?
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
@jcob_l:
Healthcheck of a database can be achieved by automating certain task..

That is exactly what slightwv posted just before... ?!?
I'm kinda confused now?!?

If you're looking for DBA scripts that you can use for "your" automation, then take a look here:
http://www.oracle-base.com/dba/scripts.php

But as slightwv already mentioned: it really depends on your system(s), environment, applications...... it's individual
0
jcob_lAuthor Commented:
What is SLA ..
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
0
slightwv (䄆 Netminder) Commented:
Service Level Agreement:
http://en.wikipedia.org/wiki/Service-level_agreement

Note:  Google:  wiki SLA
It's the first link...
0
PortletPaulfreelancerCommented:
SLA = "Service Level Agreement"

it is an agreement between provider of the database and the user(s) of certain conditions that should be provided.

99.99% "uptime" is a common measure inside a SLA
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
... whereas SLAs (or rather the term itself) are not bound to databases only, it's more like a certain kind of contract...
0
PortletPaulfreelancerCommented:
>>are not bound to databases only
Yes, agreed.
but; I had keep it simple in mind.

The question is about: automation (of Oracle administrative tasks)
0
jcob_lAuthor Commented:
yes
0
Steve WalesSenior Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.