For the mail server configuration in 12c reports, need to the update the rwserver.conf files with mail server credentials. cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 Edit the rwserver.conf and update the below, From :…
Read MoreGrants Are Not Replicating In Golden Gate SYMPTOMS Grants are not being replicated from source to target when using Integrated extract CAUSE Bug 30120608 : Capture skipping included grant after…
Read MoreDescription: This article shows how to enable HTTPS for Tomcat. It uses a Third party vendor certificate for wildcard SSL and It should be format of certificate .jks or .pem.…
Read MoreNow we are going to create an instance in cloud. Create a VM instance. Click compute —>instance—>create instance. Give name to your instance and choose in which compartment you want…
Read More1. Find out the Template file. [oracle@ebs bin]$ cd $ORACLE_HOME [oracle@ebs 12.1.0]$ cd appsutil/template/ [oracle@ebs template]$ pwd /u01/StageR122/PROD/12.1.0/appsutil/template [oracle@ebs template]$ ls -l adxdbctx.tmp -rwxrwxrwx 1 oracle oinstall 23871 Dec 29…
Read MoreGather Schema Statistics fails with “ORA-20005: Object Statistics Are Locked (Stattype = ALL)” Log file shows the following error, ORACLE error 20005 in FDPSTP Cause: FDPSTP failed due to ORA-20005:…
Read More1. 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 MoreStep-1: Check the SCN of Standby ( Data guard ) database and Find the lowest SCN from the following Queries. SQL> SELECT CURRENT_SCN FROM V$DATABASE; CURRENT_SCN -------------- 1165261 SQL> select…
Read MoreERROR weblogic.store.PersistentStoreFatalException: [Store:280029]The store record 4 could not be found. Solution The issue can be caused by the corruption of the database, by .lok or .DAT files associated with the…
Read More–Create the tuning set EXEC DBMS_SQLTUNE.CREATE_SQLSET(‘HIGH_DISK_READS’); –Populate the tuning set from the cursor cache DECLARE cur DBMS_SQLTUNE.SQLSET_CURSOR; BEGIN OPEN cur FOR SELECT VALUE(x) FROM table( DBMS_SQLTUNE.SELECT_CURSOR_CACHE( ‘parsing_schema_name <> “SYS” AND…
Read More