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

  • 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...
  • How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12
    For the process to complete successfully, the database and database listener must be started. It is not neccessary that any other Apps serv...
  • How to get Trace File for concurrent program in Oracle Apps
    1.      Navigate to Profile/System and query the following profile name: a.      Concurrent: Allow Debugging b.      Set this profile ...
  • How to configure Load Balancer in Oracle E-Business Suite R12
    This post covers steps to configure  Load Balancer  (with assumptions mentioned below) with Oracle E-Buisness Suite R12 . For overview an...
  • ORA-00600: internal error code, arguments
    Oracle support suggests as Below: Identify the object causing the ORA-600 [kdsgrp1] to be raised For example, the trace file DW2T2_o...
  • (i)export import utility in oracle
    INTRODUCTION Oracle Data pump utility enables very fast bulk data and metadata movement between Oracle databases. It provides parallel E...
  • My query is picking a bad execution plan , how to fix it to use the good execution plan available by using Oracle baselines
    Using Oracle baselines you can fix the sql plan for a SQLID:                                                    SQL plan management i...
  • Blackout configuration on Oracle Enterprise Manager
    How to Configure Blackout on OEM??? Blackouts with EMCTL I have a need to take down a database to perform a cold snapshot of the d...
  • How to Turn Tracing on Concurrent Program
    ================================= How to Turn Tracing on Concurrent Program ================================= Log into front end. using you...
  • Oracle Background processes
    You can see the Oracle background processes with this query: select * from    v$session where    type ='BACKGROUND'; H...

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.