Perfomance Tuning

  • Introduction to Performance Tuning

  • Introduction to Performance Tuning Features and Tools

  • Oracle Methodology

  • Understanding Investment Options

  • Understanding Scalability

  • System Architecture

  • Application Design Principles

  • Workload Testing, Modeling, and Implementation

  • Deploying New Applications

  • The Oracle Performance Improvement Method

  • Emergency Performance Methods

  • Performance Considerations for Initial Instance Configuration

  • Creating and Maintaining Tables for Good Performance

  • Performance Considerations for Shared Servers

  • Overview of Data Gathering

  • Automatic Workload Repository

  • Introduction to Database Diagnostic Monitoring

  • Automatic Database Diagnostic Monitor

  • Understanding Memory Allocation Issues

  • Configuring and Using the Buffer Cache

  • Configuring and Using the Shared Pool and Large Pool

  • Configuring and Using the Redo Log Buffer

  • PGA Memory Management

  • Understanding I/O

  • Basic I/O Configuration

  • Understanding Operating System Performance Issues

  • Solving Operating System Problems

  • Finding System CPU Utilization

  • Instance Tuning Steps

  • Interpreting Oracle Statistics

  • Wait Events Statistics

  • Idle Wait Events

  • Understanding Connection Models

  • Detecting Network Problems

  • Solving Network Problems

  • Introduction to SQL Tuning

  • Goals for Tuning

  • Identifying High-Load SQL

  • Automatic SQL Tuning Features

  • Developing Efficient SQL Statements

  • Automatic SQL Tuning Overview

  • SQL Tuning Advisor

  • Managing SQL Profiles with APIs

  • SQL Tuning Sets

  • SQL Tuning Information Views

  • Optimizer Operations

  • Choosing an Optimizer Goal

  • Enabling and Controlling Query Optimizer Features

  • Understanding the Query Optimizer

  • Understanding Access Paths for the Query Optimizer

  • Understanding Joins

  • Understanding Statistics

  • Automatic Statistics Gathering

  • Manual Statistics Gathering

  • System Statistics

  • Managing Statistics

  • Viewing Statistics

  • Understanding Index Performance

  • Using Function-based Indexes for Performance

  • Using Partitioned Indexes for Performance

  • Using Index-Organized Tables for Performance

  • Using Bitmap Indexes for Performance

  • Using Bitmap Join Indexes for Performance

  • Using Domain Indexes for Performance

  • Using Clusters for Performance

  • Using Hash Clusters for Performance

  • Understanding Optimizer Hints

  • Using Optimizer Hints

  • Using Plan Stability to Preserve Execution Plans

  • Using Plan Stability with Query Optimizer Upgrades

  • Understanding EXPLAIN PLAN

  • The PLAN_TABLE Output Table

  • Displaying PLAN_TABLE Output

  • Reading EXPLAIN PLAN Output

  • Viewing Parallel Execution with EXPLAIN PLAN

  • Viewing Bitmap Indexes with EXPLAIN PLAN

  • Viewing Partitioned Objects with EXPLAIN PLAN

  • End to End Application Tracing

  • Using the traces Utility

  • Understanding SQL Trace and TKPROF

  • Using the SQL Trace Facility and TKPROF

  • Avoiding Pitfalls in TKPROF Interpretation

  • Sample TKPROF Output

Labels:

Relocate Goldengate VIP and XAG Services Manager restart frequently (OGG-01022 )

While researching Oracle GoldenGate, Tenable found three vulnerabilities in GoldenGate Manager. GoldenGate Manager is the process that is in charge of monitoring, controlling, and reporting status on other GoldenGate components. The Manager listens on port 7809 where it accepts GoldenGate Software Command Interface (GGSCI) commands.


Oracle GG: 12.1.2.1.2 and later
Database : 11g /12c 
Xag      : 4.1.0


Scenario/Error :  Goldengate VIP and Xag services getting relocated frequently. whenever  Xag service getting  restart Manager also restarted  hence all Replication got stuck . 

Currently Oracle GoldenGate  cannot handle security scan, and the observed unknown message is due to that. Also Security scanning try to upload images with help of MGR port but oracle are now allow to upload this types of data.

It is Strongly recommended by Oracle to not do security scan on ogg ports

Error Massages : 
Pink  : scanner Host 
Green : GGVIP

2020-05-30 04:19:03  INFO    OGG-01021  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Command received from GGSCI: STATS   REPORTCDR.
2020-05-30 04:21:08  INFO    OGG-00957  Oracle GoldenGate Manager for Oracle, mgr.prm:  Purged old extract file /acfs/goldengate/dirdat/LC302371, applying UseCheckPoints purge rule: Oldest Chkpt Seqno 302663 > 302371.
2020-05-30 04:28:07  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Connection reset by peer.
2020-05-30 04:29:02  INFO    OGG-01021  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Command received from GGSCI: STATS   REPORTCDR.
2020-05-30 04:29:04  INFO    OGG-01021  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Command received from GGSCI: STATS   REPORTCDR.
2020-05-30 04:29:10  INFO    OGG-01022  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Unknown 18 bytes message received from [11.160.10.145]:57880:0 - 000000: 47 45 54 20 2f 20 48 54 54 50 2f 31 2e 30 0d 0a |GET / HTTP/1.0..|
000010: 0d 0a                                           |..              |.
2020-05-30 04:29:10  INFO    OGG-01022  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Unknown 18 bytes message received from [11.160.10.145]:43534:0 - 000000: 47 45 54 20 2f 20 48 54 54 50 2f 31 2e 30 0d 0a |GET / HTTP/1.0..|
000010: 0d 0a                                           |..              |.
2020-05-30 04:29:13  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Connection reset by peer.
2020-05-30 04:29:13  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Connection reset by peer.
2020-05-30 04:29:33  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Connection reset by peer.
2020-05-30 04:29:33  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Connection reset by peer.
2020-05-30 04:29:35  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Connection reset by peer.
2020-05-30 04:29:37  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Connection reset by peer.
2020-05-30 04:29:37  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Connection reset by peer.
2020-05-30 04:29:39  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Connection reset by peer.
2020-05-30 04:29:41  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Connection reset by peer.
2020-05-30 04:29:41  WARNING OGG-01223  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Connection reset by peer.
2020-05-30 04:29:45  INFO    OGG-01022  Oracle GoldenGate Delivery for Oracle, rptw01.prm:  Unknown 287 bytes message received from [11.160.10.145]:48518:0 - 000000: 47 45 54 20 2f 20 48 54 54 50 2f 31 2e 31 0d 0a |GET / HTTP/1.1..|
000010: 43 6f 6e 6e 65 63 74 69 6f 6e 3a 20 43 6c 6f 73 |Connection: Clos|
000020: 65 0d 0a 48 6f 73 74 3a 20 31 30 2e 31 35 30 2e |e..Host: 11.160.|
000030: 34 30 2e 31 36 33 0d 0a 50 72 61 67 6d 61 3a 20 |40.163..Pragma: |
000040: 6e 6f 2d 63 61 63 68 65 0d 0a 55 73 65 72 2d 41 |no-cache..User-A|
000050: 67 65 6e 74 3a 20 4d 6f 7a 69 6c 6c 61 2f 34 2e |gent: Mozilla/4.|
000060: 30 20 28 63 6f 6d 70 61 74 69 62 6c 65 3b 20 4d |0 (compatible; M|
000070: 53 49 45 20 38 2e 30 3b 20 57 69 6e 64 6f 77 73 |SIE 8.0; Windows|
000080: 20 4e 54 20 35 2e 31 3b 20 54 72 69 64 65 6e 74 | NT 5.1; Trident|
000090: 2f 34 2e 30 29 0d 0a 41 63 63 65 70 74 3a 20 69 |/4.0)..Accept: i|
0000A0: 6d 61 67 65 2f 67 69 66 2c 20 69 6d 61 67 65 2f |mage/gif, image/|
0000B0: 78 2d 78 62 69 74 6d 61 70 2c 20 69 6d 61 67 65 |x-xbitmap, image|
0000C0: 2f 6a 70 65 67 2c 20 69 6d 61 67 65 2f 70 6a 70 |/jpeg, image/pjp|
0000D0: 65 67 2c 20 69 6d 61 67 65 2f 70 6e 67 2c 20 2a |eg, image/png, *|
0000E0: 2f 2a 0d 0a 41 63 63 65 70 74 2d 4c 61 6e 67 75 |/*..Accept-Langu|
0000F0: 61 67 65 3a 20 65 6e 0d 0a 41 63 63 65 70 74 2d |age: en..Accept-|
000100: 43 68 61 72 73 65 74 3a 20 69 73 6f 2d 38 38 35 |Charset: iso-885|
000110: 39 2d 31 2c 2a 2c 75 74 66 2d 38 0d 0a 0d 0a    |9-1,*,utf-8.... |.
2020-05-30 04:29:46  INFO    OGG-01022  Oracle GoldenGate Delivery for Oracle, rptwlg.prm:  Unknown 309 bytes message received from [10.100.10.145]:63038:0 - 000000: 47 45 54 20 2f 20 48 54 54 50 2f 31 2e 31 0d 0a |GET / HTTP/1.1..|




 


This could be caused by security scan on ogg ports.  Currently ogg cannot handle security scan, and the observed unknown message is due to that.



Solutions : 
1 . Stop the Security scanning on Goldengate manager port 
2 . Wait for Security scanning completion 
3 . Permanent solution is exclude the mgr port from security scanning

For more Details : (Doc ID 2195512.1)
Labels:

Oracle Rac Traning 19c


  • Oracle RAC Features

  • Oracle RAC Technology Hierarchy

  • Oracle RAC Capabilities

  • Oracle RAC Components

  • Tools for Installing, Configuring and Managing Oracle RAC

  • Cluster Overview

  • Grid Foundation Components and Architecture

  • Oracle Clusterware Components and RAC

  • Oracle Storage Subsystems

  • File Types used by a RAC Database

  • Methods used to Share Database Files across a Cluster

  • ASM Architecture

  • Create and Manage ASM Disk Groups

  • Create and Manage ASM Cluster Filesystems

  • An Overview of RAC Services

  • Network Configuration

  • Oracle RAC Pre-installation Tasks

  • Create Oracle Groups, User Accounts, and Directories

  • Validate and Prepare the Hardware and the Operating System

  • Network Configuration

  • Install the Oracle Grid Infrastructure

  • Cluster Verification Utility (CVU, CLUVFY)

  • Install Oracle Database Software and Create a Cluster Database

  • Verify the Installation

  • Post Installation Tasks

  • Configure Client Connections with Oracle Net Manager

  • Convert an Oracle Database to a RAC Database

  • Use the DBCA for Single Instance Conversion

  • Use rconfig for Single Instance Conversion

  • RAC Specific Background Processes

  • RAC Initialization Parameters

  • Manage Undo Tablespaces in a RAC Environment

  • Manage Redo Log Files and Groups in a RAC Environment

  • Oracle Enterprise Manager Cluster Database Pages

  • Start and Stop Oracle RAC Databases and Instances

  • Administer Database Storage

  • Transparent Data Encryption and Wallets in RAC

  • Manage CRS Commands

  • CRSCTL Commands to Stop, Start and Administer Clusterware

  • Backup and Recover Voting Disks

  • Add and Remove Voting Disks

  • The ocrcheck Utility

  • The ocrdump Command

  • Administer the Oracle Cluster Registry (OCR)

  • Backup and Restore OCR

  • Troubleshoot the OCR with ocrcheck

  • ASM Initialization Parameters

  • Create an ASM Instance using ASMCA

  • Start and Stop an ASM Instance using srvctl

  • Start and Stop an ASM Instance using ASMCMD

  • Start and Stop an ASM Instance Containing Cluster Files

  • Start and Stop the ASM Listener

  • Create and Delete ASM Disk Groups

  • ASM Disk Group Attributes

  • ASM Disk Group Maintenance Tasks

  • Preferred Read Failure Groups

  • ASM Disk Statistics

  • ASM Dynamic Volume Manager

  • Manage ASM Volumes

  • Create an ASM Cluster File System (ACFS)

  • Manage an ACFS File System

  • ACFS Snapshots

  • Manage ACFS with Command Line Tools

  • RAC Management Commands

  • RAC Administration with SVRCTL

  • SVRCTL Cluster Database Configuration Tasks

  • SVRCTL Cluster Database Administration Tasks

  • Check the Current Configuration

  • SVRCTL Command Summary

  • Administer Databases and Instances

  • Administer Services and Node Applications

  • Bring a Cluster Database online and offline

  • Introduction to CRS

  • Cluster Services

  • Manage the Database Workload using Services

  • Create and Administer Services in a RAC Environment

  • Services and Client Applications

  • Manage Services with Enterprise Manager and from the Command Line

  • Configure Oracle Net to Support Services

  • Configure Service Level Thresholds

  • Configure Clients for Failover

  • RAC High Availability Framework

  • Failure Detection with Cluster Services

  • Oracle RAC and Hardware Failover

  • Connection Failover

  • Transparent Application Failover (TAF)

  • Server, Client And Runtime Load Balancing

  • Fast Application Notification (FAN)

  • Server and Client Side Oracle Notification Services

  • Configure a Fast Recovery Area for use with RAC

  • Tune Instance Recovery in RAC

  • Parallel Recovery in RAC

  • Initiate Archiving

  • Configure RMAN Backup and Recovery Settings

  • Backup a RAC Database using RMAN

  • Restore and Recover a RAC Database using RMAN

  • Display Backup Reports

  • Duplicate a RAC Database with RMAN

  • Standby Database in a RAC Configuration

  • Configure Data Guard for a RAC Environment

  • Possible Combinations of Instances in the RAC Primary and Standby Databases

  • Multi-Instance Primary with a Single Instance Standby

  • Set up a Primary in a RAC Environment

  • Set up a Single Instance Standby Database

  • Set up a Multiple Instance Primary and Cluster Standby

  • Configure RAC Primary and Standby Databases

  • Data Protection Modes

  • Role Transition Switchovers and Failovers

  • Switchover Failover in an Oracle RAC Configuration

  • Monitoring and Performance Guidelines

  • RAC Monitoring Tools

  • RAC Performance Recommendations

  • Analyze Performance Issues using OS Watcher and LTOM

  • Use the Automatic Workload Repository in RAC

  • Use the Automatic Database Diagnostic Monitor in RAC

  • Use Statspack with RAC

  • Global Cache Services (GCS) Monitoring

  • V$cache_transfer Views

  • Monitor the GES Processes

  • Monitor and Tune the RAC Cluster Environment using Enterprise Manage.

  • Prepare a New Node

  • Extend the Oracle Grid Infrastructure Home to the New Node

  • Extend the Oracle RAC Home Directory

  • Add the New Node to the Cluster

  • Create an Instance on the New Node

  • Delete an Instance from the Cluster Database

  • Remove a Node from the Cluster

  • Configure the EM Patch Interface

  • Obtain Patches

  • Apply Rolling Patches to a RAC System

  • Apply a Patchset with the opatch Utility

  • Apply a Patchset with OUI

Labels:

Core DBA Traning 19c


  • What is DBA?

  • Why a Company needs a DBA?

  • Roles & Responsibilities of DBA

  • Oracle Architecture

  • Physical and Logical Phase of Database

  • Types of files(Control file, Redolog file and Datafile)

  • Different types of Datafiles

  • Instance

  • SGA(System Global Area) and Background Process

  • Different Startup Modes

  • Different Shutdown Modes

  • Types of Database Creation

  • Manual Method of Creation

  • Introduction to Table space

  • Types of Table space(BIG & SMALL)

  • Temporary Table space

  • Altering/Renaming a Table space

  • Renaming a data file

  • Temporary Groups

  • Table space Encryption(11g)

  • What are segments?

  • What are extents?

  • What is Blocks?

  • Oracle Blocks

  • Estimation of Extents

  • Dictionary Managed Table space

  • Locally Managed Table space

  • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

  • Who are Database Users?

  • Why to create a User?

  • Creation of Users

  • Assigning Privileges

  • Creating and granting Roles

  • Allocating table space Quotas to Users

  • Assigning default table space for the Users

  • Setting Profiles for the Users

  • Levels of Authentication

  • Schema Management(11g)

  • Security(11g)

  • What is Undo?

  • Why Undo required?

  • Pending offline status

  • Brief idea about Rollback segments

  • Flashback Features

  • Flashback Table

  • Flashback query

  • Flashback Version query

  • What is spfile?

  • Difference between spfile and pfile

  • Advantages of spfile

  • What is OMF?

  • Advantages of OMF

  • Files conventions of OMF

  • Introduction to Oracle Networking

  • Network default location

  • Editing Network file

  • Tnsnames.ora

  • Introduction to Database Links

  • Types of Database Links

  • Introduction to Materialized views

  • Advantages of Materialized view

  • Refresh Modes

  • Introduction to Redo log

  • Status of Redo logs

  • Multiplexing the Redo log files

  • Re-creation of Control file

  • Renaming the Database

  • Multiplexing the Control file

  • What is a logical backup

  • Why it is required

  • Export/import Utility

  • Data Pump

  • Difference between Data Pump and Traditional Export/import

  • Impdp/expdp

  • Transportable Table spaces

  • Introduction to Physical backup

  • Types of Physical backup

  • Cold & Hot backup

  • Recovery scenarios

  • RMAN backup

  • RMAN Point in time recovery

  • RMAN 11g new features

  • What is Performance Tuning?

  • Why Tuning required?

  • Types of Tuning

  • Database Tuning

  • Tuning

  • SQL Tuning

  • Memory Tuning

  • Network Tuning

  • Partitioning and Indexes

  • Partitioning Enhancements

  • AWR/ASH/ASMM/ADDM

  • RAT(Real Application Testing)(11g)

  • SQL Performance Analyses (11g)

  • Row Chaining and Row migration

  • Resemble Table spaces


Labels: