While trying to login in oracle database, after that ORA-29702 error coming. $sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 10 10:29:23 2021 Copyright (c) 1982, 2013,…
Read More[applmgr@Doyen ~]$ adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context : /oracle/EBSFS/fs1/inst/apps/TEST_Sunapps/appl/admin/TEST_Sunapps.xml Patch edition context: /oracle/EBSFS/fs2/inst/apps/TEST_Sunapps/appl/admin/TEST_Sunapps.xml Patch file…
Read MoreTo 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 More