Loading....

Knowledge Base New

  1. GoldenGate How to handle replication with extra columns on source and target tables
  2. Installation and Configuration of GoldenGate 19c Microservices on RAC
  3. Oracle Enterprise Manager Cloud Control 13.4 Patching
  4. 19c FSFO Observer – some findings
  5. Data Guard Observer 19c – Observe Only Mode new feature
  6. FSFO with multiple standby database targets
  7. Cloning an Oracle 19c Oracle Home
  8. 19c Container Database Data Guard Configuration
  9. Oracle 12c to 19c Data Guard Upgrade with 19c Container Database
  10. Upgrade Oracle 12c non-CDB to Oracle 19c and plugin to CDB

Notes

Single TFA command to collect performance related diagnostic data

$TFA_HOME/bin/tfactl diagcollect -srdc dbperf

List plugins deployed on OEM management agent

D:\oracle\middleware\bin>emcli list_plugins_on_agent -agent_names=CPVDC1ORA1.localdomain:3872

The Agent URL is https://CPVDC1ORA1.localdomain:3872/emd/main/ –
Plug-in Name Plugin-id Version [revision]

Oracle Home oracle.sysman.oh 13.4.0.0.0
Oracle Database oracle.sysman.db 13.4.1.0.0

TKPROF Top 5 SQL statements sorted by Elapsed time

Top 5 SQL statements sorted by Elapsed time

tkprof isi_ora_2872.trc awlrs_trace.out sys=no print=5 sort=(prsela,exeela,fchela)

To sort by CPU time use sort=(prscpu,execpu,fchela)

13c Agent Not Uploading To OMS

emctl status agent shows :

Last successful upload: (none)

Last attempted upload : (none)

Number of Targets : (none)

Or

OMS reports

Status  Availability Evaluation Error

Fix

  • emctl config agent addinternaltargets
  • emctl config agent listtargets
  • emctl stop agent
  • emctl clearstate agent
  • emctl secure agent
  • emctl start agent

 

How to Collect Standard Information for a Database Performance Problem Using TFA Collector

Metalink Note DOC ID 2315692.1

$TFA_HOME/bin/tfactl diagcollect -srdc dbperf

GoldenGate DDL handle Tablespace name differences

DDLSUBST ‘PRODUSA_DATA’ WITH ‘USPRD_DATA’ INCLUDE ALL
DDLSUBST ‘PRODUSA_DATA_ENC’ WITH ‘USPRD_DATA’ INCLUDE ALL
DDLSUBST ‘PRODUSA_IDX’ WITH ‘USPRD_IDX’ INCLUDE ALL
DDLSUBST ‘PRODUSA_LOB’ WITH ‘USPRD_DATA’ INCLUDE ALL

Data Guard Broker 19c SHOW CONFIGURATION LAG

Easily view lag information for all members.

DGMGRL> show configuration lag

Configuration – dgdcdb_devl

Protection Mode: MaxPerformance
Members:
dgdcdb   – Primary database
dgdcdb_s – Physical standby database
Transport Lag:      0 seconds (computed 0 seconds ago)
Apply Lag:          0 seconds (computed 0 seconds ago)

Fast-Start Failover:  Disabled

Configuration Status:
SUCCESS   (status updated 19 seconds ago)

Cloud Control 13.4 Repository Database Parameters

alter system set “_optimizer_nlj_hj_adaptive_join”= FALSE scope=both sid=’*’;

alter system set “_optimizer_strans_adaptive_pruning” = FALSE scope=both sid=’*’;

alter system set “_px_adaptive_dist_method” = OFF scope=both sid=’*’;

alter system set “_sql_plan_directive_mgmt_control” = 0 scope=both sid=’*’;

alter system set “_optimizer_dsdir_usage_control” = 0 scope=both sid=’*’;

alter system set “_optimizer_use_feedback” = FALSE scope=both sid=’*’;

alter system set “_optimizer_gather_feedback” = FALSE scope=both sid=’*’;

alter system set “_optimizer_performance_feedback” = OFF scope=both sid=’*’;

alter system set optimizer_adaptive_plans=FALSE scope=both;

alter system set “_allow_insert_with_update_check”=TRUE;

Oracle 19c Silent Install

./runInstaller  -waitforcompletion -silent                        \
-responseFile ${ORACLE_HOME}/install/response/db_install.rsp               \
oracle.install.option=INSTALL_DB_SWONLY                                    \
ORACLE_HOSTNAME=${ORACLE_HOSTNAME}                                         \
UNIX_GROUP_NAME=dba                                                   \
INVENTORY_LOCATION=${ORA_INVENTORY}                                        \
SELECTED_LANGUAGES=en,en_GB                                                \
ORACLE_HOME=${ORACLE_HOME}                                                 \
ORACLE_BASE=${ORACLE_BASE}                                                 \
oracle.install.db.InstallEdition=EE                                        \
oracle.install.db.OSDBA_GROUP=dba                                          \
oracle.install.db.OSBACKUPDBA_GROUP=dba                                    \
oracle.install.db.OSDGDBA_GROUP=dba                                        \
oracle.install.db.OSKMDBA_GROUP=dba                                        \
oracle.install.db.OSRACDBA_GROUP=dba                                       \
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false                                 \
DECLINE_SECURITY_UPDATES=true

Start Observer in background

DGMGRL> start observer in background file is /home/oracle/backup_observer_1.dat logfile is /home/oracle/backup_observer_1.log connect identifier is oradb1;

Knowledge Base Top Categories

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?