Hi Readers Finally, I’ve successfully passed 1Z0-074, Upgrade Oracle DBA 11g or 12c to 12c R2. It was almost more than 3 months that I’ve been preparing for this. The Exam contains 75 questions related to Oracle Database 12cR2 New Features. To earn this certification you need to get 63% marks. This was the result of […]
Articles Tagged: ORACLE 12.2
Managing Tablespace in Multi-Tenant Environment Part – II
In the previous article, we have seen System tablespace and Users tablespace. Managing Tablespace in Multi-Tenant Environment Part – I In this article we will see Temporary tablespace and Undo tablespace : Temporary Tablespace : Every CDB$ROOT can have one default temporary tablespace or tablespace group. Pluggable databases must have their own temporary tablespace to […]
Generating AWR report from Active Dataguard
Oracle 12.2 came up with a new feature that we can generate AWR report from Physical Standby database if we have enabled active datagaurd. We need to perform the following steps to enable AWR reporting from a physical standby database. Step 1: Unlock SYS$UMF user and change its password using SYS user. SYS$UMF account is used […]
Upgrade and Patch Application in Application Container
In previous article we have seen Installing Application and Synchronizing it with Application PDB. Introduction to Application Container Application Container Creation and Installation of Application In this article, we will see upgrading Application and Patching Application. 1. Upgrade Application in Application Container : Before starting application upgrade you need to know the current version of […]
Application Container Creation and Installation of Application
In the previous article, we have seen Introduction of Application Container Introduction to Application Container In this article we will see creating Application Container, Installing Application in Container, Creating Application PDBs and syncing application PDB with application root. Step 1: Create an application root database SQL> CREATE PLUGGABLE DATABASE APP_PDB AS APPLICATION CONTAINER ADMIN USER APP_ADMIN […]
Introduction to Application Container
Application container is a new feature introduced in Oracle 12c Release 2. The main benefit of an application container in your environment is it makes application level patching and upgrade easy. Introduction of Multitenant Architecture In a product based company where you have multiple customers which are having same application running in your PDBs. We […]
Standby with DBCA in Oracle Database 12cR2
In the new features of Oracle Database 12cR2 (12.2.0.1) DBCA can already be used to create dataguard on the standby side. Below is the environment detail: Type Hostname db_unique_name Primary host01 orclpri Standby host02 orclsby Enable force logging on primary. SQL> alter database force logging; Database altered. SQL> select name,force_logging from v$database; NAME FORCE_LOGGING ————————— […]
Prepare standby and configure primary database for far sync
This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and physical standby database are async. Let’s begin with creating the physical standby with FAR SYNC instance in place. First of […]
TWO_TASK Environment Variables Oracle 12c
There are two environment variables for Unix to connect an Oracle database.One of them is ORACLE_SID and the other one is TWO_TASK. ORACLE_SID is used for connecting a database which is installed to the same host. TWO_TASK is used for connecting an oracle database which is installed another host. I must thank to my fellow DBA […]
Oracle Cloud (DBaaS): Move PDB with exporting the TDE master Key in Oracle 12.2
This article was written by Skant Gupta and Joel Perez in Oracle OTN. Security is one of the main issues that customers think at the time of moving or having the databases, applications and more into the Cloud. Security has many layers, areas, sections and more. When we work with databases “On-Prem”, security in many […]