a. Create a gold image of the 19c Oracle Home. $ cd $ORACLE_HOME/ $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent $./runInstaller -createGoldImage -destinationLocation /u03/database19c -silent Successfully Setup Software. Gold Image location: /u03/database19c/db_home_2018-02-26_22-47-54PM.zip…
Read MoreIntroduction: There are many times where DBA has to run tkprof for multiple trace files at one time and get them uploaded in Oracle SR. Here, I will be sharing…
Read MoreWhat is snapshot standby database? It allows to perform read-write operation on the standby database.ie converting the physical standby to snapshot standby database. On that, we can do all types…
Read MoreIntroduction to Nid Utility: NID is an utility which is used to change the database internal name and dbname of a database. The utility is placed in the $ORACLE_HOME/bin directory.…
Read MoreDatabase Migration from Non-ASM to ASM We are going to convert our oracle Database to be migrated from Non ASM to ASM storage using RMAN commands Check the ASM instance…
Read MoreWhile trying to start the opmnctl services in idm we are getting 4200 error code as below applmgr@*****:~ $ applmgr@*****:~ $ /*****/fmw/idm/instances/IDM_inst1/bin/opmnctl startall opmnctl startall: starting opmn and all managed…
Read MoreTrying to register the database manually, it fails with: $ srvctl add database -d <dbname> -o <ORACLE_HOME> PRCR-1006 : Failed to add resource ora.<dbname>.db for uat PRCT-1011 : Failed to…
Read MoreIssue : Goldengate Extract Abends with “CACHESIZE TOO SMALL” upon Startup but Succeeds upon Immediate Restart Observation : Multiple Goldengate Extract and Datapump processes processes abend with “CACHESIZE TOO…
Read MoreIssue : GoldenGate Extract Abends With Errors OGG-01417 OGG-01262 Observation : Using the extract parameter TRANLOGOPTIONS _DISABLESTREAMLINEDDBLOGREADER does not work the issue around. Reason : The issue is similar to…
Read MoreIssue : Replicat Is Abending With OGG-00660 Could not find unique key column within table definition When FUNCTION BASED INDEX and BATCHSQL Is Used Note : The issue was on…
Read More