pdpshetty.blogspot.com
ORACLE DBA-APPS DBA: Maintenance Commands
http://pdpshetty.blogspot.com/2008/06/maintenance-commands.html
THIS SITE IS TOTALLY DEDICATED TO ALL ORACLE DBA AND APPS DBA LOVERS.I WILL TRY TO COVER ALL MY EXPERIENCES AS AN ORACLE DBA. Monday, June 2, 2008. RMAN provides several commands that can be used for maintenance:. Verify that all backups on the backup media are intact. CROSSCHECK BACKUP OF DATABASE;. Display a list of files that need to be backed up based on. The retention policy. For this case study, files that don't. Have at least 2 backups will be reported. REPORT NEED BACKUP;. Datafile will be deleted.
pdpshetty.blogspot.com
ORACLE DBA-APPS DBA: Scheduling backup using Crontab in Linux
http://pdpshetty.blogspot.com/2008/06/scheduling-backup-using-crontab-in.html
THIS SITE IS TOTALLY DEDICATED TO ALL ORACLE DBA AND APPS DBA LOVERS.I WILL TRY TO COVER ALL MY EXPERIENCES AS AN ORACLE DBA. Monday, June 2, 2008. Scheduling backup using Crontab in Linux. Edit the crontab using following command and add the line as below:. 0 06,18 * * * sh /home/oracle/Desktop/bkup.sh. Scheduling backup twice a day at 6 in the morning and 6 in the evening. Contents of bkup.sh. Export ORACLE HOME=$ORACLE BASE/product/10.1.0/db 1. Crontab -l To list the cron jobs scheduled. Month (1 - 12).
pdpshetty.blogspot.com
ORACLE DBA-APPS DBA: Understanding Asynchronous COMMIT
http://pdpshetty.blogspot.com/2008/06/understanding-asynchronous-commit.html
THIS SITE IS TOTALLY DEDICATED TO ALL ORACLE DBA AND APPS DBA LOVERS.I WILL TRY TO COVER ALL MY EXPERIENCES AS AN ORACLE DBA. Wednesday, June 4, 2008. Before Oracle 10g Release 2, Life cycle of a transaction was as follows:. Transaction Starts When User Issues the First DML, Oracle generates redo entries corresponding to the DML and write it to buffer in memory. While user is issuing DML, Oracle generates redo entries corresponding to the DML and write it to buffer in memory. By default, if no WRITE clau...
pdpshetty.blogspot.com
ORACLE DBA-APPS DBA: Restoring and Recovering the Target Database
http://pdpshetty.blogspot.com/2008/06/restoring-and-recovering-target.html
THIS SITE IS TOTALLY DEDICATED TO ALL ORACLE DBA AND APPS DBA LOVERS.I WILL TRY TO COVER ALL MY EXPERIENCES AS AN ORACLE DBA. Monday, June 2, 2008. Restoring and Recovering the Target Database. In this case study, (running in no-archivelog mode), any user error. Would require a complete database recovery. You can, however, use the. Command, to recover to different points in time when incrementals were taken. (Keep in mind that in our example, we did not make use of incremental backups! Apply all incremen...
pdpshettyappsdba.blogspot.com
Oracle Apps Dba: Which FND_USER is locking the table
http://pdpshettyappsdba.blogspot.com/2008/06/which-fnduser-is-locking-table.html
Wednesday, June 11, 2008. Which FND USER is locking the table. This is a quick note to share a SQL that will tell you the FND USER.USER NAME of the person that has locked a given table in Oracle APPS. The column named "module" will tell you the name of the Form Function or the Concurrent Program Short name which has aquired a lock onto that table. Fuuser name locking fnd user name. Flstart time locking fnd user login time. Vpspid AS os process. FROM fnd logins fl. WHERE vs.sid = vlocked.session id. 10 Or...
pdpshettyappsdba.blogspot.com
Oracle Apps Dba: Load Balancer in Oracle Apps 11i , E-Business Suite
http://pdpshettyappsdba.blogspot.com/2008/06/load-balancer-in-oracle-apps-11i-e.html
Wednesday, June 11, 2008. Load Balancer in Oracle Apps 11i , E-Business Suite. What is Load Balancer in Oracle Applications 11i? Why I need load balancer in Apps 11? Is Increased load only reason for introducing load balancer in Apps 11i , No not at all . There are other reasons as well like (These are more advanced reasons and if you don't understand don't worry read it for understanding purpose at this minute). You want on some node only web server and some both form server and web server. Session Pers...
pdpshettyappsdba.blogspot.com
Oracle Apps Dba: How to Find Patching History (10.7, 11.0, 11i)
http://pdpshettyappsdba.blogspot.com/2008/06/how-to-find-patching-history-107-110.html
Wednesday, June 11, 2008. How to Find Patching History (10.7, 11.0, 11i). Starting with Oracle Applications 11.5.5 (or 11i.AD.E (Patch 1945611) and. Higher) a new autopatch feature that causes all patch history information to be. Stored in the database instead of the applptch.txt and applpsum.txt files was. Two scripts, adphrept.sql (patch history) and adfhrept.sql (file history),. Provide the patch and file history reports (see Note 162498.1). Both are. Adfhrept.r, respectively. Select DRIVER FILE NAME.
pdpshettyappsdba.blogspot.com
Oracle Apps Dba: Starting and Stopping Apps Server
http://pdpshettyappsdba.blogspot.com/2008/06/starting-and-stopping-apps-server.html
Thursday, June 5, 2008. Starting and Stopping Apps Server. Startup / Shutdown Apps. As you are aware by now there is Database Tier ( Database and DB Listener ) and Application Tier ( WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener, OnetoOne Fullfillment Server ). Order of StartUp of Services Should be. First DB Listener, Database and then Application Tier Services. Order of ShutDown of Services Should be. First Application Tier Services then Database and DB Listener. Oracle APPS ...