Knowledge Base New
- Oracle 21c New Feature – MAX_IDLE_BLOCKER_TIME parameter
- 21c New Feature – Expression based parameter values
- 21c New Feature – Attention Log
- 21c New Feature – Result Cache for Standby Database
- 21c New Feature – Data Guard Broker Create Far Sync Instance
- Oracle 21c New Feature – Prepare Database for Data Guard
- Upgrading from 12c Release 2 to 19c using latest AutoUpgrade utility
- Oracle 21c AutoUpgrade (Part 2)
- Oracle 21c AutoUpgrade (Part 1)
- Exadata and the Oracle Cloud ATP Database
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
GoldenGate 90
Oracle Cloud 6
- Exadata and the Oracle Cloud ATP Database
- Oracle GoldenGate on Oracle Cloud Marketplace (Part 2)
- Data migration to Autonomous Database using MV2ADB
- Migrate data in real-time from OCI Classic to OCI using MV2ADB and Oracle Cloud Marketplace GoldenGate
- Oracle GoldenGate on Oracle Cloud Marketplace (Part 1)
Multitenancy 21
- 19c Container Database Data Guard Configuration
- Oracle 12c to 19c Data Guard Upgrade with 19c Container Database
- Upgrade Oracle 12c non-CDB to Oracle 19c and plugin to CDB
- Pluggable Database Cloning using Snapshot Copy
- Oracle 18c Multitenancy New Features – Snapshot Carousel, CDB Fleet and Container Maps
Real Application Clusters 40
- Installation and Configuration of GoldenGate 19c Microservices on RAC
- How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 3
- How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 2
- How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 1
- Oracle 19c Grid Infrastructure Upgrade
Oracle Enterprise Manager 39
- Oracle Enterprise Manager Cloud Control 13.4 Patching
- Installing and configuring the Exadata Database Machine plug-in for EM Cloud Control
- Installing the Oracle GoldenGate monitoring plug-in (13.2.1.0.0) for Cloud Control 13c Release 2
- PSU Patch Deployment using EM12c
- Database Cloning and Provisioning using EM12c DBaaS