oracle_12_clean_environment [My wiki]

This is an old revision of the document!

First assure that you don't have any running jobs:

/u01/app/oracle/product/12.1.2/DBNAME_gg/ggsci
GGSCI (sourceSRV.izb.local as ggate@DBNAME) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING     <- Except this one, this one is by default there (Boring)

If any jobs are present, STOP them, DELETE them and Clean them.

GGSCI (sourceSRV.izb.local) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EBKDMP1     00:00:00      00:00:08    
EXTRACT     RUNNING     EBKEXT1     00:00:00      00:00:04    


GGSCI (sourceSRV.izb.local) 2> stop EBKDMP1

Sending STOP request to EXTRACT EBKDMP1 ...
Request processed.


GGSCI (sourceSRV.izb.local) 3> info EBKEXT1

EXTRACT    EBKEXT1   Last Started 2018-01-16 11:15   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Process ID           17209
Log Read Checkpoint  Oracle Redo Logs
                     2018-01-16 12:36:12  Seqno 2664, RBA 5423616
                     SCN 0.474510079 (474510079)


GGSCI (sourceSRV.izb.local) 4> stop EBKEXT1

Sending STOP request to EXTRACT EBKEXT1 ...
Request processed.


GGSCI (sourceSRV.izb.local) 5> cleanup EBKDMP1
Cleanup completed


GGSCI (sourceSRV.izb.local) 6> dblogin userid ggate password "password"
Successfully logged into database.

GGSCI (sourceSRV.izb.local as ggate@DBNAME) 7> cleanup EBKEXT1
Cleanup completed


GGSCI (sourceSRV.izb.local as ggate@DBNAME) 8> delete EBKDMP1
Deleted EXTRACT EBKDMP1.


GGSCI (sourceSRV.izb.local as ggate@DBNAME) 9> delete EBKEXT1
Deleted EXTRACT EBKEXT1.


GGSCI (sourceSRV.izb.local as ggate@DBNAME) 10> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

Be sure to delete any retail file: local retail and remote retail file. Any configuration can files can be located via:

GGSCI (sourceSRV.izb.local) 4> show all

Parameter settings:

SET DEBUG      OFF

Current directory: /u01/app/oracle/product/12.1.2/<instance release>

Editor:  vi

Reports (.rpt)                 /u01/app/oracle/product/12.1.2/DBNAME_gg/dirrpt
Parameters (.prm)              /u01/app/oracle/product/12.1.2/DBNAME_gg/dirprm
Replicat Checkpoints (.cpr)    /u01/app/oracle/product/12.1.2/DBNAME_gg/dirchk
Extract Checkpoints (.cpe)     /u01/app/oracle/product/12.1.2/DBNAME_gg/dirchk
Process Status (.pcs)          /u01/app/oracle/product/12.1.2/DBNAME_gg/dirpcs
SQL Scripts (.sql)             /u01/app/oracle/product/12.1.2/DBNAME_gg/dirsql
Database Definitions (.def)    /u01/app/oracle/product/12.1.2/DBNAME_gg/dirdef
Dump files (.dmp)              /u01/app/oracle/product/12.1.2/DBNAME_gg/dirdmp
Masterkey wallet files (.wlt)  /u01/app/oracle/product/12.1.2/DBNAME_gg/dirwlt
Credential store files (.crd)  /u01/app/oracle/product/12.1.2/DBNAME_gg/dircrd

!!!!!P.S. DO NOT DELETE THE REDO LOG FILES :) !!!!!!

Clean the environment