Block change tracking for faster Incremental RMAN backups
Posted by Abishek Kathiresan Introduction: The details of changes in the blocks of the database after the last backup are written in the block change tracking file. RMAN uses this…
Read MoreRenaming constraints
Posted by Mahendran Manickam Introduction: Here we will see How to rename a constraint in Oracle Database. Step 1: Login to sqlplus SQL> show user; USER is “MAHE” SQL> select dbms_metadata.get_ddl(‘TABLE’,…
Read MoreStarting Http Server by “Opmnctl Startall” result with “[error] (79) Value too large for define data type: could not open transfer log file /apps/oracle/logs/access_log” error in error_log file
Posted by Jayachandran A OMS_HOME/Apache/Apache/log/error_log shows: [timestamp] [error] (79) Value too large for define data type: could not open transfer log file /apps/oracle/logs/access_log or [Tue Oct 11 11:26:36 2011] [notice] child…
Read MoreORA-00600: internal error code, arguments: [2619], [4476], [], [], [], [], [], [], [], [], [], []
Posted by Sathiyaseelan Mariappan Problem: Physical standby recovery reports error in alert log: Wed Jun 23 01:10:22 2010 Media Recovery Log /mnt/import/recovery_standby/4_77799_650412287.dbf Errors in file /oracle/diag/rdbms/db1/DB1/trace/DB1_pr00_16417.trc (incident=360443): ORA-00600: internal error code,…
Read MoreORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable
Posted by Venkateshwaran Govindaraj ISSUE: ———- ORA-27492: unable to run job “APEX_040200.ORACLE_APEX_MAIL_QUEUE”: scheduler unavailable SOLUTIONS: —————— Alter system set job_queue_processes=1000;
Read MoreAPEX LOGIN ERROR
Posted by Venkateshwaran Govindaraj Introduction: Here we will discuss the error which i Faced in Oracle Apex. ERROR: I USED CORRECT USERNAME AND PASSWORD BUT STILL I FACED LOGIN ERROR SOLUTION:…
Read MoreSteps to enable recycle bin in oracle 10g and 11g
Posted by Abishek Kathiresan Below are the steps to enable recycle bin in oracle 10 & 11g Step 1: log into sqlplus SQL> SHOW PARAMETER RECYCLEBIN NAME …
Read MoreOracle Database and Applications Security Audit Part 1
Posted by Narasimha Rao.K Oracle Database and Applications Security Audit Part 1 Introduction: Hello Everyone, I would like to start series of write ups/post based on the experience regarding How to…
Read MoreSuspend and Resume in Oracle Database
Posted by Abishek Kathiresan Here we will see the suspend/resume feature in Oracle Database. ALTER SYSTEM SUSPEND statement stops all input and output (I/O) to datafiles (file header and file…
Read MoreRenaming redolog members
Posted by Mahendran Manickam Introduction: In this session we will discuss that how to remane redolog members Steps to be followed: Step1: To complete this requirement you have to shutdown the…
Read More