In this post, we are going to learn “How to install Oracle Database 11g”.Before installing Oracle 11g database server on the Linux machine, please follow the below mentioned procedure. INSTALL ORACLE DATABASE 11g SERVER...
Oracle Database 11g: Tablespace management Oracle 11g Tablespace management is one of the important tasks of a database administrator.Before learning how to manage tablespaces lets understand what is tablespace. A tablespace is one of...
What is sql loader in Oracle 11g SQL Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts a little limitation on the...
Oracle Data Pump technology enables very high-speed movement of data and metadata from one database to another. All Data Pump Export and Import processing, including the reading and writing of dump files, is done...
In Oracle 11g User Management, each Oracle database has a list of valid database users. To access a database, a user must run a database application and connect to the database instance using a...
What is a control file? An Oracle control file is a binary file necessary for the database to start and operate successfully. oracle scans the content of the control file in the mount state...
What is an Online Redo Log File The most crucial structure for recovery operations is the Online redo log file, which consists of two or more preallocated files that store all changes made to the database as they...
In this post, we are going to create an Oracle database using DBCA Start the Database Configuration Assistant (DBCA) Run the DBCA from $ORACLE_HOME/bin directory. On a welcome page click next. Step 1: select...
In this post, we are going to learn “how to create an Oracle database manually”. The database in Oracle can be created using DBCA and using the manual method. it would be a good idea...
In this post, we will discuss Oracle 11g Process Architecture that is background processes of Oracle database 11g in detail. We will discuss SMON, PMON, DBWn, LGWR, and CKPT in detail. Oracle background processes...