个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： linux
2020-02-04 18:51:21
显示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;
动态x$视图相关信息
v$fixed_table v$fixed_view_definition v$indexed_fixed_column
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
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
给主人留下些什么吧！~~