Grants Are Not Replicating In Golden Gate
Grants 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 MoreHow to apply SSL/HTTPS vendor certificate for apex application deployed on apache tomcat
Description: 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 MoreOracle Cloud 19c Grid and Database Installation in Silent mode.
Now 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 MoreHow to create or rebuild Context file in database DB Tier on R12.2
1. 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
Gather 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 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 MoreHow to Resolve Gaps in Data Guard Apply Using Incremental RMAN Backup
Step-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 MoreWeblogic Error : The Store Record X Could Not Be Found
ERROR 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 MoreHIGH RESOURCE-CONSUMING SQL STATEMENTS WHICH ARE CURRENTLY IN THE MEMORY
–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