Oracle Database Resource Portfolio - Security

Oracle Database Resource Portfolio - Security

Key Security Articles

Best Practice Documents

The following Best Practice Documents are available:

• All About Security: User, Privilege, Role, SYSDBA, O/S Authentication, Audit, Encryption, OLS, Database Vault, Audit Vault [Document 207959.1]
• Oracle Database 12c Security New Features (Security section in New Feature Guide)
• Critical Patch Updates, Security Alerts and Third Party Bulletin

Best Practice Webcasts

The following Best Practice Webcasts are available:

11gR2 Transparent Data Encryption: What You Need to Know

N/A

.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• Security Checklist: 10 Basic Steps to Make Your Database Secure from Attacks [Document 1545816.1]
• Audit Vault Server Configuration Report and Health Check Script [Document 1360138.1]
• Analyzing Issues with Oracle Audit Vault and Database Firewall, providing relevant information to support [Document 1949101.1]

Tools

• SCRIPT: Basic example to manage AUD$ table in 11.2 with dbms_audit_mgmt [Document 1362997.1]
• Oracle Database Security Assessment Tool (DBSAT) [Document 2138254.1]

Premium Knowledge Content Notes

• Information Center: An Overview Of Database Security Products [Document 1548952.2]
• Master Note For Oracle Database Authentication [Document 1349896.1]
• Master Note For Database Privileges And Roles [Document 1347470.1]
• Master Note For Oracle Database Auditing [Document 1299033.1]
• Master Note For Oracle Database Vault [Document 1195205.1]
• Master Note For Oracle Audit Vault [Document 1199033.1]
• Patching and Maintaining Database Security Products [Document 1548957.2]
• Oracle Documentation - 12c New Features for Security
• Oracle Audit Vault and Database Firewall (AVDF)
• Cost Effective Security and Compliance
• Master Note For Transparent Data Encryption ( TDE ) [Document 1228046.1]
• Master Note For Kerberos Authenticatio [Document 1375853.1]

MOS Communities

• Database Security Products Community

Troubleshooting Documents

The following Troubleshooting Documents are available:

• Troubleshooting Database Security Products [Document 1548640.2]
• Checklist for Resolving CONNECT AS SYSDBA (INTERNAL) Issues [Document 233223.1]
• Troubleshooting ORA-1031: Insufficient Privileges While Connecting As SYSDBA [Document 730067.1]
• Be Cautious When Revoking Privileges Granted to PUBLIC [Document 247093.1]

Oracle Database Resource Portfolio - RAC/Scalability

Key RAC/ScalabilityArticles

Best Practice Documents

The following Best Practice Documents are available:

• RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) [Document 810394.1]
• RAC: Frequently Asked Questions [Document 220970.1]
• Top 11 Things to do NOW to Stabilize your RAC Cluster Environment [Document 1344678.1]
• Top 11gR2 RAC Installation Issues [Document 1372375.1]
• Top 11gR2 Grid Infrastructure Upgrade Issues [Document 1366558.1]
• How to Modify Private Network Information in Oracle Clusterware [Document 283684.1]
• How to Modify Public Network Information including VIP in Oracle Clusterware [Document 276434.1]
• How to update the IP address of the SCAN VIP resources [Document 952903.1]
• Using Oracle Clusterware with Vendor Clusterware FAQ [Document 332257.1]

Best Practice Webcasts

The following Best Practice Webcasts are available:

How To Setup 12c ACFS RAC Filesystem Through EM Cloud Control 12c

Recording

.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]

Tools

• Cluster Health Monitor (CHM) FAQ [Document 1328466.1]
• TFA Collector- The Preferred Tool for Automatic or ADHOC Diagnostic Gathering Across All Cluster Nodes [Document 1513912.1]
• CRS 10gR2/ 11gR1/ 11gR2 Diagnostic Collection Guide [Document 330358.1]
• ORAchk - Oracle Configuration Audit Tool [Document 1268927.1]

Troubleshooting Assistants

• Oracle Grid Infrastructure Install [Document 1551639.2]
• Oracle Grid Infrastructure Upgrade [Document 1553630.2]
• Oracle Grid Infrastructure Patching [Document 1553605.2]

Premium Knowledge Content Notes

• Information Center: Oracle Scalability Grid Infrastructure / Clusterware and Real Application Clusters (RAC) [Document 1452965.2]
• Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure [Document 1096952.1]

MOS Communities

• RAC/Scalability MOS Community

Troubleshooting Documents

The following Troubleshooting Documents are available:

• Troubleshooting Clusterware Node Evictions (Reboots) [Document 1050693.1]
• Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evictions [Document 559365.1]
• Top 5 RAC Instance Crash Issues [Document 1375405.1]
• Top 5 Issues That Cause Troubles with Scan VIP and Listeners [Document 1373350.1]
• Top 5 Database and/or Instance Performance Issues in RAC Environment [Document 1373500.1]
• Top 5 (RAC Specific) Database Management Issues With DBCA, NETCA, DBUA and Other Tools [Document 1371066.1]
• Top 5 CRS Cluster Patching Issues [Document 1372859.1]
• Top 5 issues for Instance Eviction [Document 1374110.1]
• Troubleshooting "Global Enqueue Services Deadlock detected" [Document 1443482.1]
• Troubleshooting: "log file sync" Waits [Document 1376916.1]

Oracle Database Resource Portfolio - High Availability

Key Backup/Recovery, Corruption, and Data Guard Articles

Best Practice Documents

The following Best Practice Documents are available:

• Oracle Data Guard 11g High Availability Best Practices
• Active Data Guard 11g Best Practices (includes best practices for Redo Apply)
• Getting Started with Recovery Manager (RMAN) [Document 360416.1]
• The Gains and Pains of Nologging Operations [Document 290161.1]
• Best Practices for Avoiding and Detecting Corruption [Document 428570.1]
• Top 10 Backup and Recovery best practices. [Document 388422.1]
• Creating a Physical Standby Database [Document 1475344.1]

Best Practice / New Features Webcasts

The following Best Practice / New Features Webcasts are available:

New Feature 12c for DataGuard	Recording	.pdf
Using RMAN in a Data Guard Environment	Recording	.pdf
Database Rolling Upgrades using Transient Logical Standby Database	Recording	.pdf
Data Guard: Database Duplication for Physical Standby implementation	Recording	.pdf
Active Data Guard and Real Time Query	Recording	.pdf
Snapshot Standby Database and Real Applications Testing	Recording	.pdf
Data Guard: Fast-Start Failover	Recording	.pdf
Data Guard: Overview and Usage of the Data Guard Broker	Recording	.pdf
Recovery Manager - Duplicate Command	Recording	.pdf
Data Recovery Advisor: A Walk Through	Recording	.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• High Availability Check (HA_Check) included in RACCHECK [Document 1505808.1]
• Identify the corruption extension using RMAN/DBV/ANALYZE [Document 836658.1]

Tools

• Oracle11g Data Guard: Database Rolling Upgrade Shell Script [Document 949322.1]
• Script to Collect Data Guard Primary Site Diagnostic Information for Version 10g and above (Including RAC) [Document 1577401.1]
• Script to Collect Data Guard Physical and Active Standby Diagnostic Information for Version 10g and above (Including RAC) [Document 1577406.1]
• Script to Collect Data Guard Logical Standby Diagnostic Information for Version 10g and above (Including RAC) [Document 1577407.1]
• RMAN Backup Shell Script Example [Document 137181.1]

Troubleshooting Assistants

• Get Assistance to understand and solve Oracle Database Server Corruptions [Document 1543698.2]
• Handling Block Corruptions in oracle7 / 8 / 8i / 9i / 10g / 11g [Document 1598103.2]

Premium Knowledge Content Notes

• Information Center: Oracle Data Guard Physical Standby Database [Document 1395508.2]
• Master Note For Oracle Recovery Manager (RMAN) [Document 1116484.1]
• Master Note For Oracle Backup And Recovery [Document 1199803.1]
• Master Note for Handling Oracle Database Corruption Issues [Document 1088018.1]
• Master Note For Oracle Flashback Technologies [Document 1138253.1]
• Introduction to Oracle Fail Safe
• Maximize Availability with Oracle Database 12c - Whitepaper
• Usage, Benefits and Limitations of Standby Redo Logs (SRL) [Document 219344.1]

MOS Communities

• Database Backup & Recovery Community
• High Availability Data Guard Community

How-To / FAQ / Troubleshooting

• Resolving ORA-752 or ORA-600 [3020] During Standby Recovery [Document 1265884.1]
• Diagnosing Connection Problems with an active Data Guard Broker Configuration [Document 745201.1]
• Logs are not shipped to the physical standby database [Document 1130523.1]
• Troubleshooting ORA-16191 and ORA-1017 in Data Guard Log Transport Services [Document 1368170.1]
• Top RMAN 11.2 issues [Document Top RMAN 11.2 issues [Document 1473914.1]
• RMAN Tips, Tricks and Pitfalls [Document 1462118.1]
• Common Causes and Solutions on ORA-1113 Error Found in Backup & Recovery [Document 183367.1]
• RMAN Backup Performance [Document 360443.1]
• RMAN Restore Performance [Document 740911.1]
• How to Recover from a Lost Datafile with Different Scenarios [Document 198640.1]
• How to Recover From a DROP / TRUNCATE / DELETE TABLE with RMAN [Document 223543.1]
• FAQ - Flash Recovery Area feature [Document 305817.1]

Troubleshooting Webcasts

The following Troubleshooting Webcasts are available:

Recovery Manager - Performance Troubleshooting

Recording

.pdf/scripts

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Oracle Database Resource Portfolio - Performance

Key Performance Articles 

Best Practice Documents

 

Best Practice Webcasts

The following Best Practice Webcasts are available:

Oracle Database Resource Manager	Recording	.pdf
How to achieve Plan Stability on 11g with SQL Plan Management (SPM)	Recording	.pdf
Best Practices: Proactive Data Collection to Troubleshoot DB Performance Issues	Recording	.pdf

For other webcasts, refer to Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings

Health Checks

• SQL Tuning Health Check Script (SQLHC) [Document 1366133.1]
• SQL Tuning Health-Check Script (SQLHC) Video [Document 1455583.1]

Tools

Oracle Service Request Data Collection

• Performance Related Oracle Service Request Data Collection (SRDC) Articles [Document 1938786.1]

Tools

• Oracle Performance Diagnostic Guide (OPDG) [Document 390374.1]
• All About the SQLT Diagnostic Tool [Document 215187.1]
• Analysis of Active Session History (Ash) Online and Offline [Document 243132.1]
• OSWatcher Black Box User Guide (Includes: [Video]) [Document 301137.1]
• Performance Tuning Using Advisors and Manageability Features: AWR, ASH, ADDM and Sql Tuning Advisor [Document 276103.1]
• Automatic Workload Repository (AWR) Reports - Start Point [Document 1363422.1]
• FAQ- Statspack Complete Reference [Document 94224.1]
• Comprehensive Database Real Application Testing Diagnostic Information [Document 1287620.1]
• How To Collect 10046 Trace (SQL_TRACE) Diagnostics for Performance Issues [Document 376442.1]
• SQL_TRACE (10046), TKProf and Explain Plan - Overview Reference [Document 199081.1]

Troubleshooting Assistants

• Troubleshooting Performance Issues [Document 1543445.2]
• Diagnosing the Cause of a Slow Query [Document 1542608.2]
• SQL Performance Issues [Document 1542678.2]
• Get Assistance to understand and solve Oracle SQL issues [Document 1564632.2]
• Oracle Database ORA-00060 Errors on Single Instance (Non-RAC) Diagnosing Using Deadlock Graphs in ORA-00060 Trace Files [Document 1550091.2]
• Get Assistance to Understand and Solve Oracle Resource Manager [Document 1606825.2]

Premium Knowledge Content Notes

• Information Center: Database Performance Overview [Document 1512292.2]
• Information Center: SQL Query Performance Overview [Document 1516494.2]
• Information Center: Real Application Testing [Document 1545782.2]

MOS Communities

• Database Tuning Community
• SQL Performance Community

How-To / FAQ / Troubleshooting

• Troubleshooting Performance Issues [Document 1377446.1]
• How To Investigate Slow or Hanging Database Performance Issues [Document 1362329.1]
• Troubleshooting Query Performance Degradation - Recommended Actions [Document 742112.1]
• Troubleshooting Upgrade Related Query Performance Degradation - Recommended Actions [Document 745216.1]
• Troubleshooting a Server Upgrade Resulting in Slow Query Performance [Document 160089.1]

Troubleshooting Webcasts

The following Performance Troubleshooting Webcasts are available:

Troubleshooting DB Performance Issues with AWR	Recording	.pdf
Recovery Manager - Performance Troubleshooting	Recording	.pdf / scripts

For other webcasts, refer to  Document:1456176.1 Database Advisor Webcasts: Current Schedule and Archived recordings