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

ALLOWOUTPUTDIR – Fix OGG-25127 XXXX not in any allowed output directories.

Symptoms: Pump report: 2020-11-20 19:05:58 ERROR OGG-25127 Received an error reply requesting a graceful shutdown. (Reply received is ‘GSOutput file /u01/app/ogg/dirdat/target/TT000000 is not in any allowed output directories.’.). Cause: With this parameter, we can authorize GoldenGate to use a different location than its home to store trail files. If you need different directories for your […]

OGGMA: Create distribution path via adminclient commands

ADD DISTPATH PUMP01 SOURCE trail://127.0.0.1:5100/services/v2/sources?trail=/source/SS TARGET wss://<targetIP>:6100/services/v2/targets?trail=/target/TT ALTER DISTPATH PUMP01 OPTIONS AUTORESTART RETRIES 10 delay 2 ALTER DISTPATH PUMP01 TARGET SIZEMB 200 ALTER DISTPATH PUMP01 TARGET SEQLEN 9 ALTER DISTPATH PUMP01 OPTIONS EOFDELAY 100