
APPSDBAFREELANCE.BLOGSPOT.COM
Apps DBA Free Lance<b>This Blog is for All Oracle Apps DBA (11i / R12) Related Queries.... <br>.</b> Join this Blog for the latest updates on Oracle EBS R12 /Oracle Apps DBA..
http://appsdbafreelance.blogspot.com/
<b>This Blog is for All Oracle Apps DBA (11i / R12) Related Queries.... <br>.</b> Join this Blog for the latest updates on Oracle EBS R12 /Oracle Apps DBA..
http://appsdbafreelance.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
1 seconds
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
0
SITE IP
172.217.11.33
LOAD TIME
0.953 sec
SCORE
6.2
Apps DBA Free Lance | appsdbafreelance.blogspot.com Reviews
https://appsdbafreelance.blogspot.com
<b>This Blog is for All Oracle Apps DBA (11i / R12) Related Queries.... <br>.</b> Join this Blog for the latest updates on Oracle EBS R12 /Oracle Apps DBA..
Apps DBA Free Lance: Alter Commands: -
http://appsdbafreelance.blogspot.com/2012/12/alter-commands.html
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. Alter database: Alter a Data File. ALTER DATABASE DATAFILE 4 OFFLINE;. ALTER DATABASE DATAFILE '/opt/oracle/datafile/users01.dbf' OFFLINE;. ALTER DATABASE DATAFILE '/opt/oracle/datafile/users01.dbf' RESIZE 100m;. ALTER DATABASE DATAFILE '/opt/oracle/datafile/users01.dbf'. AUTOEXTEND ON NEXT 100M MAXSIZE 1000M;. ALTER DATABASE ARCHIVELOG;.
Apps DBA Free Lance: How To recreate the OraInventory if it gets corrupted or removed?
http://appsdbafreelance.blogspot.com/2012/12/how-to-recreate-orainventory-if-it-gets.html
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. How To recreate the OraInventory if it gets corrupted or removed? In cases where the OraInventory is missing or otherwise corrupt, recreate the oraInventory directory on UNIX systems, using the following steps. In a normal installation, there is a Global Inventory (OraInventory) and a Local Inventory ($ORACLE HOME/inventory). 5 Run Oracle Un...
Apps DBA Free Lance: 09/01/2011 - 10/01/2011
http://appsdbafreelance.blogspot.com/2011_09_01_archive.html
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. Tuesday, 27 September 2011. Resolving Oracle networking problems. This simple two part procedure will help to diagnose and fix the most common sqlnet and tnsnames configuration problems. 1 Test communication between the client and the listener. Tnsping your tns entry name. If it is successful you will see something like this:. Oradev@testerp] $ tnspinng dev. The spec...
Apps DBA Free Lance: How to apply Database Patches
http://appsdbafreelance.blogspot.com/2012/12/how-to-apply-database-patches.html
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. How to apply Database Patches. How to apply Database Patches. Database patches are of various kinds like,But in broad there are II types:. I)Patchset: To upgrade to higher version we use Database patchset.i.e For Upgrading from 10.2.0.1.0 to 10.2.0.4.0 we have to use. Patchset Updates are mainly divided into two types:. Http:/ rafioracledba&...
Apps DBA Free Lance: 08/01/2011 - 09/01/2011
http://appsdbafreelance.blogspot.com/2011_08_01_archive.html
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. Thursday, 25 August 2011. Find which media tapes have the latest backup. You can find which media tapes have the latest RMAN backup with the following query:. SELECT RECID, STAMP, SET STAMP, SET COUNT, PIECE#, DEVICE TYPE, HANDLE, MEDIA,. Where SID is the database SID, for example A7. To find the distinct tapes use:. Apps DBA Free Lance,. Posted by sukhwinder Singh.
TOTAL PAGES IN THIS WEBSITE
19
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 ...
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.
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;.
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...
Resume of Monique Underwood
Senior Oracle Applications Engineer with comprehensive knowledge in Oracle Databases, Oracle Applications technology stack including architecture, installation, configuration, maintenance, cloning and patching, Workflow Mailer, Oracle development tools and UNIX operating systems. Results and goal-oriented individual highly motivated, competent in functioning alone or as an integral team member. Exceptional analytical and problem-solving skills. Excellent verbal and written communication skills. Install a...
Oracle DBA (Core & Apps) Lab
Oracle DBA (Core and Apps) Lab. Dedicated to All Oracle Apps DBA / Core DBA in the World! Friday, December 24, 2010. UNIX FOR DBA’S. The "pwd" command displays the current directory:. U01/app/oracle/product/9.2.0.1.0. The "ls" command lists all files and directories in the specified directory. If no location is defined it acts on the current directory:. The "-a" flag lists hidden "." files. The "-l" flag lists file details. The "cd" command is used to change directories:. Root touch my.log. The "which" c...