dbapath947

Oracle 11g:Oracle Networking

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 …

Oracle 11g:Oracle Networking Read More »

Configure Listener.ora and tnsnames.ora in orcle

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 »

How to install Oracle database 11g

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 …

How to install Oracle database 11g Read More »

Oracle 11g Tablespace Management

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 …

Oracle 11g Tablespace Management Read More »