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

Test: OGG_extarct&reaplict with PK and duplicates

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

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