The Problem DNF Update fails with the below error: 2018-06-22T14:31:22 DDEBUG Cleaning up. 2018-06-22T14:31:22 INFO The downloaded packages were saved in cache until the next successful transaction. 2018-06-22T14:31:22 INFO You can remove cached packages by executing ‘dnf clean packages’. 2018-06-22T14:31:22 SUBDEBUG Traceback (most recent call last): File “/usr/lib/python3.6/site-packages/dnf/cli/main.py”, line 64, in main return _main(base, args, […]
Archives for May 2021
How To Disable Weak Cipher And Insecure HMAC Algorithms In SSH Services In CentOS/RHEL 8
Question: How To Disable Weak Cipher And Insecure HMAC Algorithms in SSH services in CentOS/RHEL 8? In order to disable weak Ciphers and insecure HMAC algorithms in ssh services in CentOS/RHEL 8 please follow the instructions bellow: 1. Edit /etc/sysconfig/sshd and uncomment CRYPTO_POLICY line: Before: # CRYPTO_POLICY=[Original value] After: CRYPTO_POLICY=[New value] 2. Make sure correct […]
How To Disable Weak Cipher And Insecure HMAC Algorithms in SSH services for CentOS/RHEL 6 and 7
This post will show how to Disable the HMAC MD5 and the CBC ciphers as an example for CentOS/RHEL 6 and 7. For CentOS/RHEL 7 For more information please look at the man pages: # man sshd_config Ciphers Specifies the ciphers allowed. Multiple ciphers must be comma-separated. If the specified value begins with a ‘+’ […]
SQL query error when Using Shell Script
The Problem When using bash profile to execute SQL commands, it errors out when it encounters some special characters. For example, consider the following script: #!/bin/ksh . ~/.bash_profile sqlplus ‘/ as sysdba’ <<EOF spool /tmp/test.log select count(*) from v_$session; spool off EOF The log file will contain the following SQL> select count(*) from v_; select […]
How To Set the Permission of the Files Created Using UTL_FILE
Question: How to set the desired file permissions for the files created using the Oracle provided UTL_FILE package? The permissions of the file created using the UTL_FILE package are not something that can be controlled by any Oracle parameter. The permissions depend on the UMASK value set at the operating system level and it is […]
Understanding Dynamic Oracle Net Server Tracing
Oracle Net tracing is controlled by sqlnet.ora parameters which are static for the lifetime of RDBMS server processes. Since there is a single sqlnet.ora file for an instance, trace settings apply to all server processes. This can pose difficulties in live production environments. Dynamic server tracing allows for tracing at a per-process level and can […]
How to Disable Oracle Net Tracing without stopping server process
When Oracle Net server tracing is invoked using sqlnet.ora (see example below) tracing on the affected server processes will continue throughout the process lifetime. If tracing needs to be stopped without stopping the server process the following method can be used. Example: static server tracing using sqlnet.ora trace_level_server = 16 trace_directory_server = /tmp diag_adr_enabled = […]
Oracle 12c New Feature: LREG Background Process
Instance registration in Oracle Net 12c behaves differently. In 12c and higher, there is a new background process called ora_lreg_sid-name. In previous releases, PMON always handled instance registration logic. In 12c, LREG (Listener REGistration) now takes over with the instance registration logic. LREG (Listener REGistration) – Registers instance information with the listener. – It is […]
What is umask in UNIX/Linux
The user file creation mode mask (umask) is a built-in shell command that may be used to set default values for the read/write/execution permissions on newly created files. It should be executed in either the “.cshrc” or “.profile” shell startup files. It is given a three-digit octal value, which represents the binary inverse of the […]
How to Optimize a Data Guard Configuration
In this post, we will see how to monitor the configuration performance of data guard along with optimization of SQL apply and redo transport for best performances. Monitoring Configuration Performance by Using Enterprise Manager Cloud Control Graphical charts on the Performance Overview page: Redo Generation Rate: Shows the redo generation rate (in KB per second) […]