Schema Export and Import from On-premise database to AWS cloud database. Step 1:Connect the on-premise database and the export the schema DECLARE hdnl NUMBER; BEGIN hdnl := DBMS_DATAPUMP.OPEN( operation => ‘EXPORT’,…
Read MoreIn Data Guard, for some reason, standby database rule are incorrectly shown as primary database, while primary database shows as standby rule. DGMGRL> show configuration; Configuration - TESTDB Protection Mode:…
Read MoreWhen try to start up an Oracle database, the below errors occur: ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device Additional information:…
Read MoreSymptoms Call to dbms_metadata.get_ddl failed with following error – ORA-04063: package body “SYS.DBMS_METADATA” has errors expdp failed with following error – Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA ORA-39126: Worker unexpected fatal error…
Read MoreSymptoms — Problem Statement:Setiting logminer to a specific tablespace reports the following error SQL> create tablespace logmnr_tbs datafile ‘${vtbsp_dir01}/logmnr_tbs01.dbf’ size 700m ;SQL> BEGIN dbms_logmnr_d.set_tablespace(‘logmnr_tbs’); end;/2 BEGIN dbms_logmnr_d.set_tablespace(‘logmnr_tbs’); end;*ERROR at line…
Read MoreError: ORA-02374: conversion error loading table “SCHEMA”.”TABLENAME” ORA-12899: value too large for column MINE_TEXT (actual: 66, maximum: 64) ORA-02372: data for row: MINE_TEXT : 0X’45737061C3B16F6C2020202020202020202020202020202020′ More About the Error: 1. Used…
Read MoreGoldenGate – Error (904, ORA-00904: : Invalid Identifier) Selecting Data in ORAUTIL_getCurrentSCN() Extract process return error (904, ORA-00904: : invalid identifier) selecting data in ORAUTIL_getCurrentSCN() The goldengate user has been…
Read MoreOGG-02544 Unhandled Error (ORA-00904: : Invalid Identifier) WARNING OGG-02544 Unhandled error (ORA-00904: : invalid identifier) while processing the record at SEQNO 219, RBA 83837638 in Integrated mode. REPLICAT will retry…
Read MoreOGG-06601 Mismatch Between The Length Of Seqno From Checkpoint (9) And Recovery (6) For Ext Trying to read trail file which uses 6 digit checkpoint with version 12.2. Version 12.2…
Read MorePlease find the below query to check. SQL>set pages 1000 SQL>set linesize 100 SQL>column APPLIED_PATCH_ID format 9999999999 SQL>column PATCH_NAME format a16 SQL>column CREATION_DATE format a16 SQL>column BUG_ID format 9999999999 SQL>column…
Read More