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
NTP
10G System Builds
Botany
Miscellaneous
Padstow
Richmond Cluster
Richmond Database
RMANCAT
Missing BigBlog Links
11G OCE RAC
Section 1 - Grid Infrastructure: Clusterware and ASM
Administering Oracle Clusterware
Grid Infrastructure Installation
Making Applications Highly Available With Oracle Clusterware
Managing Clusterware
Oracle Grid Infrastructure
Troubleshooting Oracle Clusterware
System Builds
Panania1
VICTORIA
11G OCM
11G OCM Data and Data Warehouse Management
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 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 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
Data Guard
Design Overview
FREENAS
GRIDCTRL
PADSTOW
PENRITH1
PENRITH2
REDFERN
12C OCM
12C OCM System Builds
BOTANY
PADSTOW
Data and Performance Management
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
Administer materialized views
Perform real application testing
Tune SQL statements
Data Guard
Administer a Data Guard environment
Configure a standby database for testing
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
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
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
Auditing
Backup, Recovery and Flashback for a CDB/PDB
Basics of Multitenant Container Database (CDB)
Configuring and Creating CDBs and PDBs
Emergency Monitoring, Real-Time ADDM, Compare Period ADDM, and Active Session History (ASH) Analytics
Enterprise Manager and Other Tools
In-Database Archiving and Valid-Time Temporal
Index and Table Enhancements
Information Lifecycle Management and Storage Enhancements
Managing CDBs and PDBs
Managing Tablespaces, Common and Local Users, Privileges and Roles
Oracle Data Pump, SQL*Loader, External Tables and Online Operations Enhancements
Oracle Data Redaction
Partitioning Enhancements
Privileges
Real-Time Database Operation Monitoring
Resource Manager and Other Performance Enhancements
RMAN and Flashback Data Archive
SQL Enhancements
SQL Tuning
Section 2: Key DBA Skills
Core Administration
Miscellaneous
Performance Management
Security
Storage
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 Enterprise Edition Issues
Drop Administrative User
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
PostgreSQL Issues
Move Default Tablespace is Different from Normal Tablespace
Knowledge
Demonstrations
Analysis of Effect of O_SYNC
Help Pages
runInstaller
Oracle Utilities
ADRCI SHOW ALERT Reference
Technical Notes
Oracle Cloud Infrastructure 2024 Certified Networking Professional
Design and Deploy OCI Virtual Cloud Networks (VCN)
Demonstrate an understanding of IPv4/IPv6 addressing
Demonstrate mastery in applying EndPoints to a Networking Architecture
Differentiate the VCN Gateway's roles
Examine VCN/Subnets characteristics
Recognize the different Endpoints
Design for Hybrid Networking Architectures
Assess knowledge of BGP
Demonstrate command of DRG and DRG Attachments
Evaluate OCI VPN Services
Sustain multi-cloud connectivity configurations
Validate knowhow of the different FastConnect products from OCI
Implement and Operate Secure OCI Networking and Connectivity Solutions
Apply Connectivity and related IAM concepts to inter-tenancy communications
Demonstrate CloudShell functionalities
Evaluate WAF/Edge/Certificates/services in a Networking multi-tier architecture
Illustrate Network Firewall characteristics
Show different approaches for Bastion service in multi-tier architectures
Migrate Workloads to OCI
Outline optimal connectivity strategy for a cloud migration from another Cloud Service Provider
Outline optimal connectivity strategy for a cloud migration from On-Premises
Outline optimal multi-cloud scenarios
OCI Networking Best Practices
Demonstrate knowledge of Logging and Monitoring best practices
Demonstrate knowledge of Networking Architecture Design best practices
Demonstrate knowledge of Networking Connectivity best practices
Demonstrate knowledge of Networking Security best practices
Plan and Design OCI Networking Solutions and App Services
Demonstrate an understanding of OCI load-balancing offerings and related resources
Demonstrate knowledge of OCI DNS and Traffic Steering
Recognize IP Management details, select procedural steps
Transitive Routing
Interpret key aspects of transitive routing with DRG, LPG, and Network Appliance resources
Synthesize Transitive Routing Configurations
Troubleshoot OCI Networking and Connectivity Issues
Demonstrate logging expertise in OCI
Select the right products for various troubleshooting and design scenarios
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)
GIT Procedures
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.4
Install Oracle Enterprise Linux 7.2
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 Without Grid Infrastructure on Windows XP
Install Oracle RDBMS 11.2.0.3.0 without Grid Infrastructure
Install Oracle RDBMS 11.2.0.3.0 with Grid Infrastructure
Install Oracle RDBMS 12.1.0.2.4 Without Grid Infrastructure
Install Oracle RDBMS 12.1.0.2 With 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
PostgreSQL Procedures
Backup PostgreSQL DB
Install PostgreSQL 16
Move Default Tablespace
Move Non-Default Tablespace
Upgrade PostgreSQL 14 to 16
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
GitHub 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
00 Design
01 Create VM
02 Fix OS Install Issues
03 Prepare to Install OMS 12.1.0.3.1
04 Install OMS 12.1.0.3.1
05 Add Extra Disk Space
06 Install OMS 12.1.0.3.1 Again
07 Complete OMS 12.1.0.3.1 Installation
08 Configure Firewall Rules
09 Additional Configuration Tasks
10 Apply WLS Patches
11 Install Guest Additions
12 Install RDA and EMDIAG Tools
13 Patch OMS to 12.1.0.3.2
14 Apply WLS Patches
15 Integrate BI Publisher into OEM
16 Upgrade OMS 12.1.0.4.0
17 Upgrade BIP
18 Patch WLS After OMS 12.1.0.4
19 Re-install as VM on Victoria
20 Install Packages
21 Install OMS 12.1.0.4
22 Replace OMR
23 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 March 2012
27 March 2012
12 April 2012
Book Reviews
OCM Questions and Answers
Home
>
Database Designs