Archive log mining steps(logminer to html)

1.1        Archive log mining steps(logminer to html): 1.1.1        STEP 1: Execute the below query on the target db alter session set nls_date_format=’dd-mm-yyyy hh24:mi’; select name,thread#,sequence#,first_time,next_time from v$archived_log where first_time between to_date(’05-05-2019 16:00′) and to_date(’05-05-2019 20:00′); <<<<<<<<<<<<<<<<Put the time when the record was inserted on source around example around 2019/05/05 17:43:56.030.651, we need to find corresponding […]

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

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 […]

mount SMB storage to Linux as CIFS

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 […]

Example: OGG Microservice Architecture RestAPI Commands

–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” […]

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

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 […]

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

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())] : […]

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

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 […]

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

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) […]

Install and configure VMware_vSphere 5

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                         […]

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

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 […]