11g Oracle DBA -- Part 2

 ​ 11g Oracle DBA -- Part 2

Introduction of 11g Database

Here we will go through the basic concepts of 11g Database. As an Oracle DBA you have to do the bellow activities. You have to install a Database. You may have to create a database. If required a DBA sometimes have to do an upgrade of the Database Server and the Database also. As per requirements it is a general requirement in a project that the database need to be started, stopped or restarted. They have plan the storage and memory structure of the database. It is one of the primary duty of a DBA to maintain user list and their securities. You have to manage all the database objects such as views, tables, indexes etc. To do backups and recoveries whenever required.  

Weather a DBA will do all these activities or there will be divisions in terms of responsibilities, that depends upon the requirement, scope, and size and budget of the project.

For doing the above activities a DBA uses the bellow tools. These are the weapons of a DBA to complete his tasks. 

• Oracle Universal Installer (OUI)
• Oracle Database Configuration Assistant (DBCA)
• Database Upgrade Assistant (DBUA)
• Net Configuration Assistant (NETCA)
• Oracle Enterprise Manager Database Control
• SQL* Loader
• Recovery Manager (RMAN)

​

More in Next Part