Part I Basic Database Administration
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.
- Creating and Configuring an Oracle Database
After you plan your database, you can create the database with a graphical tool or a SQL command.
- 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.
- Managing Users and Securing the Database
Establish a security policy for every database.
- 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.
- Managing Diagnostic Data
Oracle Database includes an advanced fault diagnosability infrastructure for collecting and managing diagnostic data. 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.