Linux configurations for Oracle
When manually deleting OS audit files in Oracle, the following error occurs:
$ cd $ORCALE_HOME/rdbms $ du -sh ./audit 38G ./audit $ cd audit $ rm *.aud -bash: /bin/rm: Argument list too long
$ find ./ -name "*.aud" -mtime +30 -exec rm {} \;
OR
$ find ./ -name "*.aud" -exec rm {} \;
The connections to Linux server got disconnected with message “timed out waiting for input: auto-logout”.
It is an unhappy thing when you are run some kind of long running scripts or database SQLs.
The issue is coming from the variable ‘TMOUT’ in Linux environment.
$ cat /etc/profile.d/autologout.sh export TMOUT=36000 $ grep TMOUT /etc/profile TMOUT=14400 $ echo $SHELL /bin/bash $ cat /etc/bashrc|grep TMOUT TMOUT=3600
If you want to disable timeout, then reset variable TMOUT=0
$ export TMOUT=0
This post demonstrates how to check a process memory usage in Linux. While there are system resource issues, it is always helpful to identify the root cause by checking suspected process memory usage, which can be memory leaking from time to time.
Read more of this content when you subscribe today.
While checking named status on Oracle Linux, the following warnings occur:
# systemctl status named .. . May 17 20:40:59 HOSTNAME named[8468]: network unreachable resolving './NS/IN': 2001:500:1::53#53 May 17 20:40:59 HOSTNAME named[8468]: network unreachable resolving './DNSKEY/IN': 2001:500:2d::d#53 .. .
Read more of this content when you subscribe today.
It is recommended by Oracle to disable Linux native Transparent HugePages on Oracle database servers, to avoid potential Oracle database performance issues.
This post introduces how to disable Linux native Transparent HugePages, and verify Transparent Hugepages disabled or not.
Read more of this content when you subscribe today.
Make DBA Life Easy 