A few days back I did create the physical standby database for our Oracle production database.I thought of sharing the experience with you. So here are detailed steps on How to do physical Standby creation I am assuming we have Oracle ASM configured on both the primary and standby site. ASM instance has DATA diskgroup […]
How to define custom application in R12
I was doing registration of custom application in R12 EBS env.So thought of sharing with here Here are steps on How to define custom application in R12 1) Make the directory structure for your custom application files. cd $APPL_TOP mkdir techgo mkdir techgo/12.0.0 mkdir techgo/12.0.0/admin mkdir techgo/12.0.0/admin/sql mkdir techgo/12.0.0/admin/odf mkdir techgo/12.0.0/sql mkdir techgo/12.0.0/bin mkdir techgo/12.0.0/reports mkdir […]
Snapshot controlfile feature with RMAN and ORA-00245
What is Snapshot Control file in Oracle? When RMAN needs to re-synchronize from a read-consistent version of the control file, it creates a temporary snapshot control file. RMAN needs a snapshot control file only when re-synchronizing with the recovery catalog or when making a backup of the current control file. If you are not using […]
40 Adpatch question every DBA should know
Here is the compilation of 40 Adpatch question every DBA should know What are the different types of patches? Ans : oneoff, mini packs, family packs, maintanance packs, rollup pathches, colsolidated patches. What is a oneoff patch? Ans : An oneoff patch is a small patch of (20-90K size) without any pre-req’s What is a mini […]
How to restart and skip the job from AD Controller ( ADCTRL)
AD Controller Usage: adctrl By using the AD Controller utility, you can determine the status of AutoUpgrade, AutoPatch(adpatch) , adop or AD Administration(adadmin) workers. You can also use it to and restart failed tasks. With AD Controller you can: Review worker status Restart a failed worker Restart a terminated worker Shutdown a worker Skip the […]
Running Opatch throws up org.xml.sax.SAXParseException: : XML-20108: (Fatal Error) Start of root element expected
Recently after applying multiple patches to a 10.1.2 oracle in EBS and then doing opatch lsinventory ,i received below error Oracle Interim Patch Installer version 10.0.0.64.0 Copyright (c) 2015, Oracle Corporation. All rights reserved. Oracle Home : /u11/app/oracle/product/10.1.2 Central Inventory : /var/opt/app/oraInventory from : /u11/app/oracle/product/10.1.2/oraInst.loc OPatch version : 10.0.0.64.0 OUI version : 10.2.0.3.0 Log file […]
