ITPub博客

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...

4.1 create and drop databaseC:\Users\admin>mysql -h localhost -u root -pmysqlmysql: [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 3Server version: 5.7.14 My...

原始数据:[/tmp/test]# cat emp7369    SMITH   CLERK           7902    1980-12-17      800     0       207499    ALLEN&...

遇到的问题，记录下来.[root@xxxxx016:/]# vgchange -a y vgxxxMay 21 22:57:26 - "xxxxx016": Activating volume group vgxxx with exclusive option.vgchange: Warning: Couldn't attach to the volume group physical volume "/dev/dsk/c5t5d7":I/O errorvgchange: I/O errorvgchange: I/O errorvgchange: I/O e...

Oracle 11.2.0.4 RAC 安装Linux系统安装之类，就不截图了. 1.在两个节点建立相同的group&user[root@racdb1 ~]# groupadd -g 1000 oinstall[root@racdb1 ~]# groupadd -g 1200 asmadmin[root@racdb1 ~]# groupadd -g 1201 asmdba[root@racdb1 ~]# groupadd -g 1202 asmoper[root@rac...

3.1 整数类型整数类型字节数无符合数的取值范围有符合数的取值范围TINYINT10~255-128~127...

http://dev.mysql.com/downloads/mysql/   下载地址,在下拉框中选择相应的版本windows下直接双击下载文件安装吧直接上图吧  本地连接测试一下.E:\mysql\bin>mysql -h 172.16.20.31 -uroot -pEnter password: *****ERROR 1130 ...

1.1    下载http://dev.mysql.com/downloads/mysql/   下载地址,在下拉框中选择相应的版本 1.2    安装下载下来的绿色安装包，直接解压为E:\mysql 1.3    编辑my.ini文件，将mydefault.ini copy一份出来，就该其中的参数....