歷史文章::JohnChen

設置oracle資料庫IP訪問限制 (IP白名單黑名單)

2013-09-14 15:16

可以通過修改sqlnet.ora檔來限制某些IP位址的訪問，修改完成後，可能需重啟監聽生效。(可以lsnrctl...

Oracle 最大連線數

2013-09-14 12:09

Oracle 的最大連接數是在參數SESSIONS中,可以用 select value from v$parameter where name = 'sessions'

select B.MACHINE,A.sid,A.CNT,to_char(B.LOGON_TIME,'yyyymmdd HH24MIss') as LDATE ,A.SQL_TEXT from ( select sid, SQL_TEXT,count(*) as CNT from v$open_cursor group by sid,SQL_TEXT order by CNT ) A , v$session B where A.sid = B.sid --and B.MACHINE = 'cclsunap2' order by B.MACHINE,CNT

repoforge

2013-09-13 15:49

https://pkgs.repoforge.org/rpmforge-release/

array 中的 array &hash

2013-09-11 18:35

[root@occas01 ~]# cat test.pl my @d1 = (24.2, 26.3, 23.4); my @d2 = (23.5, 27.5, 22.6); my @d3 = (25.2, 28.7, 24.8); my @daily = (\@d1, \@d2, \@d3); print $daily[2][1]; [root@occas01 ~]# perl test.pl 28.7 my @array = ({3, 5, 7, 9}, [1, 4, 8,...

RHEL6 use CentOS6 YUM

2013-09-10 12:17

[root@opsview01 ~]# cd /etc/yum.repos.d/ [root@opsview01 yum.repos.d]# vi centos.repo [base] name=CentOS-6.3 - Base baseurl=https://vault.centos.org/6.3/os/x86_64/ gpgcheck=1 enabled=1 [updates] name=CentOS-6.3 -...

NAT 設定

2013-09-10 10:22

#echo 1 > /proc/sys/net/ipv4/ip_forward Then you'll need to configure iptables to forward the packets from your internal network, on /dev/eth1, to your external network on /dev/eth0. You do this will the following commands: # /sbin/iptables -t nat -A POSTROUTING -o eth0 -j MASQUERADE #...

IPMItool command (HP iLo) - 2

2013-09-05 18:31

[nagios@Ops_Slave05 libexec]$ ipmitool -H 10.39.120.28 -I lanplus -L user -U nagiosadmin -P nagiosadmin sensor -v Sensor ID : VRM 1 (0x1) Entity ID : 9.1 Sensor Type (Discrete): Power...

IPMItool command (HP iLo)

2013-09-03 16:43

[nagios@Ops_Slave05 ~]$ ipmitool -H 10.39.120.28 -I lanplus -L user -U nagiosadmin -P nagiosadmin sdr VRM 1 | 0 unspecified | cr VRM 2 | 0 unspecified | cr UID Light ...

opsview.repo 設定

2013-09-01 23:54

[root@master conf.d]# cat /etc/yum.repos.d/opsview.repo [opsview] name = Opsview #baseurl = https://downloads.opsview.com/opsview-core/latest/yum/centos/el6/$basearch baseurl = https://downloads.opsview.com/opsview-core/latest/yum/centos/6/x86_64/ enabled = 1 protect =...

歷史文章列表