Ranjit's Oracle Blogs

Panacea for an Oracle Applications Database Administrator with Real Application Cluster and Data Guard

Pages

  • Oracle database 10g,11g and Oracle Applications(EBS)11i,R12

Monday, 12 August 2013


Posted by Ranjit Keshari Beura at 8/12/2013 07:19:00 pm
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

One of the most important areas we can develop as professionals is sharing our knowledge

My photo
Ranjit Keshari Beura
Bangalore, Karnataka, India
ORACLE APPS DBA
View my complete profile

Blog Archive

  • ►  2022 (1)
    • ►  October (1)
  • ►  2018 (15)
    • ►  May (1)
    • ►  March (1)
    • ►  February (13)
  • ►  2017 (1)
    • ►  March (1)
  • ►  2016 (5)
    • ►  September (1)
    • ►  August (2)
    • ►  April (1)
    • ►  March (1)
  • ►  2015 (3)
    • ►  September (1)
    • ►  August (2)
  • ►  2014 (36)
    • ►  October (1)
    • ►  August (1)
    • ►  July (22)
    • ►  June (2)
    • ►  February (7)
    • ►  January (3)
  • ▼  2013 (317)
    • ►  December (11)
    • ►  November (7)
    • ►  October (25)
    • ►  September (41)
    • ▼  August (91)
      • Gather Statistics with DBMS_STATS
      • Parsing SQL Statements in Oracle
      • Oracle 11g Database Startup Failed: /dev/shm and O...
      • Hang Analyze and System State Dumps.
      • Recovery of a dropped tablespace
      • NOARCHIVELOG DATABASE RECOVERY VIA RMAN
      • RMAN Restore on another machine with different fil...
      • RMAN restore on the same machine - different datab...
      • Complete loss of all database files including SPFI...
      • POINT IN TIME RECOVERY via RMAN
      • Point in time recovery using RMAN (until a log seq...
      • Recovery from complete loss of all online redo log...
      • LOSS OF ALL CONTROLFILES (NO CATALOG)
      • Recovering Datafile for which no backup exist (In ...
      • Recovering Datafile for which no backup exist (In ...
      • RMAN Recovering Block Corruption
      • RECOVER DATAFILE USING RMAN
      • USERS TABLESPACE RECOVERY USING RMAN:
      • RMAN recovery through RESETLOGS
      • SQL Trace
      • TKPROF
      • application tunning
      • SQL Trace & TKPROF
      • How to Apply Critical Patch Update (CPU) on RAC
      • How to Recreate the OraInventory
      • Oracle 11g : Alert Log file
      • New Background Processes In 11g
      • scripts
      • Setting Oracle environment variables in UNIX
      • Gather Statistics with DBMS_STATS
      • Copying Oracle Home Directories using rsync
      • Oracle 11g Database Startup Failed: /dev/shm and O...
      • Oracle Hanganalyze Performance Problems “sqlplus -...
      • Expdp / Impdp
      • Cloning Database through RMAN
      • RMAN scenarios:-
      • RMAN Backup & Recovery Scripts for Linux System
      • How to configure or setup Flash Recovery Area to a...
      • All types of database files used in Oracle DB
      • Blocks , Extents, Segments in Oracle Database : Ba...
      • Find and resolve Blocking Session
      • Some apps cases
      • Important Apps Tables
      • Concurrent Program Phases and status List
      • Upgradation of Forms and Reports Oracle Home(10g) ...
      • MRC Implementaion on Existing Environment???
      • How do we know how many users are connected to Ora...
      • "Error Occurred While Attempting to Establish an A...
      • MSG-00102: Error Message :ORA-20100: File o0000071...
      • Forms Servlet mode to Socket mode conversion on Re...
      • How to enable Apache and Jserv Debugging in Oracle...
      • APP-FND-00002: Password must contain at least one ...
      • Apps DBA - Concurrent Managers
      • Some more about RAC in details:
      • How to Create The Service Manager ‘FNDSM’ on Oracl...
      • sys.utl_recomp.recomp_parallel(20); is failing wit...
      • Simple PCP configuration
      • Apps DBA Scripts
      • Cancelling Concurrent Request from backend (script...
      • AutoConfig on the Database Tier for a New ORACLE_HOME
      • Is it safe to delete files under $COMMON_TOP/temp ...
      • FNDLOAD Utility
      • Oracle Apps R12 Forms Not Opening
      • Patching Activity Steps and Information -Oracle APPS
      • adoafmctl.sh: exiting with status 150|OPMN service...
      • What and when Index Scans is used
      • How to adjust the high watermark in ORACLE 10g – A...
      • Oracle Database 11g new feature – Automatic Memory...
      • some performance related issues
      • some important dba scripts
      • Step by Step Upgrading Oracle 10g to Oracle 11g
      • Metadata Filtering with EXLUDE & INCLUDE using EXPDP
      • RMAN Incremental Backups to Roll Forward a Physica...
      • RMAN Incremental Backups to Roll Forward a Physica...
      • RMAN Incremental Backups to Roll Forward a Physica...
      • fractured block
      • fractured block
      • 11g Agent Deployment from GRID
      • Drop User with ORA-26500
      • How to Shrink Datafiles
      • Scripts for Object Locks and Blocking Sessions.
      • Tablespace Used , Free & Total Sizes of each table...
      • To get Actual, Optimal, Reclaimable Size from the ...
      • To know ,Current SQL’s running on Instance
      • Applying CPUJan2012 Patch on 11.2.0.2/Linux(64 bit)
      • How to check the PSU/CPU patches applied
      • data pump inbetween features
      • Oracle DataPump Utility 11.2.0.3
      • Logical Backup for Oracle Databse using export and...
      • how expdp is faster than exp, what oracle internal...
    • ►  July (81)
    • ►  June (61)

Total Pageviews

Search This Blog

Followers

Popular Posts

  • SCAN and VIP Concepts in RAC
    SCAN NAME  concept was introduced in Oracle 11g and it's still unsolved mystery for few of the  Database Administrators .  The main pu...
  • Oracle R12 Apps Tables
    Oracle R12 Apps Tables Key Tables in Oracle Inventory Here is a brief description of the key tables in Oracle Inventory. Table...
  • Concurrent Manager Concepts
    Concurrent Processing  = This is a batch processing job which runs in background while user works on front end transaction. Concurrent R...
  • Script to Monitor and tune Oracle Database
    Create profile with the best plan- 1.  alter session set nls_date_format = 'DD/MM/YY HH24:MI:SS'; 2. select sql_id,plan_hash_...
  • Patching Activity Steps and Information -Oracle APPS
    1. Steps in Applying a Patch   a) login as applmgr and set the environment. For the Windows environment also, you have to test that CLASS...
  • Identify your RAC Network details.
    As per defined IP Addresses in /etc/hosts, Let’s find the same information using various commands available from GRID and OS. Let’s ver...
  • 1.what really happens internally in hot backup
    What Happens during a hot backup? There are a couple of myths around the hot backup or online backup process: Myth #1: The hot bac...
  • Blocks , Extents, Segments in Oracle Database : Back to Basics
    On popular demand from our newbie DBA readers, I am starting Oracle Database  Back to Basics  series where I am going to cover basic conce...
  • Expdp / Impdp
    Data pump is a new feature in Oracle10g that provides fast parallel data load. With direct path and parallel execution, data pump is sever...
  • important ora errors
    1.  ORA-04021: timeout occurred while waiting to lock object %s%s%s%s%s". Errorstack ORA-04021: timeout occurred while waiting t...

Links really helpful

  • morganslibrary
  • oracledba
  • ora errors
  • personal docs
  • oracle forum
  • data disk
  • important topics
  • ora faq
  • oracle documents
  • burleson

Translate

Contact Form

Name

Email *

Message *

As a reference u may follow it.Please share some suggestions over there if u have.Thank You. Watermark theme. Powered by Blogger.