Techgoeasy

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 …

How to define custom application in R12 Read More »

Snapshot controlfile feature with RMAN and ORA-00245

Oracle, Oracle Database

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 …

Snapshot controlfile feature with RMAN and ORA-00245 Read More »

40 Adpatch question every DBA should know

Interviews questions, Oracle, Oracle Ebuisness Suite

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 …

40 Adpatch question every DBA should know Read More »

How to restart and skip the job from AD Controller ( ADCTRL)

Oracle, Oracle Ebuisness Suite

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 …

How to restart and skip the job from AD Controller ( ADCTRL) Read More »

Running Opatch throws up org.xml.sax.SAXParseException: : XML-20108: (Fatal Error) Start of root element expected

Oracle, Oracle Ebuisness Suite

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 …

Running Opatch throws up org.xml.sax.SAXParseException: : XML-20108: (Fatal Error) Start of root element expected Read More »

JRE not found message while running runInstaller

Oracle, Oracle Ebuisness Suite

We often need to run runInstaller to attach Oracle home to the inventory.Recently while attaching a oracle home to central inventory i get JRE not found message while running runInstaller Issue Run runInstaller from $ORACLE_HOME/oui/bin, it fails with the following error: Starting Oracle Universal Installer… No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will …

JRE not found message while running runInstaller Read More »