LeoSunny

Leo is Sunny @_@

Docker run OGG Classic Architecture container from CIFS with docker-volume-netshare Plugin

leosunny

Docker run OGG Classic Architecture container from CIFS with docker-volume-netshare_0.36_linux_amd64 Plugin 1. Mount SMB storage to Linux as CIFS [root@linuxvm01 docker-volume-netshare_0.36_linux_amd64]# sudo mount -t cifs -o username=smb_user,file_mode=0777,dir_mode=0777,uid=54321,gid=54321 \\\\191.168.11.122\\shared /u01 \\191.168.11.122\shared on /u01 type cifs (rw,relatime,vers=default,cache=strict,username=smb_user,domain=,uid=54321,forceuid,gid=54321,forcegid,addr=191.168.11.122,file_mode=0777,dir_mode=0777,soft,nounix,serverino,mapposix,rsize=1048576,wsize=1048576,echo_interval=60,actimeo=1) 2. Run docker-volume-netshare plugin with CIFS [root@linuxvm01 docker-volume-netshare_0.36_linux_amd64]# sudo ./docker-volume-netshare cifs 2019/08/16 19:13:44 Entering go-plugins-helpers getPath 2019/08/16 19:13:44 Entering go-plugins-helpers […]

Read More

mount SMB storage to Linux as CIFS

leosunny

mount SMB storage to Linux as CIFS yum install cifs-utils sudo mount -t cifs -o username=smb_user,file_mode=0777,dir_mode=0777,uid=54321,gid=54321 \\\\191.168.1.122\\shared /u01 [root@linuxvm01 ~]# more /etc/fstab # # /etc/fstab # Created by anaconda on Sun Jul 28 20:19:48 2019 # # Accessible filesystems, by reference, are maintained under ‘/dev/disk’ # See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for […]

Read More

Example: OGG Microservice Architecture RestAPI Commands

leosunny

–Get the information of Distribution Path curl -u oggadmin:oracle -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET http://linuxvm01:9102/services/v2/sources curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET https://127.0.0.1:9102/services/v2/sources curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” -H “Accept: application/json” -X GET https://linuxvm01:19102/services/v2/sources/DIST01| python -m json.tool curl -u oggadmin:Oracle1! -k -H “Content-Type: application/json” […]

Read More

ORA-31623: a job is not attached to this session via the specified handle

leosunny

ORA-31623: a job is not attached to this session via the specified handle SYMPTOMS UDE-31623: operation generated ORACLE error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA-06512: at “SYS.DBMS_DATAPUMP”, line 3905 ORA-06512: at “SYS.DBMS_DATAPUMP”, line 5203 ORA-06512: at line 1 UDI-31623: operation generated ORACLE error 31623 ORA-31623: a […]

Read More

OGG-00868 Error code 1291, error message ORA-01291 missing logfile

leosunny

Symptoms: 2019-07-29 10:15:56 INFO OGG-02248 Logmining server DDL filtering enabled. Source Context : SourceModule : [er.redo.oraxo] SourceID : [/scratch/aime/adestore/views/aime_adc00jza/oggcore/OpenSys/src/app/er/redo/oracle/redooraix.c] SourceMethod : [REDOORAIX_abend_if_missing_logfile] SourceLine : [8360] ThreadBacktrace : [16] elements : [ng::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract()] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::er::OraTranLogDataSource::setup())] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::er::OraTranLogDataSource::setup())] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract()] : [/ogg/app/oracle/oggma/12.3.0.1.4/bin/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())] : […]

Read More

GG-02022 Logmining server does not exist on this Oracle database

leosunny

GG-02022 Logmining server does not exist on this Oracle database Symptoms: 2019-07-29 11:49:40 ERROR OGG-02022 Logmining server does not exist on this Oracle database. Cause: The extract is not registered in DB SOLUTION: 1)Register extract 2)Add extract 3)Start extract Set the ORACLE_HOME ORACLE_SID using the SETENV parameter in the extract parameter file Below is the […]

Read More

OGG-02191 Incompatible record 104 in /trail/TR000000003, rba 1,589

leosunny

OGG-02191 Incompatible record 104 in /trail/TR000000003, rba 1,589 when getting trail header. Symptoms: 2019-10-13 20:48:53 ERROR OGG-02171 Error reading LCR from data source. Status 509, data source type 0. Source Context : SourceModule : [gglib.ggtrail.TrailDataSource] SourceID : [/scratch/aime/adestore/views/aime_adc00jza/oggcore/OpenSys/src/gglib/ggtrail/TrailDataSource.cpp] SourceMethod : [readNextTrailRecord] SourceLine : [2687] ThreadBacktrace : [14] elements : [/ogg/oggma_12.3.0/bin/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**))] : [/ogg/oggma_12.3.0/bin/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))] : [/ogg/oggma_12.3.0/bin/replicat(_ZN3ggs5gglib14MultiThreading10MainThread3RunEiPPc+0xb5) […]

Read More

Install and configure VMware_vSphere 5

leosunny

VMware vSphere的安装配置 一、安装vSphere各个组件…. 1 1、安装vSphere Center. 1 2、在Vmware workstation上安装ESXi 11 二、vSphere vCenter连接配置…. 24 1、通过vSphere Client连接Vcener. 24 2、使用vSphere Client连接正常…. 35 3、新建集群…. 37 4、添加ESXi主机…. 41 5、查看ESXi主机的配置…. 48 6、添加磁盘…. 50 7、添加网络…. 57 三、新建并维护虚拟主机…. 64 1、创建Linux46（32bit）虚拟机…. 64 3-1）创建Linux虚拟机，磁盘空间不足失败…. 64 3-2）重新添加磁盘，启动并安装正常…. 75 2、创建windows2003虚拟机…. 89 一、安装vSphere Center   1、安装vSphere Center                         […]

Read More

Issues: ACFS-03008: The volume could not be resized

leosunny

Issues: ACFS-03008: The volume could not be resized Symptoms: oracle@scrboranl007090:/home/oracle % acfsutil size +50G /ogg_home/ acfsutil size: ACFS-03008: The volume could not be resized. The volume expansion limit has been reached. acfsutil size: ACFS-03216: The ADVM compatibility attribute for the diskgroup was below the required version (11.2.0.4.0) for unlimited volume expansions. oracle@scrboranl007090:/home/oracle % source asm.env […]

Read More

Test: OGG_extarct&reaplict with PK and duplicates

leosunny

Test: OGG_extarct&reaplict with PK and duplicates 1. Source table without PK and OGG extract set the PK ”PKEY” 2. Target Table has PK “PKEY” and OGG replicat the PK ”PKEY” –Prepare the testing tables CREATE TABLE SOURCE.TST_TAB01 ( PKEY NUMBER(19) NOT NULL, TIME_IN TIMESTAMP(6), TIME_OUT TIMESTAMP(6), OGG_DATETIME DATE ) TABLESPACE USERS PCTUSED 0 PCTFREE 10 […]

Read More