Database administrators have specific responsibilities and must understand how to complete database administration tasks.
Getting Started with Database Administration To get started with database administration, you must understand basic database concepts, such as the types of database users, database security, and privileges. You must also be able to complete basic tasks, such as submitting commands and SQL to the database and creating a password file.
Starting Up and Shutting Down When you start up a database, you create an instance of that database and you determine the state of the database. Shutting down a currently running Oracle Database instance can optionally close and dismount a database.
Configuring Automatic Restart of an Oracle Database Configure your Oracle database with the Oracle Restart feature to automatically restart the database, the listener, and other Oracle components after a hardware or software failure or whenever your database host computer restarts.
Managing Processes Oracle Databases uses several processes so that multiple users and applications can connect to a single database instance simultaneously.
Managing Memory Memory management involves maintaining optimal sizes for the Oracle Database instance memory structures as demands on the database change.
Monitoring the Database It is important that you monitor the operation of your database on a regular basis. Doing so not only informs you of errors that have not yet come to your attention but also gives you a better understanding of the normal operation of your database. Being familiar with normal behavior in turn helps you recognize when something is wrong.
Diagnosing and Resolving Problems Oracle Database includes an advanced fault diagnosability infrastructure for collecting and managing diagnostic data, so as to diagnose and resolve database problems. Diagnostic data includes the trace files, dumps, and core files that are also present in previous releases, plus new types of diagnostic data that enable customers and Oracle Support to identify, investigate, track, and resolve problems quickly and effectively.