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 - Install, Upgrade & Patching

Key Install, Upgrade & Patching Articles

Best Practice Documents

• Oracle 12cR1 Upgrade Companion [Document 1462240.1]
• Oracle 11gR2 Upgrade Companion [Document 785351.1]
• Upgrade Advisor: Database 11.2 to 12.1 [Document 1600704.1]
• Upgrade Advisor: Database from 10.2 to 11.2 [Document 251.1]
• Patching & Maintenance Advisor: Database (DB) Oracle Database 11.2.0.x [Document 331.1]
• Database 12c Post Patch SQL Automation [Document 1585822.1]
• Best Practices to Minimize Downtime During Upgrade [Document 455744.1]
• Oracle Database 12.1 Online Documentation - Installing and Upgrading Library
• Oracle Database 11.2 Online Documentation - Installing and Upgrading Library
• How to Verify the Integrity of a Patch/Software Download? [Document 549617.1]
• Setting up and Managing the Oracle Database with Enterprise Manager 12c - Video Demonstrations [Document 1672202.1]

Best Practice Webcasts

The following Best Practice / New Feature Webcasts are available:

Oracle Database New Features 12c	Recording	.pdf
Oracle Database 12.1 Install Features / Changes	Recording	.pdf
Oracle 12c: New Database Initialization Parameters	Recording	.pdf
12c Upgrade and New Features	Recording	.pdf
Oracle Database 12c Patching New Features	Recording	.pdf
Database Inventory: Concepts and troubleshooting	Recording	.pdf
Basic Administration of Multitenant Database	Recording	.pdf
Oracle Multitenant: Configuration and Customization Fundamentals	Recording	.pdf

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

Health Checks

• Script to Collect DB Upgrade/Migrate Diagnostic Information [Document 556610.1]
• How to Download and Run Oracle's Database Pre-Upgrade Utility [Document 884522.1]
• RDA 4 - Health Check / Validation Engine Guide [Document 250262.1]
• Health Check Alert: Oracle Database support status notification [Document 1095609.1]

Tools

Troubleshooting Assistants

• Oracle Database - Client / Install / Deinstall / Cloning [Document 1555012.2]
• Oracle Database/Client Upgrade - Downgrade [Document 1561791.2]
• Patching Oracle Database/Client [Document 1561792.2]

Premium Knowledge Content Notes

• Information Center: Upgrading and Migration Oracle Database [Document 1351112.2]
• Oracle Database 12c Release 1 Information Center [Document 1595421.2]
• Oracle Database Upgrade Path Reference List [Document 730365.1]
• Master Note For Oracle Database 12c Release 1 (12.1) Database/Client Installation/Upgrade/Migration Standalone Environment (Non-RAC) [Document 1520299.1]
• Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) [Document 169706.1]
• Master Note of Linux OS Requirements for Database Server [Document 851598.1]
• Minimum Software Versions and Patches Required to Support Oracle Products on IBM Power Systems [Document 282036.1]
• Master Note for Real Application Testing Option [Document 1464274.1]
• How To Clone An Existing RDBMS Installation Using OUI [Document 300062.1]
• Migration Of An Oracle Database Across OS Platforms (Generic Platform) [Document 733205.1]
• Oracle Database 12.1 : FAQ on Queryable Patch Inventory [Document 1530108.1]
• Patch Set Updates for Oracle Products [Document 854428.1]
• Lifetime Support and Support Policies - Oracle Database Overview [Document 1351163.1]

MOS Communities

• Oracle Database Install/Upgrade/Opatch Community
• Patch Reviews - DB Community

How-To / FAQ

• How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Document 1091294.1]
• Relinking Oracle Home FAQ ( Frequently Asked Questions) [Document 1467060.1]
• Oracle Universal Installer (OUI) FAQ [Document 458893.1]
• OPATCH FAQ [Document 242993.1]
• Frequently Asked Questions (FAQ): Patching Oracle Database Server [Document 1446582.1]
• Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes [Document 556834.1]

How-to / Troubleshooting Webcasts

The following Install ,Upgrade ,Patching How-to / Troubleshooting Webcasts are available:

How to resolve patch conflicts with MOS Conflict Checker?	Recording	.pdf
Automation of patch conflict resolution and deployment through EM 12c	Recording	.pdf
Oracle DB: How to resolve conflicts and discover available patches	Recording	.pdf
Composite Patching	Recording	.pdf

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