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

Setting , Resetting/Unsetting Database Parameters

https://coskan.wordpress.com/2007/03/07/setting-or-resetting-unsetting-parameters/  https://community.oracle.com/tech/developers/discussion/4027755/need-to-change-hidden-parameter-to-its-default-value https://community.oracle.com/mosc/discussion/3774329/11-2-0-3-many-hidden-parameters-in-init-ora You can query the documented parameters with the query below select name,value,isdefault,isses_modifiable,issys_modifiable, isinstance_modifiable,isdeprecated, from v$parameter You can query the list of undocumented parameters with the script mentioned before “how to view list of hidden parameters” Also you can query v$parameter2 as the same way you query the v$parameter view to view the session specific parameter values. […]

Enabling supplemental log data

Enabling supplemental log data The following steps check whether supplemental log data is enabled and, if not, enable it. Enter the following command: select supplemental_log_data_min, supplemental_log_data_pk from v$database; If the command returns YES or IMPLICIT, supplemental log data is already enabled. For example, SUPPLEME SUP ——– — YES NO indicates that supplemental log data is […]

Set vm of Virtual Box to access internet

[root@docker01 ~]# ping www.google.com ^C [root@docker01 ~]# nslookup www.google.com [root@docker01 ~]# more /etc/resolv.conf # Generated by NetworkManager search opasia.dk nameserver 193.162.153.164 nameserver 194.239.134.83 nameserver :: VirtualBox–setting–Network— Adapter1: Bridged Adapter, Promiscuous Mode:Deny, Cable Connected:enabled. Adapter2: Nat, Cable Connected:enabled. nmtui ifconfig more /etc/resolv.conf more /etc/sysconfig/network-scripts/ifcfg-enp0s3 more /etc/sysconfig/network-scripts/ cd /etc/sysconfig/network-scripts/ ls ls -lrt ifconfig ls more ifcfg-lo [root@docker01 […]