I've inherited management of an oracle database server, advice on path to take to be a competent dba

I've just inherited management of an oracle 10g database server with a single database running on a windows server and my database experience has been managing MySQL servers and databases on a centos servers, i've come to the conclusion that i need to extend database skills to oracle.

Now i already started composing a list of what of i need to do and i've been looking for online learning materials like udemy and oracle docs what path would other oracle dba's suggest i take to expand my dba skills to oracle.

Currently on my task list i have
  • Installing Oracle VSS writer or any oracle add ons
  • Tablespace management - increasing size, monitoring tablespace usage, adding additional dbf files
  • User management
  • Full run down on RMAN as i need to be able to connect to a target, do full hot backups to a local destination, perform a restore of the database to a dummy server as part of disaster preparedness and recovery plan and i urgently need to safely remove obsolete files from the archive log as it keeps growing and running out of physical disk space will soon be an issue.
  • How, why and when to use the scheduler
showisonManger/itAsked:
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.

slightwv (䄆 Netminder) Commented:
>>•Installing Oracle VSS writer or any oracle add ons

Why?  I've been using Oracle for over 26 years and the last 17 on Windows.  Never used VSS.

>>•Tablespace management - increasing size, monitoring tablespace usage, adding additional dbf files

Turn on autoextend and all you need to do is manage disk free space and investigate if a tablespace unexpectedly grows in space.

>>•Full run down on RMAN

Yes, RMAN is important if that is your backup and recovery software.

>>•How, why and when to use the scheduler

You use scheduler when you need to run tasks unattended and/or at scheduled times.



I would focus on overall Oracle Architecture.  Oracle is quite different than MySQL and other databases.

Here is the 10g Concepts guide:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/toc.htm

I would also work towards upgrading since 10g has been desupported A LONG time ago.
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
arnoldCommented:
If you are managing the server on which oracle is running, IMHO, first task to learn is restarting the DB following an unexpected shutdown to get the DB back up and running.
Then cursory understanding on how to check status without making changes to determine whether escalation to a DBA is needed/required.

Get the oracle reference from O'Reilly. Learn as much as you can, but note that if you initiate changes, no matter how coincidental, the DBA and others will attribute onto you should an issue arise.

https://docs.oracle.com/cd/B19306_01/server.102/b14220/startup.htm

Try and get info from the DBA on what is being added/changed, presumably a change record is maintained....

only when the DB server is not responding will you be called, so being in a position to quickly check if the server is up, and in this case, the DB status. is the quickest way to determine what is next.
db running out of space, should be escalated to the DBA......
Overtime, you might seek the additional responsibility, but understand the process at the firm for such changes.
0
Geert GOracle dbaCommented:
Oracle VSS Writer
is installed automatically
with 11.2.0.2 there is a bug, consumes memory, which requires a restart of this service every day

Tablespace
I send myself mails when something goes over 85%
You'll need to setup something which detects that

rman ... yeah that should be your swiss army knife for restore,backup and preparation tool for any next steps like upgrades

but ... you didn't really inherit only 1 server ?
You should have at least inherited 2 servers.  1 for the production environment and 1 for the test/qua environment
you'll need a test server to test all your knowledge :)
0
Seth SimmonsSr. Systems AdministratorCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- slightwv (䄆 Netminder) (https:#a42455410)
-- arnold (https:#a42455412)
-- Geert G (https:#a42455753)


If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

seth2740
Experts-Exchange Cleanup Volunteer
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
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.