Q336: Presto Magic You Have Just Been Made the System DBA?
Gary Noble , Church of Jesus Christ of Latter-Day Saints    Biography

Objectives: Learn the basics of using operating system scripts for DBA tasks.
Find your way around on the server.
Let the crontab jobs do the DBA work for you.
Abstract: Presto magic you have just been made the System DBA by management. Wait a second, what just happened? I thought I was going to be the application DBA and write sql or java code. I do not even know how to startup or shutdown a database. What does System DBA entail? How do I get started? This course will cover some basic Linux operating system scripts to get started as a System DBA. It will show how to script shutting down and starting up a database, making sure the database is running, connecting to the database, checking on the Oracle listener, where to find the alert log and scanning through it for error messages. Also, backup jobs need to be scheduled with RMAN. The intent is to show how to use Linux operating system code to help the DBA. You will be able to set up scripts so each time you log onto the system you do not have to worry about syntax errors but can quickly use an alias to execute code. The Operating System language can become your friend.

Audiernce Focus: DBA
Expertise: Beginner
Track: Database
Date: Tuesday, April 15, 2008
Time: 12:15 PM - 12:45 PM