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 ON LINUX Download the Oracle server files from oracle.com # 11.2.0.1 unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip You can download the above files …
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 the logical structure of the database. The database’s data is collectively stored in the database’s tablespaces. Tablespace contains one or more datafiles. In …
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 format of the data in the data file. You can use SQL*Loader to do the following: Load data across a network. …
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 on the system (server) selected by the specified database connect string. This means that for unprivileged users, the database administrator (DBA) must …
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 valid username defined in the database. This section explains how to manage users for a database The following are some of …
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 for the physical location of datafile and redo log files. Oracle continuously updates the control file during the functionality of the …
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 occur. Every instance of an OracleDatabase has an associated redo log to protect the database in case of an instance failure. In most cases, …
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 create a database and click next. Step 2 : Select General Purpose or Transnational Processing Step 3: Give a database name Step …
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 to create a database manually at least once to understand how a database is created step by step in Oracle. Step …
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 There are different types of processes in oracle server User Process: Starts when a database user requests to connect to an …