Unable to 'apt update' my Ubuntu 19.04

sudo sed -i -re 's/([a-z]{2}\.)?th.archive.ubuntu.com|archive.ubuntu.com|security.ubuntu.com/old-releases.ubuntu.com/g' /etc/apt/sources.list

CPU and Memory OID Alcatel 6400

Memory:

name: healthDeviceMemoryLatest

oid: .1.3.6.1.4.1.6486.800.1.2.1.16.1.1.1.9.0

CPU:

name: healthDeviceCpuLatest

oid: .1.3.6.1.4.1.6486.800.1.2.1.16.1.1.1.13.0

Pretty print json Format in BASH terminal

Pretty print json Format in BASH terminal

ex:

curl -X GET http://localhost:8001 | python3 -m json.tool

create alias in .bashrc :

alias pprint='python3 -m json.tool'

ex:

curl -X GET http://localhost:8001 | pprint

How to change the Docker default subnet IP address

create file : /etc/docker/daemon.json

{

  "bip": "11.22.33.1/24"

}

{

    "default-address-pools": [

            {

                "base": "10.10.0.0/16",

                "size": 24

            }

        ]

}

restart docker services

Custom PS1 Linux Terminal

ex:

export PS1="\[\033[36m\]\D{%Y-%m-%d-%I:%M%p}\[\033[00m\] \[\033[95m\]\u@$WSL_DISTRO_NAME\[\033[00m\]:\[\033[35m\]\w\[\033[00m\] $ "

export PS1="\[\033[33m\]\D{%Y-%m-%d-%I:%M%p}\[\033[00m\] \[\033[32m\]\u@$WSL_DISTRO_NAME\[\033[00m\]:\[\033[36m\]\w\[\033[00m\] $ "

OGG-01004, OCI Error ORA-04098: trigger 'MEIS.ZONE_TG' is invalid and failed re-validation (status = 4098)

OGG-01004, OCI Error ORA-04098: trigger 'MEIS.ZONE_TG' is invalid and failed re-validation (status = 4098)

Cause:

Triggers are causing issue while data is being loaded to table.

Resolution:

You could use the option “SUPRESSTRIGGERS” in the Replicat processes. 

If it still abends the Replicat process, 

you may have to disable the trigger in the database and restart the process.

sql> alter trigger ‘<User>.<Trigger>’ disable;

Ex:

SQL> alter trigger MEIS.ZONE_TG disable;

Oracle Golden Gate Error : Fatal error executing DDL replication: error [Error code [955], ORA-00955

ex: 

2020-07-08 10:32:56  ERROR   OGG-00519  Oracle GoldenGate Delivery for Oracle, rmeis.prm:  Fatal error executing DDL replication: error [Error code [955], ORA-00955: มีออบเจกต์อื่นที่ใช้ชื่อนี้แล้ว
SQL alter table "SERVICES_APP"."CLIENTUSESERVICE"
  add constraint PKCLIENTUSESERVICE primary key (IDCLIENT, SERVICENAME, SERVICES, STARTDATE)
  using index
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  )
  /*

Check Constraints:

SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAMEFROMDBA_CONS_COLUMNSWHEREOWNER LIKE 'SERVICES_APP'ANDTABLE_NAME LIKE 'CLIENTUSESERVICE'

SQL> l
  1  SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME
  2  FROM
  3  DBA_CONS_COLUMNS
  4  WHERE
  5  OWNER LIKE 'SERVICES_APP'
  6  AND
  7* TABLE_NAME LIKE 'CLIENTUSESERVICE'
SQL> /

CONSTRAINT_NAME                TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------ --------------------
SYS_C0018194                   CLIENTUSESERVICE               IDCLIENT
SYS_C0018196                   CLIENTUSESERVICE               SERVICES
SYS_C0018195                   CLIENTUSESERVICE               SERVICENAME
FKCLIENTUSESERVICE             CLIENTUSESERVICE               IDCLIENT

if constraint SERVICES_APP.PKCLIENTUSESERVICE doesn't exists


check Indexes:

SELECT INDEX_NAME, TABLE_NAMEFROMDBA_INDEXESWHEREOWNER LIKE 'SERVICES_APP'ANDTABLE_NAME LIKE 'CLIENTUSESERVICE'

SQL> l
  1  SELECT INDEX_NAME, TABLE_NAME
  2  FROM
  3  DBA_INDEXES
  4  WHERE
  5  OWNER LIKE 'SERVICES_APP'
  6  AND
  7* TABLE_NAME LIKE 'CLIENTUSESERVICE'
SQL> /

INDEX_NAME                     TABLE_NAME
------------------------------ ------------------------------
PKCLIENTUSESERVICE             CLIENTUSESERVICE



if index SERVICES_APP.PKCLIENTUSESERVICE exists
drop index and restart Oracle Goldent Gate

DROP INDEX SERVICES_APP.PKCLIENTUSESERVICE;