ITPub博客

简单用两个例子说明一下exists和not exists的用法.SQL> select * from tt2;        ID NAME---------- --------------------       100 EDITION       116 TABLE       280 SYNONY...

./conn[12]: cannot fork: too many processes  在HP Unix有两个可以限制系统最大进程数的内核参数：maxuprc(max user processes)和nproc(the number of system processes);maxuprc只对普通用户生效，对root用户不生效，只有nproc才对root生效。kctune 命令可以查看所有的内核参数修改maxuprc内核参数命令.kctu...

Oracle 11g 关闭listener产生xml log方法1.in sqlnet.ora添加  DIAG_ADR_ENABLED=OFF         2.in listener.ora 添加  DIAG_ADR_ENABLED_LISTENER=OFF   (因为listener名字为LISTENER,所以为DIAG_ADR_ENABLED_LISTENER。如果listener名字为LISTENER2,修改为DIAG_...

Oracle RAC中local_listener指定instance1 : SQL>alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))' sid='instance1';instance2 : SQL>alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))' sid='instance2';  &nbsp...

Oracle listener.log超过4G之后就不回再往里面写数据，所以需要定期备份和清除listener.log中的数据.如下为oracle11g listener.log清除步骤1. ps -ef | grep tns   查看DB是否使用了多个listener.2. lsnrctl status listenerx  查看listener.log在哪个位置(路径)3. lsnrctlLSNRCTL> showThe foll...

 ntpdate slew模式微调时间crontab,参考[hostname]# crontab -l* * * * * /usr/sbin/ntpdate -B xxx.xxx.xxx.xxx 1>>/tmp/ntpdate.log 2>&1-B参数的意思          Force  the  time to always be slewed using the adjtime() system call, even if the ...

1.创建bond网卡文件 在/etc/sysconfig/network-scripts/ 目录下创建ifcfg-bond0 命令：vi /etc/sysconfig/network-scripts/ifcfg-bond0 或者复制物理网卡也行: cp /etc/sysconfig/network-scripts/ifcfg-eth0 /etc/sysconfig/network-scripts/ifcfg-bond0 2.配置要绑定的网卡 编写bond0 eth1 eth2 使用命令：vi /etc...

export PS1_USER=`id |cut -d "(" -f2|cut -d ")" -f1`export PS1="\e[41m\e[37m[PROD "$PS1_USER"@"`hostname`":"'$PWD#']"\e[0m "

[root@mysql test]# grep -R linux /root/test/      #过滤文本文件中的内容/root/test/install.log.2:   131 COPPERing libselinux-2.0.94-5.8.el6.i686/root/test/install.log.2:   303 COPPERing libselinux-utils-2.0.94-5.8.el6.i686..................................

kernel: page allocation failure: order:5, mode:0x2000d0该错误通常是由于kernel内存不足导致，您可以通过增加 vm.min_free_kbytes 的大小来避免次问题， 具体方法如下：#vi /etc/sysctl.conf添加如下信息:vm.min_free_kbytes = 524288sysctl -p生效

[root@oracle6 tmp]# ll -i 786494 -rw-r--r--. 1 root root 29 Oct 27 19:23 xx[root@oracle6 tmp]# find . -inum 786494 -exec rm -rf {} \;[root@oracle6 tmp]# ll -i786494 drwxr-xr-x. 2 root root 4096 Oct 27 21:18 xxxxxx[root@oracle6 tmp]# find . -inum 786494 -exec rm -rf {} \;切换到乱码的文件夹[...

DEV下有4个磁盘设备相关的文件夹：dsk disk rdsk rdisk如下：# ls /dev | grep sk asyncdsk disk dsk rdisk rdsk 查看每一个目录下面的文件： # ll /dev/dsk ...

C:\Users\Admin>sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on 星期二 10月 4 13:24:02 2016Copyright (c) 1982, 2005, Oracle.  All rights reserved.连接到:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining opti...

SQL> show userUSER 为 "BRUCE"SQL> select count(*) from bruce;  COUNT(*)----------  83324928SQL> select segment_name,bytes/1024/1024/1024 from user_segments;SEGMENT_NAME         BYTES/1024/1024/1024-------------------- -------------------...

SQL> select segment_name,bytes/1024/1024/1024 from user_segments;SEGMENT_NAME         BYTES/1024/1024/1024-------------------- --------------------BRUCE                 &n...

SQL> select sum(bytes)/1024/1024/1024 from dba_data_files;SUM(BYTES)/1024/1024/1024-------------------------               116.464844已用时间:  00: 00: 00.03(1) 1 channel + compressed  ->  用时37:48 , 14G f...

C:\Users\admin>mysql -h localhost -uroot -pmysql mysql: [Warning] Using a password on thecommand line interface can be insecure. Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.14 MySQL CommunityServer (GPL) &n...

Oracle 启动的时候出现了  ORA-01102: cannot mount database in EXCLUSIVE mode需要将 $ORACLE_HOME/dbs下的 lk 开头的文件删除掉，重新启动就可以了.

C:\Users\Admin>rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Tue Oct 4 08:37:06 2016Copyright (c) 1982, 2005, Oracle.  All rights reserved.connected to target database: BRUCE (DBID=1667411)RMAN> run{2> allocate channel c1 type disk;3> allocate channel c2 type disk;...

和链接中遇到的很像 http://blog.itpub.net/451222/viewspace-861737/[root@xxxxx001:/]# vgchange -a y vgspace2 May 21 23:40:47 - "xxxxx001": Activating volume group vgspace2 with exclusive option.vgchange: Warning: Couldn't attach to the volume group physical volume "/dev/dsk/c8t1d0":I/O errorvgch...