tkprof multiple trace files
Introduction: 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 MoreConverting a physical standby database into snapshot standby database
What 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 MoreHow to change the db name using nid utility
Introduction 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 MoreMigrating Non ASM Database to ASM Database.
Database 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 MoreOPMNCTL startall Fails with “unexpected exit: status 4200”
While 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 MorePRCT-1011 : Failed to run “osdbagrp”. Detailed error
Trying 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 MoreGoldengate Extract Abends with “CACHESIZE TOO SMALL” upon Startup but Succeeds upon Immediate Restart
Issue : 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 MoreGoldenGate Extract Abends With Errors OGG-01417 OGG-01262
Issue : 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 MoreReplicat Is Abending With OGG-00660 Could not find unique key column within table definition When FUNCTION BASED INDEX and BATCHSQL Is Used
Issue : 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 MoreReplicat Abends With ERROR OGG-01029 Extract Reposition err – CDR Info sequence 0, rba 0
Issue : Replicat Abends With ERROR OGG-01029 Extract Reposition err – CDR Info sequence 0, rba 0 Observation : Replicat Abending with Error “OGG-01029 Extract reposition err – CDR Info sequence 0, rba 0.” This happens in Oracle GoldenGate –…
Read More