Some Important MOS DOC ID for Oracle Real Application Testing (RAT)

 Real Application Testing: Database Capture FAQ (Doc ID 1920275.1)

FAQ: Database Upgrade Using Real Application Testing (Doc ID 1600574.1)

Real Application Testing: Database Replay FAQ (Doc ID 2204090.1)

Database Testing: Best Practices (Doc ID 1535885.1)

Primary Note for Real Application Testing Option (Doc ID 1464274.1)

Database Testing: Best Practices (Doc ID 1535885.1)

Real Application Testing: Database Replay FAQ (Doc ID 2204090.1)

Mandatory Patches for Database Testing Functionality for Current and Earlier Releases (Doc ID 560977.1)

How To Find Database Replay Divergence Details (RAT) (Doc ID 1388309.1)

Scripts to Debug Slow Replay (Doc ID 760402.1)

Comprehensive Database Real Application Testing Diagnostic Information (Doc ID 1287620.1)

Database Capture and Replay: Common Errors and Reasons (Doc ID 463263.1)

Slow Database Replay with Waits on “WCR: replay clock” (Doc ID 1538269.1)

Real Application Testing: How to Run Workload Analyzer (Doc ID 1268920.1)

Dbms_Stats.Gather_Fixed_Object_Stats Is Hanging While Reading X$DBKFDG (Doc ID 2417784.1)

WGET Command to download any patchs or binary from Oracle Support site in Linux.

Hello Friends, 

First you need to search patch or binary from oracle support or MOS. Once you get it, click on download, right click on the patch and copy URL and update the same URL in highlighted yellow portions.

Also you need update your oracle support login ID and password in highlighted sky blue portion. 

Once Command is ready put the same in Linux prompt where you have internet access it will start to download the file. 

wget --http-user=<userid>@oracle.com --http-password=<SomePassword> --no-check-certificate --output-document=p35042068_190000_Linux-x86-64.zip "https://updates.oracle.com/Orion/Services/download/p35042068_190000_Linux-x86-64.zip?aru=12345678&patch_file=p35042068_190000_Linux-x86-64.zip"

Silent Mode - Oracle Database Installation and DB creation.

Steps to install oracle 11g and Database silent mode  .

============================================

--- Silent DB Binary Installation  on File System.

============================================

cat /tmp/db_install.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

oracle.install.option=INSTALL_DB_SWONLY

ORACLE_HOSTNAME=instance-20230630-1255

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/ora11g/oracle/oraInventory

SELECTED_LANGUAGES=en

ORACLE_HOME=/ora11g/oracle/product/11g/dbhome_1

ORACLE_BASE=/ora11g/oracle

oracle.install.db.InstallEdition=EE

oracle.install.db.DBA_GROUP=dba

oracle.install.db.BACKUPDBA_GROUP=dba

oracle.install.db.DGDBA_GROUP=dba

oracle.install.db.KMDBA_GROUP=dba

oracle.install.db.OSRACDBA_GROUP=dba

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

DECLINE_SECURITY_UPDATES=true

oracle.installer.autoupdates.option=SKIP_UPDATES

./runInstaller -silent -responseFile /tmp/db_install.rsp

============================================

--- Silent DB creation on File System.

============================================

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11g/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export PATH=/usr/sbin:/usr/local/bin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export ORACLE_SID=ORCL11G

export DATA_DIR=/u01/app/oracle/oradata/ORCL11G

dbca -silent -createDatabase                                                   \

     -templateName $ORACLE_BASE/product/11g/dbhome_1/assistants/dbca/templates/General_Purpose.dbc                                        \

     -gdbname ${ORACLE_SID} -sid  ${ORACLE_SID} -responseFile NO_VALUE         \

     -characterSet AL32UTF8                                                    \

     -sysPassword SysPassword                                                 \

     -systemPassword SysPassword                                              \

     -databaseType MULTIPURPOSE                                                \

     -totalMemory 4096 -automaticMemoryManagement true \

     -storageType FS                                                           \

     -datafileDestination "${DATA_DIR}"                                        \

     -redoLogFileSize 50                                                       \

     -emConfiguration NONE                                                     

============================================

--- Silent DB creation on File System with 11g EM.

============================================

dbca -silent -createDatabase -templateName /ora11g/oracle/product/11g/dbhome_3/assistants/dbca/templates/General_Purpose.dbc -gdbname oratdb -sid oratdb -responseFile NO_VALUE -characterSet AL32UTF8 -totalMemory 4096 -automaticMemoryManagement true  -emConfiguration LOCAL -datafiledestination /u01/app/oracle/oradata/ora11g -sysPassword Oracle123 -systemPassword Oracle123 -dbsnmpPassword Oracle123 -sysmanPassword Oracle123