Leo is Sunny @_@
Add new redo group and change size of redo https://docs.oracle.com/database/121/OSTMG/GUID-42519F90-AB27-46A8-9E59-18393C56C375.htm#OSTMG13960 1. query SQL> Select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024,MEMBERS,STATUS from v$log; GROUP# THREAD# SEQUENCE# BYTES/1024/1024 MEMBERS STATUS ———- ———- ———- ————— ———- —————- 1 1 13937 100 2 ACTIVE 2 1 13938 100 2 ACTIVE 3 1 13939 100 2 CURRENT 4 1 13936 100 2 INACTIVE SQL> select […]
Query archive log: SELECT TRUNC(COMPLETION_TIME) ARCHIVED_DATE, SUM(BLOCKS * BLOCK_SIZE) / 1024 / 1024 SIZE_IN_MB FROM V$ARCHIVED_LOG GROUP BY TRUNC(COMPLETION_TIME) ORDER BY 1; ARCHIVED_ SIZE_IN_MB ——— ———- 06-NOV-20 3423.69922 07-NOV-20 747.664063 08-DEC-20 25235.2773 alter session set nls_date_format = ‘YYYY-MM-DD HH24’; SELECT TRUNC(COMPLETION_TIME, ‘HH’) ARCHIVED_DATE_HOUR, SUM(BLOCKS * BLOCK_SIZE) / 1024 / 1024 SIZE_IN_MB FROM V$ARCHIVED_LOG GROUP BY […]
OGGMA Working with Paths https://docs.oracle.com/en/middleware/goldengate/core/19.1/using/working-paths.html#GUID-7F9F7045-AA27-4007-9852-BC69C2F301A1 https://docs.oracle.com/goldengate/c1230/gg-winux/GGSAU/working-paths.htm#GGSAU-GUID-ED4B15D7-5D2E-4007-B232-D353A91777A0
Symptoms: GGSCI> delete trandata dbo.* 2020-12-08 11:53:54 WARNING OGG-00782 Error in changing transaction logging for table: dbo.tab. 2020-12-08 11:53:54 ERROR OGG-05345 Failed to disable change data capture for table ‘dbo.tab in the database ‘tstdb’. SQL error: 15517: [Microsoft][ SQL Server Native Client 11.0][SQL Server]Cannot execute as the database principal because the principal “cdc” does not […]
docker exec -it –user oracle ogg4oracle_standard12 bash ggsci GGSCI (ogg) 1> view params mgr Port 7609 PURGEOLDEXTRACTS /u01/app/ogg/dirdat/PP*, NOUSECHECKPOINTS, MINKEEPDAYS 20
Symptoms: [oracle@oracle01 nmon]$ crontab -l You (oracle) are not allowed to use this program (crontab) See crontab(1) for more information Cause: it turns out that Mandriva doesn’t create default rules for crontab’s use by users. Instead, on a new install crontab is restricted to the root account. There are two files that control usage of […]
Download nmon for RHEL: http://nmon.sourceforge.net/pmwiki.php?n=Site.Download Install nmon in RHEL: cp nmon16e_x86_rhel72 /usr/local/bin/ chmod a+x /usr/local/bin/nmon16e_x86_rhel72 ln -s /usr/local/bin/nmon16e_x86_rhel72 /usr/local/bin/nmon Configure nmon: su – oracle mkdir /nmon cd nmon/ vi /nmon.sh #Syntax nmon: #[ -f | -F filename ] #[ -r < runname > ] #[ -t | -T | -Y Includes the top processes in […]
–Performance tracking sp_who2 65 DBCC opentran() dbcc inputbuffer(71) DECLARE @Spid TABLE ( SIID VARCHAR (MAX), [Status] VARCHAR(MAX), [Login] VARCHAR(MAX), HostName VARCHAR(MAX), BlkBy VARCHAR (MAX), DBName VARCHAR(MAX), COMMAND NVARCHAR(MAX), CPUTime INT, DiskIO INT, LastBatch VARCHAR(MAX), ProgramName NVARCHAR(MAX), SPID VARCHAR (MAX), REQUESTID VARCHAR (MAX) ) INSERT INTO @Spid EXEC sp_who2 SELECT * FROM @Spid — Filter by […]
Docker issue: rpc error: code = 2 desc = oci runtime error: exec failed: container_linux.go:247…connection reset by peer docker exec -it –user oracle oggma bash rpc error: code = 2 desc = oci runtime error: exec failed: container_linux.go:247: starting container process caused “process_linux.go:110: decoding init error from pipe caused \”read parent: connection reset by peer\”” […]
Mounting and mapping shares between Windows and Linux with Samba yum install samba-client samba-common -y yum install cifs-utils # smbclient -U user -L 192.168.1.122 # mkdir /mnt/myshare # mount -t cifs -o username=user //192.168.1.122/myshare /mnt/share # sudo mount.cifs //10.0.1.4/share /mnt/share/nmshare/ -o user=share,pass=share # vim /etc/fstab //192.168.1.122/myshare /mnt/share cifs username=user,password=password,_netdev 0 0 The _netdev option is […]