Force start Oracle Goldengate Replicat from Sequence Number

Force start Oracle Goldengate Replicat from Goldengate Sequence Number

error:

OGG-00446 No data selecting position from checkpoint table GGATE.CHECKPOINTTABLE for group


REPLICAT   RMEIS     Last Started 2019-08-26 17:11   Status ABENDED
Checkpoint Lag       00:00:00 (updated 01:09:02 ago)
Log Read Checkpoint  File /data/ggate/dirdat/MEIS/rm000005
                     2019-08-27 09:37:19.154883  RBA 46919569

alter RMEIS extseqno 000005 extrba 46919569

VIM Setting Example

setup vundle

git clone https://github.com/VundleVim/Vundle.vim.git ~/.vim/bundle/Vundle.vim

edit .vimrc

set nocompatible
syntax on
"enable syntax

set tabstop=4
set shiftwidth=4
set softtabstop=4
set expandtab
colorscheme monokai
set visualbell

" enable line Number
set number

"show hiden charactor
set list

" turn relative line numbers on
set rnu
set paste
set cursorline

set rtp+=~/.vim/bundle/Vundle.vim
call vundle#begin()

" let Vundle manage Vundle, required
Plugin 'VundleVim/Vundle.vim'
Plugin 'vim-airline/vim-airline'
Plugin 'tpope/vim-surround'
Plugin 'scrooloose/nerdtree'
Plugin 'sickill/vim-monokai'
Plugin 'vim-airline/vim-airline-themes'
Plugin 'Yggdroot/indentLine'

call vundle#end()

set autoindent
set smartindent

filetype plugin indent on


"disable arrows keys

nnoremap <up> <nop>
nnoremap <down> <nop>
nnoremap <left> <nop>
nnoremap <right> <nop>

inoremap <up> <nop>
inoremap <down> <nop>
inoremap <left> <nop>
inoremap <right> <nop>

" enable AirlineColorscheme bubblegum 
let g:airline_theme='bubblegum'

" Windows move shortcut
map <C-h> :call WinMove('h')<cr>
map <C-j> :call WinMove('j')<cr>
map <C-k> :call WinMove('k')<cr>
map <C-l> :call WinMove('l')<cr>

" Window movement shortcuts
" move to the window in the direction shown, or create a new window
function! WinMove(key)
    let t:curwin = winnr()
    exec "wincmd ".a:key
    if (t:curwin == winnr())
        if (match(a:key,'[jk]'))
            wincmd v
        else
            wincmd s
        endif
        exec "wincmd ".a:key
    endif

endfunction


Install ColorScheme Monokai
mkdir ~/.vim/colors
cd ~/.vim/colors
ln -s ./../bundle/vim-monokai/colors/monokai.vim monokai.vim

:PluginInstall

How to use vim in sqlplus

edit file $ORACLE_HOME/sqlplus/admin/glogin.sql

define_editor=vim

SSH Config file

vi ~/.ssh/config

Host *
        HostKeyAlgorithms +ssh-dss
        MACs hmac-sha1
        Ciphers aes256-ctr,aes128-cbc
        # KexAlgorithms diffie-hellman-group-exchange-sha256

        KexAlgorithms diffie-hellman-group-exchange-sha1,diffie-hellman-group14-sha1,diffie-hellman-group1-sha1

Host old_host

  HostKeyAlgorithms +ssh-dss

  KexAlgorithms +diffie-hellman-group1-sha1

  Ciphers aes256-ctr,aes128-cbc

ssh option name check 

ssh -Q cipher       # List supported ciphers
ssh -Q mac          # List supported MACs
ssh -Q key          # List supported public key types
ssh -Q kex          # List supported key exchange algorithms

Install Python3.7 on Windows Subsystem for Linux (WSL)

​1. Install the python3.7 package using apt-get

sudo apt-get install python3.7

2. Add python3.6 & python3.7 to update-alternatives

​sudo update-alternatives --install /usr/bin/python3 python3 /usr/bin/python3.6 1
sudo update-alternatives --install /usr/bin/python3 python3 /usr/bin/python3.7 2

3. Update python3 to point to python3.7

sudo update-alternatives --config python3

4. Test the version of python

python3 -v

5. Solve Error

sudo apt-get remove python3-apt -y

Error Permission Pipenv on /home/$USER/.cache in WLS

add $USER to root group

change Permission /home/$USER/.cache to 775

How to change default WSL mount Point

​create /etc/wsl.conf file

[automount]
root = /
options = "metadata"

reboot WSL Services