Getting Started with Oracle Server - DBA TOOLS

By Using these listed of tools,utility we can reach our goals as a "Database Administrator".
(1)OUI  - ORACLE UNIVERSAL INSTALLER
(2)DBCA - DATABASE CONFIGURATION ASSISTANCE
(3)DBUA - DATABASE UPGRADATION  ASSISTANCE
(4)NETCA - NET CONFIGURATION ASSISTANT
(5)NETMGR - NET MANAGER
(6)SQL*PLUS
(7)ISQL*PLUS
(8)EXP/IMP - EXPORT / IMPORT
(9)DATAPUMP - EXPDP / IMPDP
(10)SQL*LOADER - USE TO LOAD DATA FROM FLAT FILES INTO  DATABASE
(11)OEM - ORACLE ENTERPRISE MANAGER
(12)DBSTART - AUTOMATIC START UP ORACLE DATABASE
13)DBSHUT -  AUTOMATIC SHUT DOWN ORACLE DATABASE
let us  see  uses of Database tools
(1) OUI (ORACLE UNIVERSAL INSTALLER):                                     
  - It's java based installer   that enables to you install oracle components               
  - It's main Purpose is install & uninstall  software               
  - It's enables to "Upgrade " from one version into another version
(2) DBCA (DATABASE CONFIGURATION ASSISTANCE)                 
  - By Using these tool we can create  or delete the Database               
  - It's easiest  method of creating  database and this utility is typically located in
 ORACLE_HOME/bin
(3) DBUA (DATABASE UPGRADATION  ASSISTANCE)               
  - It help us to  through the upgrade process and configures the database for the new release.             
  - It also  supports RAC(Real Application Cluster ) and ASM (Automatic Storage Management)          - Before Upgradation it's has stated pre upgradation check for             
      * Any invalid user accounts or roles             
      * Any invalid datatypes or invalid objects             
      * Any desupported character sets             
      * Adequate resources, including rollback segments,tablespaces, and free diskspace             
      * Backs up all necessary files (optional).             
      * Any missing SQL scripts needed for the upgrade             
  - After  completion pre upgradation checks its automatically accomplish below  listed             
     * Modifies or creates new required tablespaces             
     * Invokes the appropriate upgrade scripts             
     * Archives redo logs             
     * Disables archiving during the upgrade phase             
 (4) NETCA (NET CONFIGURATION ASSISTANT )             
  - It's a Wizard based tool with a graphical user interface             
  - It Main Purpose is to configure the  listener names and protocol(IP) addresses             
 (5) NETMGR (NET MANAGER)              
  - It's a Graphical User InterFace  tool               
  - It can be used on client or server side             
  - It's integrated with  OEM (Oracle Enterprise Manager)             
  - By using these utility we can create below network components             
     * Naming             
     * Naming Methods             
     * Profiles             
     * Listeners             
 - Netca is a configuration Utility it is used to configure the tns and listener files.             
 - Netmgr is used to monitor the status of listener and find the connectivity issues.             
 (6)  SQL*PLUS &  ISQL*PLUS             
 - It's command line user interface ,Windows Graphical User Interface (GUI)             
 - SQL*PLUS is a client server using SQL, PL/SQL and special commands against an Oracle DB         - ISQL*PLUS is a  ( web-based user interface ) web browser version of SQL*PLUS             
 - Major differences of ISQL*PLUS is we can save the Query and Result in HTML Table format
(8) EXP/IMP  (EXPORT / IMPORT)             
 - It's a traditional  method of taking backup (logical  backup method)             
 - When  exporting a database objects are stored in a  binary file format which can be  imported into another oracle database             
 - We can perform  exp/imp between  the oracle databases and we cannot export data and  apply to import it into a non-Oracle database.             
 (9) DATAPUMP (EXPDP / IMPDP)             
 - Its a replacement  of  Exp/imp , the old export/ import tools are still available but not supported all oracle 10g and  11g features.The new utilities are called EXPDP / IMPDP             
 - Compare to exp/imp data pump  had much options like we can see the job status,stop_job,Kill_job,continue_client(Resume job),start_job             
 (10) SQL*LOADER                            
 - It's loads the data from external file  into database table of an oracle database             
 - It has powerful engine of data parsing that put little limitations on format data of  data files             
 (11) OEM (ORACLE ENTERPRISE MANAGER)                             
 - It's   a set of web based tools ,by using this tool  can manage  software  and hardware produced by  " ORACLE CORPORATION "& some of non " ORACLE ENTITIES "             
 - Each machine has a licensing  cost.
(12) dbstart (DATABASE  START)                             
 - It's automatically starts the oracle database instance  and listeners               -
 $cat /etc/oratab
  issuing this command we can see what are the available database listed here  by default it has  set on  'N' and we need to change 'Y' after these changes we don't need issue startup command for  each time
(13) dbshut (DATABASE SHUTDOWN)                             
 - By issuing this  command  shut down an oracle instances