Oracle Database Administration I ( 1z0-082 Exam )

Download or read book Oracle Database Administration I ( 1z0-082 Exam ) written by Anthony Daccache and published by Anthony Daccache. This book was released on with total page 95 pages. Available in PDF, EPUB and Kindle. Book excerpt: Database Administrators Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one-person job. In such cases, there is a group of DBAs who share responsibility. A database administrator's responsibilities can include the following tasks: Installing and upgrading the Oracle server and application tools Allocating system storage and planning future storage requirements for the database system Creating primary database storage structures (tablespaces) after application developers have designed an application Creating primary objects (tables, views, indexes) once application developers have designed an application Modifying the database structure, as necessary, from information given by application developers Enrolling users and maintaining system security Ensuring compliance with your Oracle license agreement Controlling and monitoring user access to the database Monitoring and optimizing the performance of the database Planning for backup and recovery of database information Maintaining archived data on tape Backing up and restoring the database Contacting Oracle Corporation for technical support Security Officers In some cases, a site assigns one or more security officers to a database. A security officer enrolls users, controls and monitors user access to the database, and maintains system security. As a DBA, you might not be responsible for these duties if your site has a separate security officer. Network Administrators Some sites have one or more network administrators. A network administrator can administer Oracle networking products, such as Oracle Net Services. See Also: Part VI, "Distributed Database Management" for information on network administration in a distributed environment Application Developers Application developers design and implement database applications. Their responsibilities include the following tasks: Designing and developing the database application Designing the database structure for an application Estimating storage requirements for an application Specifying modifications of the database structure for an application Relaying the above information to a database administrator Tuning the application during development Establishing an application's security measures during development Application developers can perform some of these tasks in collaboration with DBAs. Application Administrators An Oracle site can assign one or more application administrators to administrate a particular application. Each application can have its own administrator. Database Users Database users interact with the database through applications or utilities. A typical user's responsibilities include the following tasks: Entering, modifying, and deleting data, where permitted Generating reports from the data Tasks of a Database Administrator The following tasks present a prioritized approach for designing, implementing, and maintaining an Oracle Database: Task 1: Evaluate the Database Server Hardware Task 2: Install the Oracle Software Task 3: Plan the Database Task 4: Create and Open the Database Task 5: Back Up the Database Task 6: Enroll System Users Task 7: Implement the Database Design Task 8: Back Up the Fully Functional Database Task 9: Tune Database Performance These tasks are discussed in succeeding sections.