How to fix Cloud Server SSH Session getting disconnected frequently?


Resolution

Simply update /etc/ssh/sshd_config file on your server

Continue reading
Rate this blog entry:
0 Comments

How to set the value of optimizer_adaptive_features parameter from SQL prompt in Oracle Database 12c?


Introduction

OPTIMIZER_ADAPTIVE_FEATURES enables or disables all of the adaptive optimizer features, including adaptive plan (adaptive join methods and bitmap plans), automatic re-optimization, SQL plan directives, and adaptive distribution methods.

Continue reading
Rate this blog entry:
0 Comments

How to analyze AD and TXK issues in EBS Release 12.2.x?


Issue

There are times when we need to analyze the diagnostic information in relation to AD and TXK Patches while upgrading from Release 12.2 to 12.2.x. It could be in view of missing patches or errors in applying patches.

Continue reading
Rate this blog entry:
0 Comments

ERROR: ORA-12516: TNS:listener could not find available handler with matching protocol stack


Issue

Error comes while running Release 12.2.5 Release Update Pack (RUP).

Continue reading
Rate this blog entry:
0 Comments

How to find the largest top 10 Files and Directories in Linux?


How do I find out all large files in a directory?1. For RedHat / CentOS / Fedorafind {/path/to/directory/} -type f -size +{size-in-kb}k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'

2. For Debian / Ubuntu Linuxfind {/path/to/directory} -type f -size +{file-size-in-kb}k -exec ls -lh {} \; | awk '{ print $8 ": " $5 }'

Continue reading
Rate this blog entry:
0 Comments