Database Blog

Data Guard Log Shipping Fails With Error Ora-16191 In 11g

Posted by Sundaravel Ramasubbu Issue: PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191. Sat Aug 06 02:06:52 2011 Error 1017 received logging on to the standby ———————————————————— Check…

Read More

How to create Oracle EBS (Applications User ) with only read privilege

Posted by Abishek kathiresan Introduction: Hi Everyone here will discuss how to create Oracle EBS(application user) with only read privilege Steps to be followed: 1.Connect to the Oracle EBS 2.…

Read More

Concurrent request running abnormally for very long time without completion

Posted by  Abishek kathiresan Introduction: In this document I will show you a solution for Concurrent request running abnormally for very long time without completion 1. Identified the long running…

Read More

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 More

Creating Interactive Report as Excel format with applying font for particular column values

Introduction          If we want to show any report in excel format in page level with the different font of column values we can use this component script to achieve…

Read More

Restrict Copy Paste & Right Click In Apex Page

Introduction The Purpose of this component is to restrict the copy option from the user level of apex page.  Context Consider in our apex application we are providing any confidential…

Read More

Breadcrumbs Using Page Items

Introduction  According to the customer’s requirement, there is a table that contains both parent parts and child parts in one table. Once we create a part, a link must be…

Read More

MINIMUM DATE AND MAXIMUM DATE FOR A DATE PICKER IN A TABULAR FORM

Introduction  Using this you can set the date range of the Date picker in tabular form.  Steps to follow:  Step 1:  Set SYSDATE as the source value to an item Using PLSQL…

Read More

Displaying Classical Report in Full page with Less Columns

Introduction  This post details the steps required to display classic report in full page with less number of columns.   Step to follow:  Step 1:  Go to the page header,…

Read More

Include or Exclude column in APEX interactive report download

Introduction  This is to include or exclude column from interactive report during download.  Include column only in download Hidden column cannot be downloaded in interactive report if, Display As         :…

Read More