facebook twitter youtube facebook facebook facebook

E-Mail : info@askmlabs.com

Phone : +1.215.353.8306

Latest Post

OEM : AMP and Change Management Implementation

Written By askMLabs on Sunday, February 23, 2014 | 12:43 AM

In this article, we are going to see the implementation plan for AMP ( application management pack) and change management in oem 12c. This article gives you an idea of complete plan to implement with screen shots and references and don't eloborate detailed patching and session log. DBAs already working in oem 12c and oracle apps R12, should feel comfortable to understand the plan presented here.
  1. 1. Patches required for EBS R12
  2. 2. Patches required for OEM 12c
  3. 3. Deploy fusion middleware plug-in on the EBS host
  4. 4. Deploy plug-in on OMS and EBS agent
  5. 5. Apply recommended patches for AMP
  6. 6. Prevalidate discovery for oracle E-business suite
  7. 7. Using discovery wizard to discover EBS targets

1) Patches required for EBS R12
Product/Feature Release 12.1+ with R12.ATG_PF.B.DELTA.3
AMP: Administration  Patch 8919489
AMP: User Monitoring and Diagnostics  Patch 10168359
AMP: Cloning  Patch 9171651
ACMP: Setup Manager  Patch 9444535
ACMP: Customization Manager  Patch 9967338, Patch 7648894, Patch 16770159
Patch 9171651 - R12 rapidclone consolidated fixes jul/2010 for Release R12
Patch 14825718 - oracle forms bundle patch 10.1.2.3.2 for product Developer Forms.
Note: This patch conflicts with other existing patches in ORACLE_HOME 10.1.2.3, but conflict messages can be safely ignored

Download and apply the above recommended patches to the EBS R12

2) Patches required for OEM 12c 
Patch 13510835: hold:proceduremanager.getprocedureexecutioninfos performance
patch 14068462: merge request on top of 12.1.0.1.0 for bugs 13622118 13875571
patch 13865299: aggregate service stays down when sub-service is up
 patch 17035004 upgrade of ebs plugin 4.0 to 12.1.0.1.0 fails with em12c r3
 Patch 14660238 just before deploying the management pack on the OMS Server.
 Patch 14238075: release update pack for oracle e-business suite plug-in 12.1.0.1.0.
 Patch 12965899:  start with and connect by clause is not working in xpath query context ( If RDBMS is greater than 11.2.0.2. )

Apply all the above patches to OEM12c


3) Deploy fusion middleware plug-in on the EBS host
Goto SetupàExtensibilityàself updateàplug-in
Select Oracle Fusion Middleware in the Plug-ins table. Select Deploy On andthen select Management Agent.


4)  Deploy plug-in on OMS and EBS agent
Goto SetupàExtensibilityàself updateàplug-in
Select Oracle E-Business Suite and click Download
 After the file get downloaded click on Apply buttonOnce apply is done the status of the plug-in will be applied. Now click plug-in button to go to the plug-in page for deployment
 Select Oracle E-Business SuiteàDeploy OnàManagement Servers
Provide the repository password
During this time OMS will be down and users will not be able to login.
 Select Oracle E-Business SuiteàDeploy OnàManagement Agent
Click Add to add the EBS host and deploy the plugin. 
On OMS 








On EBS Agent :






5)  Apply recommended patches for AMP
Product/Component
Apply On
Patch Number
AMP: Discovery
Agent
AMP: Clone
Agent
EM: Framework
OMS
AMP: Install
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Diagnostics
OMS
AMP: Diagnostics
OMS
AMP: Other
OMS
AMP: Other
OMS
AMP: Other
OMS
ACMP: Patch Manager
OMS
ACMP: Customization Manager
OMS
ACMP: Customization Manager
OMS
ACMP: Customization Manager
OMS
ACMP: Setup Manager
OMS
ACMP: Setup Manager
OMS


6) Pre-validate discovery for oracle E-business suite
TagetsàOracle E-Business SuiteàDiscovery WizardàAdd Databases and select the R12 DBàPrevalidate.
 Select the R12 database and click on Prevalidate button and give the apps username and password to prevalidate Discovery.

We will get new option from targets menu as Oracle E-Business Suite.








7) Using discovery wizard to discover EBS targets
Once prevalidation in successful start discovering the EBS targets
TagetsàOracle E-Business SuiteàDiscovery WizardàAdd Databases and select the R12 DBàDiscover
Click on Discover Button to start the normal discover process to discover EBS targets.

Discovering EBS targets after prevalidation succeeded. 






Hope this helps
SRI


Installing OpenNMS in CentOS 6

Written By askMLabs on Friday, February 21, 2014 | 9:33 AM

In this article, we will see how to install OpenNMS in CentOS 6.5 version.

OpenNMS is the world’s first enterprise grade network management application platform developed under the open source model. It is a free and open-source enterprise grade network monitoring and network management platform. It is developed and supported by a community of user and developers as well as by the The OpenNMS Group, offering commercial services, training and support.

The installation procedure differs based on the host OS you choose. As we are installing it on CentOS, i am choosing to install using YUM/RPM method. For other OS installation , please refer to the link  Installing OpenNMS

1) Check the Java Version and Install repository RPM.

[root@askmlabstools pgsql]# which java
/usr/bin/java
[root@askmlabstools pgsql]# java -version
java version "1.7.0_45"
OpenJDK Runtime Environment (rhel-2.4.3.4.el6_5-x86_64 u45-b15)
OpenJDK 64-Bit Server VM (build 24.45-b08, mixed mode)
[root@askmlabstools pgsql]#
[root@askmlabstools pgsql]# rpm -Uvh http://yum.opennms.org/repofiles/opennms-repo-stable-rhel6.noarch.rpm
Retrieving http://yum.opennms.org/repofiles/opennms-repo-stable-rhel6.noarch.rpm
warning: /var/tmp/rpm-tmp.n91osI: Header V3 DSA/SHA1 Signature, key ID 5b9efd43: NOKEY
Preparing...                ########################################### [100%]
   1:opennms-repo-stable    ########################################### [100%]
[root@askmlabstools pgsql]#

2) Verify if you have postgresql installed and operational. If you don't have postgresql installed, please complete the following steps to install postgre.
yum install postgresql postgresql-server
/sbin/service postgresql start
Some distributions will require you to first initialize the database. If you see an error when running that command, try initdb first, and then start again
/sbin/service postgresql initdb
/sbin/service postgresql start
/sbin/chkconfig postgresql on
Modify the file pg_hba.conf located under /var/lib/pgsql/data/ as shown below ...
local   all         all                               trust
host    all         all         127.0.0.1/32          trust
host    all         all         ::1/128               trust
Then restart the postgre database as root user.
/sbin/service postgresql restart 

3) Now install OpenNMS using the following command ....
[root@askmlabstools data]# yum -y install opennms
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
.....
.....
.......
Installed:
  opennms.noarch 0:1.12.4-1
Dependency Installed:
  jdk.x86_64 2000:1.6.0_24-fcs     jicmp.x86_64 0:1.4.1-1     jicmp6.x86_64 0:1.2.1-1     opennms-core.noarch 0:1.12.4-1     opennms-webapp-jetty.noarch 0:1.12.4-1
Complete!
[root@askmlabstools data]#
4) Configure java to tell OpenNMS which java it has to use. Execute the following command to complete java configuration.
[root@askmlabstools bin]# /opt/opennms/bin/runjava -S /usr/java/latest/bin/java
runjava: checking specified JRE: "/usr/java/latest/bin/java"...
runjava: specified JRE is good.
runjava: value of "/usr/java/latest/bin/java" stored in configuration file
[root@askmlabstools bin]# 

5) Now create database in postgresql database for OpenNMS to use. Run the following command to create database...
[root@askmlabstools bin]# /opt/opennms/bin/install -dis
===============================================================
OpenNMS Installer
===============================================================
Configures PostgreSQL tables, users, and other miscellaneous settings.
- searching for libjicmp.so:
  - trying to load /usr/lib64/libjicmp.so: OK
- searching for libjicmp6.so:
...
...
...
Finished in 2 seconds
Upgrade completed successfully!
[root@askmlabstools bin]#
Verify that you have schema created and able to connect to database using following commands .....
bash-4.1$ psql -p5432 -dpostgres
psql (8.4.18)
Type "help" for help.
postgres=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ******** |          |
 nagiosxi |    16384 | f           | f        | f         | ******** |          |
 opennms  |    16520 | t           | t        | t         | ******** |          |
(3 rows)
postgres=# \q
bash-4.1$ exit
6) Then install "iplike", which provides an API for easily performing complicated IP address queries.
[root@askmlabstools bin]# yum -y install iplike
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
..
..
Complete!
[root@askmlabstools bin]#
7) Modify iptables to allow opennms port to be accessible. Run following commands ...
iptables -A INPUT -p tcp -m tcp --dport 8980 -j ACCEPT
service iptables save 
8) Now restart OpenNMS service as root  user and access the url.
[root@askmlabstools bin]# /sbin/service opennms status
opennms is stopped
[root@askmlabstools bin]# /sbin/service opennms start
Starting OpenNMS:
Started OpenNMS, but it has not finished starting up
                                                           [FAILED]
[root@askmlabstools bin]#
[root@askmlabstools bin]# service opennms status
opennms is running
[root@askmlabstools bin]# service opennms restart
Stopping OpenNMS:                                          [  OK  ]
Starting OpenNMS: Started OpenNMS, but it has not finished starting up
                                                           [FAILED]
[root@askmlabstools bin]
Please follow my forum thread to resolve this issue. The link is here.

Finally the url to access OpenNMS is :   http://<YOUR-OPENNMS-IP>:8980/opennms/    
The default username and password to login to url are :  admin and admin.

Hope it helps
SRI

Reference:
Install OpenNMS

How to connect to Postgre database

In this article, i am going to show you the steps to connect to the postgre database.

First you need to know the port on which postgresql is running. To know this use the following command ..

grep -i  postgresql  /etc/services

The output from the above command lists you the port the postgre is using. Now use the following command to connect to the postgre.

Assuming you installed your postgre with user "postgres" and the port used by postgre is 5432. Now switch user to  postgres and connect to it.

[root@askmlabstools pgsql]# su postgres
bash-4.1$ psql -p5432 -dpostgres
psql (8.4.18)
Type "help" for help.
postgres=# select name,setting from pg_settings where name='post';
 name | setting
------+---------
(0 rows)
postgres=# select name,setting from pg_settings where name='poRT';
 name | setting
------+---------
(0 rows)
postgres=# select name,setting from pg_settings where name='port';
 name | setting
------+---------
 port | 5432
(1 row)
postgres=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ******** |          |
 nagiosxi |    16384 | f           | f        | f         | ******** |          |
(2 rows)
postgres=# exit
postgres-# \q

Hope it help.
SRI


RAC Health Checks

This article is to present various commands used to perform rac health checks. In oracle RAC, there are various components and to know the status of individual components, these commands may help you as reference. The commands are not limited , but as an easy reference to check the status.


Login to server using grid user ( clusterware software owner ) :
Execute the environment profile.


1) RAC Node Apps Health Checks :
[grid@rac11gdb01 ~]$ srvctl status nodeapps
VIP rac11gdb01-vip is enabled
VIP rac11gdb01-vip is running on node: rac11gdb01
VIP rac11gdb02-vip is enabled
VIP rac11gdb02-vip is running on node: rac11gdb02
Network is enabled
Network is running on node: rac11gdb01
Network is running on node: rac11gdb02
GSD is disabled
GSD is not running on node: rac11gdb01
GSD is not running on node: rac11gdb02
ONS is enabled
ONS daemon is running on node: rac11gdb01
ONS daemon is running on node: rac11gdb02
[grid@rac11gdb01 ~]$



2) ASM Status : 
[grid@rac11gdb01 ~]$ srvctl status asm
ASM is running on rac11gdb02,rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status asm -n rac11gdb01
ASM is running on rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status asm -n rac11gdb02
ASM is running on rac11gdb02
[grid@rac11gdb01 ~]$



3) Database Status:
[grid@rac11gdb01 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac11gdb01
Instance racdb2 is running on node rac11gdb02
[grid@rac11gdb01 ~]$ srvctl status instance -d racdb -i racdb1
Instance racdb1 is running on node rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status instance -d racdb -i racdb2
Instance racdb2 is running on node rac11gdb02
[grid@rac11gdb01 ~]$


4) CRS Status:
[grid@rac11gdb01 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@rac11gdb01 ~]$


5) Cluster Status:
[grid@rac11gdb01 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@rac11gdb01 ~]$


6) RAC High Availability Services Status:
[grid@rac11gdb01 ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@rac11gdb01 ~]$


7) Database Services Status : 
[grid@rac11gdb01 ~]$ srvctl status service -d racdb
Service racdb_service is running on instance(s) racdb1,racdb2
[grid@rac11gdb01 ~]$


8) Listener Status: 
[grid@rac11gdb01 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac11gdb02,rac11gdb01
[grid@rac11gdb01 ~]$


9) SCAN VIP Status : 
[grid@rac11gdb01 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac11gdb02
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac11gdb01
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac11gdb01
[grid@rac11gdb01 ~]$


10) Scan Listener Status : 
[grid@rac11gdb01 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac11gdb02
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac11gdb01
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac11gdb01
[grid@rac11gdb01 ~]$


11) Server Status : 
[grid@rac11gdb01 ~]$ srvctl status server -n rac11gdb01 -a
Server name: rac11gdb01
Server state: ONLINE
Server active pools: Generic ora.racdb ora.racdb_racdb_service
Server state details:
[grid@rac11gdb01 ~]$ srvctl status server -n rac11gdb02 -a
Server name: rac11gdb02
Server state: ONLINE
Server active pools: Generic ora.racdb ora.racdb_racdb_service
Server state details:
[grid@rac11gdb01 ~]$


12)CVU Status: 
[grid@rac11gdb01 ~]$ srvctl status cvu
CVU is enabled and running on node rac11gdb01
[grid@rac11gdb01 ~]$



13) GNS Status :  ( As root user)
[root@rac11gdb01 ~]# /o001/home/11.2.0.2/grid/bin/srvctl status gns
PRCS-1065 : GNS is not configured.
[root@rac11gdb01 ~]#


14) Serverpool Details : 
[grid@rac11gdb01 ~]$ srvctl status srvpool
Server pool name: Free
Active servers count: 0
Server pool name: Generic
Active servers count: 2
[grid@rac11gdb01 ~]$


15) Cluster Interconnect Details : 
[grid@rac11gdb01 ~]$ oifcfg getif
eth0  192.168.1.0  global  public
eth1  192.168.50.0  global  cluster_interconnect


16) OCR Checks:
[grid@rac11gdb01 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3224
         Available space (kbytes) :     258896
         ID                       : 1449084471
         Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check bypassed due to non-privileged user
[grid@rac11gdb01 ~]$



17) OCR Backups:
[grid@rac11gdb01 ~]$ ocrconfig -showbackup
rac11gdb01     2013/09/23 11:46:41     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup00.ocr
rac11gdb01     2013/09/23 04:19:26     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup01.ocr
rac11gdb01     2013/09/23 00:19:25     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup02.ocr
rac11gdb01     2013/09/22 08:19:24     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/day.ocr
rac11gdb01     2013/09/10 08:18:54     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
[grid@rac11gdb01 ~]$




18) Voting Disk Status: 
[grid@rac11gdb01 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   9bc0828570854fa5bff3221500a1fc63 (ORCL:CRSVOL1) [OCR_VOTE]
Located 1 voting disk(s).
[grid@rac11gdb01 ~]$



19) Node apps config details : 
[grid@rac11gdb01 ~]$ srvctl config nodeapps  -a -g -s
Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static
VIP exists: /rac11gdb01-vip/192.168.1.73/192.168.1.0/255.255.255.0/eth0, hosting node rac11gdb01
VIP exists: /rac11gdb02-vip/192.168.1.74/192.168.1.0/255.255.255.0/eth0, hosting node rac11gdb02
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
[grid@rac11gdb01 ~]$



20) Diskgroups Status:
[grid@rac11gdb01 ~]$ crs_stat -t | grep -i dg
ora....DATA.dg ora....up.type ONLINE    ONLINE    rac11gdb01
ora.FLASH.dg   ora....up.type ONLINE    ONLINE    rac11gdb01
ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac11gdb01
[grid@rac11gdb01 ~]$

Hope this helps
SRI



Oracle Apps Technology Stack Details

Written By askMLabs on Wednesday, February 19, 2014 | 5:40 AM

In this article, i am going to show you the steps to obtain the technology stack details in oracle apps. After generating the technology stack details in html format, we can access using the apps url.

Create any temporary directory and make sure apps user has full access to that directory.
Then execute the following command to generate the tech stack inventory ...

perl $FND_TOP/patch/115/bin/TXKScript.pl
-script=$FND_TOP/patch/115/bin/txkInventory.pl
-txktop=$APPLTMP
-contextfile=$CONTEXT_FILE
-appspass=apps
-outfile=/tmp/askm/Report_Inventory.html

Session Log:
[root@ebiz1222ap01 ~]# chmod 777 /tmp/askm
[root@ebiz1222ap01 ~]# exit
logout
[applmgr@ebiz1222ap01 askm]$ touch askm
[applmgr@ebiz1222ap01 askm]$ rm askm
[applmgr@ebiz1222ap01 askm]$ perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=/home/apps/VIS/fs1/inst/apps/VIS_ebiz1222ap01/appl/admin/VIS_ebiz1222ap01.xml -appspass=apps -outfile=/tmp/askm/Report_Inventory.html
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT   = /home/apps/VIS/fs1/inst/apps/VIS_ebiz1222ap01/logs/appl/rgf/TXK/txkInventory_Tue_Feb_18_21_14_25_2014_stdout.log
Reportfile /tmp/askm/Report_Inventory.html generated successfully.
[applmgr@ebiz1222ap01 askm]$

The generated file  /tmp/askm/Report_Inventory.html can be copied to $OA_HTML directory to be accessible with the apps url.

[applmgr@ebiz1222ap01 ~]$ cd $OA_HTML
[applmgr@ebiz1222ap01 html]$ pwd
/home/apps/VIS/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html
[applmgr@ebiz1222ap01 html]$ cp /tmp/askm/Report_Inventory.html .
[applmgr@ebiz1222ap01 html]$


Now you should be able to access the tech stack inventory using the following apps URL.

http://ebiz1222ap01.askmlabs.com:8000/OA_HTML/Report_Inventory.html


To generate the report for database tier node, you can use the following command ...

perl $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl
-txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=apps
-outfile=/tmp/askm/Report_Inventory.html

Option -reporttype=text  controls whether you need the output in text format or html format.


Hope This helps,
SRI


ORACLE 12C DATAGUARD ADMINISTRATION TRAINING

Written By askMLabs on Saturday, January 18, 2014 | 8:01 AM


In this course, you will learn how to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. You'll also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role.

Current Training Schedule : 
Training Format
Online Training
Fee
USD 300 /  INR 15,000/-
Duration
4 weeks ( Sat & Sun ) - 4 Hr Session
Date
DD-MON-YYYY
Time
HH:MI to HH:MI
Instructor
Srikrishna Murthy Annam

Services :
Training Format
Self Study Material with Lab practice examples
Fee
USD xxx /  INR x,xxx/-
Prepared By
Srikrishna Murthy Annam

Only Lab : 
Practice Lab
24/7 practice lab access from our data center
Fee
USD xxx /  INR x,xxx/-
Guided  By
Srikrishna Murthy Annam

Course Content : 
In this course, you will learn how to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes. You'll also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role.

You will learn about Data Guard architecture, the configuration of physical and logical standby databases, role transitions, and Oracle Data Guard 11g features, including Oracle Active Data Guard and snapshot standby databases. You will also learn about managing a Data Guard configuration and troubleshooting.

  1. 1. Introduction to Oracle Data Guard
    1. Causes of Data Loss
    2. Oracle Data Guard Architecture
    3. Types of Standby Databases and Benefits of Each Type
    4. Using the Data Guard Broker
    5. Differentiating Standby Databases and Data Guard Broker Configuration
    6. Data Protection Modes
    7. Performing Role Transitions
  2. 2. Creating a Physical Standby Database by Using SQL and RMAN Commands
    1. Preparing the Primary Database
    2. Creating the Physical Standby Database
  1. 3. Oracle Data Guard Broker
    1. Oracle Data Guard Broker Features
    2. Oracle Data Guard Broker Configurations
    3. Data Guard Monitor Process
    4. Data Guard Monitor Configuration Files
    5. Benefits of Using the Data Guard Broker
    6. Comparing Configuration Management With and Without the Broker
    7. Using DGMGRL
  2. 4. Creating a Data Guard Broker Configuration
    1. Data Guard Configuration
    2. Setting up the Broker Configuration Files
    3. Setting the DG_BROKER_START Initialization Parameter to TRUE to Start the Data Guard Broker
    4. Creating the Broker Configuration
    5. Adding the Standby Database to the Configuration
  3. 5. Creating a Physical Standby Database by Using Enterprise Manager Grid Control
    1. Using Enterprise Manager Grid Control to Create a Physical Standby Database
    2. Using the Add Standby Database Wizard
    3. Verifying a Configuration
    4. Editing Standby Database Properties
    5. Viewing the Data Guard Configuration Status
  4. 6. Creating a Logical Standby Database
    1. Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control
    2. Verifying the Configuration
    3. Viewing Log File Details
    4. Using Enterprise Manager Data Guard Metrics
    5. Using the DGMGRL Show Configuration Command to Monitor the Configuration
    6. Viewing Standby Redo Log Information
    7. Monitoring Redo Apply
  5. 7. Creating and Managing a Snapshot Standby Database
    1. Snapshot Standby Database: Architecture
    2. Converting a Physical Standby Database to a Snapshot Standby Database
    3. Activating a Snapshot Standby Database: Issues and Cautions
    4. Viewing Snapshot Standby Database Information
    5. Converting a Snapshot Standby Database to a Physical Standby Database
  6. 8. Using Oracle Active Data Guard
    1. Using Real-Time Query
    2. Enabling and Disabling Real-Time Query
    3. Enabling Block Change Tracking on a Physical Standby Database
    4. Creating Fast Incremental Backups
    5. Monitoring Block Change Tracking
  7. 9. Configuring Data Protection Modes
    1. Preparing to Create a Logical Standby Database
    2. Checking for Unsupported Objects, Data Types, and Tables
    3. Ensuring Unique Row Identifiers
    4. Creating the Logical Standby Using SQL Commands and Grid Control
    5. Securing your Logical Standby Database
  8. 10. Performing Role Transitions
    1. Switchover vs. Failover
    2. Preparing for a Switchover
    3. Performing a Switchover using DGMGRL and Enterprise Manager
    4. Types of Failovers
    5. Re-enabling Disabled Databases
  9. 11. Using Flashback Database in a Data Guard Configuration
    1. Flashback Database
    2. Configuring Flashback Database
    3. Using Flashback Database Instead of Apply Delay
    4. Using Flashback Database and Real Time Apply
    5. Flashback Through Standby Database Role Transitions
    6. Using Flashback Database After Failover
  10. 12. Enabling Fast-Start Failover
    1. Installing the Observer Software
    2. Configuring Fast-Start Failover
    3. Configuring Automatic Reinstatement of the Primary Database
    4. Initiating Fast-Start Failover from an Application
    5. Disabling Fast-Start Failover
    6. Starting and Stopping the Observer
    7. Moving the Observer to a New Host
  11. 13. Managing Client Connectivity
    1. Client Connectivity in a Data Guard Configuration
    2. Preventing Clients from Connecting to the Wrong Database
    3. Creating Services for the Data Guard Configuration Databases
    4. Automating Client Failover in a Data Guard Configuration
    5. Automating Failover for OCI Clients
    6. Automating Failover for OLE DB Clients
    7. Configuring JDBC Clients for Failover
  12. 14. Performing Backup and Recovery Considerations in an Oracle Data Guard Configuration
    1. Backup and Recovery of a Logical Standby Database
    2. Using the RMAN Recovery Catalog in a Data Guard Configuration
    3. Creating the Recovery Catalog
    4. Registering a Database in the Recovery Catalog
    5. Configuring Daily Incremental Backups
    6. Using a Backup to Recover a Data File on the Primary Database
    7. Recovering a Data File on the Standby Database
  13. 15. Patching and Upgrading Databases in a Data Guard Configuration
    1. Upgrading an Oracle Data Guard Broker Configuration
    2. Using SQL Apply to Upgrade the Oracle Database
    3. Performing a Rolling Upgrade by Using SQL Apply
    4. Performing a Rolling Upgrade by Using an Existing Logical Standby Database
    5. Performing a Rolling Upgrade by Creating a New Logical Standby Database
    6. Performing a Rolling Upgrade by Using a Physical Standby Database
  14. 16. Monitoring a Data Guard Configuration
    1. Monitoring the Data Guard Configuration by Using Enterprise Manager Grid Control
    2. Verifying the Configuration
    3. Viewing Log File Details
    4. Using Enterprise Manager Data Guard Metrics
    5. Using the DGMGRL SHOW CONFIGURATION Command to Monitor the Configuration
    6. Viewing Standby Redo Log Information
    7. Monitoring Redo Apply
  15. 17. Optimizing a Data Guard Configuration
    1. Using Enterprise Manager Grid Control to Monitor Configuration Performance
    2. Setting the ReopenSecs and NetTimeout Database Properties
    3. Compressing Redo Data
    4. Delaying the Application of Redo Data
    5. Optimizing SQL Apply
    6. Adjusting the Number of APPLIER and PREPARER Processes

Who Can Attend :
  1. Technical Consultant
  2. Database Administrators
  3. Support Engineer

Course Objective : 
  1. Create and manage physical and logical standby databases
  2. Use Data Guard standby databases to support production functions such as reporting, querying, testing, and performing backups
  3. Use Enterprise Manager Grid Control and the Data Guard command-line interface (DGMGRL) to maintain a Data Guard configuration
  4. Use Data Guard to achieve a highly available Oracle database
  5. Preparing a Primary Database for a Data Guard Configuration
  6. Creating a Snapshot Standby Database
  7. Monitoring a Standby Database Configuration
  8. Managing a Data Guard Configuration
  9. Troubleshooting Standby Database Configurations
  10. Tuning a Standby Database
  11. Backing up and Recovering a Data Guard Configuration
  12. Using Flashback in a Data Guard Configuration
  13. Using the Data Guard Broker
Why To Choose Us : 
  1. Free Plug & Play virtual Machine 11g Data Guard
  2. Handouts for each topics
  3. Lab facility from anywhere* ( From our cloud servers )
  4. Guidance from expert trainers
  5. Help to setup database in local machines
  6. 100% Student Satisfaction
  7. Direct Interaction with Faculty at office
  8. Guidance for Interview Preparation
  9. Guidance for certification
Fee Details : 
  1. Single payment 10% discount
  2. Two installments ( 50% before starting and 50% after 2 weeks )  -- 5% discount on second payment
  3. Three installments (20% before starting + 50% before 3rd week + 30% before 4th week)
  4. Refer a friend and get 20% discount on course fee
  5. Good negotiable price for group of people as a batch
 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger