Sunday, June 26, 2016

Tablespace Management Oracle

when ever you create database by default 5 tablespaces are created 
system  # database stores its metadata
sysaux #  stores AWR and statistics of database 
temp # Used for sorting operations on database 
undo # used for holding rollback segments 
users  # default tablespace for any user on database 

Managing Default Tablespaces on oracle database #

Adding additional Space to System # 
SQL> alter tablespace system add datafile '/u01/app/oracle/oradata/em12c/system02.dbf' size 300m;

Adding additional space to sysaux # 
SQL> ALTER TABLESPACE sysaux add datafile '/u01/app/oracle/oradata/em12c/sysaux02.dbf' size 300m;
Tablespace altered.

Managing Temporary Tablespace # 
SQL> create temporary tablespace newtemp tempfile '/u01/app/oracle/oradata/em12c/newtemp01.tmp' size 100m;
Tablespace created.

Make newly created temporary as default temporary tablespace for oracle database as follows 
SQL> alter database default temporary tablespace newtemp;
Database altered.

SQL> drop tablespace temp including contents and datafiles;   
Tablespace dropped.

creating New Undo Tablespace # 
SQL> create undo tablespace newundotb datafile '/u01/app/oracle/oradata/em12c/newundotb01.dbf' size 100m;
Tablespace created.

SQL> ALTER SYSTEM SET UNDO_TABLESPACE = newundotb;

Query To check Free and Used Space 
SELECT /* + RULE */  df.tablespace_name "Tablespace",
       df.bytes / (1024 * 1024) "Size (MB)",
       SUM(fs.bytes) / (1024 * 1024) "Free (MB)",
       Nvl(Round(SUM(fs.bytes) * 100 / df.bytes),1) "% Free",
       Round((df.bytes - SUM(fs.bytes)) * 100 / df.bytes) "% Used"
  FROM dba_free_space fs,
       (SELECT tablespace_name,SUM(bytes) bytes
          FROM dba_data_files
         GROUP BY tablespace_name) df
 WHERE fs.tablespace_name (+)  = df.tablespace_name
 GROUP BY df.tablespace_name,df.bytes
UNION ALL
SELECT /* + RULE */ df.tablespace_name tspace,
       fs.bytes / (1024 * 1024),
       SUM(df.bytes_free) / (1024 * 1024),
       Nvl(Round((SUM(fs.bytes) - df.bytes_used) * 100 / fs.bytes), 1),
       Round((SUM(fs.bytes) - df.bytes_free) * 100 / fs.bytes)
  FROM dba_temp_files fs,
       (SELECT tablespace_name,bytes_free,bytes_used
          FROM v$temp_space_header
         GROUP BY tablespace_name,bytes_free,bytes_used) df
 WHERE fs.tablespace_name (+)  = df.tablespace_name
 GROUP BY df.tablespace_name,fs.bytes,df.bytes_free,df.bytes_used
 ORDER BY 4 DESC;


--Nikhil Tatineni--
--Oracle In memory--
By -

Saturday, June 25, 2016

ERROR OGG-01433 table is compressed and extract

Extract Abended with following error # 
2016-06-23 18:42:12  ERROR   OGG-01433  Failed to validate table delta.gg_new
The table is compressed and extract will not be able to extract data from Oracle logs.

 work around # 
check table is compressed 

 select compression from dba_tables
where owner = 'DELTA' and table_name = 'GG_NEW';

 if the table is compressed / enabled. 
refer to follow link 
http://shaharear.blogspot.com/2008/10/table-compression.html

 After uncompressing Table, restart the extract with begin now # 
# Goldengate cannot replicate compression Tables # 

 Nikhil Tatineni--
By -

Skip transaction GoldenGate replicat 12c

syntax for skipping transaction #
ggsci> start replicat skiptransaction 

GGSCI (red.gg.ora.com) 14> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EDELTA      00:00:09      00:00:09    
REPLICAT    ABENDED     RMOTS       00:11:15      00:14:08    

GGSCI (red.gg.ora.com) 15> start rmots skiptransaction
Sending START request to MANAGER ...
REPLICAT RMOTS starting

GGSCI (red.gg.ora.com) 16> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     EDELTA      00:00:09      00:00:05    
REPLICAT    RUNNING     RMOTS       00:14:41      00:00:01    

GGSCI (red.gg.ora.com) 17> stats rmots  
Sending STATS request to REPLICAT RMOTS ...

Start of Statistics at 2016-06-25 01:01:43.
Replicating from DELTA.GG_NEW to MOTS.GG_NEW:

*** Total statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00

*** Daily statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00

*** Hourly statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00

*** Latest statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00
End of Statistics.

--Nikhil Tatineni--
--GoldeNGate--
By -

ERROR OGG-00519 Fatal error executing DDL replication:

scenario # I am trying to drop tablespace on source database, Enabled DDL replication on source table, replicat abending with following error.  Tried with disabling trigger  result is same # Ufff # 

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options
SQL> @ddl_disable
Trigger altered.

SQL> select TABLESPACE_NAME from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
STAGE
GGS_STAGE
HARRY
ADMIN
FIX
FIX01
11 rows selected.

SQL> drop tablespace fix including contents;
Tablespace dropped.

GGSCI (red.gg.ora.com) 5> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     EDELTA      00:00:10      00:00:05    
REPLICAT    ABENDED     RMOTS       00:11:15      00:00:10   

GGSCI (red.gg.ora.com) 6> view report rmots
***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
 Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
   Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:54:11
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.
                    Starting at 2016-06-25 00:25:20
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Sat Feb 25 12:50:01 EST 2012, Release 2.6.18-308.el5xen
Node: red.gg.ora.com
Machine: x86_64
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 6448

Description: 

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2016-06-25 00:25:20  INFO    OGG-03059  Operating system character set identified as UTF-8.

2016-06-25 00:25:20  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.
replicat rmots
SETENV (ORACLE_SID=mldb69)

2016-06-25 00:25:20  INFO    OGG-02095  Successfully set environment variable ORACLE_SID=mldb69.
SETENV (ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)

2016-06-25 00:25:20  INFO    OGG-02095  Successfully set environment variable ORACLE_HOME=/u01/app/
oracle/product/12.1.0/dbhome_1.
userid ggsuser@mldb69, password ******
assumetargetdefs
reportcount every 24 hours, rate
DBOPTIONS INTEGRATEDPARAMS(parallelism 6)
discardfile /u01/app/goldengate/dirdsc/rmots.dsc, megabytes 100, append
discardrollover at 21:00
reperror (default, discard)
map delta.*, target mots.*;

2016-06-25 00:25:20  INFO    OGG-06451  Triggers will be suppressed by default.

2016-06-25 00:25:20  INFO    OGG-01971  The previous message, 'INFO OGG-06451', repeated 1 times.

2016-06-25 00:25:20  INFO    OGG-01815  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /u01/app/goldengate/dirtmp.

CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE:                                2G
CACHEPAGEOUTSIZE (default):               8M
PROCESS VM AVAIL FROM OS (min):           4G
CACHESIZEMAX (strict force to disk):   3.41G

Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE 12.1.0.2.0 Production
TNS for Linux: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Database Language and Character Set:
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "WE8MSWIN1252" 
Opened trail file /u01/app/goldengate/dirdat/aa000009 at 2016-06-25 00:25:20

2016-06-25 00:25:20  INFO    OGG-03522  Setting session time zone to source database time zone 'GMT'
2016-06-25 00:25:20  INFO    OGG-01014  Positioning with begin time: Jun 25, 2016 12:18:44 AM, starting record time: Jun 25, 2016 12:24:38 AM at extseqno 9, extrba 20569.
2016-06-25 00:25:20  INFO    OGG-03506  The source database character set, as determined from the trail file, is we8mswin1252.
2016-06-25 00:25:20  INFO    OGG-02527  Integrated Replicat does not populate a trace table.
2016-06-25 00:25:20  INFO    OGG-02545  Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.
2016-06-25 00:25:31  INFO    OGG-02530  Integrated replicat successfully attached to inbound server OGG$RMOTS.
***********************************************************************
**                     Run Time Messages                             **
***********************************************************************
Opened trail file /u01/app/goldengate/dirdat/aa000009 at 2016-06-25 00:25:32
2016-06-25 00:25:53  INFO    OGG-02529  Successfully unregistered REPLICAT RMOTS inbound server OGG$RMOTS from database.
2016-06-25 00:25:53  INFO    OGG-02525  Integrated Replicat has been unregistered.
2016-06-25 00:25:53  INFO    OGG-01407  Setting current schema for DDL operation to [SYS].
2016-06-25 00:25:53  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:25:53  INFO    OGG-01407  Setting current schema for DDL operation to [SYS].
2016-06-25 00:25:54  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:29:53  INFO    OGG-01407  Setting current schema for DDL operation to [MOTS].
2016-06-25 00:29:53  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:34:11  INFO    OGG-01407  Setting current schema for DDL operation to [MOTS].
2016-06-25 00:34:11  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:34:25  INFO    OGG-01407  Setting current schema for DDL operation to [MOTS].
2016-06-25 00:34:25  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:34:45  INFO    OGG-01407  Setting current schema for DDL operation to [MOTS].
2016-06-25 00:34:45  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:45:51  INFO    OGG-01407  Setting current schema for DDL operation to [SYS].
Source Context :
  SourceModule            : [ggapp.ddl]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150472/oggcore/OpenSys/src/ggl
ib/ggapp/ddlrep.c]
  SourceFunction          : [DDLREP_handleDDLError]
  SourceLine              : [857]
  ThreadBacktrace         : [15] elements
                          : [/u01/app/goldengate/libgglog.so(CMessageContext::AddThreadContext()+0x
1e) [0x2b2ef3dff7ee]]
                          : [/u01/app/goldengate/libgglog.so(CMessageFactory::CreateMessage(CSource
Context*, unsigned int, ...)+0x321) [0x2b2ef3dfab11]]
                          : [/u01/app/goldengate/libgglog.so(_MSG_ERR_DDL_ABEND_NO_HANDLER(CSourceC
ontext*, char const*, CMessageFactory::MessageDisposition)+0x31) [0x2b2ef3de533f]]
                          : [/u01/app/goldengate/replicat(DDLREP_handleDDLError(ggs::gglib::ggunico
de::UString const&, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, g
gs::gglib::ggunicode::UString&, int, RepConfig_t*, ggs::gglib::ggunicode::UString const&, ggs::ggli
b::ggunicode::UString const&, ggs::gglib::ggunicode::UString const&, ggs::gglib::ggapp::CDBObjName<
(DBObjType)8>&, ggs::gglib::ggapp::CDBObjName<(DBObjType)7>&, ggs::gglib::ggapp::CDBObjName<(DBObjT
ype)1>&, long*)+0xd4a) [0x5fb53a]]
                          : [/u01/app/goldengate/replicat [0x5fefc4]]
                          : [/u01/app/goldengate/replicat(DDLREP_process(char*, __std_rec_hdr*, uns
igned short)+0x1002) [0x603898]]
                          : [/u01/app/goldengate/replicat(replicate_io(file_def*, __std_rec_hdr*, c
har*, extr_ptr_def*, int*, int)+0x33dd) [0x59cc2d]]
                          : [/u01/app/goldengate/replicat(process_extract_loop()+0x31b7) [0x5972a7]
]
                          : [/u01/app/goldengate/replicat(replicat_main(int, char**)+0x5bc) [0x5bfd
ac]]
                          : [/u01/app/goldengate/replicat(ggs::gglib::MultiThreading::MainThread::E
xecMain()+0x6f) [0x68156f]]
                          : [/u01/app/goldengate/replicat(ggs::gglib::MultiThreading::Thread::RunTh
read(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x11a) [0x68041a]]
                          : [/u01/app/goldengate/replicat(ggs::gglib::MultiThreading::MainThread::R
un(int, char**)+0x128) [0x681918]]
                          : [/u01/app/goldengate/replicat(main+0x3f) [0x5be84f]]
                          : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3d07e1d994]]
                          : [/u01/app/goldengate/replicat [0x508339]]
2016-06-25 00:45:51  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [9
59], ORA-00959: tablespace 'FIX' does not exist SQL drop tablespace fix including contents /* GOLDE
NGATE_DDL_REPLICATION */], no error handler present.
***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************
Last record for the last committed transaction is the following: 
___________________________________________________________________

Resolution # Working On it # 

Need Suggestions.. 

--Nikhil Tatineni--
--GoldeNgate --



By -

DownGrade Integrated Replicat to Classic Replicat GoldenGate

scenario # I am bringing Integrated replicat down and converting back to classic replicat. Steps as follows ### 

STEP1 #
GGSCI (red.gg.ora.com) 4> dblogin userid ggsuser@mldb69, password oracle
Successfully logged into database.

STEP 2 #
GGSCI (red.gg.ora.com) 22> stop rmots

STEP 3 #
GGSCI (red.gg.ora.com) 21> info checkpointtable ggsuser.ckptab
Checkpoint table ggsuser.ckptab created 2016-06-21 01:17:44.

STEP 4 #
GGSCI (red.gg.ora.com) 8> alter replicat rmots, nonintegrated checkpointtable ggsuser.ckptab
REPLICAT (Integrated) altered.

STEP 5 # 
GGSCI (red.gg.ora.com) 9> start replicat rmots
Sending START request to MANAGER ...
REPLICAT RMOTS starting

 After restart you will see following report in the report file of replicat # 
Opened trail file /u01/app/goldengate/dirdat/aa000009 at 2016-06-25 00:25:32
2016-06-25 00:25:53  INFO    OGG-02529  Successfully unregistered REPLICAT RMOTS inbound server OGG
$RMOTS from database.
2016-06-25 00:25:53  INFO    OGG-02525  Integrated Replicat has been unregistered.

2016-06-25 00:25:53  INFO    OGG-01407  Setting current schema for DDL operation to [SYS].
2016-06-25 00:25:53  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].
2016-06-25 00:25:53  INFO    OGG-01407  Setting current schema for DDL operation to [SYS].
2016-06-25 00:25:54  INFO    OGG-01408  Restoring current schema for DDL operation to [ggsuser].


--Nikhil Tatineni--
--Oracle In Memory--


By -

Friday, June 24, 2016

Sample Datapump Scripts

[oracle@red export]$ cat expddl_mots_schema.sh
TS_EXPORT=/u01/app/export
PWD=oracle
LOGFILE=exp_schema_mots_ddl.log
ST=`date`
echo $PWD | expdp system directory=ts_export  dumpfile=exp_schema_mots_ddl.dmp  content=METADATA_ONLY logfile=$LOGFILE schemas=mots job_name=expddl_schema_mots
ET=`date`
echo "Start Time=$ST" >>$LOGFILE
echo "End Time=$ET" >>$LOGFILE

 [oracle@red export]$ cat expdata_mots_schema.sh 
TS_EXPORT=/u01/app/export
PWD=oracle
LOGFILE=exp_schema_mots_data.log
ST=`date`
echo $PWD | expdp system directory=ts_export  dumpfile=exp_schema_mots_data.dmp  content=data_only logfile=$LOGFILE schemas=mots job_name=expdata_schema_mots
ET=`date`
echo "Start Time=$ST" >>$LOGFILE
echo "End Time=$ET" >>$LOGFILE
[oracle@red export]$ nohup ./expdata_mots_schema.sh &
[1] 4888
[oracle@red export]$ nohup: appending output to `nohup.out'

[oracle@red export]$ jobs
[1]+  Running                 nohup ./expdata_mots_schema.sh &

 --Nikhil Tatineni--
--Oracle In Memory--

By -

Wednesday, June 22, 2016

Oracle Redo Log file management


Views Related to redo log files >
v$log                     Displays the redo log file information from the control file
v$logfile               Identifies redo log groups and members and member status
v$log_history      contains log history information

Header status of online redo log groups?
4 status # 
current  > LGWR is writing # 
active  > archiver is working on that group # 
inactive > not LWGR or ARCHIVER 
unused >  BRAND NEW and have sequence number 0>>

Use following Query to check size of the Redo log group & location on database

set linesize 300
column REDOLOG_FILE_NAME format a50
SELECT
    a.GROUP#,
    a.THREAD#,
    a.SEQUENCE#,
    a.ARCHIVED,
    a.STATUS,
    b.MEMBER    AS REDOLOG_FILE_NAME,
    (a.BYTES/1024/1024) AS SIZE_MB
FROM v$log a
JOIN v$logfile b ON a.Group#=b.Group# 
ORDER BY a.GROUP# ASC;

Archiver is slow?
LGWR has to wait for online redo log group"
To avoid LGWR waits( log file sync ) we add additional redolog groups for database

resizing the new online group>> or adding a new online redo log file group >
sql> alter database add logfile group < Group Number > ('location1','location2') size <M/G>;

CURRENT # WHERE LGWR is writing to online redo log group # 
Log writer forcefully switches from one online redo log group to another online redo log group ## 
sql> alter system switch logfile;
System altered.
    GROUP#    THREAD#  SEQUENCE# ARC STATUS  REDOLOG_FILE_NAME    SIZE_MB
---------- ---------- ---------- --- ---------------- --------------------------------------------
         1          1         10 YES INACTIVE         /u01/app/orcl/redo01.log         50
         2          1         11 YES INACTIVE         /u01/app/orcl/redo02.log         50
         3          1         12 NO  CURRENT          /u01/app/orcl/redo03.log        50

Make sure header status is inactive then only we drop the online redolog group;
syntax# alter database drop logfile group <group number>
example
sql> alter database drop logfile group 1;
Drop a member to existing group >
sql> alter database drop logfile member '/u01/app/orcl/redo04.log' size 100m;
If the status if active or current, we cannot drop the online redolog group 
Adding a member to the group >>
sql> alter database add logfile member 'location' to group <group Number>;
Query's to check number of archive logs generated per day
select
   Start_Date,
   Start_Time,
   Num_Logs,
   Round(Num_Logs * (Vl.Bytes / (1024 * 1024)), 2) AS Mbytes,
   Vdb.NAME AS Dbname
FROM
   (SELECT To_Char(Vlh.First_Time, 'YYYY-MM-DD') AS Start_Date, To_Char(Vlh.First_Time, 'HH24') || ':00' AS Start_Time,
   COUNT(Vlh.Thread#) Num_Logs
FROM
   V$log_History Vlh
GROUP BY
   To_Char(Vlh.First_Time, 'YYYY-MM-DD'),
   To_Char(Vlh.First_Time, 'HH24') || ':00') Log_Hist,
   V$log Vl,
   V$database Vdb
WHERE
   Vl.Group# = 1
ORDER BY
   Log_Hist.Start_Date,
   Log_Hist.Start_Time;


--Oracle In memory--
By -

Tuesday, June 21, 2016

ADD SCHEMATRANDATA fails with error Operation not supported

Today, I am trying to enable ddl replication and enabling supplemental logging at schema level and failed with following error # 

GGSCI (red.gg.ora.com) 3> dblogin userid ggsuser, password oracle
Successfully logged into database.

GGSCI (red.gg.ora.com) 4> ADD SCHEMATRANDATA delta
ERROR: Operation not supported because enable_goldengate_replication is not set to true.

-----### Later I logged into the database, Enabled the new parameter on new database :) 12.1.0.2 

SQL> alter system set enable_goldengate_replication=true scope=both;
System altered.

SQL> show parameter enable_goldengate_replication
NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication     boolean TRUE

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options

After Successfully Enabled supplemental logging at schema level # 
[oracle@red goldengate]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

GGSCI (red.gg.ora.com) 1> dblogin userid ggsuser, password oracle
Successfully logged into database.

GGSCI (red.gg.ora.com) 2> ADD SCHEMATRANDATA delta
2016-06-21 00:54:49  INFO    OGG-01788  SCHEMATRANDATA has been added on schema delta.
2016-06-21 00:54:49  INFO    OGG-01976  SCHEMATRANDATA for scheduling columns has been added on schema delta.

-- Nikhil Tatineni --
-- GoldenGate 12c--
Errors Related to GoldenGate # 

ERROR OGG-00446 Unable to lockfile 
ERROR OGG-10144 (ecbn.prm) line 6: Parameter [ASMPASSWORD] is not valid for this configuration.
ERROR OGG-06220 Classic Extract does not support multitenant container 
ERROR OGG-01224 Address already in use.
ERROR OGG-01668 problem at line 103.  Bad column definition: PREV_VDSL_UP_RATE
ERROR OGG-00665 OCI Error describe for query (status = 4031-ORA-04031 
ERROR OGG-00730 No minimum supplemental logging is enabled 
ERROR OGG-01755 Cannot register or unregister EXTRACT 

By -
Subscribe to: Posts (Atom)

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...

  • Skip transaction GoldenGate replicat 12c
    syntax for skipping transaction # ggsci> start replicat skiptransaction  GGSCI (red.gg.ora.com) 14> info all Program     St...
  • ORA-24324, ORA-24323, ORA-01090
    scenario # trying to startup / shutdown database encountered with following error # ORA-24324: service handle not initialized ORA-243...
  • ERROR OGG-01454
    Today GoldenGate Extract abended on Servers During my initial investigation,  goldengate error report says as follows  2016-02...