显示ocssd进程的主要函数
ps -ef|grep ocssd.bin|grep -v grep
pstack 327079|grep clssnm|awk '!a[$4]++ {print}'
某列求和
grep 192.168 jk.csv|awk -F , '{sum += $6} END {print (sum/1024)-360}'
chfs -a size=+10G /data
# /sbin/udevadm control --reload-rules
# /sbin/udevadm trigger --type=devices --action=change
修改ip
nmcli connection modify ens33 ipv4.method manual ipv4.addresses "192.168.204.200/24"
设置时区
timedatectl set-timezone Asia/Shanghai
查找删除文件
lsof -n|grep deleted
touch {1..5}.txt
恢复dg缺失的归档
RMAN> recover database from service primary_db noredo SECTION SIZE 1G USING COMPRESSED BACKUPSET;
跟踪会话
Linux # strace -Tttfv -s 8192 -o /tmp/stace.out -p
AIX # truss -aef -o /tmp/truss.out -p
truss -dD -o lgwrtruss.log -p
oradebug setospid 328020
oradebug dump pga_summary 1
oradebug tracefile_name
oradebug setospid 328020
oradebug dump heapdump 536870917
oradebug tracefile_name
过滤注释和空格
grep -v "^#" ansible.cfg | grep -v "^$"
进入带加号的目录
cd -- +MGMTDB
替换文本
sed -i "s/192.168.187.145/192.168.187.146/" listener.ora
超过500MB的文件,显示前30个吧
find /u01 -type f -size +500M -exec du -sm {} \; |sort -rn|head -30
挂个光驱
mount -r /dev/sr0 /mnt
vmware 默认安装的linux,来个图形吧
yum -y groupinstall "Server with GUI" 安装GUI
startx 切换到图形界面
改IP
vi /etc/sysconfig/network-scripts/ifcfg-ens33
ONBOOT=
yes
BOOTPROTO=
static
IPADDR=192.168.187.145
NETMASK=255.255.255.0
GATEWAY=192.168.187.2
恢复个ADG
rman target sys/oracle@tns_orcl auxiliary sys/oracle@tns_orcldg
RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;
cd "C:\Program Files (x86)\VMware\VMware Workstation\"
mkdir c:\vm\sharedisk\
vmware-vdiskmanager.exe -c -s 6g -a lsilogic -t 2 "c:\vm\sharedisk\ocr_vote.vmdk"
vmware-vdiskmanager.exe -c -s 10g -a lsilogic -t 2 "c:\vm\sharedisk\data.vmdk"
vmware-vdiskmanager.exe -c -s 2g -a lsilogic -t 2 "c:\vm\sharedisk\fra.vmdk"
动态x$视图相关信息
v$fixed_table v$fixed_view_definition v$indexed_fixed_column
阅读(3256) | 评论(0) | 转发(0) |