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: [oracle@PROD 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: [oracle@dbserver ~]$ 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…