
appsdbalab.blogspot.com
Oracle DBA (Core & Apps) LabDedicated to All Oracle Apps DBA / Core DBA in the World !!!
http://appsdbalab.blogspot.com/
Dedicated to All Oracle Apps DBA / Core DBA in the World !!!
http://appsdbalab.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.4 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
8
SSL
EXTERNAL LINKS
0
SITE IP
172.217.11.33
LOAD TIME
0.375 sec
SCORE
6.2
Oracle DBA (Core & Apps) Lab | appsdbalab.blogspot.com Reviews
https://appsdbalab.blogspot.com
Dedicated to All Oracle Apps DBA / Core DBA in the World !!!
Oracle DBA (Core & Apps) Lab: December 2010
http://appsdbalab.blogspot.com/2010_12_01_archive.html
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...
Oracle DBA (Core & Apps) Lab: September 2010
http://appsdbalab.blogspot.com/2010_09_01_archive.html
Oracle DBA (Core and Apps) Lab. Dedicated to All Oracle Apps DBA / Core DBA in the World! Thursday, September 23, 2010. Enable Trace for long running Concurrent Request in Apps 11i/R12. This post covers overview of How to troubleshoot long running concurrent request in Oracle Apps 11i/R12. Step 1 : Check Concurrent Request ID of long running concurrent request from front end. Step 2 : Find SID, SERIAL# and SPID by running SQL (given below). Step 4 : Disable trace (once you are happy with trace size).
Oracle DBA (Core & Apps) Lab: January 2009
http://appsdbalab.blogspot.com/2009_01_01_archive.html
Oracle DBA (Core and Apps) Lab. Dedicated to All Oracle Apps DBA / Core DBA in the World! Tuesday, January 27, 2009. RMAN - -Backup and recovery Methods being followed. RMAN - -Backup and recovery Methods being followed. These are to be done in the machine where you want to keep the RMAN catalog. Create a Database in the machine where you want to keep the RMAN catalog. 11: Create a folder with the Database name. (say. Mkdir '/d01/oracle/visdb/9.2.0/test/. Within that folder make 3 sub folders. SQL create...
Oracle DBA (Core & Apps) Lab: ORA-01555: Snapshot too old : rollback segment number XXX with name NNN too small.
http://appsdbalab.blogspot.com/2010/09/ora-01555-snapshot-too-old-rollback.html
Oracle DBA (Core and Apps) Lab. Dedicated to All Oracle Apps DBA / Core DBA in the World! Thursday, September 23, 2010. ORA-01555: Snapshot too old : rollback segment number XXX with name NNN too small. Rollback records needed by a reader for consistent read are overwritten by other writers. If in Automatic Undo Management mode, increase undo retention setting. Otherwise, use larger rollback segments. Alter rollback segment rbs0 storage (optimal 100m);. Alter system set undo retention=10800;.
Oracle DBA (Core & Apps) Lab: How to enable trace in Oracle DB level
http://appsdbalab.blogspot.com/2010/09/how-to-enable-trace-in-oracle.html
Oracle DBA (Core and Apps) Lab. Dedicated to All Oracle Apps DBA / Core DBA in the World! Thursday, September 23, 2010. How to enable trace in Oracle DB level. 1 Enable trace at instance level. Put the following line in init.ora. It will enable trace for all sessions and the background processes. Sql trace = TRUE. Sql trace = FALSE. To enable tracing without restarting database run the following command in sqlplus. SQLPLUS ALTER SYSTEM SET trace enabled = TRUE;. To stop trace run:. Oracle Apps DBA Labs.
TOTAL PAGES IN THIS WEBSITE
8
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...
Just Another Day of Apps DBA's Life | notes of an oracle apps dba
Just Another Day of Apps DBA's Life. Notes of an oracle apps dba. Author – Maris Elsins. GetMOSPatch.sh – Downloading Patches From My Oracle Support. November 12, 2013. This post originally appeared at the Pythian. How to download patches from My Oracle Support (MOS) directly to the server? Then, back in 2009 my teammate John. Published a blog post on Retrieving Oracle patches with wget. I think it’s time to get rid of browser dependency. So I’ve written a shell script getMOSPatch.sh. November 4, 2013.
Apps DBA Concepts
Just another WordPress.com weblog. Bulk collect comes handy for plsql. Find the current SQL in the database. Important for Windows Oracle Apps customer. How to find blocking session and kill the session from database. R12 - Shortcut to access the forms URL and sysadmin Responsibility page. Applications Short Name for most of the Apps Products. To find the StartCD version - R12. How to find an AD patchset level? ARCHIVE LOG START is DEPRECATED in 11g. Naveen – Pratical Apps DBA. On November 27, 2010.
Apps DBA notes | Just another WordPress.com weblog
Just another WordPress.com weblog. How Veeam backup MSSQL. July 8, 2016. I love Veeam. It is easy to use and do a nice job. Make our live easier than before. OK, What is important for DBAs here? What is the relation that DBA need to know about. How Veeam backup SQL server? This is first and most important question that I was looking for. Veeam is install service on VM during backup time and in our case is using Volume Shadow Copy Services (VSS) to backup SQL server. How this is going to be? BE CAREFUL AS...
Oracle Application DBA Portal
Major changes from 11i. Compile Apps Schema invalid objects in R12. Apps Components and Architecture. Upgrade 11.5.9 to 11.5.10.2. Upgrade from 11.5.10.2 to R12. Upgrading 9i to 10g with 11i. AppsDBA System Management Utilities Guide. Identifying Long Idle Sessions. Identifying High Active Sessions. Change hostname for EBS. Oracle12c Datafile moved Online. Upgrade 10g to 11g R1. Upgrade 11.2.0.2 to 11.2.0.3. Top 99 Responsibilities of a DBA. Disk I/O,Events,Waits. Oracle AS10g null protocol issue. New an...