Mallik034: June 2021

Wednesday, June 30, 2021

Download and Configure Terraform and Verify the Terraform Version

You can download the terraform software from Terraform official website (https://www.terraform.io/downloads.html)

Terraform Software Supports on various OS:

Linux

Windows

MacOS

Solaris

etc…

You can download for 64 bit or 32 bit software based on you OS architecture.

Download and configure for Windows:

1. Download terraform software for windows

2. Extract/unzip the software.

3. Open “Edit the system environment variable” from windows/run prompt

4. Click Environment Variables

5. Click on Path setting and add the Terraform software PATH

6. Save the setting

7. Open the command prompt and verify the Terraform version

Download and configure for Linux:

1. Download terraform software for Linux OS.

2. A) If you downloaded Terraform software on windows system then use

Winscp tool to copy Terraform software from Windows to Linux server

B) You can directly download the Terraform software on Linux Server user wget command

[root@oraclemv terraform]# wget https://releases.hashicorp.com/terraform/1.0.1/terraform_1.0.1_linux_amd64.zip

--2021-06-30 14:16:23-- https://releases.hashicorp.com/terraform/1.0.1/terraform_1.0.1_linux_amd64.zip

Resolving releases.hashicorp.com (releases.hashicorp.com)... 151.101.41.183, 2a04:4e42:a::439

Connecting to releases.hashicorp.com (releases.hashicorp.com)|151.101.41.183|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 33044548 (32M) [application/zip]

Saving to: ‘terraform_1.0.1_linux_amd64.zip’

100%[==========================================>] 33,044,548 8.55MB/s in 4.8s

2021-06-30 14:16:29 (6.62 MB/s) - ‘terraform_1.0.1_linux_amd64.zip’ saved [33044548/33044548]

[root@oraclemv terraform]#

3. Extract/unzip the software on Linux Server on any location.

4. Once the extract is done you will see the software “terraform”,

you can copy that file to /usr/bin/ or /usr/sbin/

[root@oraclemv terraform]# ls -ltrh

total 109M

-rwxr-xr-x. 1 root root 77M Jun 24 20:39 terraform

-rw-r--r--. 1 root root 32M Jun 30 14:09 terraform_1.0.1_linux_amd64.zip

[root@oraclemv terraform]# cp terraform /usr/bin/

[root@oraclemv terraform]# cp terraform /usr/sbin/

[root@oraclemv terraform]#

5. Verify the terraform version using below command

[root@oraclemv terraform]# which terraform

/usr/sbin/terraform

[root@oraclemv terraform]# terraform version

Terraform v1.0.1

on linux_amd64

[root@oraclemv terraform]#

Regards,

Mallik

Friday, June 25, 2021

What is Terraform?

IAC – Infrastructure as a code

Terraform is a tool that we can use this tool as IAC.

With help of Terraform we can perform below operations/tasks on our Infrastructure.
>>> Provision
>>> Updating
>>> Deleting

Terraform is an IAC Software by HashiCorp.

https://www.hashicorp.com (HashiCorp Official Site)

Terraform provides you capability to create, change, update, improve, delete and versioning your infrastructure

Terraform is multi-cloud IAC tool.

What that mean multi-cloud IAC tool is you can use Terraform on all major cloud provider to managed your Infrastructure
Example: AWS, GCP, AZURE, VMware, IBM, Openstack, etc..

Terraform is written in GO language
GO language (https://golang.org)

Similar Tool like Terraform are:

Terraform

AWS Cloud Formation

Azure Resource Manager

Google Cloud Deployment Manager etc…

Other Cloud Vendors
(VMware, Opestack, Kubernetes)

Regards,
Mallik

What is infrastructure? and What is infrastructure as code (IAC)?

What is infrastructure?
What is infrastructure as code (IAC)?
What are IAC software/tools?

Infrastructure?

>>> Framework (Resource to Run Application or Software)

>>> Its might be Physical or Virtual to support workflow or to support your Application

Workflow Means

>>> Storing & Processing & Analysis of data (Business Data / End user data)

Infrastructure Components:

(Servers, Network, Storage, Database, Load Balancer, DNS many more)

Infrastructure Types:

PROD Environment

DR Environment

UAT Environment

TEST Environment

DEV/SIT Environment

SDLC (Software Development Life Cycle):

DEV/SIT --- TEST --- UAT --- PROD / DR

Most common requirement for Infrastructure is?

Scale Up and Scale Down your Infrastructure

>>> In case if your business increases then you need to scale up your Infrastructure.

>>> In case if your business is down then you need to scale down your Infrastructure.

To Do All these Tasks we use IAC – Infrastructure as code

>>> Provisioning infrastructure using script/tools instead of manually configuring.

>>> Automating the provisioning of infrastructure or Infrastructure Components.

Provisioning

- Creating

- Updating (Increase / Decrease)

- Deleting

IAC – Infrastructure as code

>>> Writing code that talks to your infrastructure and work with your infrastructure.

What are the advantages of using IAC?

>>> Create a new infrastructure with script (No need to login to console every time and create new infrastructure)

>>> Update your Infrastructure (Increase / Decrease).

>>> Delete Infrastructure

>>> Version history of your applications or servers or any infrastructure.

Tools:

Terraform

AWS Cloud Formation

Azure Resource Manager

Google Cloud Deployment Manager etc…

Other Cloud Vendors

(VMware, Opestack, Kubernetes)

Regards,

Mallik

Thursday, June 24, 2021

12c DataGuard Switch Over Steps || 2 Nodes RAC Database Switch Over Steps

12c Data guard Switchover Best Practices using SQLPLUS (Doc ID 1578787.1)
11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 1304939.1)

#########################################################################

Pre Checks:

1) Verify Managed Recovery Process is running on the standby

2) Verify there are no Gap betwbeen PROD and DR

Switchover:

1) Cancel any apply delay for the target standby and make both PROD and DR in sync

2) Create Guaranteed Restore Points (optional)

3) Verify that the primary database can be switched to the Standby Role

4) If The Primary is a RAC, then shutdown all other instances keeping one instances active.

5) Switchover the primary to a standby database first.

6) Verify that the standby database is not ready to be switched to the primary role

7) Switchover the standby database to a primary

8) Open new primary database

9) Restart the new standby with apply MRP preocess

PROD Env:

DB: RAC12C

Instances: RAC12C1 & RAC12C2

Server: node1.localdomain.com & node2.localdomain.com

Oracle Home: /u01/app/oracle/product/12.2.0.1/dbhome_1

DR Env:

DB: RACSB

Instances: RACSB1 & RACSB2

Server: oraclenode1.localdomain.com & oraclenode2.localdomain.com

Oracle Home: /u01/app/oracle/product/12.2.0.1/dbhome_1

Primary:

srvctl config database -d RAC12C

srvctl status database -d RAC12C

SQL> select name,open_mode,database_role from v$database;

Standby:

srvctl config database -d RACSB

srvctl status database -d RACSB

SQL> select name,open_mode,database_role from v$database;

Prechecks Checks:

Step 1: Check MRP is running on the standby or not:

SQL> SELECT PROCESS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE 'MRP%';

Execute the below statement in primary to check "real time apply"

SQL> SELECT RECOVERY_MODE FROM V$ARCHIVE_DEST_STATUS WHERE DEST_ID=2;

Start MRP on standby if it is not running:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Step 2: Verify both PROD and DR are in sync

Verify the state of data guard on both the databases with following SQL queries:

PROD:

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#;

SELECT THREAD#, SEQUENCE# FROM V$THREAD;

DR:

ALTER SESSION SET nls_date_format='DD-MON-YYYY HH24:MI:SS';

SELECT sequence#, first_time, next_time, applied FROM v$archived_log ORDER BY sequence#;

SELECT THREAD#, MAX(SEQUENCE#) FROM V$ARCHIVED_LOG

WHERE APPLIED = 'YES'

AND RESETLOGS_CHANGE# = (SELECT RESETLOGS_CHANGE#

FROM V$DATABASE_INCARNATION WHERE STATUS = 'CURRENT')

GROUP BY THREAD#;

Step 3: Cancel any apply delay for the on standby:

alter database recover managed standby database cancel;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE NODELAY DISCONNECT FROM SESSION;

Step 4: Create Guaranteed Restore Point (optional)

In 11g and 12c we need to create GRP point on both PROD and DR where as in 19c we need to create only on PROD.

DR:

Stop MRP process

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> CREATE RESTORE POINT SWITCHOVER_PROD_TO_DR GUARANTEE FLASHBACK DATABASE;

Start MRP process:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

PROD:

Create a guaranteed restore point

CREATE RESTORE POINT SWITCHOVER_PROD_TO_DR GUARANTEE FLASHBACK DATABASE;

Step 5: Verify the database is ready for switch over or not?

SQL> alter database switchover to RACSB verify;

Step 6: Verify that the primary database can be switched over to the standby role

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

Step 7: If The Primary is a RAC, then shutdown all other instatances keep only one active:

srvctl status database -d RAC12C

srvctl stop instance -d RAC12C -i RAC12C2

Step 8: Switchover the primary to a standby database

ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY;

tail -f alert_RAC12C1.log

Step 9: Verify that the standby database can be switched to the primary role

SELECT SWITCHOVER_STATUS FROM V$DATABASE;

Step 10: Switchover the standby database to a primary

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

tail -f alert_RACSB1.log

Step 11: Open the new primary database

ALTER DATABASE OPEN;

srvctl status database -d RACSB

Step 12: Start the new standby and start recovery

STARTUP MOUNT;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

Step 13: Post Switchover drop the GRP:

On New Standby:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> DROP RESTORE POINT SWITCHOVER_PROD_TO_DR;

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

On New Primary:

SQL> DROP RESTORE POINT SWITCHOVER_PROD_TO_DR;

Note: Some useful commands:

===========================

Enable and disable log_archive_dest_state_2 / log shipping to standby:

alter system set log_archive_dest_state_2=DEFER scope=both sid='*';

alter system set log_archive_dest_state_2=enable scope=both sid='*';

Start and stop the log shipping apply at DR database:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;

alter database recover managed standby database cancel;

How to add/Remove listener to Cluster:

srvctl add listener -l LISTENER_RACSB -p 1523 -o /u01/app/oracle/product/12.2.0.1/dbhome_1

srvctl start listener -l LISTENER_RACSB

srvctl stop listener -l LISTENER_RACSB

srvctl status listener -l LISTENER_RACSB

lsnrctl status LISTENER_RACSB

lsnrctl start LISTENER_RACSB

lsnrctl stop LISTENER_RACSB

srvctl remove listener -l LISTENER_RACSB

srvctl config listener -l LISTENER_RACSB

Move Password file to DiskGroup on from local storage:

ASMCMD>mkdir +DATA/RACSB

ASMCMD>pwcopy '/tmp/orapwRAC12C' '+DATA/RACSB/orapwRACSB'

How to set the password location using srvctl:

srvctl modify database -d RACSB -pwfile '+DATA/RACSB/PASSWORD/orapwRACSB'

Verify Standby Logs:

select * from v$standby_log;

select group#, thread#, sequence#, archived, status from v$standby_log;

set lines 190 pages 190

col instance for a8

col member for a50

SELECT t.INSTANCE, l.THREAD#, l.GROUP#, l.SEQUENCE#, l.bytes, l.archived, l.status, lf.MEMBER

FROM v$log l, v$logfile lf, v$thread t

WHERE t.THREAD# = l.THREAD#

AND l.GROUP# = lf.GROUP#

ORDER BY l.THREAD#, GROUP#;

col member format a50

select GROUP#,TYPE,MEMBER from v$logfile;

select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024, MEMBERS,STATUS from v$log;

Regards,

Mallik

Tuesday, June 15, 2021

19c CDB and PDM Basic Administration Or Multitenant Database Administration

How to create common user at CDB level:

[oracle@oraclerac1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclerac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

[oracle@oraclerac1 admin]$

[oracle@oraclerac1 admin]$ tnsping ORCL
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:03:10
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclerac-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (10 msec)
[oracle@oraclerac1 admin]$

[oracle@oraclerac1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 18:03:22 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL> create user mallik identified by mallik;
create user mallik identified by mallik
*
ERROR at line 1:
ORA-65096: invalid common user or role name
SQL> create user c##_mallik identified by mallik;
User created.
SQL> grant dba to c##_mallik;
Grant succeeded.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@oraclerac1 admin]$ sqlplus c##_mallik/mallik@ORCL
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 18:04:35 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show user
USER is "C##_MALLIK"
SQL>

How to create local user at PDB level:

[oracle@oraclerac1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 18:05:36 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SQL>
SQL> alter session set container=PDB;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB READ WRITE NO
SQL>
SQL> create user mallik identified by mallik;
User created.
SQL> grant dba to mallik;
Grant succeeded.
SQL>

Default service names in PDB:

[oracle@oraclerac1 ~]$ . oraenv
ORACLE_SID = [+ASM1] ? orcl1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oraclerac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 18:09:35 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL>

[oracle@oraclerac1 admin]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:52:35
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 05-FEB-2021 22:22:06
Uptime 0 days 20 hr. 30 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oraclerac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.35.36.229)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.35.36.233)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "ba9c19dc75cf1dc2e053e524230a9483" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "pdb" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oraclerac1 admin]$

[oracle@oraclerac1 ~]$ lsnrctl service
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:12:09
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "ba9c19dc75cf1dc2e053e524230a9483" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: oraclerac1.localdomain.com, pid: 23742>
(ADDRESS=(PROTOCOL=tcp)(HOST=oraclerac1.localdomain.com)(PORT=23821))
Service "pdb" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@oraclerac1 ~]$

[oracle@oraclerac1 admin]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin
[oracle@oraclerac1 admin]$
[oracle@oraclerac1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclerac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oraclerac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb)
)
)
[oracle@oraclerac1 admin]$

[oracle@oraclerac1 admin]$ tnsping PDB
TNS Ping Utility for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:54:29
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oraclerac-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdb)))
OK (0 msec)
[oracle@oraclerac1 admin]$
[oracle@oraclerac1 admin]$ sqlplus mallik/mallik@PDB
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 18:55:46 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Last Successful login time: Sat Feb 06 2021 18:40:08 +05:30
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show parameter service_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL> show pdbs
SP2-0382: The SHOW PDBS command is not available
SQL> select con_id,name,open_mode from v$containers;
CON_ID NAME OPEN_MODE
---------- ------ ---------
3 PDB READ WRITE
SQL>

How to connect to PDB$SEED:

[oracle@oraclerac1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 18:31:58 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SQL>
SQL> alter session set container=PDB$SEED;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL>

How to create new service and how to delete service at PDB level:

[oracle@oraclerac1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 18:42:38 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> alter session set container=PDB;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB READ WRITE NO
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL>
exec dbms_service.CREATE_SERVICE('PDB1','PDB1');
exec dbms_service.start_service('PDB1');
SQL> exec dbms_service.CREATE_SERVICE('PDB1','PDB1');
PL/SQL procedure successfully completed.
SQL> exec dbms_service.start_service('PDB1');
PL/SQL procedure successfully completed.
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL>

[oracle@oraclerac1 admin]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:36:53
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 05-FEB-2021 22:22:06
Uptime 0 days 20 hr. 14 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oraclerac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.35.36.229)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.35.36.233)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "PDB1" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "ba9c19dc75cf1dc2e053e524230a9483" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "pdb" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oraclerac1 admin]$

[oracle@oraclerac1 admin]$ lsnrctl service
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:37:09
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "PDB1" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "ba9c19dc75cf1dc2e053e524230a9483" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: oraclerac1.localdomain.com, pid: 23742>
(ADDRESS=(PROTOCOL=tcp)(HOST=oraclerac1.localdomain.com)(PORT=23821))
Service "pdb" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@oraclerac1 admin]$

SQL> alter session set container=PDB;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB READ WRITE NO
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string orcl
SQL>
BEGIN
DBMS_SERVICE.stop_service(
service_name => 'PDB1'
);
END;
/
BEGIN
DBMS_SERVICE.delete_service(
service_name => 'PDB1'
);
END;
/
SQL> BEGIN
DBMS_SERVICE.stop_service(
service_name => 'PDB1'
);
END;
/
PL/SQL procedure successfully completed.
SQL> BEGIN
DBMS_SERVICE.delete_service(
service_name => 'PDB1'
);
END;
/
PL/SQL procedure successfully completed.
SQL>

[oracle@oraclerac1 admin]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:45:19
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 05-FEB-2021 22:22:06
Uptime 0 days 20 hr. 23 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oraclerac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.35.36.229)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.35.36.233)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "ba9c19dc75cf1dc2e053e524230a9483" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "pdb" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oraclerac1 admin]$

[oracle@oraclerac1 admin]$ lsnrctl service
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 06-FEB-2021 18:45:29
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2 refused:0 state:ready
LOCAL SERVER
Service "ba9c19dc75cf1dc2e053e524230a9483" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2 refused:0 state:ready
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: oraclerac1.localdomain.com, pid: 23742>
(ADDRESS=(PROTOCOL=tcp)(HOST=oraclerac1.localdomain.com)(PORT=23821))
Service "pdb" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:2 refused:0 state:ready
LOCAL SERVER
The command completed successfully
[oracle@oraclerac1 admin]$

Check the active service and and services at CDB and PDB level:

[oracle@oraclerac1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 22:14:05 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SQL> select con_id, name from v$active_services;
CON_ID NAME
---------- ----------------------------------------------------------------
1 orclXDB
3 pdb
1 orcl
1 SYS$BACKGROUND
1 SYS$USERS
SQL>
SQL> select NAME,PDB,CON_ID from v$services;
NAME PDB CON_ID
-------------------- ------------------------------ ----------
orclXDB CDB$ROOT 1
pdb PDB 3
orcl CDB$ROOT 1
SYS$BACKGROUND CDB$ROOT 1
SYS$USERS CDB$ROOT 1
SQL>
SQL> alter session set container=PDB;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDB READ WRITE NO
SQL> select con_id, name from v$active_services;
CON_ID NAME
---------- ----------------------------------------------------------------
3 pdb
SQL>
SQL> select NAME,PDB,CON_ID from v$services;
NAME PDB CON_ID
-------------------- ------------------------------ ----------
pdb PDB 3
SQL>

How/Where the PDB datafile are located:

[oracle@oraclerac1 ~]$ . oraenv
ORACLE_SID = [orcl1] ? +ASM1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oraclerac1 ~]$
[oracle@oraclerac1 ~]$ asmcmd -p
ASMCMD [+] > lsdg
State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED NORMAL N 512 512 4096 4194304 61428 51096 20476 15310 0 Y DATA/
MOUNTED NORMAL N 512 512 4096 4194304 30708 27480 10236 8622 0 N RECO/
ASMCMD [+] > cd DATA
ASMCMD [+DATA] > ls -l
Type Redund Striped Time Sys Name
Y ASM/
N ORCL/
Y oraclu/
PASSWORD HIGH COARSE FEB 05 04:00:00 N orapwasm => +DATA/ASM/PASSWORD/pwdasm.256.1063688371
PASSWORD HIGH COARSE FEB 05 05:00:00 N orapwasm_backup => +DATA/ASM/PASSWORD/pwdasm.257.1063688653
ASMCMD [+DATA] > cd ORCL
ASMCMD [+DATA/ORCL] > ls -l
Type Redund Striped Time Sys Name
Y 86B637B62FE07A65E053F706E80A27CA/
Y BA9BE798A5647436E053E524230AE0BD/
Y BA9C19DC75CF1DC2E053E524230A9483/
Y CONTROLFILE/
Y DATAFILE/
Y ONLINELOG/
Y PARAMETERFILE/
Y PASSWORD/
Y TEMPFILE/
ASMCMD [+DATA/ORCL] >

[oracle@oraclerac1 ~]$ . oraenv
ORACLE_SID = [orcl1] ?
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oraclerac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Feb 6 01:51:47 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB READ WRITE NO
SQL>
SQL> SELECT CDB FROM V$DATABASE;
CDB
---
YES
SQL> COLUMN NAME FORMAT A8
SQL> SELECT NAME, CON_ID, DBID, CON_UID, GUID FROM V$CONTAINERS ORDER BY CON_ID;
NAME CON_ID DBID CON_UID GUID
-------- ---------- ---------- ---------- --------------------------------
CDB$ROOT 1 1591536784 1 86B637B62FDF7A65E053F706E80A27CA
PDB$SEED 2 3680827711 3680827711 BA9BE798A5647436E053E524230AE0BD
PDB 3 2635452016 2635452016 BA9C19DC75CF1DC2E053E524230A9483

Regards,

Mallik

Monday, June 14, 2021

12.1.0.2 lsinventory + 12102 lsinventory

List applied patches using below commands

/u01/app/oracle/product/12102/OPatch/opatch lsinv |grep lspatches
/u01/app/oracle/product/12102/OPatch/opatch lsinv | grep desc
/u01/app/oracle/product/12102/OPatch/opatch lsinv |grep applied
/u01/app/oracle/product/12102/OPatch/opatch lsinventory
/u01/app/oracle/product/12102/OPatch/opatch lsinventory -details

Example:
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2020, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12102
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12102/oraInst.loc
OPatch version : 12.2.0.1.17
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12102/cfgtoollogs/opatch/opatch2020-09-25_10-12-45AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12102/cfgtoollogs/opatch/lsinv/lsinventory2020-09-25_10-12-45AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: dfweq02dbadm01.qa.walmart.com
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 (10) :
Patch 20730584 : applied on Sun Sep 29 03:30:00 UTC 2019
Unique Patch ID: 23061643
Patch description: "OCW Interim patch for 20730584"
Created on 13 Aug 2019, 01:05:27 hrs PST8PDT
Bugs fixed:
21339083, 24831217, 18589889, 20768643, 19061429, 26512962, 26147987
19133945, 19521169, 19341538, 20011424, 19361757, 19187207, 21123932
19302350, 23340259, 19130141, 19530755, 21441387, 19028836, 18701017
19699720, 19620918, 19168690, 18899171, 19244316, 17005215, 19653795
19471722, 18634372, 19536337, 26973611, 19184188, 19131709, 20160490
20995001, 24509984, 21131037, 20985167, 19380733, 29505730, 20552947
18943696, 19591984, 18461246, 18135723, 20014326, 27148384, 19524857
25250824, 22999793, 18890943, 27695334, 19154753, 25055154, 23087119
24808260, 19499021, 25206628, 20923930, 19046190, 25074091, 20028666
23170674, 24451580, 19051385, 19682695, 19050688, 19831611, 22891868
21607972, 26755613, 25956724, 21087799, 18922918, 27525224, 19683886
18956780, 23058136, 23757020, 20110156, 19026993, 21269977, 19558324
18362971, 18261648, 22651583, 20185476, 28915251, 19478119, 18882642
19414274, 17447588, 20752167, 19262534, 22475834, 19147513, 21242118
18893463, 19514085, 25496699, 20758997, 27738131, 27006180, 27096108
19659885, 19319904, 18703978, 23079844, 24796183, 27252023, 19700256
19703246, 20467806, 12816839, 27475272, 23304537, 19192901, 21527118
27850736, 29947376, 22992133, 24670214, 25435186, 19479503, 19147751
18901356, 27175308, 26546632, 21232394, 22162062, 18964974, 18835366
19207286, 19013789, 28540666, 22583325, 18950232, 19148791, 19556820
19158155, 16505171, 21210985, 23760401, 21228405, 22261732, 22135419
19449737, 21878613, 21646169, 19187515, 19230771, 20795241, 19853036
19453778, 21430567, 18520351, 18843572, 24797972, 19185148, 19232454
24583356, 21220597, 18541110, 18834955, 27465480, 19204743, 20175174
19140891, 18747335, 20676340, 19270660, 19325701, 21108895, 20877003
25730614, 19222693, 19662663, 26357098, 19684131, 19010177, 27267992
19272663, 18907170, 18910576, 19426384, 9372680, 20737462, 25131739
19700294, 27786669, 24801915, 25943805, 24608727, 23640904, 20289828
19331454, 22568500, 20827053, 20278216, 20119857, 19703199, 22456393
20588164, 20991879, 18508710, 18955644, 19908346, 23301767, 19589221
25795447, 18952857, 19537762, 25685286, 25066549, 21152052, 16286734
20669114, 24546078, 18762843, 18945249, 19184799, 21692274, 25810476
23346234, 19205086, 19351363, 20091753, 19031737, 19079087, 24932026
25742704, 18968981, 19148367, 19150517, 20231741, 19217019, 27496806
18730096, 18975620, 26114371, 21259359, 19067804, 28266751, 18747382
19054979, 19209951, 19318983, 19154673, 18752378, 22905714, 19150088
26860285, 19013444, 19234177, 22095969, 18999857, 25951778, 19367276
19075747, 24736511, 19874047, 19612597, 19677813, 23049292, 19427050
18910443, 20033787, 19148982, 25371632, 25131365, 27106915, 19777496
20730170, 26474627, 24362631, 18523468, 19277814, 20562133, 21420753
19071526, 22986384, 25537905, 20433932, 18850051, 20061168, 18468128
19370739, 20822591, 19609388, 20136892, 18776786, 18989446, 26439462
19148793, 22904978, 26185431, 19585454, 25492219, 26308703, 19955755
18317489, 19059053, 19807548, 22229116, 19124972, 22840085, 19617592
19398098, 18910748, 18849896, 19147509, 19076165, 19704993, 19498411
21294273, 19459023, 20634511, 21229744, 19516572, 25604442, 21474380
21484367, 20276459, 21550724, 17208793, 19234907, 20007009, 19538714
22867050, 22728264, 19525147, 19383028, 27186837, 22195657, 19513969
19622211, 23111368, 19986391, 19314048, 19473851, 18834934, 19458082
18894342, 23762756, 19522067, 23618734, 18116578, 19241857, 19076778
19066699, 25206563, 19068003, 20267877, 18937186, 19916737, 19770543
22863466, 19635215, 19613533, 21057239, 20783416, 19315522, 19141785
19885321, 19163887, 25233268, 18852058, 18715868, 27182006, 27554304
25987595, 19701617, 25715140, 25448476, 19139608, 19280860, 24403376
19908051, 21453435, 26035888, 22900591, 29146157, 18946768, 21951266
24831158, 24578464, 23063340, 19135521, 18604143, 23150001, 19627476
20568884, 20317221, 25947195, 20177779, 19266658, 19491996, 24522717
23717606, 18330979, 19027351, 23472436, 21227730, 18707416, 21118157
21113068, 19925992, 20235486, 20006646, 18439295, 15922206, 18991776
21245437, 23170839, 19163425, 19550195, 20389257, 18849021, 18861196
25026932, 17940721, 18524834, 18748932, 18835283, 19287706, 19522313
19184765, 27222423, 21639478, 25729214, 14851828, 20598625, 19226141
19053891, 18871287, 25371730, 18998228, 18980002, 25361169, 19325604
19682778, 26827699, 8934841, 18777835, 17338864, 18945906, 19513650
24692493, 28462215, 26378300, 18952577, 19702758, 19473088, 21477269
26115835, 19178517, 25197670, 18729269, 19529729, 19455563, 20877072
23275930, 24372941, 18536826, 20340620, 25776294, 19292605, 26257547
22264951, 20920711, 20660273, 25037836, 26372145, 20011635, 27682288
17592037, 18935857, 22989069, 19029647, 26591240, 19179158, 22302421
25562525, 23076471, 19140712, 22205332, 20012766, 25907259, 23049301
19184276, 27579631, 25206643, 20001507, 20510208, 19259765, 19680763
20079414, 23706534, 24422155, 18962892, 19513888, 24464953, 14661880
21519340, 20218012, 21222147, 26884984, 19551830, 19068333, 21616278
18945435, 21189769, 20775015, 19319192, 22579220, 25588693, 19178629
20839581, 18774591, 19304104, 21694237, 19284357, 22594310, 19457575
20725084, 21297657, 19021575, 19069755, 18715884, 18798573, 19584688
19018001, 19812592, 19270956, 19292272, 21967791, 21794779, 23055224
18700893, 21276514, 27047274, 24696235, 18406774, 20467377, 24341772
23621494, 28973538, 27984314, 20607821, 21976167, 21082737, 21694632
27309269, 23095976, 20115586, 28553832, 20883009, 25591658, 22322021
22069809, 19164099, 18283792, 24908629, 23635127, 19155350, 26527054
27862636, 25049033, 19884033, 19146822, 18798432, 21123424, 24356071
19471836, 24445255, 20936562, 28805158, 25037011, 22144696, 18750781
28503043, 19045143, 20559126, 26307166, 22483804, 19146980, 24396050
29131772, 27358232, 19601003, 20099624, 21378016, 19281106, 18862203
19537547, 26282865, 23733697, 19954372, 25851874, 18235274, 19205617
19513351, 19150313, 18843054, 20219458, 18708349, 19332386, 18953639
21423055, 27190262, 19371270, 25221056, 19203996, 20038431, 26877592
19370846, 26081368, 21053036, 18998379, 20157569, 25137752, 21357522
24824518, 19273577, 24667931, 24709351, 25206634, 22113170, 19632437
19288396, 18990354, 21679331, 19557558, 20620581, 19127078, 22746166
25100966, 22548137, 21792881, 20730584, 20900588, 22088198, 20053557
22664609, 19315567, 19154933, 19444471, 20953798, 18290252, 18813323
19915945, 19500293, 18643483, 19134098, 28593407, 23034352, 25206614
18965694, 25233797, 19226858, 19591356, 19602208, 22884308, 25564644
20069197, 18417590, 18920408, 18263259, 18636884, 27664844, 22289350
25291358, 19043795, 20746507, 18260170, 27068526, 18919682, 27554103
24657753, 18678829, 19319357, 19273758, 18953878, 18999195, 24314323
18759724, 20458032, 24462646, 25606616, 25569634, 19066844, 27404599
13843841, 20290467, 22934855, 19649640, 19062675, 21924910, 18859710
20862812, 19504641, 23101611, 19341481, 18304090, 19343245, 20293730
26943660, 19241655, 18242738, 19470791, 18372060, 20649573, 18953889
18827679, 19259290, 19140711, 19023430, 19045388, 20186278, 25197395
19522571, 18875012, 19709663, 18861564, 21075392, 19273760, 19225265
15885689, 20853464, 18819158, 21696068, 19049721, 21394146, 19368917
25206650, 22393909, 21255373, 25164540, 18868829, 20408163, 20579351
20350915, 21327402, 22024217, 23101338, 19820247, 25206585, 20363708
19538241, 25785073, 19804032
Patch 29990853 : applied on Sun Sep 29 03:25:15 UTC 2019
Unique Patch ID: 22994355
Created on 23 Jul 2019, 07:47:03 hrs PST8PDT
Bugs fixed:
20988651, 28889389
This patch overlays patches:
29496791
This patch needs patches:
29496791
as prerequisites
Patch 29991120 : applied on Sun Sep 29 03:24:58 UTC 2019
Unique Patch ID: 22994524
Created on 30 Jun 2019, 10:43:46 hrs PST8PDT
Bugs fixed:
20413540, 23604553
This patch overlays patches:
29496791
This patch needs patches:
29496791
as prerequisites
Patch 29774383 : applied on Sun Sep 29 03:24:39 UTC 2019
Unique Patch ID: 22961858
Patch description: "Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)"
Created on 7 Jun 2019, 10:02:47 hrs PST8PDT
Bugs fixed:
29774383, 29774367, 29251241, 29254615, 19165673, 28790654, 28915933
28440711, 28502128, 28502113, 27923320, 27952584, 27952577, 27642235
27475603, 27461789, 27461842, 25649873, 27001733, 27000663, 27000690
26635845, 26637592, 26570171, 26027162, 26023002, 26023025, 25437695
25494413, 25494379, 24917972, 25067795, 24534298, 25076732, 25076756
24315824, 21659726, 24448240, 24448282, 23177536, 22675136, 23265914
23265965, 23727148, 22674709, 22670413, 22670385, 21188537, 22139226
22118835, 22118851, 21555660, 21811517, 19623450, 21566993, 21566944
19176885, 21068507, 21047803, 21047766, 20415564, 20408829, 20408866
19877336, 19855285, 19909862, 19895362, 19895326, 19153980, 19231857
19223010, 19245191, 19699946
Patch 17553259 : applied on Sun Sep 29 03:24:04 UTC 2019
Unique Patch ID: 22812739
Created on 24 Mar 2019, 04:28:20 hrs PST8PDT
Bugs fixed:
17553259
This patch overlays patches:
29141038
This patch needs patches:
29141038
as prerequisites
Patch 25442559 : applied on Sun Sep 29 03:23:47 UTC 2019
Unique Patch ID: 21888147
Created on 22 Jan 2018, 01:49:34 hrs PST8PDT
Bugs fixed:
25442559
This patch overlays patches:
21949015
This patch needs patches:
21949015
as prerequisites
Patch 29496791 : applied on Sun Sep 29 03:17:44 UTC 2019
Unique Patch ID: 22993732
Patch description: "Database Bundle Patch : 12.1.0.2.190716 (29496791)"
Created on 28 Jun 2019, 12:28:09 hrs PST8PDT
Sub-patch 29141038; "Database Bundle Patch : 12.1.0.2.190416 (29141038)"
Sub-patch 28731800; "Database Bundle Patch : 12.1.0.2.190115 (28731800)"
Sub-patch 28259867; "Database Bundle Patch : 12.1.0.2.181016 (28259867)"
Sub-patch 27547374; "Database Bundle Patch : 12.1.0.2.180717 (27547374)"
Sub-patch 27338029; "Database Bundle Patch : 12.1.0.2.180417 (27338029)"
Sub-patch 26925263; "Database Bundle Patch : 12.1.0.2.180116 (26925263)"
Sub-patch 26717470; "Database Bundle Patch : 12.1.0.2.171017 (26717470)"
Sub-patch 26609798; "DATABASE BUNDLE PATCH: 12.1.0.2.170814 (26609798)"
Sub-patch 25869760; "DATABASE BUNDLE PATCH: 12.1.0.2.170718 (25869760)"
Sub-patch 25397136; "DATABASE BUNDLE PATCH: 12.1.0.2.170418 (25397136)"
Sub-patch 24732088; "DATABASE BUNDLE PATCH: 12.1.0.2.170117 (24732088)"
Sub-patch 24340679; "DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)"
Sub-patch 23144544; "DATABASE BUNDLE PATCH: 12.1.0.2.160719 (23144544)"
Sub-patch 22806133; "DATABASE BUNDLE PATCH: 12.1.0.2.160419 (22806133)"
Sub-patch 21949015; "DATABASE BUNDLE PATCH: 12.1.0.2.160119 (21949015)"
Sub-patch 21694919; "DATABASE BUNDLE PATCH: 12.1.0.2.13 (21694919)"
Sub-patch 21527488; "DATABASE BUNDLE PATCH: 12.1.0.2.12 (21527488)"
Sub-patch 21359749; "DATABASE BUNDLE PATCH: 12.1.0.2.11 (21359749)"
Sub-patch 21125181; "DATABASE BUNDLE PATCH: 12.1.0.2.10 (21125181)"
Sub-patch 20950328; "DATABASE BUNDLE PATCH: 12.1.0.2.9 (20950328)"
Sub-patch 20788771; "DATABASE BUNDLE PATCH: 12.1.0.2.8 (20788771)"
Sub-patch 20594149; "DATABASE BUNDLE PATCH: 12.1.0.2.7 (20594149)"
Sub-patch 20415006; "DATABASE BUNDLE PATCH: 12.1.0.2.6 (20415006)"
Sub-patch 20243804; "DATABASE BUNDLE PATCH: 12.1.0.2.5 (20243804)"
Bugs fixed:
18716250, 19438874, 24297898, 20246939, 25437699, 19240264, 20070112
21867415, 26546664, 22161543, 28774416, 19915271, 20013559, 23154666
20172151, 20801390, 19516448, 24907917, 24796092, 20129763, 20853821
19410056, 19859472, 21153266, 23702338, 19548064, 26556014, 27009164
20131617, 20003739, 24570214, 21610048, 22346829, 19495405, 20853852
21387964, 13542050, 18938517, 23735292, 27666312, 25377044, 19243313
19563657, 13498243, 23644359, 22734547, 20732272, 22243983, 19012119
19932634, 19869255, 18681056, 23324000, 23248603, 18867241, 22068305
20241212, 19439759, 19987300, 23169712, 19303936, 18856106, 22916353
19542737, 23749454, 22540743, 21981529, 19175543, 24583530, 19147016
21106027, 20051868, 22153958, 26256131, 19134173, 20447445, 20717091
26513709, 25780343, 18533573, 19769480, 21097043, 19536017, 20677396
22205263, 20919320, 22075064, 22331786, 22551446, 23589471, 23606059
23271423, 20700640, 27611612, 18440095, 22496904, 16439813, 18354830
20596234, 18594569, 19664340, 20994184, 21305617, 22268833, 19590877
22515353, 22641033, 19809171, 21186167, 26111842, 13787015, 22492533
18603592, 20563314, 20173897, 24624166, 23602960, 20181030, 26170659
21868720, 20434597, 23068169, 20819901, 21383171, 19402853, 19888853
19794897, 24341675, 23323592, 25451531, 25348956, 20717081, 27370965
19081128, 20637701, 22173980, 23514710, 25722055, 22530986, 20988771
18859658, 19723273, 27485863, 19475862, 20540694, 19015671, 20951038
22168163, 20020274, 20569094, 24308635, 19791377, 13846337, 19189762
22475617, 20181016, 8899370, 19469538, 26434436, 19631051, 25995938
19136799, 27125872, 20598042, 18988834, 29216828, 19146597, 20063894
21872833, 19680455, 24481112, 19540171, 20754928, 25051465, 20387265
20801783, 29378913, 20673810, 22075019, 21607719, 18889867, 24811725
20565112, 19996677, 20615947, 21517261, 19124336, 26051656, 19989904
16293223, 22294260, 18899662, 20243804, 23235386, 20969164, 20672955
19573061, 27680669, 21300341, 21136799, 18288842, 17805926, 27223075
22353199, 20881450, 19477176, 19212166, 19327067, 28305362, 25670786
24786669, 22191356, 22086638, 26898563, 19004100, 22495673, 19577410
26248143, 20950535, 20969159, 23294548, 19377346, 20508559, 20071054
19899544, 18648423, 20565133, 26608137, 19931709, 25423453, 22463633
19295348, 23533807, 28468312, 19576559, 25600421, 18122373, 23310662
26029777, 23124895, 18856999, 27424405, 21187090, 18893947, 26633558
20076781, 28218832, 26029780, 21196809, 22533631, 23725036, 16010876
27679641, 20144026, 27786623, 19562381, 21315800, 21903230, 24808595
21509656, 19189317, 25669791, 21917884, 20938019, 27213224, 29006527
20711718, 25982666, 25409186, 20661402, 20684983, 27951927, 22826718
21773465, 20250147, 20144019, 22330067, 19680898, 19959229, 26263721
19597439, 21387128, 22007324, 21566639, 22628825, 20226038, 17626861
18111216, 21459225, 20847534, 24285405, 21833220, 25296876, 21425496
26544823, 19364018, 20216232, 25237577, 22518491, 18494306, 22228324
18633374, 25994657, 20144042, 23172924, 22520320, 19145675, 19446007
25058080, 22365117, 19192508, 22645009, 18813860, 25165496, 24309560
22726044, 28950969, 20617709, 19971335, 18774543, 18418934, 23136865
20124446, 22330044, 21834568, 25299807, 19371175, 18940497, 22923409
19372024, 21450985, 25489342, 20249656, 21186638, 20893843, 16356176
18996056, 19317646, 19044962, 19532017, 19662635, 18999568, 21164840
20560611, 19933147, 19578247, 19982551, 22238921, 19462173, 19638998
22809871, 19995869, 22330944, 18921743, 22194927, 21897746, 19018206
17285555, 25797124, 19777862, 19475484, 22119679, 19783286, 22223463
20832474, 19304354, 19222052, 23718355, 20668053, 19168442, 27199245
18911956, 22977256, 20890311, 27445727, 19578230, 18962266, 19262984
20869721, 22348206, 24555417, 22258530, 20028247, 23197730, 27110878
21221860, 20052269, 20005124, 18819908, 19858928, 21097827, 23628685
19593445, 23007241, 20756607, 21080143, 22936751, 19653712, 19336395
20582405, 21079172, 20031873, 25489367, 18618122, 19130152, 22501616
26784509, 20176045, 22727335, 24739928, 19066316, 18687126, 18876528
19068970, 20949664, 19238815, 24747551, 24713381, 20432873, 19192570
21218243, 19294529, 20340595, 20087383, 25459958, 19271894, 20577490
27534509, 20800890, 20686773, 27236722, 20868862, 25362317, 21780146
26608238, 23315153, 20466628, 20397490, 27595973, 23240358, 22178855
19910052, 26664361, 19329654, 20859910, 19791702, 26203182, 22568797
19075256, 23115408, 20356971, 21117640, 18687101, 28026866, 22705995
25635149, 23231894, 20844426, 20884085, 19076106, 19352437, 20441797
14043712, 20192960, 21904072, 21442094, 21896841, 24425056, 25079710
19881439, 21547079, 20426193, 21503053, 24674955, 19614585, 23126545
18441401, 18890834, 18840932, 20294666, 18740837, 23476288, 19701015
22724269, 24326846, 20978173, 25452452, 20663222, 22062517, 24289874
19855835, 19054378, 19958830, 20144871, 21889720, 19347458, 19450116
20117253, 19441649, 19507904, 23326243, 20746044, 19931367, 21330561
22092979, 21123913, 24764085, 21839477, 21625179, 23263018, 19638123
19272708, 19433200, 19191274, 22338023, 28106999, 18795927, 18701619
21281532, 21660388, 22900351, 22662332, 20603181, 19461270, 28617959
22734038, 19434529, 20609727, 18799063, 19990543, 25710420, 17008068
21246723, 25557886, 20831538, 20424899, 19537328, 21877749, 28417499
19173409, 20562898, 23491861, 21608238, 20001168, 19410553, 21241052
19454986, 28199085, 20736227, 23194294, 19399918, 22068270, 20017509
27653884, 25555252, 21306422, 20118545, 25612095, 19264279, 19067244
19943771, 18043064, 19478966, 24965426, 18885870, 20081206, 26243698
26187943, 20324049, 20106567, 22527857, 19588097, 19536415, 23709062
19381346, 24348685, 20340510, 19682278, 22981722, 18628388, 20350312
22235858, 25047724, 19582781, 22966117, 27847259, 19185876, 25092777
22465352, 20777159, 20794951, 24385625, 24326444, 19566293, 19161450
22077191, 19627012, 20624914, 20617383, 18594510, 20468401, 27441326
19583624, 20027746, 27620950, 21430035, 24336249, 21116398, 16863642
22351417, 19639483, 19539945, 23312077, 27567477, 21479753, 21968539
19162308, 22254139, 22464010, 20581111, 19907278, 20936731, 19440386
18120963, 19341709, 27138798, 23665623, 20547245, 18996066, 20195148
19188927, 23200778, 19134095, 20229001, 24570598, 21172913, 20075921
17655240, 21266085, 19028800, 29379978, 19035573, 27400598, 19768226
19366375, 27999638, 24523374, 25599425, 19289642, 19250184, 21293693
19513298, 18424939, 25906117, 19824028, 23521523, 21555019, 20939028
25027852, 19447234, 20334691, 19679504, 18257176, 19263008, 26088426
17414008, 19600813, 23019710, 20897759, 22837524, 19130972, 23130347
19230581, 22046677, 19288324, 19663176, 20938170, 19891090, 21960504
24509056, 24435982, 19899833, 26262953, 20096843, 18647293, 19723336
19835133, 17532734, 20679868, 25300427, 17495022, 21842017, 20026982
27285244, 19687159, 20232621, 20977794, 19230595, 20734332, 17551063
16938780, 27548131, 21977392, 28483184, 24461826, 19676012, 19926255
23315889, 20010162, 23053606, 19841800, 20245930, 19001359, 19393542
23533524, 21099555, 27995248, 20184217, 19644859, 12963364, 19072979
19851608, 19908836, 21032832, 21421886, 19518539, 20105469, 20591915
19358317, 25323525, 20130826, 20803014, 19150533, 23642282, 14372604
19784751, 24662775, 8889083, 20033247, 21427131, 18890385, 20186868
27540613, 20923950, 20347562, 22379445, 19696041, 20049681, 18693124
22091036, 19896336, 24926999, 20048359, 27565906, 20468490, 19524384
25392535, 19932939, 21147908, 21695575, 24376878, 20440930, 20138303
19585773, 19883038, 26542135, 24718260, 19591608, 22707244, 22296366
18914624, 19547013, 20181155, 21522582, 22159570, 19501299, 26007010
20425790, 19686260, 19666651, 20871556, 13640676, 27997875, 24587802
25472112, 25735246, 22351495, 16870214, 18202441, 24415926, 19001390
21157728, 26671543, 20667450, 19012044, 20394750, 21875360, 22606521
25091141, 28000269, 19149990, 20382309, 19606174, 20848335, 28307854
25495682, 19382851, 22762046, 20960011, 29436454, 23028257, 24563422
23125826, 22503297, 18558952, 23338911, 19952975, 26088836, 27457891
22730454, 22066671, 13683743, 21950301, 20783358, 19354794, 20757079
20298413, 19146474, 19048007, 18877780, 19929706, 26635897, 20011897
22254912, 21532755, 23602213, 21283023, 20159216, 20448066, 22160989
20354677, 18665091, 23262847, 20544797, 22894949, 21059919, 18952989
18728991, 22518784, 19647503, 22917705, 22652097, 25484507, 20794034
21061354, 17533661, 19824871, 19542684, 19883092, 24401351, 20040448
20067928, 22882992, 28023399, 25330273, 21136435, 20009569, 18051556
26412540, 17249267, 19995675, 19699191, 18881811, 25479164, 19248279
19190401, 14178080, 16875041, 19232702, 18964978, 22157363, 26308650
25802510, 25766822, 21967197, 20647412, 25230870, 19601762, 20185943
26110259, 20217416, 20368850, 20798891, 25606091, 21133343, 21099502
18521623, 22347859, 20061399, 19799847, 19682726, 28501075, 18542562
19017309, 19192600, 22594071, 20658124, 19138800, 21976960, 20134339
24690216, 22507210, 20724902, 18778801, 20101006, 23501901, 18797519
19906611, 21813529, 25997810, 19852069, 21260397, 24521608, 19541796
19354335, 19730508, 22366558, 18787718, 25822410, 6599380, 21157342
20717359, 19051205, 20300454, 24308349, 21533640, 23194817, 18964939
26362155, 19871910, 22529018, 29437712, 26366517, 20133026, 21785102
25695903, 21378561, 20603431, 21542577, 20010996, 22507234, 19159710
19886165, 21030693, 25600342, 28587723, 20627866, 18110491, 19274987
19817284, 20320834, 24642295, 20480623, 19518079, 25480641, 19647120
25476149, 20233181, 19339555, 20466322, 19144692, 25823754, 25110233
20201112, 19181525, 20169408, 24908321, 17274537, 21951106, 20624386
26575788, 20245173, 18900917, 20808220, 18679653, 19482919, 27259307
28571483, 26745002, 18899974, 26966616, 19052488, 20844308, 26198757
19503821, 24350620, 19131386, 21220620, 19865345, 22816287, 19364502
19555029, 17284345, 18472224, 26883456, 29031830, 19889230, 23492665
22347483, 20879889, 20399973, 21047407, 28022101, 20900013, 26479173
19945499, 21893235, 26550584, 19624452, 19363645, 20233159, 18382302
27086138, 19468612, 19878106, 22826067, 19248799, 28432129, 19155797
19990037, 20509482, 19647567, 27255377, 24717859, 18663279, 20534497
22529088, 22862134, 21526048, 28683167, 24929210, 19879445, 25721405
21620471, 18816732, 19509565, 22864303, 19433930, 21180173, 25123585
20476175, 18549238, 24944847, 20808265, 21275387, 18895170, 19684504
19330795, 20899461, 19376952, 19024808, 22926613, 20699904, 25760195
27605624, 21419192, 19212370, 19480309, 19928926, 23314180, 19566592
19383247, 24737403, 20480209, 18904062, 26430737, 20856766, 21384810
27169796, 17258582, 20936447, 19894622, 20877664, 18430870, 24577566
19430401, 19676905, 20925795, 24622658, 26482376, 19790972, 23237091
18497527, 18673090, 22865673, 23306590, 21315084, 22129399, 19375649
24534401, 19989009, 25533545, 18191823, 25329664, 25775213, 25022574
20704530, 24376848, 25639019, 17319928, 22675506, 21372880, 14705949
20023092, 22452178, 19703301, 28390273, 20122715, 6418158, 29125374
19258504, 21188532, 19362731, 23151677, 24792678, 22090662, 19485593
16887946, 19693090, 26024732, 27012701, 19490948, 24485034, 21151241
19878169, 18182018, 17817258, 26169345, 21641760, 19818513, 23002524
19151370, 26169341, 27502420, 22761995, 23582997, 24693382, 21211305
20279368, 22165897, 19373893, 22359063, 19168167, 27032785, 19969872
18373438, 19334242, 20984916, 22367053, 20470877, 24438281, 21632821
19271943, 22351572, 28545134, 19953052, 18735746, 18604493, 19632912
20903906, 20209481, 22901797, 20978259, 22177861, 21372897, 19163723
20213973, 24801152, 23782881, 20664416, 20907061, 19120604, 18744247
25733479, 19523462, 18968507, 20830993, 19034201, 19183343, 17969866
20202880, 19585708, 26908788, 26036748, 20653340, 27554074, 22819742
16817656, 20082651, 25093739, 19187708, 19527817, 26744595, 28708023
24413809, 22664402, 21308727, 22051945, 20413820, 19262199, 22176950
28986231, 23642667, 25897615, 25643931, 19186845, 21281607, 20703629
18841764, 20558005, 19891196, 20093776, 19170047, 20703661, 20618595
20230090, 20177858, 23103188, 18127250, 19043177, 18944562, 19211433
25444961, 20331945, 19175732, 19512341, 18607546, 26875822, 27891045
19301392, 24305636, 20070689, 23115139, 21957762, 20148087, 21394225
21294938, 26112084, 20898997, 22978673, 18510194, 21293600, 18758878
20672075, 18758877, 20355900, 25977302, 22454326, 24683149, 26442308
22376809, 19582642, 20027864, 20270511, 23061702, 19309466, 19277787
19902195, 18250893, 19383839, 18863094, 19781326, 25670970, 16756406
18112769, 18456643, 19175750, 22347934, 19563433, 22364044, 18913440
18845653, 18417036, 23713236, 24844019, 19571055, 19906564, 23140259
26911000, 18917800, 19243521, 20752907, 19658708, 17734040, 18272672
18834993, 25211628, 18892426, 20747533, 18971325, 19174430, 18900107
19347744, 19184226, 22243719, 21214994, 21197098, 22446455, 20381311
26354844, 24334708, 18390735, 21899224, 20493163, 21559748, 20688221
20586677, 20070374, 22250006, 21028698, 27757888, 21623164, 21534893
22232606, 20985069, 25427662, 19298213, 24589081, 23055900, 20950386
20632205, 28852691, 19688599, 24835538, 22184431, 22353346, 19494323
19790243, 19148107, 26444887, 19461428, 23088803, 22529728, 24368922
22233968, 24303148, 21101873, 27122162, 27691939, 21188584, 19390567
21131203, 21225209, 26245237, 19284031, 19450314, 19051985, 19350952
23514911, 19016730, 25904490, 19250261, 22517782, 19900800, 20445031
20024405, 20494044, 22721409, 29032276, 19440520, 19310488, 19529953
19240456, 20611795, 20088905, 22022760, 21568648, 20936905, 19988852
20697178, 23197103, 21514877, 25577309, 18990023, 27401506, 20392464
20128644, 17210525, 25241448, 21260431, 21174395, 19448499, 25056052
19631234, 28749289, 19370504, 24423416, 19124589, 21829392, 17994602
21387771, 22690648, 19403942, 17722075, 25107334, 20721341, 20882568
19272047, 25653109, 23026585, 18604692, 25546608, 20768076, 24797119
19178851, 26096382, 19024388, 25161298, 18022774, 19050649, 27691920
22766304, 20920911, 20001738, 19189525, 20125550, 19060015, 27052607
20265853, 18748005, 22458049, 21159665, 23302839, 25307368, 23472554
24473736, 25699321, 18952631, 17670355, 17409174, 22729345, 22842151
19238590, 16941434, 26976814, 24397438, 24668398, 23108128, 20356733
22380919, 20927568, 18436647, 23065323, 20825533, 19649808, 21812537
22373397, 21519686, 24835919, 19197132, 22228997, 20557750, 24790914
20284155, 23571055, 21774511, 23855307, 21286665, 25539063, 17365043
25914276, 20952966, 22961508, 19176223, 23237313, 18783224, 22053453
23588722, 20011515, 22083366, 27634991, 24583380, 19188683, 19973780
21419850, 27986817, 15931756, 24402551, 22491079, 21320182, 23101501
24737064, 25547060, 27726780, 26261327, 21680130, 19162085, 24600330
21203024, 20043616, 20929771, 21131289, 19353144, 21450666, 19819141
21354456, 18520414, 20464614, 19645496, 19176241, 27375542, 29348063
19270287, 18307021, 19708632, 28423598, 25633101, 18973548, 25941836
18378632, 19718981, 23567857, 25655390, 19147636, 19197175, 21795499
22330282, 19029674, 19571082, 18818069, 19180770, 19879746, 18796543
21785691, 20539050, 20424183, 20227126, 19345973, 21894802, 24942924
19509982, 20333204, 23265829, 19544707, 25251648, 19957298, 19146778
20421900, 20322560, 20063230, 19230607, 18682983, 27751755, 21575362
20228468, 14254610, 27626925, 19566974, 20846438, 18829196, 17973658
19793397, 20808192, 21813400, 21429602, 29676089, 26153977, 29189889
21171382, 19200481, 21863727, 19910254, 19074147, 22190791, 18818841
21380789, 19154375, 20545234, 25417056, 21342045, 20328205, 19795047
26095405, 22374754, 21279842, 26426526, 25654936, 19843202, 19982314
21492036, 18705806, 28420042, 22024071, 24838599, 19914604, 25981498
19215966, 19183813, 21184223, 23089357, 19693124, 19404068, 19215968
19065677, 19018447, 18308268, 19056729, 19331728, 19302393, 19166028
29027694, 22519146, 26654363, 19445860, 19167353, 23093845, 19131239
18642040, 21142837, 20225417, 19136936, 25662524, 22179537, 21756699
20494924, 20217801, 22760595, 25483815, 24439410, 25256170, 25749273
20897180, 23075177, 27351628, 24299028, 22304421, 24966594, 25638456
19810774, 19183834, 24737581, 26909504, 22258300, 19317899, 21698350
26513067, 19566012, 19139189, 20557652, 25078611, 24838161, 18966843
19077215, 23499160, 19021645, 20704450, 20543011, 19023822, 22302666
22836801, 21756677, 19624156, 25432250, 25086233, 22675822, 20328248
19065222, 18674047, 18847357, 20144669, 18849537, 20315311, 22897344
25178179, 21391017, 19308965, 19882506, 18948177, 20764012, 19728268
18908550, 19468991, 20927642, 21756661, 21813024, 19706965, 20302006
24831514, 20217875, 19032777, 20862087, 18622436, 18974476, 20603378
20537624, 20917841, 19307662, 19817386, 21847223, 19843631, 20177577
20281121, 20404176, 19076343, 18866977, 29511611, 29232372, 22808310
20631846, 20904530, 20296619, 20593729, 19624139, 26354017, 20887355
21985256, 22821774, 18907688, 21087813, 20675854, 20766694, 18689530
25201454, 21971099, 19394032, 20548731, 21037923, 25602488, 21330334
21517440, 22374347, 20328279, 20496254, 19548688, 19014915, 21282605
25971286, 19180394, 27337759, 19174942, 20020936, 22212940, 20243268
20468223, 19195409, 19483288, 20671094, 19152115, 20146809, 18411216
22220568, 24386767, 20641666, 14666816, 26659182, 21848185, 25264559
23732056, 19930276, 23632545, 27687880, 20700049, 19191037, 25616268
26762083, 19591408, 20241083, 20879709, 23003979, 20165574, 20005313
28578164, 20005796, 19547370, 22624709, 23084507, 23184263, 20069788
20228093, 25093872, 27381498, 14165431, 19805359, 26324206, 26729494
20354900, 27367194, 20378086, 29388020, 20361671, 18674024, 19689979
22380132, 19854717, 24411921, 19873610, 16619249, 19440105, 23278758
21641414, 21091431, 20707932, 19907473, 19440586, 21174000, 22757364
21930149, 23480973, 22175564, 23278750, 22499356, 20725343, 19561643
19153897, 19512276, 23265456, 25558986, 19195895, 20758638, 20830459
18475439, 22243217, 25790353, 21828126, 22528955, 27825241, 21665897
20746251, 18663314, 22568177, 25764020, 25357142, 18678808, 23096938
20162495, 18369237, 21329301, 20082778, 25894239, 21612959, 19825394
19645930, 28174827, 20446883, 27314206, 21299490, 18897633, 21068213
21455569, 25313154, 18079675, 21793604, 21744290, 23591576, 18254023
18463035, 20591183, 18760601, 21549434, 25643818, 19128452, 25317989
19594959, 18548433, 27207110, 19547774, 25757748, 20402832, 19526873
20536378, 19488514, 29200700, 18966425, 19265346, 24010030, 19315691
20001362, 19131607, 21143725, 19174521, 18115378, 23177923, 20401975
19605498, 18306996, 27560602, 18851894, 19875836, 27034890, 21424824
19359219, 18810904, 19542097, 20261923, 19277336, 20318889, 20828104
21083850, 20261926, 21060755, 18942489, 25240188, 19769625, 20318883
26828994, 26526726, 21049500, 22256560, 18794814, 20081450, 23328639
27229389, 20321129, 20766180, 25475853, 21765742, 23300142, 26237773
22975893, 22492474, 25335790, 25034396, 19880190, 22504793, 21502702
19773811, 21291274, 21293453, 18007682, 19881042, 20126138, 26385473
20475845, 29408136, 22148226, 22528741, 25417958, 20001466, 24652769
19597583, 19326908, 26822620, 23072137, 25874678, 22540882, 21249747
24825843, 26318627, 24719799, 27801337, 19054077, 21385422, 22657942
20428621, 21899588, 20451844, 23326313, 22251691, 28891741, 19932746
19333670, 19598441, 18798250, 19285025, 21373473, 23260854, 23061453
19148478, 19884571, 14643995, 22146062, 20824172, 25882264, 27744223
19698040, 22297022, 19607219, 28612674, 20588502, 21239922, 20542788
23037377, 19520602, 20874880, 21476308, 18753782, 26546754, 26421667
23613512, 19563300, 25429959, 19141838, 21915719, 21856417, 19309149
22472825, 27251690, 19524158, 19525002, 23548817, 25861398, 23736203
23025340, 19335438, 19871282, 20804108, 19058490, 19207117, 21651772
18799993, 25303756, 25919622, 26569225, 25986062, 20835241, 22917573
20958816, 19475971, 24617969, 19006817, 19347898, 24717183, 19536132
18967382, 23132311, 20369110, 23134970, 20348653, 27504770, 24812585
20496341, 19632217, 21896069, 16087033, 26171897, 17027695, 20781373
25789277, 19171086, 20815650, 17867700, 19791273, 19403858, 20322037
27397048, 21241829, 18421248, 21751519, 18419520, 20962057, 22074084
22654475, 19571367, 20276452, 28636676, 19927393, 29135406, 19529868
27434193, 19708342, 27757567, 18508040, 21153142, 23749547, 18743542
18424767, 19609438, 20857041, 20072221, 20310880, 20657411, 19332396
19571350, 21821302, 21306811, 18900245, 25120668, 23507063, 20032123
22855193, 23645516, 20287585, 16777441, 22495919, 21472390, 20528052
19341239, 18897147, 28993590, 25192729, 25410017, 20139836, 19546825
20952633, 19176326, 19212061, 22018363, 18849970, 24300640, 20860659
22905130, 26121990, 20508451, 22905136, 18764841, 21263635, 18739883
15894842, 19143193, 19354542, 27710072, 23209741, 18499088, 18775971
27348081, 24329056, 22077553, 25856821, 19140924, 20214168, 18938454
24457597, 20554364, 19468347, 21691327, 18803726, 18802876, 20657441
25207410, 21285458, 22628989, 21070063, 24425998, 14683854, 24437510
20669434, 25865785, 22972770, 22666009, 18300729, 20828947, 21373076
22300581, 25659655, 25492379, 25551676, 25353150, 21679209, 14283239
25614776, 18749211, 18952766, 22922076, 23731896, 25575628, 19970163
21365452, 21239530, 20011646, 19886365, 20437153, 24848928, 27124624
20880215, 24848923, 23539020, 24605906, 26388538, 19982584, 15996428
19013183, 21095391, 25042823, 20019581, 22695831, 23178558, 24365589
25248384, 22236041, 25634317, 17972478, 20134113, 19587324, 16739157
20656178, 24346821, 20273319, 26095327, 26758193, 21063322, 20716291
18934048, 21121136, 18907741, 22062026, 19925146, 27829295, 22153180
20074466, 20096277, 20596195, 23215145, 20539160, 22077517, 22815955
20707790, 23854396, 26555609, 19811763, 18302923, 25186079, 16354467
21795111, 25179774, 19576659, 20390564, 19029552, 25879984, 25029423
26623652, 21345404, 21439779, 28072567, 20617820, 26658759, 21646361
21893830, 24321547, 27097854, 21297872, 20161701, 20064203, 21681552
22460450, 21553476, 19680796, 22717225, 17551261, 21554789, 19230722
18942923, 18684802, 19191531, 18764866, 23310310, 21913183, 20171986
22366322, 25957038, 21132297, 19240996, 24385168, 23170620, 24719736
18868646, 19025195, 29142109, 26637824, 16923858, 18427406, 29301463
18549042, 21093564, 20165291, 19189240, 19428389, 20842388, 20194605
24337882, 20130196, 20474192, 20366825, 21644640, 25119290, 20313052
28849751, 21794615, 20471920, 22806698, 19899243, 19188385, 18727933
20074391, 27396672, 19157754, 22495062, 24316947, 20451063, 19065556
21097914, 20123899, 19146626, 25947799, 20878790, 21322887, 22305887
19617921, 22983815, 24350831, 19578350, 20099675, 25225795, 20250735
21516425, 26439748, 19537845, 21072646, 19627721, 20898391, 19291380
28226179, 27060167, 20534663, 22329820, 19705781, 22536802, 22087683
21197626, 21656630, 20373598, 22707866, 19279273, 19475148, 18886413
19513406, 25490238, 21517767, 20696223, 20922010, 25150925, 22247534
27006218, 22913528, 25433696, 18674170, 24642496, 20703000, 20018770
20313024, 18608261, 22476743, 25975723, 24560906, 20144308, 19727038
19670108, 19068610, 23508801, 20267166, 19460920, 19297917, 21218121
22950945, 20564072, 19385656, 23528412, 19220183, 22311278, 23115314
21174504, 22140382, 23134070, 28357401, 21274291, 20557786, 21911701
19143550, 19787571, 20118035, 22030856, 20009833, 23065489, 18759589
19604659, 16359751, 26039623, 22820579, 19318409, 22653923, 20212067
29030780, 19540182, 19327391, 20256086, 20068538, 21668627, 19196832
19822816, 23272045, 19912337, 19487147, 23149541, 24581821, 17158137
22845846, 25954054, 25646373, 20754583, 21350832, 21296029, 21629064
19662976, 28737603, 22599147, 18952331, 19031341, 21827522, 24378358
19811709, 23229229, 20708701, 25353983, 19280225, 20613079, 20698836
19468890, 20354411, 19213447, 21157175, 19233039, 27314390, 26336977
21752827, 24974467, 25405100, 24393981, 18953292, 24409977, 22568016
18963099, 19313563, 23761724, 19269405, 19563715, 21626377, 20595686
20003240, 23105538, 26198926, 22778199, 25129925, 21218165, 22220445
17890099, 21649497, 26446098, 18791688, 19192487, 19641649, 19721304
22841860, 19168395, 18967466, 19890034, 19619732, 21164318, 20266282
23148260, 18090142, 19289499, 22468781, 16556115, 20139391, 21665955
19978542, 27151826, 19264172, 25477657, 23543183, 19409212, 19019270
19074086, 23035249, 20677974, 22264489, 18990693, 24664211, 19348649
19698567, 22569317, 19452434, 21422580, 24735430, 22338374, 21445204
20235511, 23220453, 18742258, 19649591, 23008056, 19200977, 20559144
18610915, 20723042, 22666802, 20690515, 19798240, 19512155, 22761738
21079201, 17947871, 20832516, 26089440, 19504946, 20828433, 26615291
20505778, 18733351, 22255113, 26362821, 21787056, 19989661, 21273804
22782647, 19126146, 20544065, 28033429, 18511269, 19049932, 17835294
20976241, 18868195, 19818721, 18971927, 27846298, 25305405, 18371441
19391024, 26714910, 24385983, 24421668, 19803231, 21550777, 23195445
20513399, 20106456, 22500027, 20930092, 22199829, 18909599, 19526750
19954575, 20370037, 23572982, 19392364, 21515534, 22514212, 22256431
19637186, 22094845, 19022470, 22094844, 18954112, 24944660, 24573817
19649152, 28951382, 19201867, 21058333, 20841419, 21888938, 20739811
27242226, 21842740, 19534363, 20024112, 25489607, 25142953
Patch 29705856 : applied on Mon Jul 15 03:34:48 UTC 2019
Unique Patch ID: 22895402
Created on 29 Apr 2019, 14:38:18 hrs PST8PDT
Bugs fixed:
23321125, 25139545, 25297023
This patch overlays patches:
29141038
This patch needs patches:
29141038
as prerequisites
Patch 21395269 : applied on Mon Jul 15 03:33:44 UTC 2019
Unique Patch ID: 22643173
Created on 3 Jan 2019, 03:54:55 hrs PST8PDT
Bugs fixed:
21395269
This patch overlays patches:
28731800
This patch needs patches:
28731800
as prerequisites
Patch 19215058 : applied on Mon Jul 15 03:32:42 UTC 2019
Unique Patch ID: 18676539
Created on 25 Feb 2015, 00:34:20 hrs PST8PDT
Bugs fixed:
19215058
--------------------------------------------------------------------------------
OPatch succeeded.

Regards,
Mallik

Wednesday, June 30, 2021

Download and Configure Terraform and Verify the Terraform Version

Terraform Software Supports on various OS:

Download and configure for Windows:

Download and configure for Linux:

Friday, June 25, 2021

IAC – Infrastructure as a code

Terraform is an IAC Software by HashiCorp.

Terraform is multi-cloud IAC tool.

Similar Tool like Terraform are:

What is infrastructure?What is infrastructure as code (IAC)?What are IAC software/tools?

Infrastructure?

Workflow Means

Infrastructure Types:

SDLC (Software Development Life Cycle):

Most common requirement for Infrastructure is?

To Do All these Tasks we use IAC – Infrastructure as code

Provisioning

IAC – Infrastructure as code

What are the advantages of using IAC?

Tools:

Thursday, June 24, 2021

12c Data guard Switchover Best Practices using SQLPLUS (Doc ID 1578787.1)11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 1304939.1)

Pre Checks:

Switchover:

PROD Env:

DR Env:

Primary:

Standby:

Prechecks Checks:

PROD:

DR:

DR:

PROD:

On New Primary:

Tuesday, June 15, 2021

How to create common user at CDB level:

How to create local user at PDB level:

Default service names in PDB:

How to connect to PDB$SEED:

How to create new service and how to delete service at PDB level:

Check the active service and and services at CDB and PDB level:

How/Where the PDB datafile are located:

Monday, June 14, 2021

List applied patches using below commands

What is infrastructure?
What is infrastructure as code (IAC)?
What are IAC software/tools?

12c Data guard Switchover Best Practices using SQLPLUS (Doc ID 1578787.1)
11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus (Doc ID 1304939.1)