How to clone Oracle Software (11g/12c/18c) fast and easy on Linux and AIX

For AIX there is an extra step. When I ran the clone.pl on AIX, I got the following message: [[email protected] software]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/clone/bin/clone.pl ORACLE_BASE=/app/oracle ORACLE_HOME=/app/oracle/product/18.0.0.0/db ORACLE_HOME_NAME=OH_18000 Your platform requires the root user to perform certain pre-clone OS preparation. The root user should run the shell script ‘rootpre.sh’ before you proceed with cloning. rootpre.sh can be…

ORA-16631: operation requires shutdown of database or instance

On short, after upgrading one of my databases from 11203 to 11204, I’ve noticed that the standby database was in a DISABLED state:   DGMGRL> show configuration Configuration – DG_CONFIG Protection Mode: MaxPerformance Databases: DB_PRI- Primary database DB_STANDBY – Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS   I tried to set it…

DIA-48322: Relation [INCIDENT] of ADR V[2] incompatible with V[2] tool

I got this issue while using ADRCI tool to maintain the logs. This is how I fixed it: [[email protected] ~]$ adrci ADRCI: Release 11.2.0.3.0 – Production on Wed May 31 09:43:29 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ADR base = “/u01/app/oracle” adrci> show homes ADR Homes: diag/diagtool/user_oracle/host_3933716914_11 diag/clients/user_oracle/host_3933716914_11 diag/rdbms/dbinst/DBINST…

Database upgrade from 10.2.0.5.0 to 11.2.0.4

The following document is the best one you can start documenting yourself from: 11gr2-upgrade-bp-apr2012-1610082.pdf From the above document, I followed: Note 251.1: Database Upgrades from 10.2 to 11.2 On that note, on the PLAN tab, I followed: Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1) In this document you’ll find a bunch of…

ORA-01203: wrong incarnation of this file – wrong creation SCN

Like in everyone else’s life, this kind of “happiness” is happening. This is what I got on one of my test STANDBY databases while I was trying to start the Recovery Manager: Managed Standby Recovery starting Real Time Apply Read of datafile ‘/u01/oradata/DB/filename.dbf’ (fno 113) header failed with ORA-01203 Rereading datafile 113 header failed with…

Agent has disabled full monitoring of this target. Only target Status is being monitored – EM12c

I ran into this “exception”: Agent has disabled full monitoring of this target. Only target Status is being monitored”: After a couple of researches, I’ve found that this is a Bug and therefor I needed to follow Doc ID 2207479.1. First you need to make sure that you’re patching the right ORACLE_HOME: export ORACLE_HOME=/u01/app/oracle/product/agent12cR5/core/12.1.0.5.0 [server1 25104978]$ $ORACLE_HOME/OPatch/opatch…

Time to upgrade the OPatch

As the title suggest, it’s time to upgrade the OPatch. This is what I got when I wanted to apply a patch (namely 20760982) to a 11.2.0.4 database (linux): [[email protected] 20760982]$ $ORACLE_HOME/OPatch/opatch apply Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0.4 Central Inventory : /u01/app/oracle/oraInv from…