Database Blog

ORA-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 More

APEX 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

Steps 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 More

Oracle 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 More

Suspend 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 More

Renaming 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

Apps login shows blank page

Introduction solution to fix when apps login shows blank page Posted by Saravanan Problem : R12 AppsLocalLogin shows blank page Check for the following log file cd $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1 vi application.log Go…

Read More

Restrict adding blank row in Tabular form

Introduction: This post talks about how to restrict adding more than one blank row in Tabular form using JavaScript in Oracle Apex. Procedure: Create a Tabular form region. After creating…

Read More

Sending Calendar Invite via APEX Application

Introduction Using below code we can send individual emails to the users with an ICS file as attachment. ICS is a global format for calendar files widely being utilized by…

Read More

Role based Authorization in Oracle APEX5

 Introduction Following below we can implement Role based Authorization in Oracle APEX Application, in version 5. Steps To Follow Create below Application Item: USER_ROLE Table: ROLE_ACCESS_CONTROL The purpose of this…

Read More