Search this site
Embedded Files
Skip to main content
Skip to navigation
Yet Another OCM
Home
10G OCM
10G Data Guard
10G Data Guard (01)
10G Data Guard (02)
10G Data Guard (03)
10G Data Guard (04)
10G Data Guard (05)
10G Data Guard (06)
10G Data Guard (07)
10G Data Guard (08)
10G Data Guard (09)
10G Data Guard (10)
10G Data Guard (11)
10G Data Guard (12)
10G OCM Planning
10G Services
Grid Control
Grid Control (01)
Grid Control (02)
Grid Control (03)
Grid Control (04)
Grid Control (05)
Grid Control (06)
Grid Control (07)
Grid Control (08)
Grid Control (09)
Grid Control (10)
Grid Control (11)
Grid Control (12)
Grid Control (13)
Grid Control (14)
Grid Control (15)
Grid Control (16)
NTP
NTP (01)
NTP (02)
NTP (03)
NTP (04)
NTP (05)
NTP (06)
10G System Builds
Botany
Botany (01)
Botany (02)
Botany (03)
Botany (04)
Botany (05)
Botany (06)
Botany (07)
Botany (08)
Botany (09)
Botany (10)
Miscellaneous
10.2.0.2 Upgrade
CLUVFY CRSINST
First VM Created
Going in Circles
Linux CDs Downloaded
Newer Network Design
SPFILE on raw
VIP Problem on Richmond1
VIP Problem on Richmond1 (01)
VIP Problem on Richmond1 (02)
VIP Problem on Richmond1 (03)
VIP Problem on Richmond1 (04)
VMWare Clustering Problem
VMWare Problems
Padstow
Padstow (01)
Padstow (02)
Padstow (03)
Padstow (04)
Padstow (05)
Padstow (06)
Padstow (07)
Padstow (08)
Padstow (09)
Padstow (10)
Padstow (11)
Richmond Cluster
Richmond Cluster (01)
Richmond Cluster (02)
Richmond Cluster (03)
Richmond Cluster (04)
Richmond Cluster (05)
Richmond Cluster (06)
Richmond Cluster (07)
Richmond Cluster (08)
Richmond Cluster (09)
Richmond Cluster (10)
Richmond Cluster (11)
Richmond Cluster (12)
Richmond Cluster (13)
Richmond Cluster (14)
Richmond Cluster (15)
Richmond Cluster (16)
Richmond Cluster (17)
Richmond Cluster (18)
Richmond Cluster (19)
Richmond Cluster (20)
Richmond Cluster (21)
Richmond Cluster (22)
Richmond Cluster (23)
Richmond Database
Richmond Database (01)
Richmond Database (02)
Richmond Database (03)
Richmond Database (04)
Richmond Database (05)
Richmond Database (06)
Richmond Database (07)
RMANCAT
RMANCAT (01)
RMANCAT (02)
RMANCAT (03)
RMANCAT (04)
RMANCAT (05)
11G OCE RAC
Section 1 - Grid Infrastructure: Clusterware and ASM
Administering Oracle Clusterware
Demonstrate OCR backup and recovery techniques
Display Clusterware management proficiency
Managing Network Settings
Grid Infrastructure Installation
Install Grid Infrastructure
Perform pre-install tasks for Grid Infrastructure
Verify the installation
Making Applications Highly Available With Oracle Clusterware
Contrast Policy-Managed and Administration Managed databases
Describe the functionality of server pools
Describe the High Availability components of Oracle Clusterware
Managing Clusterware
Perform prerequisite steps for extending a cluster
Use Oracle Universal Installer (OUI) to add a node to an Oracle Clusterware home
Use OUI to remove a node from an Oracle Clusterware home
Oracle Grid Infrastructure
Describe Cluster hardware best practices
Describe how Grid Plug and Play affects Clusterware
Explain the principles and purposes of clusters
Understand Oracle Clusterware Architecture
Troubleshooting Oracle Clusterware
Enable component-level debugging
Enable resource debugging
Enable tracing for Java-based tools
Gather all log files using diagcollection.pl
Locate Oracle Clusterware log files
Troubleshoot the Oracle Cluster Registry (OCR) file
Section 2 - Real Application Clusters
System Builds
Panania1
00 Create VMWare Image
VICTORIA
01 Install VM Server
02 Problem Installing VM Manager
03 Patch GRIDCTRL
04 Finish OEM Virtualisation Intallation
05 Diagnose VM Agent Problem
06 Build VM Server Manually
07 Response From Oracle Support
08 Upgrade to OEM 12C
11G OCM
11G OCM Data and Data Warehouse Management
11G OCM Add a tablespace by using Transportable Tablespace Feature of Data Pump Import
11G OCM Configure a schema to support a star transformation query
11G OCM Configure and use parallel execution for queries
11G OCM Configure Flashback Data Archive
11G OCM Create partitioned tables
11G OCM Troubleshoot fast materialized views to fast refresh and query rewrite
11G OCM Use and access SecureFile LOBS
11G OCM Use Oracle Streams to capture and propagate changes in a table
11G OCM Data Guard
11G OCM Configure archivelog deletion policy for the dataguard configuration
11G OCM Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
11G OCM Convert the standby to a snapshot standby
11G OCM Database, RMAN, EM and Network Configuration
11G OCM Create an Archival Backup
11G OCM Create and Manage a tablespace that uses NFS mounted file system file
11G OCM Create and Manage encrypted tablespaces
11G OCM Create Base Recovery Catalog
11G OCM Install and configure EM Agent
11G OCM Performance Management
11G OCM Configure baseline templates
11G OCM Gather statistics on a specific table without invalidating cursors
11G OCM Replay a captured workload
11G OCM Set up and configure Resource Manager
11G OCM Use multi column statistics
11G OCM Use partitioned indexes
11G OCM Use Result Cache
11G OCM Use SQL Access Advisor
11G OCM Use SQL Plan Management feature
11G OCM Use SQL Tuning Advisor
11G OCM System Builds
BANKSTOWN
01 Creation with ASM Storage
02 Deploy EM Agent on BANKSTOWN
03 Upgrade to EM Agent 10.2.0.5.0
04 Startup Problems for Bankstown
05 Some Start Up Problems Fixed
06 EM Agent Does Not Start After Server is on New Subnet
07 Adjusted MEMORY_TARGET for OCM11G Database
Data Guard
01 Copy Wallet to PADSTOW
02 Set Up FLASHBACK on BANKSTOWN
03 Create Physical Standby on PADSTOW
Design Overview
00 Original Design
01 Cut Down Design
02 Newer Design
FREENAS
01 Create VM Image
02 Create OS Image
03 Create NFS Volumes
GRIDCTRL
DNS
OEM Online Patching Set Up
OMS Does Not Start After Server is on New Subnet
Reset Agent TimeZone
Set Up Agent Deploy Application
PADSTOW
01 Create PADSTOW System
PENRITH1
01 Build PENRITH1 VM Image
02 Install PENRITH1 OS Image
03 Install Oracle Validated RPM
04 Oracle Clusterware Preinstallation Tasks
05 Set Up Shared Disk Storage
06 Installing Oracle Clusterware
07 Oracle Clusterware Postinstallation Procedures
08 Install ASM Software
09 Install Oracle Database Software
10 Configure ASM Storage
11 Create Database Failed
12 Remove DirectNFS in ASM
13 Create Database Successful
14 Set Up DirectNFS for Example Database
15 Deploy EM Agent on PENRITH Cluster
16 Set Up RMAN on EXAMPLE
17 Voting Disk Problems on PENRITH1
PENRITH2
01 Problem with PENRITH2
REDFERN
01 Create Oracle Client
12C OCM
12C OCM System Builds
BOTANY
2018-05-10 Initial Build
PADSTOW
2018-05-09 Initial Build
Data and Performance Management
Administer materialized views
Configure the database to retrieve all previous versions of the table rows
Configure the Oracle Database Resource Manager
Create a plugged-in tablespace by using the transportable tablespace feature
Create partitioned tables
Create SQL Plan baselines
Perform real application testing
Tune SQL statements
Data Guard
Administer a Data Guard environment
Configure a standby database for testing
Use DGMGRL to convert to Snapshot Standby
Use OEM to convert to Snapshot Standby
Use SQL*Plus to Convert to Snapshot Standby
Configure a standby database to apply redo
Configure a standby database to use for reporting
Configure fast start failover
Create a physical standby database
Restore the standby database to its normal function
Use OEM to Convert to Physical Standby
Use SQL*Plus to Convert to Physical Stanby
Design Journal
General Database and Network Administration, and Backup Strategy
Configure the network environment to allow connections to multiple databases
Create and manage database configuration files
Create and manage pluggable databases
Clone PDB from Unplugged PDB
Create PDB using DBCA (Simple)
Create Snapshot Copy Clone
Create and manage users, roles, and privileges
Protect the database from data loss due to failures
Grid Infrastructure and RAC
Administer Oracle Clusterware
Configure Database Services
Create a Real Application Clusters (RAC) database
Create and manage ASM instances
Create ASM Cloud File System (ACFS)
Create ASM disk groups
Install Oracle Database 12c software
Install Oracle Grid Infrastructure
12C OCP Upgrade
Section 1: New Features of Oracle Database 12c
ADR and Network Enhancements
Explain ADR Enhancements
Network Enhancements
Auditing
Create and enable audit policies
Enable and configure Unified Audit Data Trail
Enable Unified Auditing
Backup, Recovery and Flashback for a CDB/PDB
Perform backup of CDB and PDB
Perform recovery of CDB and PDB
Basics of Multitenant Container Database (CDB)
Explain root and multitenant architecture
Identify the benefits of the multitenant container database
Configuring and Creating CDBs and PDBs
Create and configure a CDB
Create and configure a PDB
Migrate a non-CDB to a PDB database
Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics
Diagnose performance issues using ASH enhancements
Generate ADDM Compare Period
Perform emergency monitoring and real-time ADDM
Enterprise Manager and Other Tools
Use EM Express
Use OUI, DBCA for installation and configuration
In-Database Archiving and Valid-Time Temporal
Differentiate between ILM and Valid-Time Temporal
Set and use Valid Time Temporal
Use In-Database archiving
Index and Table Enhancements
Use Index enhancements
Use Online operation enhancements
Use Table enhancements
Information Lifecycle Management and Storage Enhancements
Move a data file online
Perform tracking and automated data placement
Use ILM features
Managing CDBs and PDBs
Change instance parameters for a CDB/PDB
Establish connection to a CDB/PDB
Start up and shut down a CDB/PDB
Managing Tablespaces, Common and Local Users, Privileges and Roles
Manage tablespaces in a CDB/PDB
Manage users and privileges for CDB/PDB
Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
Use Oracle Data Pump enhancements
Use SQL*Loader and External table enhancements
Oracle Data Redaction
Partitioning Enhancements
Explain Index enhancements for partitioned tables
Explain Partitioning enhancements
Privileges
Create, enable and use privilege analysis
Use administrative privileges
Real-Time Database Operation Monitoring
Resource Manager and Other Performance Enhancements
Explain Multi-process Multi-threaded Oracle architecture
Use Flash Cache
Use Resource Manager for a CDB and PDB
RMAN and Flashback Data Archive
Implement the new features in Flashback Data Archive
Use RMAN enhancements
SQL Enhancements
Configure extended datatypes
Use Oracle Database Migration Assistant for Unicode
Use Row limiting clause, and secure file LOBs enhancements
SQL Tuning
Use Adaptive Execution Plans
Use Adaptive SQL Plan Management
Use enhanced features of statistics gathering
Section 2: Key DBA Skills
Core Administration
Apply and review patches
Back up and recover the database
Configure server and client network for a database
Detect and repair data failures with Data Recovery Advisor
Explain the fundamentals of DB architecture
Implement Flashback Technology
Install and configure a database
Load and Unload Data
Monitor database alerts
Perform daily administration tasks
Troubleshoot network and database issues
Miscellaneous
Create a default permanent tablespace
Relocate SYSAUX occupants
Use Direct NFS
Use Secure File LOBs
Use the Redo Logfile Size Advisor
Performance Management
Analyze and identify performance issues
Design the database layout for optimal performance
Implement Application Tuning
Manage memory
Monitor performance
Perform real application testing
Use Resource Manager to manage resources
Security
Configure and manage auditing
Create the password file
Develop and implement a security policy
Implement column and tablespace encryption
Storage
Administer ASM
Implement Space Management
Manage ASM disks and diskgroups
Manage ASM instance
Manage database structures
Manage VLDB
Database Designs
Much Ado About Nothing
Logical Design
Issues
Cloud Control Issues
Cloud Control Not Starting Automatically in OVM_EM12R2
Installation of OMA Fails with Time Zone Issue
Unable to Connect to OMS on CRONULLA
Unable to Startup OMS on CRONULLA
Linux Issues
Root Password is Unknown
Unable to Unzip Files Bigger than 2GB
Unable to Use NFS Under VirtualBox
Oracle Patching Issues
OPatch Apply of GI PSU 12.1.0.2.161018 fails
Oracle Personal Edition Issues
Got ORA-01031 when logging on remotely using SYS AS SYSDBA
OERI kql_tab_diana While Running noncdb_to_pdb
Unable to Set up Unified Auditing under 12.1.0.1
OVM Issues
ETH0 has wrong MAC Address after Upgrade to OVMS 3.2.6
OVMM Fails to Enable TCPS Connections
sudo is Missing in OVM_EM12R2
Oracle Enterprise Edition Issues
Drop Administrative User
Knowledge
Demonstrations
Analysis of Effect of O_SYNC
Help Pages
runInstaller
Oracle Utilities
ADRCI SHOW ALERT Reference
Technical Notes
Procedures
Create Oracle Database
Create 12.1 Container Database No OMF
Create 12c Container Database Using OMF
Create 12C Non-CDB Database Using OMF
Create 12C Non-CDB Database Without OMF
Deinstall Oracle RDBMS
Deinstall Oracle RDBMS 11.2.0.1.0
Deinstall Oracle RDBMS 12.1.0.2
Deinstall RDBMS 11.2.0.3 (Non Grid)
Install Grid Infrastructure
Install 12.1.0.2 GI Standalone
Install Grid Infrastructure 11.2.0.3.3 on GRIDCTRL
Install Linux
Install Oracle Enterprise Linux 7.2
Install Oracle Enterprise Linux 7.4
Install Ubuntu 16.04 LTS Server
Install Oracle RDBMS
Install Oracle RDBMS 11.2.0.1.0 with Grid Infrastructure
Install Oracle RDBMS 11.2.0.3.0 with Grid Infrastructure
Install Oracle RDBMS 11.2.0.3.0 without Grid Infrastructure
Install Oracle RDBMS 11.2.0.3.0 Without Grid Infrastructure on Windows XP
Install Oracle RDBMS 12.1.0.2 With Grid Infrastructure
Install Oracle RDBMS 12.1.0.2.4 Without Grid Infrastructure
Install Oracle RDBMS 19.5.1.0.200114 without Grid Infrastructure
Miscellaneous
Convert XEN HVM to PV
Create New ASM Disk Group Using ASMCA
Create VNC Server under OEL8
Disable FIREWALLD
Enable DIRECTNFS for Oracle RDBMS 12.1.0.2
Install SQL Developer Data Modeler on Ubuntu 18.04
Install unixODBC Packages Under RHEL 5.4
Manually Create Cloud Control VM from Appliance
Relocate Datafile under 11.2.0.4
Setting Up X-windows to a Remote Server
Starting XTERM with White Background
Use NFS for Oracle Software
Use Pre-Installation RPM
Patch Oracle Database
Apply Oracle RDBMS 11.2.0.3.3 Patchset (Incomplete)
Apply Oracle RDBMS 11.2.0.3.4 Patchset
Apply Oracle RDBMS 12.1.0.2.190416 Patchset
Finding the 11.2.0.3.3 PSU
Upgrade Oracle Database
Upgrade PRODSRVR on PENRITH from 11.2.0.1 to 11.2.0.3 on Windows XP
Upgrade REPOS to 11.2.0.3.3 from 11.1.0.7.0 on GRIDCTRL
Projects
Setting Up a Private Cloud
00 Design
01 Setting Up the Cloud Management Infrastructure
02 Setting Cloud for IaaS
03 Setting Cloud for IaaS 2
04 Setting Cloud for IaaS 3
Reading Notes
Oracle VM Implementation and Administration Guide
Pro Oracle Database 12c Administration
Resource Allocations
IP Addresses
Victoria VM Resources
System Builds
ALLAWAH
2021-02-02 Planning and Build VM
AUBURN
2018-02-21 Planning
2018-02-22 Create VM
2018-02-26 Finish Server Installation
2018-02-27 Install Ansible
2018-03-25 Install Extra Python Modules
2018-03-27 Create GIT Repository
2018-03-29 Add Extra Disk Drive
2020-01-02 Upgrade to Python3 for Ansible
2020-09-23 Upgrade to Ansible 2.10.1
2020-10-15 Upgrade to Ubuntu 20.04
CLIFTON
2016-09-07 0 Planning
2016-09-07 1 Build VM
2017-08-01 Convert to XEN
2020-01-09 Install Oracle Client
CLOUDCTL
00 Download EM12CR3 Template to VICTORIA
01 Extract Template into Seed Pool
02 Deploy EM12CR3 Template into Running Pool
03 Fix Networking Issues
04 Clean Up Seed Pool
05 Save VM UUID in Configuration File
CRONULLA
2014-03-03 Design
2014-03-04 Create VM
2014-03-06 Fix OS Install Issues
2014-03-09 Install OMS 12.1.0.3.1 Again
2014-03-14 Complete OMS 12.1.0.3.1 Installation
2014-03-16 Configure Firewall Rules
2014-04-14 Apply WLS Patches
2014-04-19 0 Additional Configuration Tasks
2014-04-19 1 Install Guest Additions
2014-04-26 0 Install RDA and EMDIAG Tools
2014-04-26 1 Patch OMS to 12.1.0.3.2
2014-05-24 0 Prepare to Install OMS 12.1.0.3.1
2014-05-24 1 Install OMS 12.1.0.3.1
2014-05-24 2 Add Extra Disk Space
2014-05-24 3 Apply WLS Patches
2014-06-17 Integrate BI Publisher into OEM
2014-06-29 0 Upgrade OMS 12.1.0.4.0
2014-06-29 1 Upgrade BIP
2014-06-29 2 Patch WLS After OMS 12.1.0.4
2015-06-15 Re-install as VM on Victoria
2015-06-20 Install Packages
2015-09-07 Install OMS 12.1.0.4
2015-10-10 Replace OMR
2020-01-28 Updated .bashrc for OMS and OPMN
GOLDENGATE
2014-12-03 Planning
2014-12-03 Set Up goldengate1
2021-02-04 Create XEN VM Images
2021-02-05 Start Installation
GORDON
00 Setup
01 Patch GI and DB with PSU 12.1.0.2.5
02 Create EMREPOS Database Using DBCA
03 Fix Up 12.1.0.2.5 and Recreate EMREPOS
04 Install OEM Agent
05 Disable Firewall
06 Move OMR
07 Move OMR - Second Attempt
08 Move OMR - Third Attempt
09 Move OMR - Fourth Attempt
10 Move GORDON to VICTORIA
11 Correct GORDON Network Interface
12 Patch GI with PSU 12.1.0.2.161018
13 Downgrade GORDON to OEL6U5
GRIDCTRL
00 Update DNS for REVESBY Cluster
01 Upgrade EM12CR3p1 (1)
02 Upgrade EM12CR3p1 (2)
03 Deinstall EM12CR1 and Others
04 Install DB PSU 11.2.0.4.0
05 Install EM12CR3p1
06 Set up XDCMP
07 Set Login Timeout and Login Profile
08 Performance Problems
09 Deinstall EM12103P1
10 Automate REPOS Start Up
11 Fix REPOS For OMS Install
12 Apply PSU 11.2.0.4.2 to REPOS
13 Install REPVFY
14 Change DB Parameters for OEM 12.1.0.4
15 Apply PSU 11.2.0.4.3 to REPOS
16 Apply PSU 11.2.0.4.5 to REPOS
17 Apply PSU 11.2.0.4.6 to REPOS
18 Apply Patch 17583185
MELBOURNE
00 Design
01 Create VM
02 Install OVMM 3.2.6
03 Enabling Remote Log Ins
04 Install TightVNC
OATLEY
2020-04-13 Planning and Initial Build
PERSONAL
2020-03-09 Upgrade to 19C
RANDWICK
2020-03-14 Planning
REDFERN
2014-12-23 Planning
2014-12-29 Set Up redfern1
2015-01-01 Set Up DNS and iSCSI
2015-04-04 Create REDFERN1 with OEL7
2015-04-06 Build REDFERN1 on Victoria
2015-04-06 Build REDFERN2 on Victoria
2016-04-23 Install GI 12.1.0.2
2017-11-19 Correct UDEV Settings
2017-11-25 ASM Fails to Start
2017-11-28 Recreate REDFERN Cluster on VICTORIA
2017-11-30 De-Install GI
2017-12-02 GI Installation Attempt #3
2018-02-01 Revised Planning
2018-02-02 Install OEL 7.4
2018-02-28 Ansible Playbook for GI 12.1.0.2 Install
2018-03-01 Ansible Playbook for Oracle Directories
2018-03-02 Ansible Playbook for Oracle User
2018-03-06 Ansible Playbook for GI Network
2018-03-07 Ansible Playbook for GI Storage
2018-03-11 Ansible Playbook for ASMLIB Setup
2018-03-14 Ansible Playbook for Software NFS
2018-03-15 Ansible Roles
2018-03-17 Ansible Playbook to Install GI Software
2018-03-20 Ansible Playbook for Install GI Software (2)
2018-03-24 Ansible Rearrange Variables
2018-03-27 Manage Ansible Playbook in GIT
2018-05-22 Use iSCSI
2018-06-17 NMCLI Commands
Revesby
00 Download OVM Template for DB to VICTORIA
01 Extract Template into Seed Pool
02 Set Up Networking for RAC
03 Set Up Shared Disks for RAC
04 Deploy RAC Nodes
05 Start Up Fails
Victoria
2013-12-24 0 Install OVMS 3.2.6
2013-12-24 1 Add Bridge
2013-12-24 2 Create Repository
2013-12-25 Fix Networking Issues
2014-04-26 Rebuild Victoria
2015-03-29 Install OVMS 3.3.1
2015-04-01 Set Up OVS File System
2015-04-04 Set Up XEN Network
2015-04-26 Rebuild Victoria Again
2018-01-16 Upgrade to OVMS 3.4.4
2018-02-01 Upgrade to OVMS 3.3.4 - Attempt #2
2019-11-19 Set Jumbo Frames on Bridges (1)
2019-12-28 Create CPU Pools
2020-02-17 Mount ISO Images
2021-03-28 Rebuild as 3.4.6 Server
Announcements
12 April 2012
12 March 2012
27 March 2012
Book Reviews
Files
OCM Questions and Answers
Yet Another OCM
Tune SQL statements
References
Oracle
®
12.1 Database SQL Tuning Guide
1 Introduction to SQL Tuning
Tasks and Tools for SQL Tuning
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse