Recent Updates Page 2 Toggle Comment Threads | Keyboard Shortcuts

  • Sachin Thapa 08:01 on February 7, 2016 Permalink | Reply  

    Hi Viewers,

    Thanks for all your support 41K+ views and still counting..
    Happy learning 🙂

    Cheers,
    Sachin

     
  • Sachin Thapa 06:18 on November 5, 2015 Permalink | Reply  

    Reach out us for any queries. 

     
  • Sachin Thapa 09:36 on October 24, 2015 Permalink | Reply
    Tags: , , , ,   

    Internal Workflow of an E-Business Suite Concurrent Manager Process 

    Concurrent processing is one of the key elements of any E-Business Suite system. It provides scheduling and queuing functionality for background jobs, and it’s used by most of the application modules. As many things depend on concurrent processing, it’s important to make sure that the configuration is tuned for your requirements and hardware specification.

    This is the first article in a series about the performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance, and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading!

    There are few things that need to be clear before we start: (More …)

     
  • Sachin Thapa 19:44 on August 12, 2015 Permalink | Reply
    Tags: , , , datafile is missing, ,   

    Full restore via RMAN of a database when a datafile is missing and never backed up !! 

    Problem Description
    ——————-

    Full restore via RMAN of a database when a datafile is missing and never
    backed up results in the following errors:

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command

    (More …)

     
  • K.T.Chowdary 14:58 on June 25, 2015 Permalink | Reply
    Tags:   

    Types of Checkpoint in Oracle 

    Checkpoint types can be divided as INCREMENTAL and COMPLETE.

    Also COMPLETE CHECKPOINT can be divided further into
    PARTIAL and FULL.

    In Incremental Checkpoint,checkpoint information is written to the
    controlfile. In the following cases:

    1.Every three second.
    2. At the time of log switch – Sometimes log switches may trigger a complete checkpoint , if the next log where the log switch is to take place is Active.

    In complete Checkpoint,checkpoint information is written
    in controlfile,datafile header and also dirty block is
    written by DBWR to the datafiles.

    Full Checkpoint

    1.fast_start_mttr_target
    2.Before Clean Shutdown
    3.Some log switches may trigger a complete checkpoint , if the next log where the log switch is to take place is Active.
    This has more chance of happenning when the Redo Log files are small in size and continuous transactions are taking place.
    4.when the ‘alter system checkpoint’ command is issued

    Partial Checkpoint happens in the following cases.

    1.before begin backup.
    2.before tablespace offline.
    3.before placing tablespace in read only.
    4.Before dropping tablespace.
    5.before taking datafile offline.
    6.When checpoint queue exceeds its threshold.
    7.before segment is dropped.
    8.Before adding and removing columns from table.

     
  • K.T.Chowdary 14:51 on June 25, 2015 Permalink | Reply
    Tags:   

    Uninstall all Oracle components using the Oracle Universal Installer (OUI) in Windows 

    • Run regedit.exe and delete the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE key. This contains registry entires for all Oracle products.
    • Delete any references to Oracle services left behind in the following part of the registry:

    HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Ora*

    It should be pretty obvious which ones relate to Oracle.

    • Reboot your machine.
    • Delete the “C:\Oracle” directory, or whatever directory is your ORACLE_BASE.
    • Delete the “C:\Program Files\Oracle” directory.
    • Empty the contents of your “c:\temp” directory.
    • Empty your recycle bin.
     
  • K.T.Chowdary 13:29 on June 11, 2015 Permalink | Reply
    Tags:   

    RMAN (Recovery Manger) 

    Important points about RMAN

    • Rman is centralized backup restore and recovery utility across the enterprise database.
    • If we configure rman there will be minimal dba intervention during restore and recovery
    • We can configure rman in 2 modes.
    • No catalog mode
    • Catalog mode (More …)
     
  • K.T.Chowdary 13:25 on June 11, 2015 Permalink | Reply
    Tags:   

    How to identify and recover from block corruption in RMAN? 

    First check whether the block is corrupted or not by using this command
    sql>select file# block# from v$database_block_corruption;

    file# block
    2 507

    the above block is corrupted…

    conn to Rman

    To recover the block use this command…

    Rman>blockrecover dataile 2 block 507;

    the above command recover the block 507

    Now just verify it…..

    Rman>blockrecover corruption list;

     
  • Sachin Thapa 19:00 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-00020 maximum number of processes exceeded . 

    ORA-00020 maximum number of processes exceeded
    Cause: All process state objects are in use.
    Action: Increase the value of the PROCESSES initialization parameter.

    ORA-00020 comes under “Oracle Database Server Messages”. These messages are generated by the Oracle database server when running any Oracle program.

    (More …)

     
  • Sachin Thapa 18:59 on May 18, 2015 Permalink | Reply
    Tags: , , ,   

    ORA-28002: the password will expire within 7 days . 

    ORA-28002: the password will expire within 7 days
    Cause: The user's account is about to about to expire and the password needs 
    to be changed.
    Action: Change the password or contact the database administrator.
    
    
    Reference: Oracle Documentation 
    
    Solutions:
    
    1) Simply change the password to avoid it temporary
    
      [oracle@lnxsvr ~]$ sqlplus scott/tiger
    
      SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012
    
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
      ERROR:
      ORA-28002: the password will expire within 7 days
    
      Connected to:
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
    
      SQL> PASSWORD
      Changing password for SCOTT
      Old password:
      New password:
      Retype new password:
      Password changed
    
    
    2) Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITED 
       then change the password to avoid it permanently
       
      [oracle@lnxsvr ~]$ sqlplus scott/tiger
    
      SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012
    
      Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
      ERROR:
      ORA-28002: the password will expire within 7 days
    
      Connected to:
      Oracle Database 11g Release 11.2.0.1.0 - 64bit Production   
    
      SQL> connect / as sysdba
      Connected.
      
      SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';
    
      PROFILE
      ------------------------------
      DEFAULT
    
      SQL> SELECT  LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' 
      AND RESOURCE_NAME='PASSWORD_LIFE_TIME';
    
      LIMIT
      ----------------------------------------
      60
    
      SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    
      Profile altered.
    
      SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';
    
      ACCOUNT_STATUS
      --------------------------------
      EXPIRED(GRACE)
    
      SQL> connect scott/tiger
      Connected.
      
      SQL> PASSWORD
      Changing password for SCOTT
      Old password:
      New password:
      Retype new password:
      Password changed
     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel