Saturday, May 26, 2018

Oracle Exadata x7-2 Eighth Rack Improvements


Oracle Exadata x7-2 Eighth Rack Improvements

1. Used 10TB HHDs - 53 TB with High Redundancy (67 TB with Normal Redundancy)
2. Cores Per CPU/Server - 24/48
3. DRAM Per Server - 384 GB
4. Infiband (Internal) - 40 Gb/s
5. Ethernet (External) - 25 GigE
6. All-Flash per server - 51.2 TB
7. Flash Cache per server - 25.6 TB
8. Disk capacity per server - 120 TB
9. SQL offload cores per server - 20
10. Two separate internal HDDs for OS and Cell Software (M2 Disks)

Friday, May 4, 2018

AWR Snapshots and Reports - PDB level in Oracle 12c R2 (12.2.0.1.0)


AWR Snapshots and Reports - PDB level in Oracle 12c R2 (12.2.0.1.0)


1. AWR Snapshots and reports can be created only at the container database (CDB) level in 
   Oracle 12c R1 (12.1.0.1.0 / 12.1.0.2.0)
2. AWR Snapshots and reports can be created at the container database (CDB) level as well as pluggable database (PDB) level 
   in Oracle 12c R2 (12.2.0.1.0)
3. By default, AWR Snapshots and reports can be generated only at the container database (CDB) level
4. If you want to generate AWR Snapshots and reports at PDB level, set the following parameter 
   "awr_pdb_autoflush_enabled=TRUE" (by default FALSE)

oracle@exaserver01 ~]$ sqlplus / as sysdba


SQL*Plus: Release 12.2.0.1.0 Production on Thu May 3 14:29:18 2018
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show con_name

CON_NAME
----------
CDB$ROOT

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO

SQL> alter session set container=ORCLPDB;
Session altered.

SQL> show con_name

CON_NAME
--------
ORCLPDB

SQL> show user
USER is "SYS"

SQL> show parameter awr_pdb_autoflush_enabled

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
awr_pdb_autoflush_enabled            boolean     FALSE

SQL> alter system set awr_pdb_autoflush_enabled=TRUE;
System altered.

SQL> show parameter awr_pdb_autoflush_enabled

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
awr_pdb_autoflush_enabled            boolean     TRUE


SQL> set lines 100
SQL> select * from cdb_hist_wr_control;

      DBID SNAP_INTERVAL
---------- ---------------------------------------------------------------------------
RETENTION                                                                   TOPNSQL        CON_ID
--------------------------------------------------------------------------- ---------- ----------
1826807715 +40150 00:01:00.0
+00008 00:00:00.0                                                           DEFAULT             3

SQL> execute dbms_workload_repository.modify_snapshot_settings(interval => 60);
PL/SQL procedure successfully completed.

SQL> select * from cdb_hist_wr_control;

      DBID SNAP_INTERVAL
---------- ---------------------------------------------------------------------------
RETENTION                                                                   TOPNSQL        CON_ID
--------------------------------------------------------------------------- ---------- ----------
1826807715 +00000 01:00:00.0
+00008 00:00:00.0                                                           DEFAULT             3

SQL> show parameter AWR_SNAPSHOT_TIME_OFFSET

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
awr_snapshot_time_offset             integer     0

SQL> alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both;
alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database


SQL> alter session set container=CDB$ROOT;
Session altered.

SQL> SHOW CON_NAME

CON_NAME
------------------------------
CDB$ROOT

SQL> show user
USER is "SYS"

SQL> show parameter AWR_SNAPSHOT_TIME_OFFSET

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
awr_snapshot_time_offset             integer     0

SQL> alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both;
System altered.

SQL> show parameter AWR_SNAPSHOT_TIME_OFFSET

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
awr_snapshot_time_offset             integer     1000000

SQL> select * from awr_pdb_snapshot;


AWR Report at PDB level:






Note: Pluggable Database (PDB) Snapshot ID's can be different from Container Database (CDB)
Snapshot ID's when you generate PDB Snapshot ID's manually.

Friday, March 30, 2018

Virtual IP Addresses In Oracle Exadata x6/x7


Virtual IP Addresses In Oracle Exadata

Note: If not able to find VIPs in /etc/hosts, check the below you can find out VIPs in Oracle Exadata :)


$ srvctl status vip -n dbserver01
VIP dbserver01-vip.abc.com is enabled
VIP dbserver01-vip.abc.com is running on node: dbserver01
[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]

$ srvctl status vip -n dbserver02
VIP dbserver02-vip.abc.com is enabled
VIP dbserver02-vip.abc.com is running on node: dbserver02
[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]

$ srvctl status vip -n dbserver03
VIP dbserver03-vip.abc.com is enabled
VIP dbserver03-vip.abc.com is running on node: dbserver03
[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]

$ srvctl status vip -n dbserver04
VIP dbserver04-vip.abc.com is enabled
VIP dbserver04-vip.abc.com is running on node: dbserver04
[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]
$

[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]
$ nslookup dbserver01-vip
Server:         17.2.3.20
Address:        17.2.3.20#53
Name:   dbserver01-vip.abc.com
Address: 10.5.3.77

[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]
$ nslookup dbserver02-vip
Server:         17.2.3.20
Address:        17.2.3.20#53
Name:   dbserver02-vip.abc.com
Address: 10.5.3.78

[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]
$ nslookup dbserver03-vip
Server:         17.2.3.20
Address:        17.2.3.20#53
Name:   dbserver03-vip.abc.com
Address: 10.5.3.79

[ oracle@dbserver01.abc.com : Thu Mar 29, 10:06 AM : /home/oracle ]
$ nslookup dbserver04-vip
Server:         17.2.3.20
Address:        17.2.3.20#53
Name:   dbserver04-vip.abc.com
Address: 10.5.3.80

RAC Service Not Failover during Instance Shutdown Using srvctl stop instance with Abort and Force option in 11.2.0.4/12.1.0.2/12.2.0.1


RAC Service Not Failover during Instance Shutdown Using srvctl stop instance with Abort and 
Force option in 11.2.0.4/12.1.0.2/12.2.0.1

Check the GRID version

[grid@dbserver01 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [12.2.0.1.0]
[grid@dbserver01 ~]$

[grid@dbserver01 ~]$ crsctl query crs softwareversion
Oracle Clusterware version on node [dbserver01] is [12.2.0.1.0]
[grid@dbserver01 ~]$

$ su - oracle
[oracle@dbserver01 ~]$ ps -ef | grep pmon
oracle    26358      1  0 Mar29 ?        00:00:04 ora_pmon_dbm011
grid      64858      1  0 Feb28 ?        00:01:54 asm_pmon_+ASM1
oracle   289299 289250  0 12:32 pts/1    00:00:00 grep pmon
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ . oraenv
ORACLE_SID = [oracle] ? dbm011
The Oracle base has been set to /u01/app/oracle
[oracle@dbserver01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri Mar 30 12:32:34 2018
Copyright (c) 1982, 2016, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Creating service with PREFERRED in both the instances. 

[oracle@dbserver01 ~]$ srvctl add service -d dbm01 -s serv5 -r dbm011,dbm012 -tafpolicy BASIC -failovertype SELECT 
-failovermethod BASIC -failoverretry 2 -failoverdelay 5

[oracle@dbserver01 ~]$ srvctl status service -d dbm01
Service serv5 is not running.
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl start service -d dbm01 -s serv5
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl status service -d dbm01 -s serv5
Service serv5 is running on instance(s) dbm011,dbm012
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl config service -d dbm01 -s serv5
Service name: serv5
Server pool:
Cardinality: 2
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 2
TAF failover delay: 5
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Pluggable database name:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: dbm011,dbm012
Available instances:
CSS critical: no
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl stop instance -d dbm01 -i dbm011 -f
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl status service -d dbm01
Service serv5 is running on instance(s) dbm012
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl config service -d dbm01 -s serv5
Service name: serv5
Server pool:
Cardinality: 2
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 2
TAF failover delay: 5
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Pluggable database name:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: dbm011,dbm012
Available instances:
CSS critical: no

[oracle@dbserver01 ~]$ srvctl start instance -d dbm01 -i dbm011

[oracle@dbserver01 ~]$ srvctl status service -d dbm01
Service serv5 is running on instance(s) dbm011,dbm012
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl status service -d dbm01 -s serv5
Service serv5 is running on instance(s) dbm011,dbm012
[oracle@dbserver01 ~]$

Creating service with PREFERRED and AVAILABLE in the instances. 

[oracle@dbserver01 ~]$ srvctl add service -d dbm01 -s serv6 -r dbm011 -a dbm012 -tafpolicy BASIC -failovertype SELECT 
-failovermethod BASIC -failoverretry 2 -failoverdelay 5
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl status service -d dbm01 -s serv6
Service serv6 is not running.
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl start service -d dbm01 -s serv6
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl status service -d dbm01 -s serv6
Service serv6 is running on instance(s) dbm011
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl status service -d dbm01 -s serv6
Service serv6 is running on instance(s) dbm011

[oracle@dbserver01 ~]$ srvctl config service -d dbm01 -s serv6
Service name: serv6
Server pool:
Cardinality: 1
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 2
TAF failover delay: 5
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Pluggable database name:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: dbm011
Available instances: dbm012
CSS critical: no
[oracle@dbserver01 ~]$

[oracle@dbserver01 ~]$ srvctl stop instance -d dbm01 -i dbm011 -f

[oracle@dbserver01 ~]$ srvctl status service -d dbm01 -s serv6
Service serv6 is not running.

[oracle@dbserver01 ~]$ srvctl start instance -d dbm01 -i dbm011

[oracle@dbserver01 ~]$ srvctl status service -d dbm01 -s serv6
Service serv6 is running on instance(s) dbm011

Please refer MOS: 

1. Services Are Not Failing Over To Node2 Automatically When First Node1 Is Down And Vice Versa (Doc ID 2177143.1)
2. The Bug 22472054 is seen fixed in GI 12.2 version
3. Apply the patch for bug 22472054.

Sunday, February 25, 2018

Moving Pluggable Database (PDB) between the different Container Database (CDB) in Different Servers with ASM Storage


Moving Pluggable Database (PDB) between the different Container Database (CDB) with ASM Storage


Moving Pluggable Database (PDB) between the different Container Database (CDB) with ASM Storage

==========Source Cluster RAC1 and RAC2==============================>

Source Cluster: RAC1 and RAC2
Source Container Database: CONTDB
Source Pluggable Database: CONPDB3


Target Cluster: RAC3 and RAC4
Target Container Database: CONTDB
Target Pluggable Database: CONPDB3



[oracle@rac1-12c ~]$ . oraenv
ORACLE_SID = [primdb1] ? contdb
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac1-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 25 06:10:56 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
SQL> connect sys/oracle@contdb as sysdba
Connected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        READ WRITE NO
SQL> alter session set container=CONPDB3;
Session altered.

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/system.335.968994861
+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/sysaux.334.968994861
+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/users.332.968994889

SQL> connect sys/oracle@contdb as sysdba
Connected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        READ WRITE NO


SQL> alter pluggable database conpdb3 close immediate instances=all;
Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        MOUNTED
SQL> select name ,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
CONPDB1                        READ WRITE
CONPDB2                        READ WRITE
CONPDB3                        MOUNTED

SQL> alter pluggable database conpdb3 unplug into '/u01/app/oracle/CONPDB3_NEW.xml';
Pluggable database altered.

SQL> exit

[oracle@rac1-12c ~]$ . oraenv
ORACLE_SID = [contdb] ? contdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac1-12c ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Feb 25 06:16:04 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database: CONTDB (DBID=1349816764)

RMAN> BACKUP FOR TRANSPORT AS COMPRESSED BACKUPSET FILESPERSET=1024 
PLUGGABLE DATABASE 'CONPDB3' FORMAT '/u01/app/oracle/CONPDB3.dfb';

Starting backup at 25-FEB-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=82 instance=contdb1 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00019 name=+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/sysaux.334.968994861
input datafile file number=00018 name=+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/system.335.968994861
input datafile file number=00020 name=+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/users.332.968994889
channel ORA_DISK_1: starting piece 1 at 25-FEB-18
channel ORA_DISK_1: finished piece 1 at 25-FEB-18
piece handle=/u01/app/oracle/CONPDB3.dfb tag=TAG20180225T061635 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 25-FEB-18

RMAN> exit


[oracle@rac1-12c ~]$ cd /u01/app/oracle/
[oracle@rac1-12c oracle]$ ls -lrth
total 148M
drwxrwxr-x.  3 oracle oinstall 4.0K Jun 23  2017 product
drwxr-xr-x   4 root   root     4.0K Jun 23  2017 tfa
drwxr-xr-x   3 oracle oinstall 4.0K Jun 23  2017 rac1-12c
drwxr-xr-x   3 oracle oinstall 4.0K Jun 24  2017 log
drwxr-xr-x   2 oracle oinstall 4.0K Jun 24  2017 checkpoints
drwxrwxr-x   5 oracle oinstall 4.0K Jun 24  2017 crsdata
drwxr-x---   7 oracle oinstall 4.0K Jun 29  2017 cfgtoollogs
drwxrwxr-x  19 oracle oinstall 4.0K Oct 25 22:48 diag
drwxr-x---   8 oracle oinstall 4.0K Nov  8 04:53 audit
drwxr-x---   7 oracle oinstall 4.0K Feb 25 05:13 admin
-rw-r--r--   1 oracle vboxsf   5.4K Feb 25 05:31 conpdb3.xml
-rw-r--r--   1 oracle vboxsf   5.4K Feb 25 06:13 CONPDB3_NEW.xml
-rw-r-----   1 oracle vboxsf   148M Feb 25 06:16 CONPDB3.dfb

[oracle@rac1-12c oracle]$ scp CONPDB3_NEW.xml oracle@192.168.2.201:/u01/app/oracle/
oracle@192.168.2.201's password:
CONPDB3_NEW.xml                                   100% 5525     5.4KB/s   00:00
[oracle@rac1-12c oracle]$ scp CONPDB3.dfb oracle@192.168.2.201:/u01/app/oracle/
oracle@192.168.2.201's password:
CONPDB3.dfb                                       100%  148MB  73.9MB/s   00:02
[oracle@rac1-12c oracle]$ cd


[oracle@rac1-12c ~]$ . oraenv
ORACLE_SID = [contdb1] ? contdb
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac1-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 25 09:43:06 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect sys/oracle@contdb as sysdba
Connected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        MOUNTED

SQL> col PATCH_ID format 999999999
SQL> col PATCH_UID format 99999999
SQL> col VERSION format a10
SQL> col STATUS format a15
SQL> col DESCRIPTION format a80
SQL> set lines 200 pages 1000
SQL> select PATCH_ID, PATCH_UID, VERSION, STATUS, DESCRIPTION 
from DBA_REGISTRY_SQLPATCH order by BUNDLE_SERIES;
no rows selected

SQL> !
[oracle@rac1-12c ~]$ cd /u01/app/oracle/product/12.1.0.2/db_1/OPatch/
[oracle@rac1-12c OPatch]$ ./opatch lspatches
There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/12.1.0.2/db_1".

OPatch succeeded.
[oracle@rac1-12c OPatch]$

===========================Target Cluster RAC3 and RAC4=================>

[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [orcldb1] ? contdb
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 25 06:22:16 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect sys/oracle@contdb as sysdba
Connected.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
SQL> exit


[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [+ASM1] ? contdb1
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/12.1.0.2/db_1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Feb 25 06:51:58 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database: CONTDB (DBID=1349963590)

RMAN> run
{
set command id  to 'CONPDB3';
RESTORE FOREIGN DATAFILE  18 TO NEW, 19 TO NEW, 
20 TO NEW FROM BACKUPSET '/u01/app/oracle/CONPDB3.dfb';
};
2> 3> 4> 5>
executing command: SET COMMAND ID

Starting restore at 25-FEB-18
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=97 instance=contdb1 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring foreign file 00018
channel ORA_DISK_1: restoring foreign file 00019
channel ORA_DISK_1: restoring foreign file 00020
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/CONPDB3.dfb
channel ORA_DISK_1: restoring foreign file 18 to +DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/system.350.969000723
channel ORA_DISK_1: restoring foreign file 19 to +DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/sysaux.349.969000723
channel ORA_DISK_1: restoring foreign file 20 to +DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/users.351.969000723
channel ORA_DISK_1: foreign piece handle=/u01/app/oracle/CONPDB3.dfb
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
Finished restore at 25-FEB-18
RMAN> exit

[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [contdb1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle

ASMCMD> cd DATA
ASMCMD> cd CONTDB
ASMCMD> ls
5D900B1A1E953788E053C902A8C0836A/
5D902973DAA94A24E053C902A8C0F831/
5D902BDD14014BFCE053C902A8C0636A/
65FEDAA33CD86078E0536502A8C07E3C/
ARCHIVELOG/
AUTOBACKUP/
CONTROLFILE/
DATAFILE/
FD9AC20F64D244D7E043B6A9E80A2F2F/
ONLINELOG/
PARAMETERFILE/
PASSWORD/
TEMPFILE/
ASMCMD> cd 65FEDAA33CD86078E0536502A8C07E3C/

ASMCMD> ls
DATAFILE/
ASMCMD> cd datafile
ASMCMD> ls
SYSAUX.349.969000723
SYSTEM.350.969000723
USERS.351.969000723
ASMCMD> ls -l
Type      Redund  Striped  Time             Sys  Name
DATAFILE  UNPROT  COARSE   FEB 25 06:00:00  Y    SYSAUX.349.969000723
DATAFILE  UNPROT  COARSE   FEB 25 06:00:00  Y    SYSTEM.350.969000723
DATAFILE  UNPROT  COARSE   FEB 25 06:00:00  Y    USERS.351.969000723
ASMCMD> exit

[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [+ASM1] ? contdb
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 25 06:55:00 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect sys/oracle@contdb as sysdba
Connected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [contdb] ? contdb1
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/12.1.0.2/db_1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Feb 25 06:58:45 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database: CONTDB (DBID=1349963590)

RMAN> change datafilecopy '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/system.350.969000723',
2> '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/sysaux.349.969000723',
3> '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/users.351.969000723' uncatalog;

using target database control file instead of recovery catalog
uncataloged datafile copy
datafile copy file name=+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/
system.350.969000723 RECID=7 STAMP=969000740
uncataloged datafile copy
datafile copy file name=+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/
sysaux.349.969000723 RECID=8 STAMP=969000748
uncataloged datafile copy
datafile copy file name=+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/
users.351.969000723 RECID=6 STAMP=969000724
Uncataloged 3 objects

RMAN> exit
Recovery Manager complete.

[oracle@rac3-12c ~]$ cd /u01/app/oracle/
[oracle@rac3-12c oracle]$ cat CONPDB3_NEW.xml | grep path
  +DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/system.335.968994861
  +DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/sysaux.334.968994861
  +DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/TEMPFILE/temp.333.968997067
  +DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/users.332.968994889
[oracle@rac3-12c oracle]$

ASMCMD> pwd
+data/contdb/65FEDAA33CD86078E0536502A8C07E3C/datafile

ASMCMD> exit
[oracle@rac3-12c oracle]$ cd

[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [+ASM1] ? contdb1
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/12.1.0.2/db_1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 25 07:04:54 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect sys/oracle@contdb as sysdba
Connected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO

SQL> create pluggable database CONPDB3 as clone  using '/u01/app/oracle/CONPDB3_NEW.xml'
  2  source_file_name_convert = (
  3  '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/system.335.968994861',
     '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/system.350.969000723',
  4  '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/sysaux.334.968994861',
     '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/sysaux.349.969000723',
  5  '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/users.332.968994889',
     '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/users.351.969000723',
  6  '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/TEMPFILE/temp.333.968997067',
     '+DATA/CONTDB/65FEDAA33CD86078E0536502A8C07E3C/DATAFILE/conpdb3_temp01.dbf')
  7  file_name_convert=NONE
  8  NOCOPY;

Pluggable database created.

SQL> select name,open_mode from v$pdbs;

NAME                           OPEN_MODE
------------------------------ ----------
PDB$SEED                       READ ONLY
CONPDB1                        READ WRITE
CONPDB2                        READ WRITE
CONPDB3                        MOUNTED

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        MOUNTED
SQL>
SQL> alter pluggable database CONPDB3 open instances=all;

Warning: PDB altered with errors.

[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [contdb] ?
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 25 10:54:01 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect sys/oracle@contdb as sysdba
Connected.
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        READ WRITE YES

SQL> select cause, type, message from PDB_PLUG_IN_VIOLATIONS where name = 'CONPDB3';

CAUSE                                                            TYPE
---------------------------------------------------------------- ---------
MESSAGE
---
SQL Patch                                                        ERROR
PSU bundle patch 171017 (DATABASE PATCH SET UPDATE 12.1.0.2.171017): Installed in the CDB but not in the PDB.

[oracle@rac3-12c ~]$ . oraenv
ORACLE_SID = [contdb] ? contdb1
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/12.1.0.2/db_1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c ~]$ cd /u01/app/oracle/product/12.1.0.2/db_1/OPatch/

[oracle@rac3-12c OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Sun Feb 25 10:56:36 2018
Copyright (c) 2012, 2016, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/
sqlpatch_11332_2018_02_25_10_56_36/sqlpatch_invocation.log

Connecting to database...OK
Note:  Datapatch will only apply or rollback SQL fixes for PDBs
       that are in an open state, no patches will be applied to closed PDBs.
       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
       (Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Bundle series PSU:
  Not installed in the binary registry and ID 171017 in PDB CDB$ROOT, ID 171017 in PDB PDB$SEED, 
  ID 171017 in PDB CONPDB1, ID 171017 in PDB CONPDB2

Adding patches to installation queue and performing prereq checks...
Installation queue:
  For the following PDBs: CDB$ROOT PDB$SEED CONPDB1 CONPDB2
    The following patches will be rolled back:
      26713565 (DATABASE PATCH SET UPDATE 12.1.0.2.171017)
    Nothing to apply
  For the following PDBs: CONPDB3
    Nothing to roll back
    Nothing to apply

Installing patches...
Patch installation complete.  Total patches installed: 4

Validating logfiles...
Patch 26713565 rollback (pdb CDB$ROOT): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26713565/21602269/
26713565_rollback_CONTDB_CDBROOT_2018Feb25_10_57_32.log (no errors)
Patch 26713565 rollback (pdb PDB$SEED): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26713565/21602269/
26713565_rollback_CONTDB_PDBSEED_2018Feb25_10_58_23.log (no errors)
Patch 26713565 rollback (pdb CONPDB1): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26713565/21602269/
26713565_rollback_CONTDB_CONPDB1_2018Feb25_10_58_23.log (no errors)
Patch 26713565 rollback (pdb CONPDB2): SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26713565/21602269/
26713565_rollback_CONTDB_CONPDB2_2018Feb25_10_58_23.log (no errors)
SQL Patching tool complete on Sun Feb 25 10:59:37 2018
[oracle@rac3-12c OPatch]$

[oracle@rac3-12c OPatch]$ . oraenv
ORACLE_SID = [contdb] ? contdb1
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac3-12c OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Feb 25 11:01:09 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        READ WRITE YES

SQL> select inst_id, name, restricted from gv$containers;

   INST_ID NAME                           RES
---------- ------------------------------ ---
         1 CDB$ROOT                       NO
         1 PDB$SEED                       NO
         1 CONPDB1                        NO
         1 CONPDB2                        NO
         1 CONPDB3                        YES
         2 CDB$ROOT                       NO
         2 PDB$SEED                       NO
         2 CONPDB1                        NO
         2 CONPDB2                        NO
         2 CONPDB3                        YES

10 rows selected.

SQL> alter pluggable database CONPDB3 close immediate instances=ALL;
Pluggable database altered.

SQL> select inst_id, name, restricted from gv$containers;

   INST_ID NAME                           RES
---------- ------------------------------ ---
         1 CDB$ROOT                       NO
         1 PDB$SEED                       NO
         1 CONPDB1                        NO
         1 CONPDB2                        NO
         1 CONPDB3
         2 CDB$ROOT                       NO
         2 PDB$SEED                       NO
         2 CONPDB1                        NO
         2 CONPDB2                        NO
         2 CONPDB3

10 rows selected.

SQL> alter pluggable database CONPDB3 open read write instances=ALL;
Pluggable database altered.

SQL> select inst_id, name, restricted from gv$containers;

   INST_ID NAME                           RES
---------- ------------------------------ ---
         1 CDB$ROOT                       NO
         1 PDB$SEED                       NO
         1 CONPDB1                        NO
         1 CONPDB2                        NO
         1 CONPDB3                        NO
         2 CDB$ROOT                       NO
         2 PDB$SEED                       NO
         2 CONPDB1                        NO
         2 CONPDB2                        NO
         2 CONPDB3                        NO

10 rows selected.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        READ WRITE NO

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 CONPDB1                        READ WRITE NO
         4 CONPDB2                        READ WRITE NO
         5 CONPDB3                        READ WRITE NO

SQL> connect sys/oracle@192.168.2.201:1521/conpdb3 as sysdba
Connected.

SQL> show con_name

CON_NAME
------------------------------
CONPDB3

SQL> connect user1/oracle@192.168.2.201:1521/conpdb3
Connected.

SQL> select * from tab1;

        NO
----------
         1

SQL>



Saturday, September 16, 2017

Rollback interim patch in Oracle 12c R1 (12.1.0.2.0) - 21519686 patch


Rollback interim patch in Oracle 12c R1 (12.1.0.2.0) - 21519686 patch

[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle    5046     1  0 00:17 ?        00:00:00 asm_pmon_+ASM1
oracle    7259     1  0 00:18 ?        00:00:00 ora_pmon_corcldb1
oracle    7261     1  0 00:18 ?        00:00:00 mdb_pmon_-MGMTDB
oracle    7275     1  0 00:18 ?        00:00:00 ora_pmon_orcl1

[oracle@rac1-12c ~]$ srvctl stop instance -d orcl -i orcl1 -f
[oracle@rac1-12c ~]$ srvctl stop instance -d corcldb -i corcldb1 -f

[oracle@rac2-12c ~]$ srvctl stop instance -d orcl -i orcl2 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d corcldb -i corcldb2 -f

OR

[oracle@rac2-12c ~]$ srvctl stop database -d orcl
[oracle@rac2-12c ~]$ srvctl stop database -d corcldb


[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686
21519686;

[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-28-38AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-28-38AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  21519686     : applied on Fri Sep 15 02:07:26 IST 2017
Unique Patch ID:  20178159
   Created on 9 May 2016, 09:28:22 hrs PST8PDT
   Bugs fixed:
     21519686

Rac system comprising of multiple nodes
  Local node = rac1-12c
  Remote node = rac2-12c

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch rollback -id 21519686

Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-28-51AM_1.log


Patches will be rolled back in the following order:
   21519686
The following patch(es) will be rolled back: 21519686

This node is part of an Oracle Real Application Cluster.
Remote nodes: 'rac2-12c'
Local node: 'rac1-12c'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y

Rolling back patch 21519686...

RollbackSession rolling back interim patch '21519686' from OH '/u01/app/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...
RollbackSession removing interim patch '21519686' from inventory

Patching in rolling mode.

The node 'rac2-12c' will be patched next.

Please shutdown Oracle instances running out of this ORACLE_HOME on 'rac2-12c'.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')

Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'rac2-12c'
   Rollback-related files are:
     FR = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt"
     DR = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt"
     FP = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt"
     MP = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt"
     RC = "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remote_cmds.txt"

Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_files.txt" with actual path.
Removing files on remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/remove_dirs.txt" with actual path.
Removing directories on remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Instantiating the file "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt.instantiated" by replacing $ORACLE_HOME in "/u01/app/oracle/product/12.1.0.2/db_1/.patch_storage/NRollback/2017-09-17_00-28-51AM/rac/make_cmds.txt" with actual path.
Running command on remote node 'rac2-12c':
cd /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/db_1 || echo REMOTE_MAKE_FAILED::>&2


The node 'rac2-12c' has been patched.  You can restart Oracle instances on it.


Finished patching in rolling mode.

Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-28-51AM_1.log

OPatch succeeded.

[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686

[oracle@rac1-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-30-20AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-30-20AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Rac system comprising of multiple nodes
  Local node = rac1-12c
  Remote node = rac2-12c

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle    5046     1  0 00:17 ?        00:00:00 asm_pmon_+ASM1
oracle    7261     1  0 00:18 ?        00:00:00 mdb_pmon_-MGMTDB
oracle   19112 16276  0 00:30 pts/1    00:00:00 grep pmon

[oracle@rac1-12c ~]$ ssh rac2-12c
Last login: Sun Sep 17 00:25:37 2017 from 192.168.2.1

[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle    4969     1  0 00:17 ?        00:00:00 asm_pmon_+ASM2
oracle   19012 18954  0 00:30 pts/1    00:00:00 grep pmon

[oracle@rac2-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches |grep 21519686

[oracle@rac2-12c ~]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-17_00-31-19AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-17_00-31-19AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Rac system comprising of multiple nodes
  Local node = rac2-12c
  Remote node = rac1-12c

--------------------------------------------------------------------------------

OPatch succeeded.


[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle    4969     1  0 00:17 ?        00:00:00 asm_pmon_+ASM2
oracle   20365 18954  0 00:32 pts/1    00:00:00 grep pmon

[oracle@rac2-12c ~]$ srvctl start database -d orcl
[oracle@rac2-12c ~]$ srvctl start database -d corcldb

[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle    4969     1  0 00:17 ?        00:00:00 asm_pmon_+ASM2
oracle   20479     1  0 00:32 ?        00:00:00 ora_pmon_orcl2
oracle   20794     1  0 00:32 ?        00:00:00 ora_pmon_corcldb2
oracle   21357 18954  0 00:33 pts/1    00:00:00 grep pmon

[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle    5046     1  0 00:17 ?        00:00:00 asm_pmon_+ASM1
oracle    7261     1  0 00:18 ?        00:00:00 mdb_pmon_-MGMTDB
oracle   20259     1  0 00:32 ?        00:00:00 ora_pmon_orcl1
oracle   20706     1  0 00:32 ?        00:00:00 ora_pmon_corcldb1
oracle   21183 16276  0 00:33 pts/1    00:00:00 grep pmon
[oracle@rac1-12c ~]$


Published 100 Oracle Technology Articles Globally - Oracle Technology Network (OTN) - Spanish, Portuguese and English


Published 100 Oracle Technology Articles Globally - Oracle Technology Network (OTN) - Spanish, Portuguese and English

Oracle Technology Network (OTN) – SPANISH           (36 Articles)


Article-1: Oracle RAC 12c: "Flex ASM" y "Flex Cluster"
http://www.oracle.com/technetwork/es/articles/database-performance/caracteristicas-flex-asm-y-cluster-2088714-esa.html

Article-2: Oracle Exadata Database Machine: "Smart Flash Logging"
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-smart-flash-logging-2088700-esa.html

Article-3: Oracle Exadata Database Machine: “Exachk”
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-database-machine-exachk-2095610-esa.html

Article-4: Oracle Exadata Database Machine: “Exadata Hybrid Columnar Compression (EHCC)”
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-hybrid-columnar-compression-2098797-esa.html

Article-5: Oracle Exadata Database Machine: “Write-Back Flash Cache”
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-write-back-flash-cache-2101480-esa.html

Article-6: Oracle Exadata Database Machine: IO Resource Manager (IORM)
http://www.oracle.com/technetwork/es/articles/database-performance/io-resource-manager-2100979-esa.html

Article-7: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 1) 
http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-de-datos-parte1-2166616-esa.html

Article-8: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 2)
http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte2-2167445-esa.html

Article-9: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 3)
http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte3-2167449-esa.html

Article-10: Todo lo que tienes que saber sobre COMMON y LOCAL en Oracle Database 12c
http://www.oracle.com/technetwork/es/articles/idm/common-local-12c-2190666-esa.html

Article-11: Oracle Database 12c: Una introducción a los conceptos de Respaldo, Recuperación y Recuperación a 
un punto en el tiempo (PITR) de PDBs
http://www.oracle.com/technetwork/es/articles/database-performance/pdbs-backup-recovery-dbpitr-2192211-esa.html

Article-12: Migración a la versión 12c de la base de datos Oracle sin interrupción de servicio usando Oracle Golden Gate 12c
http://www.oracle.com/technetwork/es/articles/datawarehouse/oracle-golden-gate-2192209-esa.html

Article-13: RMAN: Como hacer para Restaurar y/o Recuperar solo los "Tablespaces" esenciales
http://www.oracle.com/technetwork/es/articles/database-performance/restaurar-recuperar-tablespaces-2228109-esa.html

Article-14: Oracle Standby Database, un "amigo" para 1000 casos
http://www.oracle.com/technetwork/es/articles/database-performance/oracle-standby-database-2232804-esa.html

Article-15: Oracle Database 12c: Data Redaction
http://www.oracle.com/technetwork/es/articles/idm/oracle-data-redaction-12c-esp-2226725-esa.html

Article-16: Oracle Database 12c: Cómo usar archivos “XML Manifest” para conectar y desconectar PDBs
http://www.oracle.com/technetwork/es/articles/sql/xml-manifest-pdbs-2244550-esa.html

Article-17: Creación de un reporte simple usando Information Publisher Report.
http://www.oracle.com/technetwork/es/articles/oem/reportes-con-information-publisher-2492705-esa.html

Article-18: Oracle Database as a Service (DBaaS): Aplicando Parches con un clic
http://www.oracle.com/technetwork/es/articles/database-performance/aplicar-parche-oracle-dbaas-3338001-esa.html

Article-19: Oracle Database 12c Multitenant: Métodos de Upgrade
http://www.oracle.com/technetwork/es/articles/database-performance/multitenant-metodos-de-upgrade-3351666-esa.html

Article-20: Replicación consolidada y en cascada (DDL and DML) usando Oracle GoldenGate (11g y 12c) entre 
Bases de Datos Oracle (11g y 12c)
http://www.oracle.com/technetwork/es/articles/database-performance/consolidada-cascada-ddl-dml-3418927-esa.html

Article-21: Arquitectura y Setup de FileSystems ACFS en Oracle 12c RAC de 3 Nodos con Flex ASM
http://www.oracle.com/technetwork/es/articles/database-performance/setup-filesystems-acfs-flex-asm-3427843-esa.html

Article-22: Replicación de datos con múltiples procesos "Extract" y "Replicat" con el modo de captura integrada 
utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/es/articles/database-performance/replicacion-datos-multiples-proceso-3661869-esa.html

Article-23: Oracle Exadata Database Machine - Funcionalidad :Disk Scrubbing
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-db-machine-disk-scrubbing-3679915-esa.html

Article-24: Replicación entre IBM DB2 LUW y Oracle Database utilizando Oracle GoldenGate Parte I
http://www.oracle.com/technetwork/es/articles/database-performance/repliacion-ibm-3713613-esa.html

Article-25: Clonación en Caliente de una Pluggable Database (PDB) en Ambiente Multi-Tenant con Oracle Database 12c R2.
http://www.oracle.com/technetwork/es/articles/database-performance/clonacion-pdb-3713590-esa.html

Article-26: Uso de OAKCLI en Oracle Database Appliance (ODA) X5-2 con Alta Disponibilidad.
http://www.oracle.com/technetwork/es/articles/database-performance/uso-de-oakcli-3709129-esa.html

Article-27: Replicación de múltiples bases de datos “Pluggable” (PDBs) en una arquitectura 
“Multitenant” utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/es/articles/database-performance/bases-de-datos-pluggable-3708769-  esa.html

Article-28: Replicacion bidireccional con base de datos Pluggable (PDB) en una arquitectura Multitenant utilizando 
Oracle GoldenGate 12c
http://www.oracle.com/technetwork/es/articles/database-performance/replicacion-bidireccional-3737802-esa.html

Article-29: Reubicando Pluggable Database (PDB) en Modo READ WRITE en Ambiente MultiTenant con Real Application Cluster (RAC)
http://www.oracle.com/technetwork/es/articles/database-performance/default-3754342-esa.html

Article-30: Performance Profiles para PDBs en Oracle Database 12c Release 2
http://www.oracle.com/technetwork/es/articles/database-performance/perform-profile-3803116-esa.html

Article-31: Consultando Impala y Hive desde Oracle usando un gateway heterogeneo ODBC
http://www.oracle.com/technetwork/es/articles/database-performance/default-3679880-esa.html

Article-32: Creando puntos de restauración de base de datos utilizando snapshots ZFS de Oracle Solaris
http://www.oracle.com/technetwork/es/articles/database-performance/restaura-db-snapshots-zfs-oracle-3679894-esa.html

Article-33: Configuración y administración de Oracle Database Vault 12c en un ambiente “Multitenant” utilizando 
Oracle Enterprise Manager 12c.
http://www.oracle.com/technetwork/es/articles/database-performance/databasevault-12c-multitenant-3703502-esa.html

Article-34: Flashback Pluggable Database (PDB) en Ambiente Multi-Tenant con Oracle Database 12c R2.
http://www.oracle.com/technetwork/es/articles/database-performance/flashback-pdb-3715323-esa.html

Article-35: Instalación de Parches de Servidor, Discos y Base de Datos en un Oracle Database Appliance (ODA) 
X5-2 High Availability (HA)
http://www.oracle.com/technetwork/es/articles/database-performance/parches-discos-3803644-esa.html

Article-36: Juego de Caracteres de PDBs, Como limitar IO por PDB y Como Configurar Memoria por PDB en Ambientes 
Multi-Tenant Usando Oracle 12c R2 (12.2.0.1.0)
http://www.oracle.com/technetwork/es/articles/database-performance/juegodecaracteres-3873458-esa.html
      

Oracle Technology Network (OTN) – Portuguese           (29 Articles)


Article-37: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 1)
http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-nivel-asm-banco-de-dados-2129933-ptb.html

Article-38: Oracle Exadata Database Machine X3: “Smart Flash Logging”
http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-smart-flash-logging-2132507-ptb.html

Article-39: Oracle Exadata Database Machine: “Write-Back Flash Cache”
http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-write-back-flash-cache-2164875-ptb.html

Article-40: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 2)
http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-asm-banco-dados-parte2-2166649-ptb.html

Article-41: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 3)
http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-asm-banco-de-dados-parte3-2166659-ptb.html

Article-42: Oracle RAC 12c:Flex ASM e Flex Cluster
http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-rac-12c-flex-asm-cluster-2172079-ptb.html

Article-43: Oracle Exadata Database Machine: Exachk
http://www.oracle.com/technetwork/pt/articles/servers-storage-admin/oracle-exadata-exachk-2209072-ptb.html

Article-44: Tudo o que você precisa saber sobre o Common e o Local no Oracle Database 12c
http://www.oracle.com/technetwork/pt/articles/idm/common-local-oracle-database-12c-2235405-ptb.html

Article-45: Funcionalidade Data Redaction - Oracle Database 12c
http://www.oracle.com/technetwork/pt/articles/idm/funcionalidade-data-redaction-12c-2209076-ptb.html

Article-46: Oracle Exadata Database Machine: “Exadata Hybrid Columnar Compression (EHCC)
http://www.oracle.com/technetwork/pt/articles/oem/oracle-hybrid-columnar-compression-2436203-ptb.html

Article-47: Oracle Database 12c: An introduction to concepts backup, recovery and recovery to a point in time (PITR) of PDBs
http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-databse-pitr-pdbs-2438403-ptb.html

Article-48: Migração para a versão 12c do Banco de Dados sem Downtime, utilizando Oracle Golden Gate
http://www.oracle.com/technetwork/pt/articles/datawarehouse/migracao-12-oracle-golden-gate-2479499-ptb.html

Article-49: Criação de um relatório simples utilizando o Information Publisher Report
http://www.oracle.com/technetwork/pt/articles/oem/information-publisher-report-oem-2488821-ptb.html

Article-50: Oracle Exadata Database Machine: I/O Resource Manager (IORM).
http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-resource-manager-iorm-2507896-ptb.html

Article-51: Replicação bi-direcional com Pluggable Database (PDB) utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-bi-direcional-com-pdbs-2931915-ptb.html

Article-52: Replicação de múltiplos Pluggable Databases em um Banco de Dados Multitenant utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-pdbs-oracle-goldengate-2941832-ptb.html

Article-53: Replicação de Dados com Múltiplos processos de Extração e Replicação em Modo de Captura Integrada no 
Oracle GoldenGate 12c
http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-dados-oracle-goldengate-2995049-ptb.html

Article-54: Opções de Atualização no Oracle 12c Multitenant Database
http://www.oracle.com/technetwork/pt/articles/database-performance/atualizacao-oracle-12c-multitenant-2996705-ptb.html

Article-55: Criando pontos de restauração para o banco de dados Oracle utilizando snapshots do Oracle Solaris ZFS
http://www.oracle.com/technetwork/pt/articles/database-performance/criando-point-in-time-snapshots-zfs-3215254-ptb.html

Article-56: Database as a Service (DBAAS): Aplicação de patches de forma simplificada
http://www.oracle.com/technetwork/pt/articles/database-performance/aplicando-patches-dbaas-3321593-ptb.html

Article-57: Replicação consolidada e em cascata combinadas (DDL e DML) usando Oracle GoldenGate (11g e 12c) entre 
Oracle databases (11g e 12c)
http://www.oracle.com/technetwork/pt/articles/database-performance/replica-ddl-dml-oracle-goldengate-3410097-ptb.html

Article-58: Replicação entre o IBM DB2 LUW e o Oracle Database 12c utilizando o Oracle GoldenGate - Parte 1
http://www.oracle.com/technetwork/pt/articles/database-performance/replicar-db2-database-goldengate-3496397-ptb.html

Article-59: Flashback Pluggable Database (PDB) emambiente Multi-Tenant usando Oracle Database 12c R2
http://www.oracle.com/technetwork/pt/articles/database-performance/flashback-3703752-ptb.html

Article-60: Clonando a quente umPluggable Database (PDB) emum ambiente Multi-Tenantusando Oracle Database 12c R2
http://www.oracle.com/technetwork/pt/articles/database-performance/pdb-multi-tenant-3746608-ptb.html

Article-61: Realocando Pluggable Database (PDB) em modo READ WRITE em ambiente Multi-Tenant com Real Application Cluster (RAC)
http://www.oracle.com/technetwork/pt/articles/database-performance/read-write-3755576-ptb.html

Article-62: Disk Scrubbing Feature Oracle Exadata Database Machine
http://www.oracle.com/technetwork/pt/articles/database-performance/disk-scrubbing-3758877-ptb.html

Article-63: Pluggable Database (PDB) Character sets, IORM e Configurações de memória em um ambiente Multi-Tenant usando 
Oracle 12c R2 (12.2.0.1.0)
http://www.oracle.com/technetwork/pt/articles/database-performance/iorm-pdb-3760315-ptb.html

Article-64: Uso do OAKCLI em Oracle Database Appliance (ODA) X5-2 High Availability (HA)
http://www.oracle.com/technetwork/pt/articles/database-performance/oakcli-x5-3760326-ptb.html

Article-65: Pluggable Database Performance Profiles no Oracle Database 12c Release 2
http://www.oracle.com/technetwork/pt/articles/database-performance/profiles-3835567-ptb.html

Oracle Technology Network (OTN) – English               (8 Articles)


Article-66: An Insight into Oracle Flex ASM and Its Benefits
http://www.oracle.com/technetwork/articles/database/flexasm-flexcluster-benefits-odb12c-2177371.html

Article-67: Oracle Exadata Database Machine – Write-Back Flash Cache
http://www.oracle.com/technetwork/articles/database/exadata-write-back-flash-2179184.html

Article-68: Multiple Pluggable Database (PDBs) Replication in Multitenant Database Using Oracle GoldenGate 12c
https://community.oracle.com/docs/DOC-995763

Article-69: Data Replication with Multiple Extracts and Multiple Replicats with Integrated Capture Mode Using 
Oracle GoldenGate 12c
https://community.oracle.com/docs/DOC-995764

Article-70: Upgrade Options In Oracle 12c Multitenant Database
https://community.oracle.com/docs/DOC-995765

Article-71: Bi-Directional Replication with Pluggable Database (PDB) in Multitenant Database Using Oracle GoldenGate 12c
https://community.oracle.com/docs/DOC-995762

Article-72: How To Query Hive and Impala from Oracle using ODBC Heterogeneous Gateway
https://community.oracle.com/docs/DOC-1002634

Article-73: Database Patching: Patch like a King with a Single Click – Database As A Service (DbaaS)
https://community.oracle.com/docs/DOC-1005964

United Kingdom Oracle User Group (UKOUG) – English             (2 Articles)


Article-74: MAA/Data Guard 12c Setup Guide: Creating a RAC Physical Standby Database for a RAC Primary Database
http://www.ukoug.org/what-we-offer/library/maadata-guard-12c-setup-guide-creating-a-rac-physical-
standby-database-for-a-rac-primary-database/

Article-75: Integrating Global Service Manager (GSM) and Managing Global Data Services (GDS) with EM Cloud Control 13c
https://www.ukoug.org/what-we-offer/library/integrating-global-service-manager-gsm-and-managing-global-data-
services-gds-with-em-cloud-control-13c/

OTech Magazine – English                            (3 Articles)


Article-76: Bi-Directional Replication with conflict detection and resolution (CDR) using Oracle GoldenGate 12c
http://otechmag.com/magazine/2015/summer/ravikumar-yv.html

Article-77: Oracle 12c (12.1.0.2.0) Standard Edition (SE2) with Multitenant Environment with High Availability Options
http://www.otechmag.com/magazine/2015/fall/ravikumar-yv.html

Article-78: Oracle Database 12c - Global Data Services (GDS) / Global Service Manager (GSM)
http://www.otechmag.com/magazine/2015/winter/ravikumar-yv.html

All things ORACLE from redgate – English                        (2 Articles)


Article-79: Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c.
http://allthingsoracle.com/upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c/

Article-80: Integrated DDL and DML with Encrypt using Oracle GoldenGate 12c.
http://allthingsoracle.com/integrated-ddl-and-dml-with-encrypt-using-oracle-goldengate-12c/

DELL’s Toad World (Connected Intelligence) – English                    (20 Articles)


Article-81: Oracle Exadata Database Machine - DCLI Introduction and Setup
http://www.toadworld.com/platforms/oracle/w/wiki/11009.oracle-exadata-database-machine-dcli-introduction-and-setup.aspx

Article-82: Rolling RECO data disk group resize activity for Oracle Exadata Database Machine
http://www.toadworld.com/platforms/oracle/w/wiki/11021.rolling-reco-data-disk-group-resize-activity-for-
oracle-exadata-database-machine.aspx

Article-83: Container Database (CDB) with Pluggable Databases (PDBs) in Oracle 12c RAC
http://www.toadworld.com/platforms/oracle/w/wiki/11059.container-database-cdb-with-pluggable-databases-
pdbs-in-oracle-12c-rac.aspx

Article-84: Recovering Table in Non-Container Database and Pluggable Database (PDB) in Container Database (CDB)
http://www.toadworld.com/platforms/oracle/w/wiki/11065.recovering-table-in-non-container-database-and-
pluggable-database-pdb-in-container-database-cdb.aspx

Article-85: Oracle Database In-Memory Option
http://www.toadworld.com/platforms/oracle/w/wiki/11083.oracle-database-in-memory-option.aspx

Article-86: The Unified Audit features of Oracle Database 12c
http://www.toadworld.com/platforms/oracle/w/wiki/11102.the-unified-audit-features-of-oracle-database-12c.aspx

Article-87: Converting RAC One Node Container Database with PDB to RAC Container Database with PDB
http://www.toadworld.com/platforms/oracle/w/wiki/11136.converting-rac-one-node-container-database-with-pdb-to-
rac-container-database-with-pdb.aspx

Article-88: Real-Time Downstream Integrated Capture between Oracle 11g and Oracle 12c using Oracle GoldenGate 12c
http://www.toadworld.com/platforms/oracle/w/wiki/11186.real-time-downstream-integrated-capture-between-oracle-11g-and-
oracle-12c-using-oracle-goldengate-12c.aspx

Article-89: Restore and Recovery Pluggable Database (PDB) after dropping Pluggable Database (PDB) in Multitenant Environment
http://www.toadworld.com/platforms/oracle/w/wiki/11197.restore-and-recovery-pluggable-database-pdb-after-dropping-
pluggable-database-pdb-in-multitenant-environment

Article-90: Database upgrade from Oracle 11gR2 to Oracle 12c Pluggable Database (PDB) in Multitenant Architecture 
using Transportable Tablespace (TTS) method
http://www.toadworld.com/platforms/oracle/w/wiki/11357.database-upgrade-from-oracle-11gr2-to-oracle-12c-pluggable-
database-pdb-in-multitenant-architecture-using-transportable-tablespace-tts-method

Article-91: Creating RAC Physical Standby Container Database for a RAC Primary Container Database with Pluggable 
Databases (PDBs) in Multitenant Environment
http://www.toadworld.com/platforms/oracle/w/wiki/11373.creating-rac-physical-standby-container-database-for-a-
rac-primary-container-database-with-pluggable-databases-pdbs-in-multitenant-environment

Article-92: Upgrade Pluggable Database (PDB) from One Container Database (12.1.0.1) to another Container Database 
(12.1.0.2) In Multitenant Environment
http://www.toadworld.com/platforms/oracle/w/wiki/11374.upgrade-pluggable-database-pdb-from-one-container-database-
12-1-0-1-to-another-container-database-12-1-0-2-in-multitenant-environment

Article-93: Database upgrade from Oracle 11g (11.2.0.4.0) to Oracle 12c (12.1.0.2.0) using logical standby database method
http://www.toadworld.com/platforms/oracle/w/wiki/11429.database-upgrade-from-oracle-11g-11-2-0-4-0-to-oracle-12c-
12-1-0-2-0-using-logical-standby-database-method

Article-94:Removing Node and Adding Node from the Cluster for Oracle 12c (12.1.0.2.0) Real Application Clusters (RAC)
http://www.toadworld.com/platforms/oracle/w/wiki/11430.removing-node-and-adding-node-from-the-cluster-for-oracle-
12c-12-1-0-2-0-real-application-clusters-rac

Article-95:Oracle Database 12c (12.1.0.2.0) Multitenant New Features with Real Application Clusters (RAC)
http://www.toadworld.com/platforms/oracle/w/wiki/11437.oracle-database-12c-12-1-0-2-0-multitenant-new-features-
with-real-application-clusters-rac

Article-96: Database Resource Manager (DBRM) In Real Application Cluster (RAC) and Managing resources between 
Pluggable Databases (PDBs) in Multitenant Environment
http://www.toadworld.com/platforms/oracle/w/wiki/11512.database-resource-manager-dbrm-in-real-application-cluster-
rac-and-managing-resources-between-pluggable-databases-pdbs-in-multitenant-environment

Article-97: Creating Physical Standby Database Setup with DGMGRL for Container Database with pluggable databases 
using Oracle Enterprise Manager Cloud Control 13c
http://www.toadworld.com/platforms/oracle/w/wiki/11525.creating-physical-standby-database-setup-with-dgmgrl-for-
container-database-with-pluggable-databases-using-oracle-enterprise-manager-cloud-control-13c

Article-98:Cloning Container Database (CDB) with Pluggable Databases (PDBs) Using Enterprise Manager Cloud Control 13c 
http://www.toadworld.com/platforms/oracle/w/wiki/11592.cloning-container-database-cdb-with-pluggable-databases-
pdbs-using-enterprise-manager-cloud-control-13c

Article-99: Oracle Database 12c – Partition Table Enhancements (Interval reference, Cascading Truncate and Exchange 
Operations) for Pluggable database (PDB) in Container Database (CDB)
http://www.toadworld.com/platforms/oracle/w/wiki/11605.oracle-database-12c-partition-table-enhancements-interval-
reference-cascading-truncate-and-exchange-operations-for-pluggable-database-pdb-in-container-database-cdb

Article-100: Role of Grid Infrastructure Management Repository (GIMR) database in Oracle 12c Real Application Cluster 
(RAC) R1 (12.1.0.2.0) environment
https://www.toadworld.com/platforms/oracle/b/weblog/archive/2016/12/05/role-of-grid-infrastructure-management-repository

IT Central Station – English                            (1 Article)

Article-101: With Multi-Tenancy, You Can Set Up Background Processes And Memory At The Container Level
https://www.itcentralstation.com/product_reviews/oracle-database-review-39827-by-architec8a80?gitb_token=
IWlcGsIWsWpa-0eTVVv2KQ&tid=um-npro-post

Thursday, September 14, 2017

RAC Rolling Patch - Oracle Database 12c Release 12.1.0.2.0 - PLSQL Patch for Bug# 21519686 for Linux-x86-64 Platforms



RAC Rolling Patch - Oracle Database 12c Release 12.1.0.2.0 - PLSQL Patch for Bug# 21519686 for Linux-x86-64 Platforms


[oracle@rac1-12c ~]$
[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle    5192     1  0 01:51 ?        00:00:00 asm_pmon_+ASM1
oracle    9881     1  0 01:53 ?        00:00:00 mdb_pmon_-MGMTDB
oracle    9973     1  0 01:53 ?        00:00:00 ora_pmon_orcl1
oracle   10278     1  0 01:53 ?        00:00:00 ora_pmon_corcldb1
oracle   15951 13690  0 01:57 pts/1    00:00:00 grep pmon

[oracle@rac1-12c ~]$ ls -lrth p*
-rw-r--r-- 1 oracle oinstall 114K Sep 15 01:52 p21519686_121020_Linux-x86-64.zip

[oracle@rac1-12c ~]$ scp p21519686_121020_Linux-x86-64.zip oracle@192.168.2.102:/home/oracle
p21519686_121020_Linux-x86-64.zip                     100%  113KB 113.4KB/s   00:00

[oracle@rac1-12c ~]$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch
[oracle@rac1-12c OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-03-07AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-03-07AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
  Local node = rac1-12c
  Remote node = rac2-12c
--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@rac1-12c OPatch]$ . oraenv
ORACLE_SID = [orcl1] ? orcl1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac1-12c OPatch]$ srvctl stop instance -d orcl -i orcl1 -f

[oracle@rac1-12c OPatch]$ ps -ef | grep pmon
oracle    5192     1  0 01:51 ?        00:00:00 asm_pmon_+ASM1
oracle    9881     1  0 01:53 ?        00:00:00 mdb_pmon_-MGMTDB
oracle   10278     1  0 01:53 ?        00:00:00 ora_pmon_corcldb1
oracle   19007 13690  0 02:05 pts/1    00:00:00 grep pmon

[oracle@rac1-12c OPatch]$ srvctl stop instance -d corcldb -i corcldb1 -f

[oracle@rac1-12c OPatch]$ ps -ef | grep pmon
oracle    5192     1  0 01:51 ?        00:00:00 asm_pmon_+ASM1
oracle    9881     1  0 01:53 ?        00:00:00 mdb_pmon_-MGMTDB
oracle   19314 13690  0 02:06 pts/1    00:00:00 grep pmon

[oracle@rac1-12c OPatch]$ cd
[oracle@rac1-12c ~]$
[oracle@rac1-12c ~]$ cd /home/oracle/
[oracle@rac1-12c ~]$ unzip p21519686_121020_Linux-x86-64.zip
Archive:  p21519686_121020_Linux-x86-64.zip
   creating: 21519686/
   creating: 21519686/files/
   creating: 21519686/files/lib/
   creating: 21519686/files/lib/libserver12.a/
  inflating: 21519686/files/lib/libserver12.a/kkxm.o
   creating: 21519686/etc/
   creating: 21519686/etc/config/
  inflating: 21519686/etc/config/actions.xml
  inflating: 21519686/etc/config/inventory.xml
   creating: 21519686/online/
   creating: 21519686/online/files/
   creating: 21519686/online/files/hpatch/
  inflating: 21519686/online/files/hpatch/bug21519686.pch
   creating: 21519686/online/etc/
   creating: 21519686/online/etc/config/
  inflating: 21519686/online/etc/config/inventory.xml
  inflating: 21519686/online/etc/config/deploy.xml
  inflating: 21519686/online/etc/config/actions.xml
   creating: 21519686/online/etc/xml/
  inflating: 21519686/online/etc/xml/GenericActions.xml
  inflating: 21519686/online/etc/xml/ShiphomeDirectoryStructure.xml
  inflating: 21519686/README.txt

[oracle@rac1-12c ~]$ cd 21519686/
[oracle@rac1-12c 21519686]$ pwd
/home/oracle/21519686

[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-07-01AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   21519686

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21519686' to OH '/u01/app/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...
Patch 21519686 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-07-01AM_1.log

OPatch succeeded.

[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
21519686;

OPatch succeeded.

[oracle@rac1-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-08-40AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-08-40AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  21519686     : applied on Fri Sep 15 02:07:26 IST 2017
Unique Patch ID:  20178159
   Created on 9 May 2016, 09:28:22 hrs PST8PDT
   Bugs fixed:
     21519686

Rac system comprising of multiple nodes
  Local node = rac1-12c
  Remote node = rac2-12c

--------------------------------------------------------------------------------

OPatch succeeded.


[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle    5192     1  0 01:51 ?        00:00:00 asm_pmon_+ASM1
oracle    9881     1  0 01:53 ?        00:00:00 mdb_pmon_-MGMTDB
oracle   21486 13690  0 02:10 pts/1    00:00:00 grep pmon

[oracle@rac1-12c ~]$ srvctl start instance -d orcl -i orcl1

[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle    5192     1  0 01:51 ?        00:00:00 asm_pmon_+ASM1
oracle    9881     1  0 01:53 ?        00:00:00 mdb_pmon_-MGMTDB
oracle   21704     1  0 02:11 ?        00:00:00 ora_pmon_orcl1
oracle   22112 13690  0 02:11 pts/1    00:00:00 grep pmon

[oracle@rac1-12c ~]$ srvctl start instance -d corcldb -i corcldb1

[oracle@rac1-12c ~]$ ps -ef | grep pmon
oracle    5192     1  0 01:51 ?        00:00:00 asm_pmon_+ASM1
oracle    9881     1  0 01:53 ?        00:00:00 mdb_pmon_-MGMTDB
oracle   21704     1  0 02:11 ?        00:00:00 ora_pmon_orcl1
oracle   22885     1  0 02:12 ?        00:00:00 ora_pmon_corcldb1
oracle   23551 13690  0 02:14 pts/1    00:00:00 grep pmon

[oracle@rac1-12c ~]$ . oraenv
ORACLE_SID = [orcl1] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@rac1-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 15 02:14:13 2017
Copyright (c) 1982, 2014, Oracle.  All rights reserved.


SQL> connect sys/oracle@orcl as sysdba
Connected.

SQL> select instance_name,instance_number from gv$instance;

INSTANCE_NAME    INSTANCE_NUMBER
---------------- ---------------
orcl2                          2
orcl1                          1

SQL> exit

Login to Node-2
==================

[oracle@rac1-12c ~]$ ssh rac2-12c
Last login: Fri Sep 15 01:59:43 2017 from 192.168.2.1

[oracle@rac2-12c ~]$ ls -la p*
-rw-r--r-- 1 oracle oinstall     116093 Sep 15 01:59 p21519686_121020_Linux-x86-64.zip

[oracle@rac2-12c ~]$ chmod -R 777 p21519686_121020_Linux-x86-64.zip

[oracle@rac2-12c ~]$ unzip p21519686_121020_Linux-x86-64.zip
Archive:  p21519686_121020_Linux-x86-64.zip
   creating: 21519686/
   creating: 21519686/files/
   creating: 21519686/files/lib/
   creating: 21519686/files/lib/libserver12.a/
  inflating: 21519686/files/lib/libserver12.a/kkxm.o
   creating: 21519686/etc/
   creating: 21519686/etc/config/
  inflating: 21519686/etc/config/actions.xml
  inflating: 21519686/etc/config/inventory.xml
   creating: 21519686/online/
   creating: 21519686/online/files/
   creating: 21519686/online/files/hpatch/
  inflating: 21519686/online/files/hpatch/bug21519686.pch
   creating: 21519686/online/etc/
   creating: 21519686/online/etc/config/
  inflating: 21519686/online/etc/config/inventory.xml
  inflating: 21519686/online/etc/config/deploy.xml
  inflating: 21519686/online/etc/config/actions.xml
   creating: 21519686/online/etc/xml/
  inflating: 21519686/online/etc/xml/GenericActions.xml
  inflating: 21519686/online/etc/xml/ShiphomeDirectoryStructure.xml
  inflating: 21519686/README.txt

[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle    5238     1  0 01:52 ?        00:00:00 asm_pmon_+ASM2
oracle   11098     1  0 01:53 ?        00:00:00 ora_pmon_corcldb2
oracle   12326     1  0 01:55 ?        00:00:00 ora_pmon_orcl2
oracle   22816 22605  0 02:15 pts/1    00:00:00 grep pmon

[oracle@rac2-12c ~]$ srvctl stop instance -d orcl -i orcl2 -f
[oracle@rac2-12c ~]$ srvctl stop instance -d corcldb -i corcldb2 -f

[oracle@rac2-12c ~]$ ps -ef | grep pmon
oracle    5238     1  0 01:52 ?        00:00:00 asm_pmon_+ASM2
oracle   23780 22605  0 02:16 pts/1    00:00:00 grep pmon

[oracle@rac2-12c ~]$ cd /home/oracle/21519686/
[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/12.1.0.2/db_1".

OPatch succeeded.

[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-06AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-17-06AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
  Local node = rac2-12c
  Remote node = rac1-12c

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch apply -local
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-16AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   21519686

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0.2/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '21519686' to OH '/u01/app/oracle/product/12.1.0.2/db_1'

Patching component oracle.rdbms, 12.1.0.2.0...
Patch 21519686 successfully applied.
Log file location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-16AM_1.log

OPatch succeeded.

[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lspatches
21519686;

OPatch succeeded.

[oracle@rac2-12c 21519686]$ /u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version    : 12.2.0.1.8
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-09-15_02-17-51AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-09-15_02-17-51AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac2-12c.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.2.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  21519686     : applied on Fri Sep 15 02:17:28 IST 2017
Unique Patch ID:  20178159
   Created on 9 May 2016, 09:28:22 hrs PST8PDT
   Bugs fixed:
     21519686

Rac system comprising of multiple nodes
  Local node = rac2-12c
  Remote node = rac1-12c
--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@rac2-12c 21519686]$ ps -ef | grep pmon
oracle    5238     1  0 01:52 ?        00:00:00 asm_pmon_+ASM2
oracle   24957 22605  0 02:17 pts/1    00:00:00 grep pmon

[oracle@rac2-12c 21519686]$ srvctl start instance -d orcl -i orcl2
[oracle@rac2-12c 21519686]$ srvctl start instance -d corcldb -i corcldb2

[oracle@rac2-12c 21519686]$ ps -ef | grep pmon
oracle    5238     1  0 01:52 ?        00:00:00 asm_pmon_+ASM2
oracle   25197     1  0 02:18 ?        00:00:00 ora_pmon_orcl2
oracle   25829     1  0 02:19 ?        00:00:00 ora_pmon_corcldb2
oracle   26892 22605  0 02:20 pts/1    00:00:00 grep pmon

[oracle@rac2-12c 21519686]$ . oraenv
ORACLE_SID = [orcl2] ? orcl
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@rac2-12c 21519686]$ cd

[oracle@rac2-12c ~]$ sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 15 02:21:10 2017
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect sys/oracle@orcl as sysdba
Connected.

SQL> select instance_name,instance_number from gv$instance;

INSTANCE_NAME    INSTANCE_NUMBER
---------------- ---------------
orcl1                          1
orcl2                          2

SQL> exit

[oracle@rac2-12c ~]$ srvctl status database -d orcl
Instance orcl1 is running on node rac1-12c
Instance orcl2 is running on node rac2-12c

[oracle@rac2-12c ~]$ srvctl status database -d corcldb
Instance corcldb1 is running on node rac1-12c
Instance corcldb2 is running on node rac2-12c

Sunday, August 20, 2017

Oracle GoldenGate Version 12.3.0.1.0 Supports Oracle Database 12cR2 (12.2.0.1.0)


Oracle GoldenGate Version 12.3.0.1.0 Supports Oracle Database 12cR2 (12.2.0.1.0)



Login to Oracle GoldenGate and check Extract (ES01), Pump (PS01) and Replicat Process (RS01)




Login to Source Pluggable Database (SPDB) and Insert the transaction and Check Target Pluggable Database (TPDB)



Summary: Oracle GoldenGate Version 12.3.0.1.0 Supports Oracle Database 12cR2 (12.2.0.1.0)