# vi /etc/fatab /home/db/u01 /u01 none defaults,bind 0 0 # mount -a
ssh remote command with trusted by ssh-keygen Hint!
[local ~]# ssh-keygen Generating public/private rsa key pair. Enter file in which to save the key (/root/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /root/.ssh/id_rsa. Your public key has been saved in /root/.ssh/id_rsa.pub. The key fingerprint is: SHA256:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx root@local The key's randomart image is: +---[RSA 2048]----+ […]
oracle : use dblink by command line
must be added tnsnames [DB Links] object not enough ~ # vi /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora REMOTETNS1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.10)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = XE))) # su - oracle -c "expdp dbuser/xxxxxx@REMOTETNS1 dumpfile=file.dmp logfile= file.log directory=BACKUP_DIR reuse_dumpfiles=y"
linux fast ping test : Flood ping
# ping -f 192.168.0.1 # ping -i0.1 192.168.0.1
centos 7 : set multi gateway Hint2
vi /etc/sysconfig/network-scripts/ifcfg-eth0 IPV4_ROUTE_METRIC=202 IPV4_DNS_PRIORITY=202 vi /etc/sysconfig/network ip route add default via 222.222.222.193 dev eth1 table 201 ip route append default nexthop via 192.168.0.1 dev eth0 while ip rule delete table 201 2>/dev/null; do true; done while ip rule delete table 202 2>/dev/null; do true; done ip rule add from 222.222.222.192/27 […]
T/s, B/s, bps for 64bit calculation Hint
In case 64bits per Transfer computer 1T/s = 1Transfer per second 1B/s = 1Byte per second 1bps = 1bit per second 1Byte = 8bits 1T = 8Bytes = 64bits 1T/s = 8B/s = 64bps Memory DDR4 2400Mhz = 2400MT/s or dual = 4800MT/s 2400MT/s = 2.4GT/s = 8Bytes * 2.4GT/s = 19.2GB/s = 64bits […]
centos 7 : network device Hint
# dmesg | grep alx # nmcli dev show # lspci -nn | grep 0200 # cat /proc/net/dev # ethtool -i enp8s0 # ethtool enp8s0 # lshw -C network # lsmod
centos 7 : oracle listener config & log Hint with /etc/hosts
# vi /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora ----------------------- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = owl)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /home/oracle/app/oracle ----------------------- # vi /etc/hosts ----------------------- 127.0.0.1 owl ----------------------- […]
centos 7 : yum cache reset Hint
# yum clean packages # yum clean metadata # yum clean dbcache # yum clean all # yum clean makecache
centos 7 : yum repos by iso file Hint
centos 7 : yum repos by iso file Hint # mkdir /mnt/centos7 # mount -t iso9660 -o loop /db/install/CentOS-7/CentOS-7-x86_64-DVD-1804.iso /mnt/centos7 # /mnt/centos7 # cat /mnt/centos7/.discinfo ----------------------------- 1543162572.807980 7.6 x86_64 ----------------------------- # ls -al /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 # vi /etc/yum.repos.d/owl.repo ----------------------------- [owl] mediaid=1543162572.807980 name=owl baseurl=file:///mnt/centos7 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7 enabled=1 […]