The yum(Yellowdog Updater Modified) service is an automatic update tool to update the system each day. You can use both up2date/yum on Oracle Enterprise Linux/ Oracle Linux. Yum uses a configuration file at /etc/yum.conf. Additional configuration files are also read from the directory set by the reposdir option (default is ‘/etc/yum.repos.d’). Yum is an automatic […]
Archives for July 2019
How to Re-Create the Yum Cache and/or Force a Fetch of the Package List of the Enabled Repositories
This post briefly outlines how it possible to re-create the yum cache, or said in another way, force a fetch of the cache data from the enabled yum repositories. The enabled yum repositories are the ones in the following file /etc/yum.conf or in the following folder /etc/yum.repos.d that have their “enabled” setting to “1”, e.g. […]
How to Mirror Swap, Boot and Root Partions in CentOS/RHEL 7 Using mdadm Utility
This is required when there is no RAID controller card available for the server and the only solution is software RAID. This post makes changes to partitions, so if there is any existing data on any disks being used for this purpose, it should be backed up prior to creating the RAID array as per […]
MySQL Server Error – “Can’t Create A New Thread (errno 11)”
OS error 11 is “Resource temporarily unavailable”. The most common cause of receiving this error when trying to create a new thread is having hit the process’s kernel enforced a limit on open file descriptors. The second most common cause is having hit the process’s kernel enforced limit on the number of processes/threads. Here are […]
How to use a Wrapper Script to set Custom Per-Process Attributes for MySQL Server
There may be times you need to set custom per-process limits or attributes. It is possible to patch mysqld_safe, but using a wrapper script is easier to implement. In earlier versions, you could use mysqld_safe’s mysqld= option to specify the path to your wrapper script, but this feature was removed as of 5.5.52, 5.6.33 and […]
SLES 12: Database Startup Error with ORA-27300 ORA-27301 ORA-27303 While Starting using Srvctl
The Problem 12.1 RAC database error while starting via srvctl, alert log showing database startup and further goes down: alert_ORCL2.log inside [oracle base]/diag/rdbms/[db name]/[SID name]/trace: Fri Nov 03 15:06:25 2017 Adjusting the default value of parameter parallel_max_servers from 960 to 486 due to the value of parameter processes (600) Starting ORACLE instance (normal) (OS id: […]
New Connections to the Database lead to ORA-12518 or TNS-12518
The Problem ORA-12518 errors in the listener log when new users are connecting to the Database. Example is as follows: TNS-12518: TNS:listener could not hand off client connection TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact IBM/AIX RISC System/6000 Error: 32: Broken pipe This is an intermittent problem that would likely occur at […]
ORA-12518: TNS:listener Could Not Hand Off Client Connection
On : 11.2.0.4 version, Clusterware, when attempting to connect to database via listener, the following error occurs: ERROR ———————– ERROR: ORA-12518: TNS:listener could not hand off client connection 15-AUG-2017 01:40:01 * (CONNECT_DATA=(CID=(PROGRAM=myapp)(HOST=__jdbc__)(USER=admin))(SERVER=DEDICATED)(SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=11.22.33.44)(PORT=1521)) * establish * oracle * 12518 TNS-12518: TNS:listener could not hand off client connection TNS-12536: TNS:operation would block TNS-12560: TNS:protocol adapter […]
Oracle 12c Multitenant Architecture: Troubleshooting Ora-12518
The Problem When attempting to connect to PDB via listener, the following error occurs. ORA-12518: TNS:listener could not hand off client connection Listener log: 03-APR-2017 08:57:31 * (CONNECT_DATA=(SID=wd1)(CID=(PROGRAM=d:\orasfw\prd1\bin\sqlplus.exe)(HOST=Host name )(USER=ismeirb))) * (ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XX.XX)(PORT=63994)) * establish * wd1 * 12518 TNS-12518: TNS:listener could not hand off client connection TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error 64-bit […]
Empty Directories in the Flash Recovery Area (FRA) are not deleted
The Problem RMAN archived redolog backups and maintenance commands are deleting files from the Flash Recovery Area (FRA) when needed. For example: RMAN> backup archivelog all delete input; delete obsolete; These commands only delete the files, but not the actual directories when they are empty after the deletion of the files. The Solution When there […]