Oracle released the E-Business Suite Release 12.2.12 with 19c Database Single node Vision virtual appliance for On-Premise. Please note that the EBS instance that comes with Vision Instance which means you cannot use this for any Production, DEV or Test environments. Oracle EBS Vision instances are used only for Training, Demo purpose.  12.2.12 Virtual Appliance Contains: Vision Database DB 19c (19.18 RU) FMW 11.1.1.9 Apr2023 EBS CPU Jan2023 CPU/PSU for the technology components. System schema migration completion patch Below are the high level steps to Deploy EBS R12.2.12 VM appliance ..read more

Oracle released the E-Business Suite Release 12.2.10 with 19c Database Single node Vision with October 2020 CPU VM virtual appliance for On-Premise. Please note that the EBS instance that comes with VM Appliance is a Vision Instance which means you cannot use this for any Production, DEV or Test environments. Oracle EBS Vision instances are used only for Training, Demo purpose.  This is the first EBS Vision Instance with 19c Database VM Appliance released for On-Premise.  Below are the high level steps to Deploy EBS R12210 VM appliance: Download the Oracle EBS VM Appliance software ..read more

Execute the following steps to rename the Pluggable Database (PDB) in Oracle EBS R122 with 19c database. Here I am changing PDB name from "TESTHYD1" to "TESTBAN1". Connect to the CDB and check the information about the PDB: SQL> select name, open_mode, restricted from v$pdbs;NAME OPEN_MODE RES---------- --------------- ---PDB$SEED READ ONLY NOTESTHYD1 READ WRITE NOSQL> Close the PDB and check the status: SQL> alter pluggable database "TESTHYD1" close; Pluggable database altered.SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ..read more

Below are the highlited steps to upgrade your Oracle 11g/12c Database to 19c with EBS R12.1/R12.2 1. Install Oracle Database 19c Binaries 2. Apply additional 19c RDBMS patches 3. Apply 19c interoperability patches on application R12.1/R12.2 4. Create an empty container database (CDB) without a PDB 5. Run pre-upgrade diagnostic reports 6. Upgrade the database from 11g/12c to 19c using DBUA 7. Perform post Database Upgrade steps (run post fix-up script) 8. Convert Database to Multitenant Architecture (Non-CDB to PDB) 9. Perform Post Database upgrade steps Most of the steps are similar ..read more

Recently I have encountered below error while importing database dump file on Oracle Database 11gR2 and dump file was exported from 19c database. ORA-39001: invalid argument valueORA-39000: bad dump file specificationORA-39142: incompatible version number 5.1 in dump file "/u01/HYDSERVER/admin/rhyddb22/dpdump/testing.dmp" This is basically downgrade situation, because we are exporting dump file in 19c database and importing it into 11g database. To overcome this error, while exporting the dump file in 19c database we need to explicitly use VERSION parameter which specified to be the target C ..read more

Oracle recently announced that Oracle Database 19c is certified with Oracle E-Business Suite Release 12.1 / 12.2.  You may now start planning your database upgrade from 11g or 12c to 19c. The minimum certified version of Oracle Database 19c for Oracle EBS is Oracle Database 19c (19.3). Oracle Database 19c offers customers the best performance, scalability, reliability, and security for all their operational and analytical workloads. What's New For EBS With Oracle Database 19c: There are several mandatory architecture updates when you upgrade your Oracle E-Business Suite database to Orac ..read more

UTL_FILE_DIR is desupported with 19c database. UTL_FILE_DIR is a database pfile parameter. Which is used for EBS custom code or products requres access for read write file Operations on file system.  In Database 19c, the UTL_FILE_DIR replaced with database directory objects. With the EBS database upgrade to Database 19c, an equivalent Directory Object will be created for each UTL_FILE_DIR entry Pre-existing EBS product code and custom code will continue to function. Query to find UTL_FILE_DIR location in EBS Database 19c: select value from APPS.v$parameter where name='utl_file_dir ..read more

Today I have hit the following issue while executing the 'opatch lsinventory'  command in 11gR2  database. -bash-3.2$ $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.locOracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/db_hyd/11.2.0.4Central Inventory : /u01/db_hyd/oraInventory from : /u01/db_hyd/11.2.0.4/oraInst.locOPatch version : 11.2.0.3.4OUI version : 11.2.0.4.0Log file location : /u01/db_hyd/11.2.0.4/cfgtoollogs/opatch/opatch2020-06-23_05-36-23AM_1.logList of Homes on this sy ..read more

After cloning an Oracle EBS Release 12 instance on a Linux server, following error occur while starting up the Apache service. Apache/HTTP Startup Log: Executing service control script:/u01/R12EBS/inst/apps/r12hyupg_hydhost02/admin/scripts/adapcctl.sh startscript returned: **************************************************** You are running adapcctl.sh version 120.6.12000000.4Starting OPMN managed Oracle HTTP Server (OHS) instance ...opmnctl: opmn is already running. opmnctl: starting opmn managed processes... ================================================================================op ..read more

Following query will helps 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 will prompt for "NO_OF_DAYS" and "USER_CONCURRENT_PROGRAM_NAME". NO_OF_DAYS => "Enter Number of Days for History: "; USER_CONCURRENT_PROGRAM_NAME => "Enter User Concurrent Program Name: "; -- Query To Check Concurrent Program Run History set pages 100 linesize 200col Parameters for a20 col "Conc Program Name" for a30 col "Started at" for a20col "Completed at" for a20col "Username" for a10 SELECT distinct ft.user_co ..read more