Scripts related to TEMP TABLESPACE
Posted by Abishek Kathiresan Introduction: Hi All, Here we will discuss Scripts related to TEMP TABLESPACE. To check instance-wise total allocated, total used TEMP for both rac and non-rac set…
Read MoreOracle – Data Guard Broker Setup
Posted by Sundaravel Ramasubbu Introduction : In this session we will see How to set up Data Guard Broker. NOTE: Environment in my case Prerequisite Check DG_BROKER_START parameter on Primary and…
Read MoreBlock 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 MoreUsers Receive Error “Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object” During Login To E-Business Suite
Posted by Jayachandran A On : 12.1.1 version, Jserv, JDK, JVM, JRE Introduction: When attempting to login EBS, the following error occurs. ERROR ———– Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException:…
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 MoreEBS R12.2 Cloning Steps
Posted by Venkatesh R K Introduction: In this document we are going to discuss the steps for EBS Cloning. NOTE: The following Clone approach is applicable for the APPLICATION version from…
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 More