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 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 MoreIssue : 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 MoreWe might face some scenarios for convert string data into rows. Here you can separate a string into rows by giving the string separator as input. Users can give any…
Read MoreEXPORT AND IMPORT DATAPUMP BACKUP USING TABLESPACE PARAMETER In this blog, we are going to learn about how to do export/import data pump backup by using the tablespace parameter [oracle@oracle Desktop]$ cd [oracle@oracle ~]$ export ORACLE_SID=Trainee [oracle@oracle ~]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Feb 4 10:42:03 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started.…
Read MoreSCRIPT TO VIEW WHICH DATABASE INSTANCE IS RUNNING In this tutorial, we going to learn about to find which database instance is running now. Mostly we use “/etc/oratab” to view…
Read MoreThere are many scenarios, DBA struggling to identify the sessions running in database on sudden adhoc request. To capture the session quickly with the information what we get is really…
Read MoreIssue: The Commvault issue is reporting saying that first node connection is fine and rest all the 2 nodes is not connecting. Solution: The following are the key points that…
Read More