Add new redo group and change size of redo

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:

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

this type of principal cannot be impersonated, or youdo not have permission

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

Fix: (oracle) are not allowed to use this program (crontab)

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

Setup NMON in RHEL

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

SQL Server Commands

–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 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

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