Monthly Archives: September 2021

Automatic Storage Management Cluster File System(ACFS) mount point creation

ACFS concept was introduced in 11.2.0.1 it only manages the non-database files.  Oracle ACFS (Automatic Storage Management Cluster File System) is the preferred file manager for non-database files. It is…

Read More

SSH Key Generation for Third Party Server Authentication

It’s a secure access credential used in the Secure Shell (SSH) protocol. This is one of the authentication methods that Oracle uses to communicate with third party server such as sFTP. Steps…

Read More

Script to create VMSTAT and to collect Metrix in a database

Please use the below.   CREATE TABLE DBA.STATS$TOTALUSERS ( MEASURED_DATE DATE, TOTAL_USERS NUMBER, ACTIVE_USERS NUMBER ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K…

Read More

Query to get the user details from Cluster database

Please use the below query. set line size 750 pages 9999 col box for a30 col username for a30 col spid for a30 col program for a30 col os_user for…

Read More

Timeout Error Encountered for pasteBinary.sh While Running “adop phase=fs_clone”

when attempting to execute “adop phase=fs_clone”, the following error occurs: # Calling ApplyAppsTier… # Creating the FMW Home from ApplyAppsTier Creating FMW Home. Running /u01/app/fs1/EBSapps/comn/clone/FMW/pasteBinary.sh -javaHome /u01/app/fs1/EBSapps/comn/clone/FMW/t2pjdk -al /u01/app/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -tl…

Read More

vi editor commands usage

There are so many commands we use while working with vi editors. Here I have shared some commands. i    – for insert mode. I    – inserts text at…

Read More

Query To Check Concurrent Program Run History in EBS

The following query will help you to find the history of concurrent programs run in your EBS environment. You should connect to ‘apps’ user for executing this query and query…

Read More

While starting database ORA-03113: end-of-file on communication channel

ERROR While starting database ORA-03113: end-of-file on communication channel Problem: On further diagnosis of ADRCI logs, I found disk space size assigned to Flash recovery area falling short Solution: Mount…

Read More

Discoverer Java connecting screen become hang or Blank

Environment: E-Business Suite R12.1.3 Discoverer – 11.1.1.6.0 and JRE1.7 Issue: Connecting To Discoverer, EBS Forms become hang or Blank, While check the log file we found the the following error is…

Read More

Prevent the APEX application from being opened in multiple tabs with the same Session state

1. Overview This document talks about prevent opening Oracle APEX application in multiple tabs with the same session state. 2. Technologies and Tools Used The following technologies have been used…

Read More