To start admin server on patch environment forcepatchfs option should be used as below. Source environment $. /data01/fs1/EBSapps/appl/APPS_Jay1.env cd $ADMIN_SCRIPTS_HOME [applmgr@mercury scripts]$ sh adadminsrvctl.sh start forcepatchfs You are running adadminsrvctl.sh…
Read MoreBelow are the major Golden gate files and their locations. Reports (.rpt) /u01/doyen/goldengate/ogg/dirrpt Parameters (.prm) /u01/doyen/goldengate/ogg/dirprm Replicat Checkpoints (.cpr) /u01/doyen/goldengate/ogg/dirchk Extract Checkpoints (.cpe) /u01/doyen/goldengate/ogg/dirchk Process Status (.pcs) /u01/doyen/goldengate/ogg/dirpcs SQL Scripts…
Read MoreHere are the differences between data dictionary views and V$ views, in Oracle. Data Dictionary Views : 1. Data will not be lost even after the instance is shutdown .…
Read MoreGetting the following error applying a patch running Adop: adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context :…
Read MoreDescription: These two tables FND_ENV_CONTEXT FND_CONCURRENT_REQUESTS grown to 4 GB size . To speed up. Solution: 1. First Purge and then De-fragmentation to improve the performance of the DML fired…
Read MoreProblem: Concurrent program are running from long time and are not getting completed. $INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132×66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace Get error: Environment:Environment java.lang.UnsatisfiedLinkError: Can’t…
Read MoreExecute the below in Application Tier: Run adpreclone on Application Tier $ perl ./adpreclone.pl appsTier Execute the following on the Database Tier: Logon as oracle database user and set envirnoment…
Read MoreI am trying to start EM on my newly created database, while starting EM, getting failed with OC4J Configuration issue… while diagnosed there is no OC4J_DBConsole_localhost directory exist in ORACLE_HOME.…
Read MoreAfter Completion of oracle clone , faced issue while running autoconfig. ERROR : ——– ERROR at line 1: ORA-04091: table APPLSYS.FND_PROFILE_OPTION_VALUES is mutating, trigger/function may not see it ORA-06512: at…
Read MoreError : ======= Bad header found during buffer read Data in bad block: type: 2 format: 2 rdba: 0x21008dd0 last change scn: 0x0006.12114f8e seq: 0x37 flg: 0x04 spare1: 0x0 spare2:…
Read More