Posts by Sakthi Sethuperumal S

fs_clone fails with ETCC not run in the database node

Introduction: This blog discusses about ADOP fs_clone error in E-Business suite. The intended audience of this blog are E-Business suite DBA’s On running fs_clone it may fail with error as…

Read More

ADOP Prepare fails with ORA-20001

Introduction:   This blog discusses about ADOP error in E-Business suite. The intended audience of this blog are E-Business suite DBA’s While running ADOP Prepare phase as a part of…

Read More

Increase oacore process in Oracle EBS 12.1.3

How to increase oacore/jvm processes in R12.1.3 Below are the steps to increase oacore process: STEP1: Take a backup of context file and opmn.xml file. a. /u01/inst/apps/<CONTEXT_NAME>/ora/10.1.3/opmn/conf/opmn.xml b.$CONTEXT_FILE STEP2: Modify…

Read More

OEM13.4 not monitoring all Disks

INTRODUCTION: OEM13.4 is not monitoring all the Disks so we are unable to monitor the Disk alerts. SOLUTION: To fix this issue we need to change a parameter called EM_MONITOR_ALL_DISKS…

Read More

There are no active Responsibilities for the use – Oracle EBS 12.1

ISSUE: User was unable to view the responsibilities when logged in. SOLUTION: 1.Check the responsibilities of the user. 2.If the responsibilities are not end dated, end date the user(not the…

Read More

Customer LOGO in R12 Login Page(ORACLE EBS)

INTRODUTION The below steps will demonstrate how to add the client organization logo in R12 login page. STEP 1:Get the Logo from the customer. STEP2:Login as sysadmin navigate to system…

Read More

ORACLE WALLETS

Oracle Wallets Oracle Wallet is a container/repository that stores credentials such as certificates, certificate requests, and private keys, with oracle wallets we can also connect to a particular database schema…

Read More

NID UTILITY IN ORACLE12C

NID UTILITY IN ORACLE 12C DATABASE We can change both DBID and DB NAME using NID utility, the following will show how to change the DB NAME using NID utility.…

Read More

UPGRADE JDK 1.6 to 1.7 IN ORACLE EBS12.1.3

  UPGRADING JDK FROM 1.6 to 1.7 OF ORACLE HOME 10.1.3 AND 10.1.2 IN ORACLE EBS 12.1.3.   STEP1: Download certified Java from MOS follow the DOC ID:1439822.1 and move…

Read More

MIGRATING 19C DATABASE FROM LINUX TO WINDOWS.

INTRODUCTION The below steps showes us how to migrate a 19c database using Transportable Tablespace. MIGRATION FROM LINUX TO WINDOWS MIGRATION FROM LINUX TO WINDOWS BY TRANSPORTABLE TABLESPACE CREATED A TABLESPACE CREATED A TABLE BY HAVING DEFAULT TABLESPACE AS TBS(CREATED TABLESPACE),   EXECUTED THE DBMS_TTS.TRANSPORT_SET_CHECK FOR TRANSPORTING TABLESPACE TBS THAT IS TRUE, ALSO CHECKED IF THERE IS ANY VIOLATIONS   CHECKED THE ENDIAN FORMAT ON BOTH THE PLATFORMS PERFORMED EXPORT BY DATAPUMP FOR TRANSPORT TABLESPACE   DATABASE IN THE WINDOWS PLATFORM   PERFORMED AN IMPORT IN THE TARGET PLATFORM   AFTER THE IMPORT HECK WHETHER THE TABLESPACE IS AVAILABLE AND MAKE IT READ WRITE, CHECK FOR THE TABLE CREATED WITH DEFAULT TABLESPACE(TBS)

Read More