In this post, we will discuss networking concepts in Oracle Database 11g. The post will cover different types of networking concepts like listener.ora, tnsnames.ora and sqlnet.ora we also learn about materialized views and different...
In this post, we are going to learn how to configure listener.ora, tnsnames.ora and how to create a materialized views Configure Oracle Networking Configure listener.ora A listener is configured with one or more listening...
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...