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 types of materialized views. Oracle Networking Oracle Networking facilitates accessing of data existing on a remote server whether it is client …
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 protocol addresses, information about supported services, and parameters that control its run-time behavior. The listener configuration is stored in a configuration …
Configure Listener.ora and tnsnames.ora in orcle Read More »
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 …