faillock clear authentication failure to fix Linux login failed issue

Symptoms: Login Linux with oracle account failed, whereas the password is correct root@linuxvm01: /root % : passwd -S oracle oracle PS 2021-01-22 1 90 7 -1 (Password set, SHA512 crypt.) root@linuxvm01: /root % : passwd –status oracle oracle PS 2021-01-22 1 90 7 -1 (Password set, SHA512 crypt.) root@linuxvm01: /root % : grep oracle /etc/shadow […]

OGG4BD to send boolean data to Cassandra

OGG4BD to send boolean data to Cassandra –Create target table in Cassandra CREATE TABLE TARGET.TARGET01 ( col1 text PRIMARY KEY, col5 float, col2 bigint, col3 timestamp, col4 boolean ) WITH bloom_filter_fp_chance = 0.01 AND caching = {‘keys’: ‘ALL’, ‘rows_per_partition’: ‘NONE’} AND comment = ” AND compaction = {‘class’: ‘org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy’, ‘max_threshold’: ’32’, ‘min_threshold’: ‘4’} AND compression […]

Alert the usage of tablespace

Alert the usage of tablespace —-Create tablespace for user create tablespace yw_cux_data  datafile ‘/u02/lsdb/yw_cux_data01.dbf’ size 100m; create user lsdb_yw identified by ****** default tablespace yw_cux_data temporary  tablespace temp; grant connect,dba to lsdb_yw; grant select on DBA_FREE_SPACE to lsdb_yw; grant select on  DBA_DATA_FILES to lsdb_yw; grant execute on sys.UTL_TCP to lsdb_yw; grant execute on sys.UTL_SMTP to […]

OGG-05259 The Extract’s recovery checkpoint LSN is not in the cdc.lsn_time_mapping table of database ‘test’.

OGG-05259 The Extract’s recovery checkpoint LSN 00009da1:0057deff:0004 is not in the cdc.lsn_time_mapping table of database ‘test’. Symptoms: 2019-10-08 14:33:14 INFO OGG-05257 For CDC tuning best practices, please see https://technet.microsoft.com/en-us/library/dd266396%28v=sql.100%29.aspx. 2019-10-08 14:33:14 WARNING OGG-05292 The Oracle GoldenGate capture job is running on database test with NOMANAGECDCCLEANUP. Oracle GoldenGate will not purge CDC enabled tables. Source Context […]

Configure probe to monitor Tomcat

Download tomcat https://tomcat.apache.org/download-70.cgi Install tomcat on Windows set CATALINA_HOME=F:\app\apache-tomcat-7.0.69 set JAVA_HOME=F:\app\Java\jdk1.7.0_79 start Install probe Download probe https://launchpad.net/lambdaprobe/+download https://github.com/psi-probe/psi-probe http://code.google.com/p/psi-probe/ —newest version —–>3.0.0-SNAPSHOT/ We download this version that it is psi-probe-web-3.0.0-20160603.023429-26.war Install probe on tomcat in windows   tomcat-users.xml edit $CATALINA_HOME/conf/tomcat-users.xml Example1: <role rolename=”manager-gui”/> <role rolename=”manager-script”/> <role rolename=”manager-jmx”/> <role rolename=”manager-status”/> <user username=”admin” password=”admin” roles=”manager-gui,manager-script,manager-jmx,manager-status”/> Example2 <role […]

OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File)

OGG Replicat Abends On LOB Data. OGG Error: OGG-01028: Unexpected LOB Record Or Record Fragment In … (Trail File) SYMPTOMS: 2018-10-06 18:13:43 ERROR OGG-02188 Unexpected LOB record or record fragment in /trail/DL000000016, rba 1,750. CAUSE: replicat altered to start on trail where the first record is a LOB and not the base record INSERT/UPDATE/DELETE SOLUTION: […]

Install OGG for SQL Server in windows

Install OGG for Sql Server Prepare Check sqlserver veriosn  SELECT @@version Microsoft SQL Server 2016 (SP1-CU10-GDR) (KB4293808) – 13.0.4522.0 (X64) Jul 17 2018 22:41:29 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor) Requirements https://docs.oracle.com/goldengate/c1230/gg-winux/OGGIN/installing-sql-server1.htm#OGGIN-GUID-EB7DD65D-4344-4F72-9B45-18631536AC84 For SQL Server 2016, use or install the Microsoft […]

Docker run OGG4BD to Hadoop

MacBook-Air:.docker $ docker login –username=leosunnyPassword: Login Succeeded MacBook-Air:.docker $ docker pull leosunny/goldengate4bd:12.3.2.1.0 MacBook-Air:~ $ docker run –name=ogg4bd -d leosunny/goldengate4bd:12.3.2.1.0 MacBook-Air:~ $ docker exec -it –user oracle ogg4bd bash [oracle@64eeba6b8b09 ogg]$ pwd /u01/app/ogg [oracle@64eeba6b8b09 ogg]$ ggsci Oracle GoldenGate for Big Data Version 12.3.2.1.0 (Build 018) Oracle GoldenGate Command Interpreter Version 12.3.0.1.2 OGGCORE_OGGADP.12.3.0.1.2_PLATFORMS_180430.2321 Linux, x64, 64bit (optimized), […]