Exaple: expdp&impdp in parfile

impdp_tab01_user.par directory=DMPDIR dumpfile=expdp_tab01_user.dmp logfile=impdp_tab01_user.log parallel=4 cluster=n EXCLUDE=INDEX EXCLUDE=TABLE_STATISTICS EXCLUDE=INDEX_STATISTICS TABLE_EXISTS_ACTION=REPLACE transform=disable_archive_logging:y transform=storage:n TABLES=USER.tab01 remap_schema=USER:USER remap_tablespace=USERS:USERS impdp c##ogg_user@ORCLPDB1 parfile=impdp_tab01_user.par vi expdp_tab01_user.par DIRECTORY=DMPDIR DUMPFILE=expdp_tab01_user.dmp LOGFILE=expdp_tab01_user.log CLUSTER=N PARALLEL=4 TABLES= USER.tab01 expdp c##ogg_user@pstg parfile=expdp_tab01_user.par vi expdp_orcl_preprod_data_schemas.par DIRECTORY=DMPDIR DUMPFILE=expdp_orcl_preprod_data_schemas_%U.dmp LOGFILE=expdp_orcl_preprod_data_schemas.log FLASHBACK_SCN=1197898541013 CLUSTER=N PARALLEL=4 SCHEMAS=USER,OGG EXCLUDE=TABLE_STATISTICS EXCLUDE=INDEX_STATISTICS vi impdp_orcl_preprod_data_schemas.par directory=DMPDIR dumpfile=expdp_orcl_preprod_data_schemas_1111.dmp logfile=imppdp_orcl_preprod_data_schemas_.log PARALLEL=10 CLUSTER=N SCHEMAS=USER,OGG TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y TRANSFORM=STORAGE:N vi expdp_orcl_preprod_data_user.par DIRECTORY=DMPDIR DUMPFILE=expdp_orcl_preprod_data_user_%U.dmp […]

faillock clear authentication failure to fix Linux login failed issue

Symptoms: Login Linux with oracle account failed, whereas the password is correct Debug: root@linuxvm01:/root % tail -f /var/log/secure Oct 2 07:33:03 linuxvm01 adminsrvr[49581]: 2019-10-02T07:33:03.342+0000 INFO | ‘oggadmin’ IS authorized for ‘user’ role by HTTP. Oct 2 07:33:14 linuxvm01 unix_chkpwd[18549]: password check failed for user (oracle) Oct 2 07:33:14 linuxvm01 sshd[18493]: pam_unix(sshd:auth): authentication failure; logname= uid=0 […]

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: MacBook-Air:~ $ docker run –name=ogg4bd -d leosunny/goldengate4bd: 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 (Build 018) Oracle GoldenGate Command Interpreter Version OGGCORE_OGGADP. Linux, x64, 64bit (optimized), […]