To find the SQL query history which was executed yesterday in oracle
The below query is used to find the history of sql statement which has been executed earlier. Below query has been used for finding the yesterday data. eg: set colsep…
Read MoreHow to Change Weblogic Password in R12.2
1. Shutdown the Application Services using $ADMIN_SCRIPTS_HOME/adstpall.sh 2. Start the admin server on Primary node using $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start 3. Run the below command to create new password perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword…
Read MoreOracle EBS SSO Benefits ?
1. Users don’t have to remember dozens of passwords for Oracle e-Business Suite – 11i, 12.1, and 12.2. 2. Weak passwords in Applications are no longer allowed. Welcome123 and Oracle123…
Read MoreDifference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4
We have recently upgraded Oracle EBS 12.1.3 to Oracle EBS R12.2.4. There are lot of differences. 1)In R12.2 we have to kind of filesystems fs1(run filesystem) and fs2(patch filesystem) where…
Read MoreORA-29702: error occurred in Cluster Group Service operation
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 Moreadop prepare phase failing with the error ![UNEXPECTED]Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table.
[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 MoreSteps to start admin server on patch file system in r12.2
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 MoreOracle Golden Gate files Location and extension
Below 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 MoreDifferences between data dictionary views and V$ views
Here 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 MoreAdop Fails With Error: ssh is not enabled for the following nodes
Getting 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 More