How do I reduce the size of my listener log?
1. you need to set listener log status off
2. Then move current listener.log file as listener.log.old
3. Create another new log file for listener
4. And finally sett listener log status on
Find your listener.log file
and follow below steps ...
lsnrctl set log_status off
mv listener.log listener.old
touch listener.log
lsnrctl set log_status on
Comment below if you need any help.
How to check active connection in linux
Linux command to check all active connection
As oracle Apps DBA sometime i nned to know the active connection in my server. Or who are working as system administrator they have a common requirement like same.
So follow bellow info to find active connection in your linux system
By Using last command
[root@ebs ~]# last -a | grep -i still
Aply this command and you will get information like below image.
By using ss command
[root@ebs ~]# ss | grep ssh
Aply this command and you will get information like below image.
By using w command
[root@ebs ~]# w
Aply this command and you will get information like below image.
By using who command
[root@ebs ~]# who
By using ps command
[root@ebs ~]# ps auxwww | grep sshd: | grep -v grep
By using netstat command
[root@ebs ~]# netstat -tnpa | grep 'ESTABLISHED.*sshd'
I hope this topic will be helpful for both Oracle Apps DBA and Linux System Administrator.
