Edition-based redefinition in Oracle Database 11gR2//12c/18c/19c allows multiple versions of PL/SQL objects, views and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero down time. It also means we can maintain multiple copies of the same object What is Edition in Oracle? An edition is effectively a […]
10 Things you must know about EBS R12.2
(1) Adop uses SID_patch service_name to connect to database (2) Adop Connects to other nodes in multinodes setup via ssh and applies the patch ( similar to RAC patchings).It is executed by user on master node.It is important to enable the ssh from master node to other nodes If a node unexpectedly becomes inaccessible via […]
Oracle EBS with Oracle Database 19c frequently Asked Questions
Now Oracle EBS is certified to use with Oracle database 19c(19.3) . Also A CDB with one PDB (single tenant) is currently the only certified deployment for Oracle E-Business Suite with Database 19c. So oracle database has to be multitenant on Oracle 19c. Many questions comes when it comes to using Multitenant database with EBS […]
How to create RMAN recovery catalog and register database in catalog
RMAN Recovery catalog is a very important registry. Control file registry get rotated after some time so you lost many backup information. By storing backup information in recovery catalog ,you get rid of this problem Also it provides a central repository where you can find all the backup information. Here are the steps on How to […]
Oracle 19c upgrade step by step
Here in this post, we will looking at how to upgrade an existing 12c database to 19c Database.Here is the high level summary of the steps Installation of Oracle 19c Oracle Home Preupgrade Checks 19c Upgrade PostUpgrade Checks Installation of Oracle 19c Oracle Home You can take a look at the below article for detailed […]
Timezone settings in Oracle database
I am presenting here the some of the good queries on timezone settings how to check timezone version in oracle database/how to check dst patch in oracle SQL> select * from v$timezone_file; FILENAME VERSION ———— ———- timezlrg.dat 4 or SELECT tz_version FROM registry$database; or COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A20 SELECT property_name, property_value […]
