1、yast命令
2、查看端口被谁占用
linux15:~/breeze/ideploy # lsof -i:19981
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
java 224525 username 82u IPv6 1659862518 0t0 TCP localhost:19981 (LISTEN)
java 224525 username 83u IPv6 1659862519 0t0 TCP linux15:19981 (LISTEN)
3、linux系统的定时任务
crontab -e
5、远程连接命令
mstsc -v
6、查看oracle数据库错误码含义
oerr ora 2236
7、两个单板间相互拷贝文件
scp a.txt root@10.10.10.10:/home
scp root@10.10.10.10:/home/a.txt /home
8、设置linux系统时间
date -s "2014-01-01 01:01:01"
9、数据库备份与恢复
exp log=export.log file=aaaaa.dmp userid=bbbb/123456 grants=yes rows=yes constraints=yes indexes=yes buffer=100000
imp log=import.log file=aaaaa.dmp userid=cccc/123456 fromuser=bbbb touser=cccc grants=yes
10、修改数据库用户的密码
alter user dbuser identified by 123456;
11、数据库表空间文件被异常删除解决方法:
select * from dba_data_files
alter database datafile '/opt/oracle/oradata/fjdm' offline drop;
offline后,shutdown immediate;startup;
12、查看、修改数据库字符集
查看数据库字符集
echo $NLS_LANG;
select * from v$nls_parameters;
select value from nls_database_Parameters where parameter='NLS_CHARACTERSET';
ZHS16GBK/AL32UTF8
update nls_database_Parameters set value = 'ZHS16GBK' where parameter='NLS_CHARACTERSET';
select userenv('language') from dual;
ALTER DATABASE CHARACTER SET ZHS16GBK;
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';
oracle修改服务器端字符集:
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET AL32UTF8;
如果出现了 ERROR at line 1: ORA-12712: new character set must be a superset of old character set
SQL>ALTER DATABASE character set INTERNAL_USE AL32UTF8;
# 使用INTERNAL_USE可以跳过超集的检查,ALTER DATABASE character set INTERNAL_USE
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP 再检查就发现已经把字符集修整过来了NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
13、oracle连接数不够的解决方法
ORA-12516: TNS:listener could not find available handler with matching protocol stack
show parameter process;(查看当前连接数)
alter system set processes=1150 scope=spfile;
alter system set processes=1500 scope=spfile;
14、查看当前用户句柄限制
vi /etc/security/limits.conf
查找如下行,星号有可能是具体的用户名称,最后一个生效:
* soft nofile 16384
* hard nofile 16384
1.查看进程当前使用文件句柄数,12718为进程号
ls /proc/12718/fd |wc -l
15、修改数据库用户默认表空间
alter user jsm17_cpx default tablespace TS_DLSC_DATA;
16、挂载命令
mount -t nfs -o soft,intr,actimeo=1,acregmin=1,acregmax=1,acdirmin=1,acdirmax=1,timeo=30,rsize=16384,wsize=16384 10.137.212.63:/lpx/share/dlsc /home/jsm17_cpx/dls/contentFile
umount -l 10.137.212.49:/lpx/share/dlsc
17、存储过程
查看用户都有哪些存储过程
SELECT distinct name FROM ALL_SOURCE where TYPE='PROCEDURE';
查看存储过程具体内容
SELECT text FROM ALL_SOURCE where TYPE='PROCEDURE' AND name = 'P_DELOFFLINECDR';
查看表相关的存储过程和和触发器
select * from user_source where text like '%chargetask%';
18、统计指定数据库用户下所有表的记录数并排序(用户名大小写敏感)
SELECT owner,table_name,num_rows FROM dba_tables WHERE owner = ('DLSC_CPX') order by num_rows desc;
19、windows系统查看IP对应的主机名
nbtstat -A 10.10.10.10
20、查找命令的定义处
whereis startapp
21、linux踢人操作
who
linux15 /home/dlsc_cpx> who
dlsc_cpx pts/1 2014-07-25 15:14 (10.135.170.152)
pkill -kill -t pts/1
22、linux历史记录放在/var/log/message
23、awk命令
cat 111.txt | awk -F "|" '{if(NR==2) print $66}' | sort | wc -l
24、重启ftp
service vsftpd stop
service vsftpd start
25、递归创建目录
mkdir -p 111/222/333
26、命令执行结果为下一命令的输入参数
ps -ef | grep user | grep -v "grep" | awk '{print $2}' | xargs kill -9
27、配置ftp最大连接数
vi /etc/vsftpd.conf max_clients=0 (0代表不限制)
28、sed命令
1、删除文件中指定内容 sed -i "/${username}\/dls\/bin\/mountnfs.sh/d" /etc/init.d/after.local
2、perl -pi -e 's|requestdecodeurlfilter|DecodeUrlFilter|g' $DLS_HOME/webapps/dlsc/WEB-INF/web.xml;