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 […]
Monthly Archives: August 2018
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 […]
Manually Create and configure CDB database and PDB database
In the previous article, we can see that the architecture of multitenant. In this post, we will configure manually CDB and PDB. Introduction of Multitenant Architecture Step 1: create initmycdb.ora [oracle@localhost ~]$ cd $ORACLE_HOME/dbs [oracle@localhost dbs]$ cat initmycdb.ora db_name=mycdb CONTROL_FILES=’/u02/oradata/mycdb/control01.ctl’,’/u02/oradata/mycdb/control02.ctl’ ENABLE_PLUGGABLE_DATABASE=TRUE DB_CREATE_FILE_DEST=’/u02/oradata/’ DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’ DB_BLOCK_SIZE=8192 UNDO_MANAGEMENT=AUTO UNDO_TABLESPACE=undotbs USER_DUMP_DEST=’/u01/oracle/admin/mycdb/adump/’ Step 2: Create necessary directories. [oracle@localhost dbs]$ mkdir […]
Describe the CDB root and pluggable database containers
In the previous article, we have explored Multitenant architecture. Introduction of Multitenant Architecture We have heard this word container database and pluggable database many times after 12c came into the market. Today we will see what does it mean by a pluggable database and container database. Container Database and Pluggable Database : In a multi-tenant […]
Introduction of Multitenant Architecture
Oracle databases are always extremely advanced and sophisticated software components that are state of the art for RDBMS. Till 12.1 came into the market we used to have Single Database associated with Single Instance [Except RAC environment], to support each application we need to create a new database. So the organization which handles 50 different […]
Creating Data Guard with 2 node RAC Primary and 2 node RAC standby
In this article, we will see the creation of DataGuard with 2 node RAC Primary Database and 2 node RAC Standby database. Primary Database Standby Database Primary Instance Standby Instance RACDB DGRACDB RAC1 DGRAC RAC2 DGRAC1 What I have already done 1. My production database is up and running with 2 node RAC Oracle Version […]
Advantage Of RMAN in Oracle
This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits. RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]
Using DBMS_ROLLING to Upgrade the Oracle Database
We know the pain of Upgrading Database, taking hours of downtime. But, Oracle comes with a new feature called DBMS_ROLLING from 12C Release 1. If you are having a license for Active Data Guard this method will minimize your downtime for upgrade or patching. This method is well automated. You just need 90 seconds 120 […]
TNS-12547: TNS:lost contact
Being DBA we all are aware that we must have knowledge of OS level too because Database not just runs over the only one OS. In a different organization, we have a different OS. Being a part if IT we understand that different OS environment has a different parameter. We have to set them. Today […]
ORA-12154: TNS:could not resolve the connect identifier
We are continuing with the same series of listener errors. Let’s have looked over the new error. Let’s go for the steps [oracle@hostname]$ sqlplus sys@test_1as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 7 15:01:04 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter password: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified […]