Step-By-Step Configuration Of Data Guard Broker in Oracle 11g

 Here we will configure the data Guard Broker . Here are the steps :

Primary Databse   =  Prod
Standby Database =  Prodstd

Step 1 :  Check the Data Guard Broker process 
SQL> sho parameter dg_broker
NAME                                   TYPE             VALUE
-----------------                    ----------          ----------
dg_broker_start                boolean          FALSE

Step 2  : Start the Data Guard Broker Process on Primary database   
SQL>alter system set dg_broker_start=true scope=both;
System altered.

Step 3 : Check DG_BROKER on standby database and start it 
SQL> sho parameter dg_broker
NAME                                    TYPE             VALUE
-----------------                      ----------         ----------
dg_broker_start                  boolean         FALSE

SQL>alter system set dg_broker_start=true scope=both ;
System altered.

Step By Step applying a database patch to your Database Environment...

Step 1
======
Download the database patch from www.metalink.oracle.com

Our OS and Oracle Database environments are:

OS: Linux-x86-64bit 5.5
Database: Oracle Database 10g release 2 (10.2.0.1.0)

How to create database link in oracle 11gr2

                                 Database link Details:

Database link is a schema object in one database which enables us to access objects

 on another databases.And the other databases not need to be an Oracle Database

 system.But here, to access non-Oracle systems we should use Oracle different 

Services.

ORA-00845: MEMORY_TARGET not supported on this system

Hi Friends,

Sometimes when we all try to connect 11g (newly installed software) and then trying to STARTUP the database, we faced below error message as shown below:

Install/Clone 32-bit 11GR2 Client On Linux x86_64 Fails With Error In Invoking Target 'Mkldflags ntcontab.o nnfgt.o' Of Makefile ins_net_client.mk (Doc ID 1473421.1)

In this Document APPLIES TO: Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later Linux x86-64 ***Checked for relevance on 16-Dec-2013***  SYMPTOMS Install/Clone 32-bit 11g R2 client on Linux RHEL 5 (64-bit) server fails with relinking errors. INFO: (if [ "compile" = "compile" ] ; then \ /bb/bin/oracle/product/client/11.2.0.3/bin/gennttab > ntcontab.c ;\ /usr/bin/gcc -m32 -m32 -fPIC -c ntcontab.c ;\ rm -f /bb/bin/oracle/product/client/11.2.0.3/lib/ntcontab.o ;\ mv ntcontab.o /bb/bin/oracle/product/client/11.2.0.3/lib/ ;\   /usr/bin/ar rv /bb/bin/oracle/product/client/11.2.0.3/lib/libn11.a /bb/bin/oracle/product/client/11.2.0.3/lib/ntcontab.o ; fi)

Error in invoking 'ntcontab.o' of makefile while installing 11gr2 client on Linux x86-64 bit server (Doc ID 1313504.1)

In this Document

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Generic UNIX
***Checked for relevance on 16-Dec-2013***

SYMPTOMS

While installing 11gr2 (11.2.0.x) 64 bit client on a Linux x86-64 bit server the following errors occur during the relink phase of installation:

Requirements for Installing Oracle 11.2.0.4 RDBMS on OL7 or RHEL7 64-bit (x86-64) (Doc ID 1962100.1)

In this Document Purpose Scope Details References APPLIES TO: Oracle Database - Standard Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2] Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2] Linux x86-64 PURPOSE This note explains the requirements that need to be met for a successful installation of Oracle 11gR2 RDBMS release 11.2.0.4 on Red Hat Enterprise Linux 7.0 (or higher 7.x version), 64-bit (x86-64).  These guidelines apply to cluster (RAC) or standalone / single instances. It is NOT the purpose of this NOTE to repeat every "how-to" step that is presented in the 11gR2 Installation Guide manual. For example this NOTE does not include how to create the Linux OS account named "oracle", nor does it cover how to set environment variables. Both are adequately covered in Chapter 2 "Oracle Database Pre-installation Requirements" of the 11gR2 Installation Guide manual.