Have a question? Ask or enter a search term.

BACKUP & RECOVERY(10)

• RECOVER MANAGED STANDBY DATABASE INSTANCES ALL is not working on 19.5
• Ready RMAN Backup Script To Schedule from Crontab
• Re-execution of Duplicate command on 19c DB fails with RMAN-06054: media recovery requesting unknown archived log
• Datafile Rename with minimal Downtime using RMAN
• RMAN-05502: the target database must be mounted when issuing a DUPLICATE command

DATAGUARD(10)

• Standby RAC Database Creation Steps 19c
• Duplicate of a standby DB fails with ORA-39511: Start of CRS resource for instance ‘223’ failed with error
• Setup AWR on Standby DB
• Duplicate of a Standby DB fails with ORA-19845
• Script to delete applied archivelogs on a STANDBY database

PERFORMANCE TUNING(15)

• Which is better for gathering statistics? DBMS_STATS or ANALYZE command
• The Pursuit of Ultimate Performance On Non Production Oracle Databases
• SQL Tuning Script
• New Sections in 19c AWR In Comparison With 11g’s AWR
• Speed Up The Data Pump Import In Oracle 19c

ORACLE RAC(16)

• Introduction To a Great Tool: RAC Configuration Audit Tool (RAC & DB Health Check & MAA Check)
• RAC MOST USED COMMANDS
• DBA Diary
• Cleanup Logs on Oracle RAC 12c+
• 18c Remarkable New Features

DATABASE SECURITY(6)

• Unable to obtain current patch information due to error: 16000
• Unable to obtain current patch information due to error: 20013 When Starting up a DB Instance
• Auditing Using LogMiner
• The difference between granting direct privileges to a user and granting same privileges within a role
• Hiding table Data from unauthorized Users

SHELL SCRIPT(27)

• Shell Script To Monitor/Check The Lag/Sync Status Between Primary And Standby Oracle Database
• RMAN Backup Shell Script for Oracle
• Import Shell Script For Importing Data On Oracle
• Script to delete applied archivelogs on a STANDBY database
• Script to Monitor and Report Audit Trail Records in sys.aud$

DBA BUNDLE(19)

• DBA Bundle 4.4
• DBA Bundle v4.3
• DBA Bundle V6.0
• DBA Bundle V4.2
• DBA BUNDLE 5.8

TROUBLESHOOTING(17)

• ORA-04088: error during execution of trigger ‘SYS.XDB_PI_TRIG’ PLS-00302: component ‘IS_VPD_ENABLED’ must be declared
• ORADEBUG How To
• Upgrade TIMEZONE Version On Oracle 19.5 from 32 to 33 to Fix ORA-39405 During Import
• Sharing the Same Read Only Tablespace between Multiple Databases
• Duplicate of a Database Fails With Error: ORA-17502: ksfdcre:4 Failed to create file

DATABASE UPGRADE(11)

• 19c Remarkable New Features
• ORA-28040: No matching authentication protocol
• Upgrade from 11.2.0.3 to 19c Using GoldenGate [Cookbook]
• Drop Oracle Database
• Upgrade RAC 11.2.0.1 to 11.2.0.3 (Part IV RAC Database Upgrade from 11.2.0.1 to 11.2.03)

LINUX(5)

• Linux Security Hardening Checklist
• systemd: Unit awscsrdb.mount is bound to inactive unit dev-nvme8n1.device. Stopping, too
• Gather Statistics Shell Script Can Now Run In nohup Mode | Oracle On Linux
• Easy Way to Configure VNC Server On Linux
• How To Calculate Your Network Bandwidth Speed

POSTGRES(3)

• Install PostgreSQL 12 on CentOS 7
• Create A Database In Postgres
• Enable And Disable Archive Mode In Postgres

OEM 13C(2)

• Create a Read Only EM Account on OEM13c Can Create AWR Report And View Performance Pages
• OEM 13c Agent installation failed with: plugins.txt not found. The Management Agent installation failed. The plug-in oracle.sysman.oh may not be present in the Management Agent software

GOLDENGATE(3)

• Upgrade from 11.2.0.3 to 19c Using GoldenGate [Cookbook]
• 360 Degree Database Server Monitoring Script For Oracle
• Linux Shell Script To Monitor and Report GoldenGate Lag

CLOUD(3)

• ORA-06553: PLS-306: wrong number or types of arguments in call to ‘UPLOAD_TO_S3’
• The DBA Guide For Managing Oracle Database on Amazon RDS | In One Page!
• How To Import A Schema on Amazon RDS

EXADATA(1)

• All About ASM