Hot PDB cloning in Oracle database 12.2

Last updated on November 26th, 2018 at 05:14 pmIn Oracle database release 12.1, in order to clone a PDB, The source PDB must be quiescent(read only mode) for the duration of the clone operation. So it was called a “cold clone” operation because it involved an outage (from a transactional perspective) in the source database. This applies for both the same CDB clone or Remote … Continue reading Hot PDB cloning in Oracle database 12.2 »

Refreshable PDB in Oracle Database 12.2

Last updated on November 26th, 2018 at 05:14 pmRefreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that … Continue reading Refreshable PDB in Oracle Database 12.2 »

Oracle Enqueue and locks(Oracle table locks): How it works

Enqueue and locks

Oracle database is the widely used database in industry .Here I am trying to explains  about oracle locks Topics Covered What is Oracle Enqueue and locks What is Enqueue identifier? What is Enqueue resource? How is the lookup done in Resource table? How is Enqueue operations works? How is the queue checked when lock is release or converted Common Types of Enqueue Views and Table … Continue reading Oracle Enqueue and locks(Oracle table locks): How it works »

MySQL COALESCE and NULLIF Function

Last updated on January 1st, 2019 at 01:02 pmWe will be discussing MySQL COALESCE and NULLIF Function  in this post . We will also be showing  MySQL COALESCE  examples and NULLIF mysql Function example COALESCE Function COALESCE  in MySQL is a very useful function to select first not null values from the list of values Syntax COALESCE(val1, val2,val3,…valn) The above syntax is equivalent to the … Continue reading MySQL COALESCE and NULLIF Function »

Coalesce Function in Oracle

Last updated on January 1st, 2019 at 01:06 pmCoalesce Function is a useful function in oracle and it is very useful when we want to return first non null values in the list expr1 : This is returned if it is not null expr2: This is returned if it is not null and first expression is null exprn: This is returned if the preceding expression … Continue reading Coalesce Function in Oracle »

NVL2 function in Oracle

Last updated on October 30th, 2018 at 04:33 amNVL2 function is a nesting function .It examines the first impression, if the the first impression is not null ,then NVL2 function returns the second expression. if the first impression is null, then it return the third expression. expr1: it is the source values or expression which may contain null. You can provide column name,function on the … Continue reading NVL2 function in Oracle »

NVL function in Oracle

NVL function is a nesting function which is used to substitute null values with certain values In the above syntax expr1 : it is the source values or expression which may contain null. You can provide column name,function on the column name expr2 : It is the target value which will be placed in case null is returned from expr1 If expr1 is null, then … Continue reading NVL function in Oracle »

Update statement in oracle

Update statement in oracle is used to update the existing rows in the table. It is a DML statement. DML stand data manipulation language. We can use this statement to update specific rows ,set of rows or all rows in the table. Syntax is given below Table : It is the table name which need to be updated column : it is the single column … Continue reading Update statement in oracle »

Unable To Authenticate Session in R12

Unable To Authenticate Session or Unable to create session is one of the most common errors in R12 instance ERROR ———————– “Unable to authenticate session” This can happen after the instance is cloned or any changes happened to the system with wrong parameter The first log which you should check in case of this error is $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log Here are some common errors which you might … Continue reading Unable To Authenticate Session in R12 »

Helpful queries for Oracle Apps

How to compile the package,package body ,procedures alter package <package name > compile; alter package <package name > compile body; alter procedure <procedure name > compile; If it is not successfully compiled, we can look at the errors from the below sql Login to SQL*Plus. SELECT text FROM dba_errors WHERE name = packagename; The output will look something like this. TEXT ——————————————————————— PLS-00302: component ‘XYZ’ … Continue reading Helpful queries for Oracle Apps »

How to assign User management Responsibility to user in R12

You may need sometimes to assign User management responsibility to the users in EBS R12 Steps to assign the responsibility are Open Define User form Look for the user which need to assigned the responsibility by typing user name in username column and pressing F11 Assign the user management responsibility to the user and Press Save Now User should be  able to see the responsibility … Continue reading How to assign User management Responsibility to user in R12 »