appsdbablog.wordpress.com
Oracle Apps DBA | A Place to discuss Oracle Application DBA Topics
A Place to discuss Oracle Application DBA Topics. Apps DBA Interview Questions. September 11, 2006. In my first post i am planning to share whith you some applicatiosn DBA querstions that i have gathered from various sources. 1How many ORACLE HOME are Oracle Apps and whats significance of each? There are three $ORACLE HOME in Oracle Apps, Two for Application Tier (Middle Tier) and One in Database Tier. ORACLE HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database. Apps Listener ...
appsdbaclass.blogspot.com
Oracle Apps DBA (Oracle EBS R12)
This Blog is for All Oracle Apps DBA (11i / R12) Related Queries. Join this Blog for the latest updates on Oracle EBS R12 and Oracle Apps 11i DBA. Monday, February 06, 2012. Re-create database links : -. To check for the existence of database links, use SQL*Plus on the database server node to connect to the Applications database instance as APPS and run the following query:. Sqlplus apps/ apps password SQL select db link from dba db links;. Posted by Sukhwinder Singh. Links to this post. There was an err...
appsdbaexperts.blogspot.com
Apps DBA Help
Thursday, December 9, 2010. Upgrading R12.1.1 to 12.3.3. To apply Oracle E-Business Suite Release 12.1.3, follow these steps:. Download all the patches. P9239095 R12 GENERIC.zip. P9817770 R12.ATG PF.B R12 LINUX.zip. P9239089 R12.AD.B R12 LINUX.zip. P9239090 R12 LINUX 1of6.zip. P9239090 R12 LINUX 2of6.zip. P9239090 R12 LINUX 3of6.zip. P9239090 R12 LINUX 4of6.zip. P9239090 R12 LINUX 5of6.zip. P9239090 R12 LINUX 6of6.zip. P9966055 R12.FND.B R12 GENERIC.zip. B) Stop all application Services. Apply mandatory ...
appsdbafaqs.blogspot.com
ORACLE DBA AND ORACLE APPS DBA FAQS
ORACLE DBA AND ORACLE APPS DBA FAQS. This blog is designed to capture/compile all important,useful and real time questions,scenarios really required for a Oracle DBA and Oracle Apps DBA. Please do comment your comments and suggestions. Saturday, January 21, 2012. Patch Application Assistant (admsi.pl) in Oracle Apps R12. Patch Application Assistant) is tool/Perl script to generate customized installation instructions. Is under $AD TOP/bin. 2 You can run admsi.pl. Patch Application Assistant) in two mode.
appsdbaforum-biswajit.blogspot.com
Apps DBA Forum
Thursday, September 3, 2015. EBS Changes in R12.2. Oracle Weblogic Server ( Fusion Middleware 11g). Oracle Access Manager 11g. Details description about each of the changes to follow soon. Monday, March 23, 2015. RMAN configuration in 7 Steps. Even if you are not an Oracle DBA, you’ll still encounter a situation where you may have to take a backup of an Oracle database. Using Oracle RMAN, you can take a hot backup for your database, which will take a consistent backup even when your DB is up and running.
appsdbafreelance.blogspot.com
Apps DBA Free Lance
This Blog is for All Oracle Apps DBA (11i / R12) Related Queries. Join this Blog for the latest updates on Oracle EBS R12 /Oracle Apps DBA. Monday, 17 December 2012. Re-create database links : -. To check for the existence of database links, use SQL*Plus on the database server node to connect to the Applications database instance as APPS and run the following query:. Sqlplus apps/ apps password. SQL select db link from dba db links;. Sqlplus apps/ apps password. SQL alter session set global names=false;.
appsdbaguides.blogspot.com
AppsWorld
Friday, January 25, 2013. Query to fetch the Latest CPU patch details from Database. Column BUG format a8;. Column PATCH format a60;. Set linesize 100;. Set pagesize 200;. Select b.bug number BUG, b.LAST UPDATE DATE LDATE, decode(bug number,. 13979374, 'July 2012 CPU patch for 11i RUP7',. 13979377, 'July 2012 CPU patch for 11i RUP6',. 13979372, 'July 2012 CPU patch for R12.1 ATG PF.B.Delta3',. 13979375, 'July 2012 CPU for R12.0 ATG PF.A.Delta6',. 13621940, 'April 2012 CPU for 11i RUP7',. 13621939','13322...