• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Archives for July 2019

How to use ‘yum’ to connect ULN on CentOS/RHEL/OEL 6

by admin

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

Filed Under: CentOS/RHEL 6, Linux, OEL 6

How to Re-Create the Yum Cache and/or Force a Fetch of the Package List of the Enabled Repositories

by admin

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

Filed Under: CentOS/RHEL 6, CentOS/RHEL 7, Linux

How to Mirror Swap, Boot and Root Partions in CentOS/RHEL 7 Using mdadm Utility

by admin

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

Filed Under: CentOS/RHEL 7, Linux

MySQL Server Error – “Can’t Create A New Thread (errno 11)”

by admin

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

Filed Under: Linux, mysql

How to use a Wrapper Script to set Custom Per-Process Attributes for MySQL Server

by admin

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

Filed Under: mysql

SLES 12: Database Startup Error with ORA-27300 ORA-27301 ORA-27303 While Starting using Srvctl

by admin

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

Filed Under: oracle, oracle 12c, SuSE Linux Enterprise

New Connections to the Database lead to ORA-12518 or TNS-12518

by admin

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

Filed Under: oracle

ORA-12518: TNS:listener Could Not Hand Off Client Connection

by admin

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

Filed Under: oracle, Oracle 11g

Oracle 12c Multitenant Architecture: Troubleshooting Ora-12518

by admin

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

Filed Under: oracle, oracle 12c

Empty Directories in the Flash Recovery Area (FRA) are not deleted

by admin

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

Filed Under: oracle

« Previous Page
Next Page »

Primary Sidebar

Recent Posts

  • protonvpn-cli Command Examples in Linux
  • protonvpn-cli connect Command Examples
  • procs Command Examples in Linux
  • prlimit: command not found

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright