凡所有相☯皆是虛妄

調整redo log file 的一個script

2010-09-02T01:46:00.001-07:00

在8i（8.1.7.4）上用到增加一個redo log file group 成員的例子

db03-oracle $cat alterredo.sql
alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 1;
alter database add logfile group 1 ('/u01/oradata/databasesid/redo1.log','/u04/oradata/databasesid/redo1.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 2;
alter database add logfile group 2 ('/u01/oradata/databasesid/redo2.log','/u04/oradata/databasesid/redo2.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 3;
alter database add logfile group 3 ('/u01/oradata/databasesid/redo3.log','/u04/oradata/databasesid/redo3.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 4;
alter database add logfile group 4 ('/u01/oradata/databasesid/redo4.log','/u04/oradata/databasesid/redo4.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 5;
alter database add logfile group 5 ('/u01/oradata/databasesid/redo5.log','/u04/oradata/databasesid/redo5.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 6;
alter database add logfile group 6 ('/u01/oradata/databasesid/redo6.log','/u04/oradata/databasesid/redo6.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 7;
alter database add logfile group 7 ('/u01/oradata/databasesid/redo7.log','/u04/oradata/databasesid/redo7.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 8;
alter database add logfile group 8 ('/u01/oradata/databasesid/redo8.log','/u04/oradata/databasesid/redo8.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 9;
alter database add logfile group 9 ('/u01/oradata/databasesid/redo9.log','/u04/oradata/databasesid/redo9.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 10;
alter database add logfile group 10 ('/u01/oradata/databasesid/redo10.log','/u04/oradata/databasesid/redo10.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 11;
alter database add logfile group 11 ('/u01/oradata/databasesid/redo11.log','/u04/oradata/databasesid/redo11.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 12;
alter database add logfile group 12 ('/u01/oradata/databasesid/redo12.log','/u04/oradata/databasesid/redo12.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 13;
alter database add logfile group 13 ('/u01/oradata/databasesid/redo13.log','/u04/oradata/databasesid/redo13.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 14;
alter database add logfile group 14 ('/u01/oradata/databasesid/redo14.log','/u04/oradata/databasesid/redo14.log') size 6291456 reuse;

alter system switch logfile;
alter system checkpoint;
alter database drop logfile group 15;
alter database add logfile group 15 ('/u01/oradata/databasesid/redo15.log','/u04/oradata/databasesid/redo15.log') size 6291456 reuse;

alter system switch logfile;
db03-oracle $

記錄一下。

遭遇 ORA-03232: unable to allocate an extent of 40 blocks from tablespace 5

2010-08-30T20:23:00.001-07:00

對Oracle database 進行 exp imp操作的時候，跑到最後發現報錯了

…

MP-00017: following statement failed with ORACLE error 604:
"ALTER TABLE "abc_USER_AUTOPAY_PLAN" ENABLE CONSTRAINT "FK_AUTOP_PLAN_abc""
IMP-00003: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-03232: unable to allocate an extent of 40 blocks from tablespace 5

…

解決步驟：

1 tablespace 5是什麼

SQL> select * from v$tablespace;
       TS# NAME
---------- ------------------------------
         0 SYSTEM
         1 TOOLS
         2 OEM_REPOSITORY
         3 RBS
         4 TEMP
        5 APP_TEMP
         6 USERS
         7 ABC_DATA
         8 INDX
         9 ABC_INDX
        10 DRSYS
11 rows selected.

增大 tablespace size 無效

alter database datafile '/u04/oradata/crprod/apptemp01.dbf' resize 2000m;

google一下發現可能是 dba_tablespace的 next_extent的問題

SQL> select next_extent from dba_tablespaces where tablespace_name = 'APP_TEMP';
NEXT_EXTENT
-----------
65536

SQL> alter tablespace app_temp default storage (next 1m);
Tablespace altered.
SQL> select next_extent from dba_tablespaces where tablespace_name = 'APP_TEMP';
NEXT_EXTENT
-----------
1048576

手工運行-成功：

SQL> ALTER TABLE ABC_USER_AUTOPAY_PLAN ENABLE CONSTRAINT FK_AUTOP_PLAN_UPROF_ABC;
Table altered.

記錄一下備忘！

转应该告诉儿童什么

2010-08-06T18:28:00.001-07:00

发现twitter上不错的几句话记录一下:

告诉儿童:

1.平安成长比成功更重要.
2.背心短裤覆盖的地方,不许别人摸.
3.生命第一,财产第二.
4.小秘密要告诉妈妈.
5.不喝陌生人的饮料,不吃陌生人的糖果.
6.不与陌生人讲话.
7.遇到危险可以打破玻璃,破坏家具.
8.遇见危险可以自己先跑.
9.不保守坏人的秘密.
10.坏人可以骗.

realVNC Could not init font path element /usr/X11R6/lib/X11/fonts/misc/, removing from list! 處理

2010-05-12T00:13:00.001-07:00

參考：http://cha.homeip.net/blog/2005/08/137.html

vnc-4_1_3-x86_linux.tar.gz

安裝realvnc for linux 後發現啟動不了

查看~/.vnc/xxx.log發現

Couldn't open RGB_DB '/usr/X11R6/lib/X11/rgb'

Xvnc Free Edition 4.1.3 - built Oct 15 2008 12:55:42
Copyright (C) 2002-2008 RealVNC Ltd.
See http://www.realvnc.com for information on VNC.
Underlying X server release 40201000, The XFree86 Project, Inc

Wed May 12 22:18:05 2010
vncext:      VNC extension running!
vncext:      Listening for VNC connections on port 5901
vncext:      Listening for HTTP connections on port 5801
vncext:      created VNC server for screen 0
error opening security policy file /usr/X11R6/lib/X11/xserver/SecurityPolicy
Could not init font path element /usr/X11R6/lib/X11/fonts/misc/, removing from list!
Could not init font path element /usr/X11R6/lib/X11/fonts/Speedo/, removing from list!
Could not init font path element /usr/X11R6/lib/X11/fonts/Type1/, removing from list!
Could not init font path element /usr/X11R6/lib/X11/fonts/CID/, removing from list!
Could not init font path element /usr/X11R6/lib/X11/fonts/75dpi/, removing from list!
Could not init font path element /usr/X11R6/lib/X11/fonts/100dpi/, removing from list!

Fatal server error:
could not open default font 'fixed'
xsetroot: unable to open display 'pennyho.test.com:1'
Warning: This program is an suid-root program or is being run by the root user.
The full text of the error or warning message cannot be safely formatted
in this environment. You may get a more descriptive message by running the
program as a non-root user or by removing the suid bit on the executable.
xterm Xt error: Can't open display: %s

(gnome-session:22056): Gtk-WARNING **: cannot open display:
vncconfig: unable to open display "pennyho.crp.com:1"

發現/usr/X11R6/lib/X11/ 沒有內容

google了一下發現http://www.linuxquestions.org/questions/linux-desktop-74/vnc-problems-could-not-open-default-font-fixed-481175/

cp –rf /usr/share/X11 /usr/X11R6/lib/X11

再次啟動，vncserver 查看一下端口

# netstat -untlp |grep Xvnc
tcp        0      0 0.0.0.0:5801                0.0.0.0:*                   LISTEN      3463/Xvnc
tcp        0      0 0.0.0.0:5901                0.0.0.0:*                   LISTEN      3463/Xvnc
tcp        0      0 0.0.0.0:6001                0.0.0.0:*                   LISTEN      3463/Xvnc

出來了

remote 瀏覽器訪問5801端口 ok！

記錄一下備忘

記錄一下我的過程：

tar xvfz vnc-4_1_3-x86_linux.tar.gz
cd vnc-4_1_3-x86_linux

./vncinstall /usr/local/bin

mkdir -p /usr/X11R6/lib/modules/extensions/

cd vnc-4_1_3-x86_linux

cp vnc.so /usr/X11R6/lib/modules/extensions/
mkdir -p /usr/local/vnc/classes
cp java/* /usr/local/vnc/classes
cp -rf /usr/share/X11 /usr/X11R6/lib/X11

# which vncserver
/usr/local/bin/vncserver

# netstat -tln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State
tcp        0      0 0.0.0.0:771                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:904                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:25300               0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN
tcp        0      0 :::22                       :::*                        LISTEN

]# vncserver

You will require a password to access your desktops.

Password:
Verify:

New 'CRRACTEST.localdomain:1 (root)' desktop is CRRACTEST.localdomain:1

Creating default startup script /root/.vnc/xstartup
Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/CRRACTEST.localdomain:1.log

# netstat -tln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State
tcp        0      0 0.0.0.0:771                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:904                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:5801                0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:5901                0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:6001                0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:25300               0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN
tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN
tcp        0      0 :::22                       :::*                        LISTEN

從remote IE or firefox :

:5801">http://vncserver<ip>:5801

就可以訪問到了

當然如果希望gnome or kde env,修改 ~/.vnc/xstartup文件

GNOME:

xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
gnome-session &

KDE:

xsetroot -solid grey
vncconfig -iconic &
xterm -geometry 80x24+10+10 -ls -title "$VNCDESKTOP Desktop" &
startkde &

補充完畢

vmware安裝在Centos5.3上的報錯vmware gcc: error trying to exec 'cc1': execvp: No such file or directory

2010-05-04T21:46:00.001-07:00

運行

vmware-config.pl ,報錯

…

vmware gcc: error trying to exec 'cc1': execvp: No such file or directory

…

糾結了半天原來認為是kernel 的問題，後來發現

gcc-c++ 沒有安裝

yum install gcc-c++

再次運行過去了

記錄一下備忘

keepalived failover實驗

2010-05-03T20:20:00.001-07:00

實驗keepalived 對2個lvs server進行failover的切換

要求：

1.可以切換過去

2.發送mail

安裝keepalived-1.1.19.tar.gz 目前最新的

./configure

make

make install 三部曲

#cp /usr/local/etc/rc.d/init.d/keepalived /etc/rc.d/init.d/

#cp /usr/local/etc/sysconfig/keepalived /etc/sysconfig/

#mkdir /etc/keepalived

#cp /usr/local/etc/keepalived/keepalived.conf /etc/keepalived/

#cp /usr/local/sbin/keepalived /usr/sbin/

然後便捷.conf文件

! Configuration File for keepalived
global_defs {
   notification_email {
                yourname@yourdomain //要收到mail的address
   }
   notification_email_from lvs-machine@lvsdomain 發送
   smtp_server 127.0.0.1
   smtp_connect_timeout 30
   router_id LVS_DEVEL
}
# VIP1
vrrp_instance VI_1 {
    state MASTER

    smtp_alert    #這個是關鍵，如果沒有這個不會發mail!
    interface eth0
    virtual_router_id 51
    priority 150        advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        172.16.1.240
    }
}

virtual_server 172.16.1.240 80 {
    delay_loop 6
    lb_algo wrr
    lb_kind DR
    persistence_timeout 60
    protocol TCP

    real_server 172.16.1.233 80 {
        weight 3
        TCP_CHECK {
        connect_timeout 10
        nb_get_retry 3
        delay_before_retry 3
        connect_port 80
        }
     }
}
[root@lvserver keepalived]#

backup

! Configuration File for keepalived
global_defs {
   notification_email {
                yourname@yourdomain
   }
   notification_email_from lvs-backup@lvs-domain
   smtp_server 127.0.0.1   #default 啟動sendmail 25端口
   smtp_connect_timeout 30
   router_id LVS_DEVEL
}

# VIP1
vrrp_instance VI_1 {
    state BACKUP             #.......MASTER..BACKUP
        smtp_alert
    interface eth0
    virtual_router_id 51
    priority 99    # ......100..99
    advert_int 1
    authentication {
        auth_type PASS
        auth_pass 1111
    }
    virtual_ipaddress {
        172.16.1.240
    }
}

virtual_server 172.16.1.240 80 {
    delay_loop 6
    lb_algo wrr
    lb_kind DR
    persistence_timeout 60
    protocol TCP

    real_server 172.16.1.233 80 {
        weight 3
        TCP_CHECK {
        connect_timeout 10
        nb_get_retry 3
        delay_before_retry 3
        connect_port 80
        }
     }
}

在default情況下，master 掉了會切換到slave(backup) lvs server, 但是當master 回來的時候會取代slave,還是master.

這個要跟實際應用策略有關係。

要注意就是：

smtp_alert的設置，否則不會收到mail

測試發現他發出來的mail不是太明顯，沒有辦法編輯格式，後來想了一下，可以使用其他的手段做一個mail script.發送。

網上很多資料。不再列舉了

記錄一下，備忘！

參考：

http://www.linuxtone.org/thread-1077-1-1.html

sendmail “cannot open `/usr/share/sendmail-cf/m4/cf.m4': No such file or directory” 問題處理

2010-05-02T19:43:00.001-07:00

在生成sendmail configure file的時候報錯了

m4 sendmail.mc >sendmail.cf

cannot open `/usr/share/sendmail-cf/m4/cf.m4': No such file or directory

網上查一下少

sendmail-cf

這個包

因為我這裡使用的是OEL 5.4 從iso上面找到

[root@lvserver Server]# rpm -Uvh sendmail-cf-8.13.8-2.el5.x86_64.rpm

warning: sendmail-cf-8.13.8-2.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159

Preparing... ########################################### [100%]

1:sendmail-cf ########################################### [100%]

[root@lvserver Server]#

再次運行m4 sendmail.mc >sendmail.cf ok

[root@lvserver ~]# netstat -tln

Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address               Foreign Address             State

tcp        0      0 127.0.0.1:199               0.0.0.0:*                   LISTEN

tcp        0      0 0.0.0.0:904                 0.0.0.0:*                   LISTEN

tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN

tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN

tcp        0      0 0.0.0.0:25                  0.0.0.0:*                   LISTEN   <-here

tcp        0      0 0.0.0.0:860                 0.0.0.0:*                   LISTEN

tcp        0      0 :::22                       :::*                        LISTEN

發一個mail測試一下：

[root@lvserver ~]# mail -s "lvs222 test" youname@example.com.hk </dev/null

Null message body; hope that's ok

[root@lvserver ~]#

收到，測試成功記錄一下，

sendmail的配置文件的地址：

[root@lvserver mail]# pwd

/etc/mail

啟動關閉

[root@lvserver init.d]# pwd

/etc/init.d

[root@lvserver init.d]# ./sendmail

Usage: ./sendmail {start|stop|restart|condrestart|status}

記錄一下備忘！

apache 中如何添加mod_info.c這個文件

2010-04-20T23:41:00.001-07:00

最近做實驗，發現在1.3.x , 2.2.x version中mod_status是defult安裝的，但是mod_info不是default安裝的。

如何安裝呢？

------------------apache 1.3.x----
[root@web232 standard]# /usr/local/apache/bin/apxs -cia mod_info.c
apxs:Error: Sorry, no DSO support for Apache available
apxs:Error: under your platform. Make sure the Apache
apxs:Error: module mod_so is compiled into your server
apxs:Error: binary `/usr/local/apache/bin/httpd'.

應該是沒有按照要求進行編譯

./configure --prefix=/usr/local/ --enable-module=so

如果這樣編譯就可以了

在2.2.x環境下
---apache2.2.x----
[root@web233 generators]# /usr/local/apache2/bin/apxs -cia mod_info.c
/usr/local/apache2/build/libtool --silent --mode=compile gcc -prefer-pic   -DLINUX=2 -D_REENTRANT -D_GNU_SOURCE -D_LARGEFILE64_SOURCE -g -O2 -pthread -I/usr/local/apache2/include -I/usr/local/apache2/include   -I/usr/local/apache2/include   -c -o mod_info.lo mod_info.c && touch mod_info.slo
/usr/local/apache2/build/libtool --silent --mode=link gcc -o mod_info.la -rpath /usr/local/apache2/modules -module -avoid-version    mod_info.lo
/usr/local/apache2/build/instdso.sh SH_LIBTOOL='/usr/local/apache2/build/libtool' mod_info.la /usr/local/apache2/modules
/usr/local/apache2/build/libtool --mode=install cp mod_info.la /usr/local/apache2/modules/
cp .libs/mod_info.so /usr/local/apache2/modules/mod_info.so
cp .libs/mod_info.lai /usr/local/apache2/modules/mod_info.la
cp .libs/mod_info.a /usr/local/apache2/modules/mod_info.a
chmod 644 /usr/local/apache2/modules/mod_info.a
ranlib /usr/local/apache2/modules/mod_info.a
PATH="$PATH:/sbin" ldconfig -n /usr/local/apache2/modules
----------------------------------------------------------------------
Libraries have been installed in:
   /usr/local/apache2/modules
If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the `-LLIBDIR'
flag during linking and do at least one of the following:
   - add LIBDIR to the `LD_LIBRARY_PATH' environment variable
     during execution
   - add LIBDIR to the `LD_RUN_PATH' environment variable
     during linking
   - use the `-Wl,--rpath -Wl,LIBDIR' linker flag
   - have your system administrator add LIBDIR to `/etc/ld.so.conf'
See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
chmod 755 /usr/local/apache2/modules/mod_info.so
[activating module `info' in /usr/local/apache2/conf/httpd.conf]
[root@web233 modules]# pwd
/usr/local/apache2/modules
[root@web233 modules]# ls
httpd.exp mod_info.so
已经增加了
# Example:
# LoadModule foo_module modules/mod_foo.so
LoadModule info_module        modules/mod_info.so ＃這個是自動添加上的

添加如下內容：
<Location /server-info>
    SetHandler server-info
    Order deny,allow
    Allow from all    #我這裡是測試環境所以也就這樣設了 production 環境注意一下
</Location>
http://172.16.1.233/server-info

看到信息了

注意httpd.conf中間ExtendedStatus 在2.2.x版本是沒有的

ExtendedStatus On

加上restart apache

就可以看到信息了

臨時開發vsftpd

2010-04-16T00:38:00.001-07:00

yum install vsftpd

cd /etc/vsftpd

[root@carbon vsftpd]# ls
ftpusers user_list vsftpd.conf vsftpd.conf.bak vsftpd_conf_migrate.sh
[root@carbon vsftpd]#

[root@carbon vsftpd]# cat vsftpd.conf
anonymous_enable=NO
local_enable=YES
write_enable=YES
listen=YES
listen_port=21
max_clients=100
max_per_ip=5
idle_session_timeout=600
data_connection_timeout=120
accept_timeout=60
connect_timeout=60
tcp_wrappers=YES
guest_enable=YES
#guest_username=vsftpd
guest_username=yourusername
virtual_use_local_privs=YES
#pam_service_name=ftp
chroot_local_user=YES
pasv_enable=YES
pasv_min_port=30998
pasv_max_port=30999
[root@carbon vsftpd]#

[root@carbon pam.d]# pwd
/etc/pam.d
[root@carbon pam.d]# cp vsftpd ftp #否這server上的用戶登錄不上

[root@carbon pam.d]# vsftpd /etc/vsftpd/vsftpd.conf

[root@carbon pam.d]# netstat –tln

tcp 0 0 0.0.0.0:21 0.0.0.0:* LISEN

本地ftp---ok

遠程ftp –ok

apache ab stress tool “apr_socket_recv: Connection reset by peer (104)” 的處理

2010-04-12T02:40:00.001-07:00

使用apache 自帶的stresss tools ab, 如果併發設定的稍微大點就報錯了

類似：

[root@localhost bin]# ./ab -n 1000000 -c 2000 http://172.16.1.237/index.html

This is ApacheBench, Version 2.3 <$Revision: 655654 $>

Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 172.16.1.237 (be patient)

apr_socket_recv: Connection reset by peer (104)

Total of 80159 requests completed

開始懷疑是web server設置， os kernel parameter 設置的問題，後面發現不是，而是ab 這個程序自身的問題，要打patch:

我用的是2.2.15 ，最新發佈的找到 srccode/support/ab.c

--修改代碼ab.c

1367 }

1368 return;

1369 } else {

1370 //apr_err("apr_socket_recv", status); //原來的

1371 bad++;

1372 close_connection(c);

1373 return;

1374

1375 }

1376 }

1377 }

make

使用這個新生成的ab做測試壓力可以達到20000

[root@localhost support]# ./ab -k -n 1000000 -c 20000 http://172.16.1.237/index.html

This is ApacheBench, Version 2.3 <$Revision: 655654 $>

Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 172.16.1.237 (be patient)

Completed 100000 requests

Completed 200000 requests

Completed 300000 requests

Completed 400000 requests

Completed 500000 requests

Completed 600000 requests

Completed 700000 requests

Completed 800000 requests

Completed 900000 requests

Completed 1000000 requests

Finished 1000000 requests

Server Software: Apache/2.2.15

Server Hostname: 172.16.1.237

Server Port: 80

Document Path: /index.html

Document Length: 62 bytes

Concurrency Level: 20000

Time taken for tests: 129.656 seconds

Complete requests: 1000000

Failed requests: 26877

(Connect: 0, Receive: 8959, Length: 8959, Exceptions: 8959)

Write errors: 0

Keep-Alive requests: 982282

Total transferred: 344888716 bytes

HTML transferred: 61514602 bytes

Requests per second: 7712.75 [#/sec] (mean)

Time per request: 2593.110 [ms] (mean)

Time per request: 0.130 [ms] (mean, across all concurrent requests)

Transfer rate: 2597.69 [Kbytes/sec] received

Connection Times (ms)

min mean[+/-sd] median max

Connect: 0 128 1551.6 0 93118

Processing: 1 583 3610.3 260 104485

Waiting: 0 284 639.7 252 54667

Total: 1 711 4610.9 260 128455

Percentage of the requests served within a certain time (ms)

50% 260

66% 349

75% 397

80% 424

90% 476

95% 504

98% 664

99% 12202

100% 128455 (longest request)

[root@localhost support]#

[root@localhost support]# ./ab -k -n 1000000 -c 30000 http://172.16.1.237/index.html

/root/httpd-2.2.15/support/.libs/lt-ab: Invalid Concurrency [Range 0..20000]

Usage: /root/httpd-2.2.15/support/.libs/lt-ab [options] [http://]hostname[:port]/path

再次修改src code, grep 一下20000，將這個參數加大

但是無論如何也上不了 30000，

[root@localhost support]# ./ab -k -n 1000000 -c 30000 http://172.16.1.237/index.html

This is ApacheBench, Version 2.3 <$Revision: 655654 $>

Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 172.16.1.237 (be patient)

Test aborted after 10 failures

apr_socket_connect(): Cannot assign requested address (99)

有時間再查，記錄一下

ORACLE 11g RAC ons offline 處理

2010-04-11T19:28:00.001-07:00

同事報生產環境的ons offline.但是神奇的是rac的node並沒有影響，記錄一下解決過程

[root@oracle02 trace]# which crs_start
/u01/app/11.1.0/crs/bin/crs_start
[root@oracle02 trace]# which crs_stop
/u01/app/11.1.0/crs/bin/crs_stop
這個的ora.oracle02.ons 可以從ora....e02.ons 和 host
[root@oracle02 trace]# crs_stop ora.oracle02.ons （Name 和Host)這兩個地方找到
Target set to OFFLINE for `ora.oracle02.ons`
[root@oracle02 trace]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....b5.inst application    ONLINE    OFFLINE
ora.crpb5.db   application    ONLINE    OFFLINE
ora....d1.inst application    ONLINE    ONLINE    oracle01
ora....d2.inst application    ONLINE    ONLINE    oracle02
ora.crprod.db application    ONLINE    ONLINE    oracle01
ora....SM1.asm application    ONLINE    ONLINE    oracle01
ora....01.lsnr application    ONLINE    ONLINE    oracle01
ora....e01.gsd application    ONLINE    ONLINE    oracle01
ora....e01.ons application    ONLINE    ONLINE    oracle01
ora....e01.vip application    ONLINE    ONLINE    oracle01
ora....SM2.asm application    ONLINE    ONLINE    oracle02
ora....02.lsnr application    ONLINE    ONLINE    oracle02
ora....e02.gsd application    ONLINE    ONLINE    oracle02
ora....e02.ons application    OFFLINE   OFFLINE
ora....e02.vip application    ONLINE    ONLINE    oracle02
[root@oracle02 trace]# crs_start ora.oracle02.ons
Attempting to start `ora.oracle02.ons` on member `oracle02`
Start of `ora.oracle02.ons` on member `oracle02` succeeded.
[root@oracle02 trace]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....b5.inst application    ONLINE    OFFLINE
ora.crpb5.db   application    ONLINE    OFFLINE
ora....d1.inst application    ONLINE    ONLINE    oracle01
ora....d2.inst application    ONLINE    ONLINE    oracle02
ora.crprod.db application    ONLINE    ONLINE    oracle01
ora....SM1.asm application    ONLINE    ONLINE    oracle01
ora....01.lsnr application    ONLINE    ONLINE    oracle01
ora....e01.gsd application    ONLINE    ONLINE    oracle01
ora....e01.ons application    ONLINE    ONLINE    oracle01
ora....e01.vip application    ONLINE    ONLINE    oracle01
ora....SM2.asm application    ONLINE    ONLINE    oracle02
ora....02.lsnr application    ONLINE    ONLINE    oracle02
ora....e02.gsd application    ONLINE    ONLINE    oracle02
ora....e02.ons application    ONLINE    ONLINE    oracle02
ora....e02.vip application    ONLINE    ONLINE    oracle02
[root@oracle02 trace]#
之前嘗試 onsctl stop |start 沒有什麼效果，原因待查
[root@oracle02 trace]# onsctl help
usage: /u01/app/oracle/product/11.1.0/bin/onsctl start|stop|ping|reconfig|debug
start                            - Start opmn only.
stop                             - Stop ons daemon
ping                             - Test to see if ons daemon is running
debug                            - Display debug information for the ons daemon
reconfig                         - Reload the ons configuration
help                             - Print a short syntax description (this).
detailed                         - Print a verbose syntax description.
[root@oracle02 trace]#
ref: http://blog.roodo.com/mywork/archives/11858971.html

關於ons,好像是跟jdbc連接有關係，我們application使用的是dot net.所以沒有看到影響。得空研究一下。

apache(2.2.15) +php(5.2.10) 實驗

2010-03-29T02:38:00.001-07:00

這次測試加在php動態頁面的效果

apache pre-fork mode:

1, apache compiled

./configure --prefix=/usr/local/apache2 --enable-so --enable-rewrite --with-mpm=prefork

2 php compiled

./configure --prefix=/usr/local/php --with-config-file-path=/usr/local/php --with-mysql=/usr/local/webserver/mysql --with-apxs2=/usr/local/apache2/bin/apxs

3. make
make ZEND_EXTRA_LIBS='-liconv'

4 .make install

5. 編輯測試文件

[root@LB1 bin]# cd /usr/local/apache2/htdocs/

[root@LB1 htdocs]# ls

index.html

[root@LB1 htdocs]# vi index.php

[root@LB1 htdocs]# cat index.php

<?php

phpinfo();

[root@LB1 htdocs]#

6, apache httpd.conf中添加：

設置web server環境

#載入php5的函式庫
LoadModule php5_module modules/libphp5.so
#指定php執行的副檔名
AddType application/x-httpd-php .php .phtml .inc .php3
#原始碼副呈現的副檔名
AddType application/x-httpd-php-source .phps

StartServers 2

MaxClients 150

MinSpareThreads 25

MaxSpareThreads 75

ThreadsPerChild 25

MaxRequestsPerChild 0

</IfModule>

7 壓力baseline收集

php 頁面部分

===prefork mode====

[root@LB1 bin]# ./ab -n 10000 -c 10 http://172.16.1.222/index.php

This is ApacheBench, Version 2.3 <$Revision: 655654 $>

Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 172.16.1.222 (be patient)

Completed 1000 requests

Completed 2000 requests

Completed 3000 requests

Completed 4000 requests

Completed 5000 requests

Completed 6000 requests

Completed 7000 requests

Completed 8000 requests

Completed 9000 requests

Completed 10000 requests

Finished 10000 requests

Server Software: Apache/2.2.15

Server Hostname: 172.16.1.222

Server Port: 80

Document Path: /index.php

Document Length: 40213 bytes

Concurrency Level: 10

Time taken for tests: 5.047 seconds

Complete requests: 10000

Failed requests: 0

Write errors: 0

Total transferred: 403848771 bytes

HTML transferred: 402178437 bytes

Requests per second: 1981.49 [#/sec] (mean)

Time per request: 5.047 [ms] (mean)

Time per request: 0.505 [ms] (mean, across all concurrent requests)

Transfer rate: 78146.56 [Kbytes/sec] received

Connection Times (ms)

min mean[+/-sd] median max

Connect: 0 0 0.6 0 8

Processing: 1 5 0.8 5 12

Waiting: 0 1 0.9 1 8

Total: 2 5 0.8 5 13

Percentage of the requests served within a certain time (ms)

50% 5

66% 5

75% 5

80% 6

90% 6

95% 6

98% 7

99% 7

100% 13 (longest request)

[root@LB1 bin]#

btw:再進行work方式的時候使用類似上面的辦法報錯了“

[root@LB1 bin]# ./apachectl start

[Mon Mar 29 23:57:53 2010] [crit] Apache is running a threaded MPM, but your PHP Module is not compiled to be threadsafe. You need to recompile PHP.

Pre-configuration failed

”解決，參見上一篇文章

worker 方式：

1, apache complied

./configure --prefix=/usr/local/httpd2 --enable-so --enable-rewrite --with-mpm=worker

2, php compiled

./configure --prefix=/usr/local/php2 --with-config-file-path=/usr/local/phpw --with-mysql=/usr/local/webserver/mysql --with-apxs2=/usr/local/httpd2/bin/apxs --enable-maintainer-zts

3. make
make ZEND_EXTRA_LIBS='-liconv'

4 .make install

5. 編輯測試文件

[root@LB1 bin]# cd /usr/local/apache2/htdocs/

[root@LB1 htdocs]# ls

index.html

[root@LB1 htdocs]# vi index.php

[root@LB1 htdocs]# cat index.php

<?php

phpinfo();

[root@LB1 htdocs]#

6, apache httpd.conf中添加：

設置web server環境

StartServers 2

MaxClients 150

MinSpareThreads 25

MaxSpareThreads 75

ThreadsPerChild 25

MaxRequestsPerChild 0

</IfModule>

啟動apache

7 收集壓力基準：

[root@LB1 htdocs]# cd ../bin

[root@LB1 bin]# ./ab -n 10000 -c 10 http://172.16.1.222/index.php

This is ApacheBench, Version 2.3 <$Revision: 655654 $>

Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 172.16.1.222 (be patient)

Completed 1000 requests

Completed 2000 requests

Completed 3000 requests

Completed 4000 requests

Completed 5000 requests

Completed 6000 requests

Completed 7000 requests

Completed 8000 requests

Completed 9000 requests

Completed 10000 requests

Finished 10000 requests

Server Software: Apache/2.2.15

Server Hostname: 172.16.1.222

Server Port: 80

Document Path: /index.php

Document Length: 40284 bytes

Concurrency Level: 10

Time taken for tests: 4.213 seconds

Complete requests: 10000

Failed requests: 3

(Connect: 0, Receive: 0, Length: 3, Exceptions: 0)

Write errors: 0

Total transferred: 404509865 bytes

HTML transferred: 402839865 bytes

Requests per second: 2373.57 [#/sec] (mean)

Time per request: 4.213 [ms] (mean)

Time per request: 0.421 [ms] (mean, across all concurrent requests)

Transfer rate: 93762.80 [Kbytes/sec] received

Connection Times (ms)

min mean[+/-sd] median max

Connect: 0 0 0.2 0 4

Processing: 1 4 1.8 4 45

Waiting: 0 3 1.5 3 30

Total: 1 4 1.8 4 46

Percentage of the requests served within a certain time (ms)

50% 4

66% 4

75% 5

80% 5

90% 6

95% 7

98% 8

99% 9

100% 46 (longest request)

[root@LB1 bin]#

對比發現，從動態頁面來看，worker方式的優勢就顯現出來了，處理能力明顯被pre-fork方式強。

記錄一下，備忘

Apache is running a threaded MPM, but your PHP Module is not compiled to be threadsafe. You need to recompile PHP. Pre-configuration failed 的處理

2010-03-29T02:22:00.001-07:00

在pre-fork mode下apache+php5運行沒有問題，但是在worker mode, apache啟動的時候，報錯了

如何處理呢，發現別人已經遇到這個問題

./configure --prefix=/usr/local/php2 --with-config-file-path=/usr/local/php2 --with-mysql=/usr/local/webserver/mysql --with-apxs2=/usr/local/httpd2/bin/apxs --enable-maintainer-zts --with-experimental-zts

紅色字體上後加入的

重新configure; make ; make install ok

Btw, php5.2.10 直接make 報錯

make使用

make ZEND_EXTRA_LIBS='-liconv'

猜想應該是php5.2.10內部的libconv可能不好用吧。

make install後，運行apache ok.

記錄一下！

如何加快make的速度

2010-03-29T02:17:00.001-07:00

如果您有編譯的經歷，對opensource的長時間make 一定有體會，比如php, 比如mysql的源代碼安裝

看到別人的一個安裝文檔用到了make –j 10,

man make 查了一下，發現

[root@LB1 httpd-2.2.15]# make -j 10

-j [jobs], --jobs[=jobs]

Specifies the number of jobs (commands) to run simultaneously. If there is more than one -j option, the last one is effective. If the -j option is given without an argument, make will not limit the number of jobs that can run simultaneously.

就是啟動多個job 來運行make , 記錄一下，提高效率

類似：error while loading shared libraries: libiconv.so.2 問題的處理

2010-03-29T02:13:00.001-07:00

安裝apache2.2以後，發現啟動不了

報類似的錯誤：

error while loading shared libraries: libiconv.so.2: cannot open shared object file: No such file or directory

查找發現這個文件在/usr/local/lib下面

查看/etc/ld.so.conf 發現裏面沒有內容

將/usr/local/lib 添加在這個文件中

運行ldconfig

再次運行ok, 記錄一下備忘！

apache web server 實驗

2010-03-28T20:16:00.001-07:00

項目需要, 做了一個 apache baseline的實驗, 發現再PC上, 我的測試機器是dell optiplex 755 , apache mpm worker mode 並沒有 pre-fork mode 的效率高,可能是multi-core的優勢沒有顯示出來吧,留一個記錄備查!

[root@LB1 bin]# uname -at
Linux LB1.localdomain 2.6.18-164.el5 #1 SMP Thu Sep 3 04:15:13 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
[root@LB1 bin]#

[root@LB1 bin]# free
total used free shared buffers cached
Mem: 2015392 1099068 916324 0 131880 582036
-/+ buffers/cache: 385152 1630240
Swap: 4063224 0 4063224
[root@LB1 bin]#

[root@LB1 proc]# cat cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Core(TM)2 Duo CPU E8200 @ 2.66GHz
stepping : 6
cpu MHz : 2000.000
cache size : 6144 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 2
apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx smx est tm2 cx16 xtpr lahf_lm
bogomips : 5319.97
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 23
model name : Intel(R) Core(TM)2 Duo CPU E8200 @ 2.66GHz
stepping : 6
cpu MHz : 2000.000
cache size : 6144 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
apicid : 1
fpu : yes
fpu_exception : yes
cpuid level : 10
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl vmx smx est tm2 cx16 xtpr lahf_lm
bogomips : 5319.98
clflush size : 64
cache_alignment : 64
address sizes : 36 bits physical, 48 bits virtual
power management:

[root@LB1 httpd-2.2.15]# ./configure --with-mpm=prefork --prefix=/usr/local/apache_prefork --with-included-apr --with-expat=builtin

[root@LB1 httpd-2.2.15]# make -j 10

-j [jobs], --jobs[=jobs]
Specifies the number of jobs (commands) to run simultaneously. If
there is more than one -j option, the last one is effective. If
the -j option is given without an argument, make will not limit
the number of jobs that can run simultaneously.

[root@LB1 httpd-2.2.15]# make install

第二组

[root@LB1 httpd-2.2.15]# ./configure --with-mpm=worker --prefix=/usr/local/apache_worker --with-included-apr --with-expat=builtin

[root@LB1 httpd-2.2.15]# make -j 10

[root@LB1 httpd-2.2.15]# make install

分别配置参数

StartServers 5
MinSpareServers 5
MaxSpareServers 75
MaxClients 150
MaxRequestsPerChild 0

StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0

[root@LB1 conf]#

测试第一组: prefork mode

[root@LB1 bin]# ./apachectl start
[root@LB1 bin]# netstat -tln |grep 80
tcp 0 0 :::80 :::* LISTEN
[root@LB1 bin]#

[root@LB1 bin]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 16039
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 16039
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@LB1 bin]# ulimit -n 102400
[root@LB1 bin]#

[root@LB1 bin]# ./ab -n 10000 -c 10 http://172.16.1.222/index.html
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 172.16.1.222 (be patient)
Completed 1000 requests
Completed 2000 requests
Completed 3000 requests
Completed 4000 requests
Completed 5000 requests
Completed 6000 requests
Completed 7000 requests
Completed 8000 requests
Completed 9000 requests
Completed 10000 requests
Finished 10000 requests

Server Software: Apache/2.2.15
Server Hostname: 172.16.1.222
Server Port: 80

Document Path: /index.html
Document Length: 44 bytes

Concurrency Level: 10
Time taken for tests: 0.737 seconds
Complete requests: 10000
Failed requests: 0
Write errors: 0
Total transferred: 2950000 bytes
HTML transferred: 440000 bytes
Requests per second: 13565.19 [#/sec] (mean)
Time per request: 0.737 [ms] (mean)
Time per request: 0.074 [ms] (mean, across all concurrent requests)
Transfer rate: 3907.94 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.1 0 1
Processing: 0 1 0.1 1 8
Waiting: 0 0 0.1 0 1
Total: 0 1 0.2 1 8

Percentage of the requests served within a certain time (ms)
50% 1
66% 1
75% 1
80% 1
90% 1
95% 1
98% 1
99% 1
100% 8 (longest request)
[root@LB1 bin]#

第二组 worker

[root@LB1 bin]# ./ab -n 10000 -c 10 http://172.16.1.222/index.html
This is ApacheBench, Version 2.3 <$Revision: 655654 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking 172.16.1.222 (be patient)
Completed 1000 requests
Completed 2000 requests
Completed 3000 requests
Completed 4000 requests
Completed 5000 requests
Completed 6000 requests
Completed 7000 requests
Completed 8000 requests
Completed 9000 requests
Completed 10000 requests
Finished 10000 requests

Server Software: Apache/2.2.15
Server Hostname: 172.16.1.222
Server Port: 80

Document Path: /index.html
Document Length: 44 bytes

Concurrency Level: 10
Time taken for tests: 0.790 seconds
Complete requests: 10000
Failed requests: 0
Write errors: 0
Total transferred: 2950295 bytes
HTML transferred: 440044 bytes
Requests per second: 12660.63 [#/sec] (mean)
Time per request: 0.790 [ms] (mean)
Time per request: 0.079 [ms] (mean, across all concurrent requests)
Transfer rate: 3647.71 [Kbytes/sec] received

Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.1 0 1
Processing: 0 1 0.5 1 16
Waiting: 0 0 0.4 0 15
Total: 0 1 0.5 1 16

Percentage of the requests served within a certain time (ms)
50% 1
66% 1
75% 1
80% 1
90% 1
95% 2
98% 2
99% 2
100% 16 (longest request)
[root@LB1 bin]#

如何查找redo file?

2010-03-19T21:21:00.001-07:00

備忘一下

SQL> select group#, members, status from v$log;

    GROUP#    MEMBERS STATUS
---------- ---------- ----------------
         1          2 INACTIVE
         2          2 CURRENT
         3          2 INACTIVE
         4          2 CURRENT

SQL> desc v$logfile
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
GROUP#                                             NUMBER
STATUS                                             VARCHAR2(7)
TYPE                                               VARCHAR2(7)
MEMBER                                             VARCHAR2(513)
IS_RECOVERY_DEST_FILE                              VARCHAR2(3)

SQL> col member for a30
SQL> select * from v$logfile;

SQL> set linesize 300
SQL> /

    GROUP# STATUS TYPE    MEMBER                         IS_
---------- ------- ------- ------------------------------ ---
         1         ONLINE +CRPROD_DATA/crprod/onlinelog/ NO
                           group_1.257.686193451

1 ONLINE +FLASH_RECOVERY_AREA/crprod/on YES
linelog/group_1.257.686193459

2 ONLINE +CRPROD_DATA/crprod/onlinelog/ NO
group_2.258.686193481

2 ONLINE +FLASH_RECOVERY_AREA/crprod/on YES
linelog/group_2.258.686193491

GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------------ ---

3 ONLINE +CRPROD_DATA/crprod/onlinelog/ NO
group_3.265.686198773

3 ONLINE +FLASH_RECOVERY_AREA/crprod/on YES
linelog/group_3.259.686198787

4 ONLINE +CRPROD_DATA/crprod/onlinelog/ NO
group_4.266.686198801

4 ONLINE +FLASH_RECOVERY_AREA/crprod/on YES

GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------------ ---
linelog/group_4.260.686198809

8 rows selected.

solaris 7 force umount cmd

2010-03-17T19:13:00.001-07:00

在一個超級古老的機器上mount 了一個nfs, 但是nfs server移除以後就沒有辦法 umount 這個目錄了

umount /backup

報錯如下：

nfs umount: /backup: is busy

怎麼辦呢？

google了一下，使用如下命令可以幹掉

Solaris 2.6 and Solaris 7: umount -o force /mount-point

試用了一下，還是報錯

不過df -k的時候發現已經很順暢了，感覺已經去掉了

當然還有另一種辦法

try following ...

unshare /backup
umount /backup

沒有測試過，等下次有機會測試一下

記錄一下備忘！

How to Delete a node from RAC test

2010-03-05T00:01:00.001-08:00

在測試環境中做一個一個RAC delete node的實驗記錄一下

環境是vmware

OS: OEL 5.2

DB: oracle 11gR1

http://docs.google.com/Doc?docid=0AbicX7azhQtmZGs3NzQ2Ml85NjBmbWMyZjRjZw&hl=en

Awk 做url

2010-03-03T02:01:00.001-08:00

學習了一個小技巧

ls | awk '{print "<a href="$0">"$0"</a><br />"}' > index.html

將目錄下的東西寫道成href

ref:

http://ithelp.ithome.com.tw/question/10021489

BBED complie

2010-03-02T18:20:00.001-08:00

發現一個有用的工具BBED,處理壞塊使用的，根據網上提供的方法，自己做了一個實驗：

我的環境是openSolaris 其他的*nix也是類似

1，源文件在哪裡？

cd $ORACLE_HOME

oracle@opensolaris:/opt/oracle/product/10.2.0/db_1$ find . -name ins_rdbms.mk
./rdbms/lib/ins_rdbms.mk

2,編譯：

oracle@opensolaris:/opt/oracle/product/10.2.0/db_1/rdbms/lib$ make -f ins_rdbms.mk /opt/oracle/product/10.2.0/db_1/rdbms/lib/bbed

Linking BBED utility (bbed)
rm -f /opt/oracle/product/10.2.0/db_1/rdbms/lib/bbed
/usr/ccs/bin/ld -64 -o /opt/oracle/product/10.2.0/db_1/rdbms/lib/bbed -L/opt/oracle/product/10.2.0/db_1/rdbms/lib/ -L/opt/oracle/product/10.2.0/db_1/lib/ -dy /opt/oracle/product/10.2.0/db_1/lib/prod/lib/amd64/crti.o /opt/oracle/product/10.2.0/db_1/lib/prod/lib/amd64/crt1x.o /opt/oracle/product/10.2.0/db_1/lib/s0main.o /opt/oracle/product/10.2.0/db_1/rdbms/lib/ssbbded.o /opt/oracle/product/10.2.0/db_1/rdbms/lib/sbbdpt.o `cat /opt/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 /opt/oracle/product/10.2.0/db_1/rdbms/lib/defopt.o -ldbtools10 -lclntsh `cat /opt/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /opt/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /opt/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /opt/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /opt/oracle/product/10.2.0/db_1/lib/sysliblist` -R /opt/SUNWcluster/lib:/opt/oracle/product/10.2.0/db_1/lib:/opt/ORCLcluster/lib/ -Y P,:/opt/SUNWcluster/lib:/opt/ORCLcluster/lib/:/usr/ccs/lib/amd64:/usr/lib/amd64 -Qy -lc -lrt -laio -lposix4 -lkstat -lm /opt/oracle/product/10.2.0/db_1/lib/prod/lib/amd64/crtn.o

驗證一下：

oracle@opensolaris:/opt/oracle/product/10.2.0/db_1/rdbms/lib$ ls -al bbed
-rwxr-xr-x 1 oracle oinstall 862016 2010-03-03 10:06 bbed

執行

oracle@opensolaris:/opt/oracle/product/10.2.0/db_1/rdbms/lib$ ./bbed
Password:（blockedit 為default password)

BBED: Release 2.0.0.0.0 - Limited Production on Wed Mar 3 10:07:15 2010

************* !!! For Oracle Internal Use only !!! ***************

BBED>

這個工具是內部人員使用的哦

BBED>

記錄一下，備忘，繼續學習！

ref:

http://www.databasejournal.com/features/oracle/article.php/3835546/Installing-Oracle-Block-Browser-and-Editor-tool-bbed.htm

http://www.eygle.com/archives/2005/09/how_to_compile.html

add a disk to linux

2010-03-02T02:15:00.001-08:00

在xen上增加一個disk,當人是vritual的：）

[root@Mocktrade dev]# fdisk /dev/xvdb ＃ xvdb 難道xen下的disk都是xvdx嗎？
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.
The number of cylinders for this disk is set to 4895.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
   (e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
Command (m for help): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete a partition
   l   list known partition types
   m   print this menu
   n   add a new partition
   o   create a new empty DOS partition table
   p   print the partition table
   q   quit without saving changes
   s   create a new empty Sun disklabel
   t   change a partition's system id
   u   change display/entry units
   v   verify the partition table
   w   write table to disk and exit
   x   extra functionality (experts only)
Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-4895, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-4895, default 4895):
Using default value 4895
Command (m for help): p
Disk /dev/xvdb: 40.2 GB, 40265318400 bytes
255 heads, 63 sectors/track, 4895 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
    Device Boot      Start         End      Blocks   Id System
/dev/xvdb1               1        4895    39319056   83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@ dev]#
[root@ dev]#
[root@ dev]# mkfs
mkfs         mkfs.cramfs mkfs.ext2    mkfs.ext3
[root@ dev]# mkfs.ext3 -b 4096 /dev/xvdb1
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
4915200 inodes, 9829764 blocks
491488 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
300 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
        32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
        4096000, 7962624
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information:
done
This filesystem will be automatically checked every 29 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.

[root@ /]# df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/xvda3            26306612   7741500 17207220 32% /
/dev/xvda1              101086     19708     76159 21% /boot
tmpfs                  1572864         0   1572864   0% /dev/shm
[root@ /]# mkdir /u01

[root@/]# mount /dev/xvdb1 /u01
[root@ /]# cd /u01
[root@ u01]# touch reame.txt
[root@ u01]# ls
lost+found reame.txt
[root@ u01]# cd /etc
[root@ etc]# vi fstab

cat /etc/fstab
LABEL=/                 /                       ext3    defaults        1 1
LABEL=/boot             /boot                   ext3    defaults        1 2
tmpfs                   /dev/shm                tmpfs   defaults        0 0
devpts                  /dev/pts                devpts gid=5,mode=620 0 0
sysfs                   /sys                    sysfs   defaults        0 0
proc                    /proc                   proc    defaults        0 0
/dev/xvdb1             /u01                   ext3    defaults        1 1
LABEL=SWAP-xvda2        swap                    swap    defaults        0 0

[root@ etc]# df -lh
Filesystem            Size Used Avail Use% Mounted on
/dev/xvda3             26G 7.4G   17G 32% /
/dev/xvda1             99M   20M   75M 21% /boot
tmpfs                 1.5G     0 1.5G   0% /dev/shm
/dev/xvdb1             37G 177M   35G   1% /u01
[root@]#

reboot

記錄一下，備忘！

lower_case_table_names 可以引發mysql replication 不成功

2010-03-02T01:57:00.001-08:00

很早以前配置過一個mysql的replication, 跑的很好，突然客戶的mysql database replicaiton失效了

重新配置replication也無效

~~[crhk@_Slave bin~~]$ cat mysqld_slave.sh
#!/bin/sh
/usr/bin/mysqld_safe --skip-slave-start &
~~[crhk@_Slave bin]$~~

------------------------------------slave----------------------------------
~~[root@_Slave bin~~]# ./mysqld_slave.sh
~~[root@_Slave bin]#~~ Starting mysqld daemon with databases from /var/lib/mysql

~~[root@_Slave mysql]#~~ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.45-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show slave status;
Empty set (0.00 sec)
mysql>
mysql> change master to
    -> master_host='A.B.C.D',
    -> master_port=3306,
    -> master_user='repl',
    -> master_password='password',
    -> master_log_file='mysql-bin.000031',
    -> master_log_pos=201937405;
ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log
mysql>

將同步所需文件全部刪除

rm /var/lib/mysql/relay-log.info
rm /var/lib/mysql/master.info
rm /var/run/mysqld/*

重新做，問題依然

只能跟蹤log了

。。。。

100301 22:26:38 mysqld started
100301 22:26:38 [Warning] /usr/libexec/mysqld: ignoring option '--innodb_file_per_table' due to invalid value 'ON'
100301 22:26:38 [Warning] /usr/libexec/mysqld: ignoring option '--innodb_file_per_table' due to invalid value 'ON'
100301 22:26:39 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100301 22:26:39 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 8 2665319758.
InnoDB: Doing recovery: scanned up to log sequence number 8 2665319758
InnoDB: Last MySQL binlog file position 0 3092, file name /var/lib/mysql/mysql-bin.000037
100301 22:26:39 InnoDB: Started; log sequence number 8 2665319758
100301 22:26:39 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
100301 22:27:47 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000037' at position 3268, relay log '/var/run/mysqld/mysqld-relay-bin.000001' position: 4
100301 22:27:47 [Note] Slave I/O thread: connected to master 'repl@172.16.12.29:3306', replication started in log 'mysql-bin.000037' at position 3268
100301 22:27:47 [ERROR] Slave: Error 'Table 'databasename.GuessFall' doesn't exist' on query. Default database: 'databasename'. Query: 'insert into GuessFall (GuessFallId,UserId,StockCode,State,StartPrice,EndPrice,CreateDate,StopDate) values ('ff52146c-81f6-4334-8920-ef3f059ff3e8','b27e0e77-9cf2-aa9b-e040-10ac0d0c2f1f', '02777', 0, -1, 0.000, '2010-03-01 22:14:40','2010-03-01 22:14:40')', Error_code: 1146
100301 22:27:47 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000037' position 3268

。。。。

發現插入不了

這是開始懷疑master/slave 的配置問題不一致了

diff一下，果然，slave庫中少了

lower_case_table_names=1

修改之slave my.cnf文件，重新配置，正常了

Myql 官方解釋：

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

簡而言之就是寫入不區分大小寫

0 --名字對大小寫敏感，default

1 - -table name on disk是小寫，名字對大小寫敏感

2--存儲根據create table or create database 的語句，mysql 查詢的時候轉換小寫，對大小寫不敏感

教訓：

1. replication 方式下的 master /slave的環境配置一致很重要，

2.lower_case_table_names 這類常用參數，應該在database配置的時候設置好了，避免不必要的改動。

oracle exp parfile mode

2010-02-25T02:04:00.001-08:00

發現一個oracle exp的方法不錯，就是用file方式。記錄一下備查

oracle@opensolaris:~$ cat experfstat.par
userid=perfstat/perfstat
owner=perfstat
DIRECT=y
CONSISTENT=y
file=/export/home/oracle/perfstat.dmp
grants=y
indexes=y
oracle@opensolaris:~$

oracle@opensolaris:~$ exp parfile=experfstat.par
Export: Release 10.2.0.1.0 - Production on Thu Feb 25 17:55:39 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in UTF8 character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user PERFSTAT
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user PERFSTAT
About to export PERFSTAT's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export PERFSTAT's tables via Direct Path ...
. . exporting table         STATS$BG_EVENT_SUMMARY        308 rows exported
. . exporting table          STATS$BUFFERED_QUEUES          0 rows exported
. . exporting table     STATS$BUFFERED_SUBSCRIBERS          0 rows exported
. . exporting table   STATS$BUFFER_POOL_STATISTICS         14 rows exported
. . exporting table          STATS$CR_BLOCK_SERVER          0 rows exported
. . exporting table     STATS$CURRENT_BLOCK_SERVER          0 rows exported
. . exporting table        STATS$DATABASE_INSTANCE          1 rows exported
. . exporting table          STATS$DB_CACHE_ADVICE        294 rows exported
. . exporting table                 STATS$DLM_MISC          0 rows exported
. . exporting table   STATS$DYNAMIC_REMASTER_STATS          0 rows exported
. . exporting table       STATS$ENQUEUE_STATISTICS        826 rows exported
. . exporting table          STATS$EVENT_HISTOGRAM       6692 rows exported
. . exporting table               STATS$FILESTATXS         70 rows exported
. . exporting table           STATS$FILE_HISTOGRAM        350 rows exported
. . exporting table               STATS$IDLE_EVENT         70 rows exported
. . exporting table STATS$INSTANCE_CACHE_TRANSFER          0 rows exported
. . exporting table        STATS$INSTANCE_RECOVERY         14 rows exported
. . exporting table         STATS$JAVA_POOL_ADVICE         28 rows exported
. . exporting table                    STATS$LATCH       5348 rows exported
. . exporting table           STATS$LATCH_CHILDREN          0 rows exported
. . exporting table     STATS$LATCH_MISSES_SUMMARY         14 rows exported
. . exporting table             STATS$LATCH_PARENT          0 rows exported
. . exporting table        STATS$LEVEL_DESCRIPTION          5 rows exported
. . exporting table             STATS$LIBRARYCACHE        154 rows exported
. . exporting table              STATS$MUTEX_SLEEP          0 rows exported
. . exporting table                   STATS$OSSTAT        238 rows exported
. . exporting table               STATS$OSSTATNAME         17 rows exported
. . exporting table                STATS$PARAMETER       3696 rows exported
. . exporting table                  STATS$PGASTAT        196 rows exported
. . exporting table        STATS$PGA_TARGET_ADVICE        196 rows exported
. . exporting table    STATS$PROCESS_MEMORY_ROLLUP        376 rows exported
. . exporting table           STATS$PROCESS_ROLLUP        111 rows exported
. . exporting table     STATS$PROPAGATION_RECEIVER          0 rows exported
. . exporting table       STATS$PROPAGATION_SENDER          0 rows exported
. . exporting table           STATS$RESOURCE_LIMIT         70 rows exported
. . exporting table                 STATS$ROLLSTAT        154 rows exported
. . exporting table         STATS$ROWCACHE_SUMMARY        532 rows exported
. . exporting table                 STATS$RULE_SET         14 rows exported
. . exporting table                 STATS$SEG_STAT          0 rows exported
. . exporting table             STATS$SEG_STAT_OBJ          4 rows exported
. . exporting table            STATS$SESSION_EVENT          0 rows exported
. . exporting table                  STATS$SESSTAT          0 rows exported
. . exporting table          STATS$SESS_TIME_MODEL          0 rows exported
. . exporting table                      STATS$SGA         56 rows exported
. . exporting table                  STATS$SGASTAT        318 rows exported
. . exporting table        STATS$SGA_TARGET_ADVICE        112 rows exported
. . exporting table       STATS$SHARED_POOL_ADVICE        196 rows exported
. . exporting table                 STATS$SNAPSHOT         14 rows exported
. . exporting table                  STATS$SQLTEXT        362 rows exported
. . exporting table                 STATS$SQL_PLAN        330 rows exported
. . exporting table           STATS$SQL_PLAN_USAGE          0 rows exported
. . exporting table           STATS$SQL_STATISTICS         14 rows exported
. . exporting table              STATS$SQL_SUMMARY        885 rows exported
. . exporting table   STATS$SQL_WORKAREA_HISTOGRAM         67 rows exported
. . exporting table      STATS$STATSPACK_PARAMETER          1 rows exported
. . exporting table        STATS$STREAMS_APPLY_SUM          0 rows exported
. . exporting table          STATS$STREAMS_CAPTURE          0 rows exported
. . exporting table      STATS$STREAMS_POOL_ADVICE          0 rows exported
. . exporting table                  STATS$SYSSTAT       5180 rows exported
. . exporting table             STATS$SYSTEM_EVENT        798 rows exported
. . exporting table           STATS$SYS_TIME_MODEL        266 rows exported
. . exporting table               STATS$TEMPSTATXS         14 rows exported
. . exporting table           STATS$TEMP_HISTOGRAM         14 rows exported
. . exporting table                   STATS$THREAD         14 rows exported
. . exporting table      STATS$TIME_MODEL_STATNAME         19 rows exported
. . exporting table                 STATS$UNDOSTAT          8 rows exported
. . exporting table                 STATS$WAITSTAT        252 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.
oracle@opensolaris:~$

dbms_job實驗

2010-02-25T00:02:00.001-08:00

做statspack實驗的時候發現一個問題，就是設定dbms_job後，不自動進行刷新，記錄一下，備忘

在oracle的$ORACLE_HOME/rdbms/admin下有一個腳本spauto.sql看名字就知道是自動做statspack的。其中有一段腳本可以直接來用

--
-- Schedule a snapshot to be run on this instance every hour, on the hour
variable jobno number;
variable instno number;
begin
select instance_number into :instno from v$instance;
dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);
commit;
end;
/

創建一個user job

SQL>
SQL>
variable jobno number;
variable instno number;
begin
select instance_number into :instno from v$instance;
dbms_job.submit(:jobno, 'statspack.snap;', trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);tno);
commit;
5 end;
6 /
PL/SQL procedure successfully completed.
SQL>

SQL> select job, last_date, this_date, next_date from user_jobs;
JOB LAST_DATE THIS_DATE NEXT_DATE
---------- ------------------- ------------------- -------------------
21 2010-02-25 16:00:00
1 row selected.
SQL>

因為是實驗所以將間隔設定的為1min一次

SQL> exec dbms_job.interval(21, 'sysdate+1/(24*60)');
PL/SQL procedure successfully completed.
SQL>

SQL> commit;
Commit complete.

SQL> col interval for a30
SQL> select job, last_date, this_date, next_date , interval from user_jobs;
JOB LAST_DATE THIS_DATE NEXT_DATE INTERVAL
---------- ------------------- ------------------- ------------------- ------------------------------
21 2010-02-25 16:00:00 sysdate+1/(24*60)
1 row selected.
SQL>

可以看到已經設置成功了。

但是等了1min發現沒有新的snap記錄

SQL> select count(*) from stats$snapshot;
COUNT(*)
----------
3
1 row selected.

感覺應該是next_date這個字段有影響

執行

SQL> exec dbms_job.next_date(21, to_date('20100225 15:45:01', 'yyyymmdd hh24:mi:ss'));
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.

SQL> select sysdate from dual;
SYSDATE
-------------------
2010-02-25 15:45:10
1 row selected.

SQL> select job, last_date, this_date, next_date , interval from user_jobs;
JOB LAST_DATE THIS_DATE NEXT_DATE INTERVAL
---------- ------------------- ------------------- ------------------- ------------------------------
21 2010-02-25 15:45:05 2010-02-25 15:46:05 sysdate+1/(24*60)
1 row selected.

注意已經發生變化了

SQL> select count(*) from stats$snapshot;
COUNT(*)
----------
4
1 row selected.

等1min左右

SQL> select count(*) from stats$snapshot;
COUNT(*)
----------
5
1 row selected.

記錄一下，備忘。

openSolaris 0906 install GCC

2010-02-22T23:22:00.001-08:00

1,像偉大的SUN默哀1 min

2,使用 open Solaris live CD 0906安裝一個測試環境。

運行gcc

root@opensolaris:~# gcc
-bash: gcc: command not found
root@opensolaris:~#

沒有找到gcc,安裝

圖形介面

System->Administration –> Package Manager

Search all package for “GCC” or “SUNWgcc”

Install /update packages

“installation completed successfully”

root@opensolaris:~# cd /usr/sfw/bin
root@opensolaris:/usr/sfw/bin# ls gcc
gcc
root@opensolaris:/usr/sfw/bin# ./gcc
gcc: no input files
root@opensolaris:/usr/sfw/bin# ./gcc -v
Reading specs from /usr/sfw/lib/gcc/i386-pc-solaris2.11/3.4.3/specs
Configured with: /builds2/sfwnv-111a/usr/src/cmd/gcc/gcc-3.4.3/configure --prefix=/usr/sfw --with-as=/usr/sfw/bin/gas --with-gnu-as --with-ld=/usr/ccs/bin/ld --without-gnu-ld --enable-languages=c,c++,f77,objc --enable-shared
Thread model: posix
gcc version 3.4.3 (csl-sol210-3_4-20050802)
root@opensolaris:/usr/sfw/bin#

記錄一下，備忘！

Oracle scn相關

2010-02-22T20:24:00.001-08:00

如何查看Oracle當前的SCN呢？

SQL> select current_scn,scn_to_timestamp(current_scn) ,timestamp_to_scn(sysdate)
from v$database ;

CURRENT_SCN SCN_TO_TIMESTAMP(CURRENT_SCN)                                      T                                                                                                                               IMESTAMP_TO_SCN(SYSDATE)
----------- --------------------------------------------------------------------                                                                                                                               ------- -------------------------
    4170959 03-MAR-10 09.30.34.000000000 AM                                                                                                                                                                     4170958

SQL> l
1 select current_scn,scn_to_timestamp(current_scn) ,timestamp_to_scn(sysdate)
2* from v$database
SQL> /

SQL> /

current_scn與 convert以後的sysdate，不一定對應的。

繼續研究

Oracle archive log mode 相關

2010-02-22T19:07:00.001-08:00

發現自己搭建的RAC環境（vmware +OEL linux 5 + oracle 11g),總是包空間不夠，想了一下，應該是archive log mode 因為不管它了，瘋漲log了

如何發現是archive log mode呢？

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

SQL>

archive log 放在那個地方呢？

show parameter archive

SQL> show parameter archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      %t_%s_%r.dbf
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     4
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
standby_archive_dest                 string      ?/dbs/arch
SQL>

沒有顯示出來，如何解決呢？

用v$archive_dest這個view

SQL> desc v$archive_dest;
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
DEST_ID                                            NUMBER
DEST_NAME                                          VARCHAR2(256)
STATUS                                             VARCHAR2(9)
BINDING                                            VARCHAR2(9)
NAME_SPACE                                         VARCHAR2(7)
TARGET                                             VARCHAR2(7)
ARCHIVER                                           VARCHAR2(10)
SCHEDULE                                           VARCHAR2(8)
DESTINATION                                        VARCHAR2(256)
LOG_SEQUENCE                                       NUMBER
REOPEN_SECS                                        NUMBER
DELAY_MINS                                         NUMBER
MAX_CONNECTIONS                                    NUMBER
NET_TIMEOUT                                        NUMBER
PROCESS                                            VARCHAR2(10)
REGISTER                                           VARCHAR2(3)
FAIL_DATE                                          DATE
FAIL_SEQUENCE                                      NUMBER
FAIL_BLOCK                                         NUMBER
FAILURE_COUNT                                      NUMBER
MAX_FAILURE                                        NUMBER
ERROR                                              VARCHAR2(256)
ALTERNATE                                          VARCHAR2(256)
DEPENDENCY                                         VARCHAR2(256)
REMOTE_TEMPLATE                                    VARCHAR2(256)
QUOTA_SIZE                                         NUMBER
QUOTA_USED                                         NUMBER
MOUNTID                                            NUMBER
TRANSMIT_MODE                                      VARCHAR2(12)
ASYNC_BLOCKS                                       NUMBER
AFFIRM                                             VARCHAR2(3)
TYPE                                               VARCHAR2(7)
VALID_NOW                                          VARCHAR2(16)
VALID_TYPE                                         VARCHAR2(15)
VALID_ROLE                                         VARCHAR2(12)
DB_UNIQUE_NAME                                     VARCHAR2(30)
VERIFY                                             VARCHAR2(3)
COMPRESSION                                        VARCHAR2(7)

SQL> col dest_name for a50
SQL> col destination for a50
SQL> select dest_name, status, destination from v$archive_dest;

DEST_NAME                                          STATUS    DESTINATION
-------------------------------------------------- --------- --------------------------------------------------
LOG_ARCHIVE_DEST_1                                 VALID     /u01/app/oracle/product/11.1.0/db_1/dbs/arch
LOG_ARCHIVE_DEST_2                                 INACTIVE
LOG_ARCHIVE_DEST_3                                 INACTIVE
LOG_ARCHIVE_DEST_4                                 INACTIVE
LOG_ARCHIVE_DEST_5                                 INACTIVE
LOG_ARCHIVE_DEST_6                                 INACTIVE
LOG_ARCHIVE_DEST_7                                 INACTIVE
LOG_ARCHIVE_DEST_8                                 INACTIVE
LOG_ARCHIVE_DEST_9                                 INACTIVE
LOG_ARCHIVE_DEST_10                                VALID     USE_DB_RECOVERY_FILE_DEST

10 rows selected.

SQL>

到相應的目錄下找到時間比較久遠的文件，delete,空間就釋放了，

因為我這裡是測試環境，所以沒有考慮那麼複雜

[oracle@croracle02 dbs]$ df -lh
Filesystem            Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       18G 8.8G 7.8G 54% /
/dev/sda1              99M   12M   82M 13% /boot
tmpfs                1006M 667M 340M 67% /dev/shm
/dev/sdd1             2.0G 843M 1.2G 42% /u02

記錄一下，備忘

expdp實驗

2010-02-19T18:40:00.001-08:00

仰慕expdp,impdp很久，一直沒有動手做過，記錄一下expdp的實驗的內容：

[oracle@localhost ~]$ expdp scott/tiger DIRECTORY=dump_dir dumpfile=emp.dmp tables=emp
Export: Release 10.2.0.1.0 - 64bit Production on 星期六, 27 2月, 2010 7:12:40
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DUMP_DIR is invalid

報錯了

[oracle@localhost ~]$ sqlplus scott/tiger
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 2月 27 07:18:57 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> create directory dump_dir as '/u01';
create directory dump_dir as '/u01'
*
ERROR at line 1:
ORA-01031: insufficient privileges

SQL> conn / as sysdba;
Connected.
SQL> create directory dump_dir as '/u01/dump';
Directory created.
SQL> grant read, write on directory dump_dir to scott;
Grant succeeded.
SQL>

[oracle@localhost ~]$ expdp scott/tiger DIRECTORY=dump_dir dumpfile=emp.dmp tables=emp
Export: Release 10.2.0.1.0 - 64bit Production on 星期六, 27 2月, 2010 7:22:27
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_TABLE_01": scott/******** DIRECTORY=dump_dir dumpfile=emp.dmp tables=emp
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "SCOTT"."EMP" 7.820 KB 14 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
/u01/dump/emp.dmp
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 07:22:49
[oracle@localhost ~]$

[oracle@localhost dump]$ ls
emp.dmp export.log
[oracle@localhost dump]$
[oracle@localhost dump]$ strings emp.dmp |less
<CHARSET>WE8ISO8859P1</CHARSET> //字符集

<NCHARSET
>AL16UTF16</NCHARSET>國家字符集

這個表的數據不大，體現不出來優勢，不過基本上跑過了，呵呵!

春節後的第一貼！

opensolaris(solaris5.11)下如何mount ntfs 格式的usb disk?

2010-01-31T20:44:00.001-08:00

opensolaris mount usb disk
################################################################
root@opensolaris:~/software# wget -c http://www.belenix.org/binfiles/FSWpart.tar.gz
--12:34:27-- http://www.belenix.org/binfiles/FSWpart.tar.gz
           => `FSWpart.tar.gz'
Resolving www.belenix.org... 204.152.191.108
Connecting to www.belenix.org|204.152.191.108|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 34,587 (34K) [application/x-gzip]
100%[====================================>] 34,587        41.66K/s
12:34:28 (41.58 KB/s) - `FSWpart.tar.gz' saved [34587/34587]
root@opensolaris:~/software# ls
FSWpart.tar.gz
root@opensolaris:~/software# gunzip -c FSWpart.tar.gz |tar xvf -
FSWpart/
FSWpart/pkgmap
FSWpart/pkginfo
FSWpart/install/
FSWpart/install/copyright
FSWpart/reloc/
FSWpart/reloc/usr/
FSWpart/reloc/usr/bin/
FSWpart/reloc/usr/bin/prtpart
FSWpart/reloc/usr/bin/prtpart.bin
FSWpart/reloc/usr/share/
FSWpart/reloc/usr/share/src/
FSWpart/reloc/usr/share/src/prtpart.c
root@opensolaris:~/software# ls
FSWpart FSWpart.tar.gz
root@opensolaris:~/software# pkgadd -d . FSWpart
Processing package instance <FSWpart> from </root/software>
x86 Partition Table Dumper(i386) 0.1
#
# Copyright 2006 Sun Microsystems, Inc. All rights reserved.
# Use is subject to license terms.
#
# Author Moinak Ghosh
#
Using </> as the package base directory.
## Processing package information.
## Processing system information.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.
## Checking for setuid/setgid programs.
Installing x86 Partition Table Dumper as <FSWpart>
## Installing part 1 of 1.
/usr/bin/prtpart
/usr/bin/prtpart.bin
/usr/share/src/prtpart.c
[ verifying class <none> ]
Installation of <FSWpart> was successful.
root@opensolaris:~/software#
root@opensolaris:~/software# wget -c http://www.belenix.org/binfiles/FSWfsmisc.tar.gz
--12:37:17-- http://www.belenix.org/binfiles/FSWfsmisc.tar.gz
           => `FSWfsmisc.tar.gz'
Resolving www.belenix.org... 204.152.191.108
Connecting to www.belenix.org|204.152.191.108|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4,286,525 (4.1M) [application/x-gzip]
100%[====================================>] 4,286,525     72.92K/s    ETA 00:00
12:38:03 (91.30 KB/s) - `FSWfsmisc.tar.gz' saved [4286525/4286525]
root@opensolaris:~/software#
root@opensolaris:~/software# gunzip -c FSWfsmisc.tar.gz |tar xvf -
FSWfsmisc/
FSWfsmisc/pkgmap
FSWfsmisc/pkginfo
FSWfsmisc/install/
FSWfsmisc/install/copyright
FSWfsmisc/install/depend
FSWfsmisc/reloc/
FSWfsmisc/reloc/etc/
FSWfsmisc/reloc/etc/gnome-vfs-2.0/
FSWfsmisc/reloc/etc/gnome-vfs-2.0/modules/
FSWfsmisc/reloc/etc/gnome-vfs-2.0/modules/libntfs.conf
FSWfsmisc/reloc/usr/
FSWfsmisc/reloc/usr/bin/
FSWfsmisc/reloc/usr/bin/chattr
FSWfsmisc/reloc/usr/bin/lsattr
FSWfsmisc/reloc/usr/bin/ntfscat
FSWfsmisc/reloc/usr/bin/ntfscluster
FSWfsmisc/reloc/usr/bin/ntfscmp
FSWfsmisc/reloc/usr/bin/ntfsfix
FSWfsmisc/reloc/usr/bin/ntfsinfo
FSWfsmisc/reloc/usr/bin/ntfsls
FSWfsmisc/reloc/usr/bin/uuidgen
FSWfsmisc/reloc/usr/bin/xlsmounts
FSWfsmisc/reloc/usr/bin/xumount
FSWfsmisc/reloc/usr/include/
FSWfsmisc/reloc/usr/include/et/
FSWfsmisc/reloc/usr/include/et/com_err.h
FSWfsmisc/reloc/usr/include/ext2fs/
FSWfsmisc/reloc/usr/include/ext2fs/bitops.h
FSWfsmisc/reloc/usr/include/ext2fs/ext2_err.h
FSWfsmisc/reloc/usr/include/ext2fs/ext2_fs.h
FSWfsmisc/reloc/usr/include/ext2fs/ext2_io.h
FSWfsmisc/reloc/usr/include/ext2fs/ext2_types.h
FSWfsmisc/reloc/usr/include/ext2fs/ext2fs.h
FSWfsmisc/reloc/usr/include/ntfs/
FSWfsmisc/reloc/usr/include/ntfs/attrib.h
FSWfsmisc/reloc/usr/include/ntfs/attrlist.h
FSWfsmisc/reloc/usr/include/ntfs/bitmap.h
FSWfsmisc/reloc/usr/include/ntfs/bootsect.h
FSWfsmisc/reloc/usr/include/ntfs/collate.h
FSWfsmisc/reloc/usr/include/ntfs/compat.h
FSWfsmisc/reloc/usr/include/ntfs/compress.h
FSWfsmisc/reloc/usr/include/ntfs/debug.h
FSWfsmisc/reloc/usr/include/ntfs/device.h
FSWfsmisc/reloc/usr/include/ntfs/device_io.h
FSWfsmisc/reloc/usr/include/ntfs/dir.h
FSWfsmisc/reloc/usr/include/ntfs/endians.h
FSWfsmisc/reloc/usr/include/ntfs/gnome-vfs-method.h
FSWfsmisc/reloc/usr/include/ntfs/gnome-vfs-module.h
FSWfsmisc/reloc/usr/include/ntfs/index.h
FSWfsmisc/reloc/usr/include/ntfs/inode.h
FSWfsmisc/reloc/usr/include/ntfs/layout.h
FSWfsmisc/reloc/usr/include/ntfs/lcnalloc.h
FSWfsmisc/reloc/usr/include/ntfs/list.h
FSWfsmisc/reloc/usr/include/ntfs/logfile.h
FSWfsmisc/reloc/usr/include/ntfs/logging.h
FSWfsmisc/reloc/usr/include/ntfs/mft.h
FSWfsmisc/reloc/usr/include/ntfs/mst.h
FSWfsmisc/reloc/usr/include/ntfs/ntfstime.h
FSWfsmisc/reloc/usr/include/ntfs/rich.h
FSWfsmisc/reloc/usr/include/ntfs/runlist.h
FSWfsmisc/reloc/usr/include/ntfs/security.h
FSWfsmisc/reloc/usr/include/ntfs/support.h
FSWfsmisc/reloc/usr/include/ntfs/tree.h
FSWfsmisc/reloc/usr/include/ntfs/types.h
FSWfsmisc/reloc/usr/include/ntfs/unistr.h
FSWfsmisc/reloc/usr/include/ntfs/version.h
FSWfsmisc/reloc/usr/include/ntfs/volume.h
FSWfsmisc/reloc/usr/info/
FSWfsmisc/reloc/usr/info/libext2fs.info.gz
FSWfsmisc/reloc/usr/lib/
FSWfsmisc/reloc/usr/lib/e2initrd_helper
FSWfsmisc/reloc/usr/lib/fs/
FSWfsmisc/reloc/usr/lib/fs/ext2fs/
FSWfsmisc/reloc/usr/lib/fs/ext2fs/mount
FSWfsmisc/reloc/usr/lib/fs/ntfs/
FSWfsmisc/reloc/usr/lib/fs/ntfs/mount
FSWfsmisc/reloc/usr/lib/gnome-vfs-2.0/
FSWfsmisc/reloc/usr/lib/gnome-vfs-2.0/modules/
FSWfsmisc/reloc/usr/lib/gnome-vfs-2.0/modules/libntfs-gnomevfs.a
FSWfsmisc/reloc/usr/lib/gnome-vfs-2.0/modules/libntfs-gnomevfs.la
FSWfsmisc/reloc/usr/lib/gnome-vfs-2.0/modules/libntfs-gnomevfs.so.1.0.0
FSWfsmisc/reloc/usr/lib/libcom_err.a
FSWfsmisc/reloc/usr/lib/libext2fs.a
FSWfsmisc/reloc/usr/lib/libntfs.la
FSWfsmisc/reloc/usr/lib/libntfs.so.9.0.0
FSWfsmisc/reloc/usr/sbin/
FSWfsmisc/reloc/usr/sbin/badblocks
FSWfsmisc/reloc/usr/sbin/blkid
FSWfsmisc/reloc/usr/sbin/debugfs
FSWfsmisc/reloc/usr/sbin/dumpe2fs
FSWfsmisc/reloc/usr/sbin/e2fsck
FSWfsmisc/reloc/usr/sbin/e2image
FSWfsmisc/reloc/usr/sbin/e2label
FSWfsmisc/reloc/usr/sbin/filefrag
FSWfsmisc/reloc/usr/sbin/findfs
FSWfsmisc/reloc/usr/sbin/fsck.ext2
FSWfsmisc/reloc/usr/sbin/fsck.ext3
FSWfsmisc/reloc/usr/sbin/logsave
FSWfsmisc/reloc/usr/sbin/mke2fs
FSWfsmisc/reloc/usr/sbin/mkfs.ext2
FSWfsmisc/reloc/usr/sbin/mkfs.ext3
FSWfsmisc/reloc/usr/sbin/mklost+found
FSWfsmisc/reloc/usr/sbin/mkntfs
FSWfsmisc/reloc/usr/sbin/ntfsclone
FSWfsmisc/reloc/usr/sbin/ntfscp
FSWfsmisc/reloc/usr/sbin/ntfslabel
FSWfsmisc/reloc/usr/sbin/ntfsresize
FSWfsmisc/reloc/usr/sbin/ntfsundelete
FSWfsmisc/reloc/usr/sbin/tune2fs
FSWfsmisc/reloc/usr/share/
FSWfsmisc/reloc/usr/share/locale/
FSWfsmisc/reloc/usr/share/locale/cs/
FSWfsmisc/reloc/usr/share/locale/cs/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/cs/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/de/
FSWfsmisc/reloc/usr/share/locale/de/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/de/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/es/
FSWfsmisc/reloc/usr/share/locale/es/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/es/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/fr/
FSWfsmisc/reloc/usr/share/locale/fr/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/fr/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/it/
FSWfsmisc/reloc/usr/share/locale/it/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/it/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/nl/
FSWfsmisc/reloc/usr/share/locale/nl/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/nl/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/pl/
FSWfsmisc/reloc/usr/share/locale/pl/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/pl/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/rw/
FSWfsmisc/reloc/usr/share/locale/rw/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/rw/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/sv/
FSWfsmisc/reloc/usr/share/locale/sv/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/sv/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/locale/tr/
FSWfsmisc/reloc/usr/share/locale/tr/LC_MESSAGES/
FSWfsmisc/reloc/usr/share/locale/tr/LC_MESSAGES/e2fsprogs.mo
FSWfsmisc/reloc/usr/share/man/
FSWfsmisc/reloc/usr/share/man/man1/
FSWfsmisc/reloc/usr/share/man/man1/chattr.1
FSWfsmisc/reloc/usr/share/man/man1/lsattr.1
FSWfsmisc/reloc/usr/share/man/man1/uuidgen.1
FSWfsmisc/reloc/usr/share/man/man5/
FSWfsmisc/reloc/usr/share/man/man5/e2fsck.conf.5
FSWfsmisc/reloc/usr/share/man/man5/mke2fs.conf.5
FSWfsmisc/reloc/usr/share/man/man8/
FSWfsmisc/reloc/usr/share/man/man8/badblocks.8
FSWfsmisc/reloc/usr/share/man/man8/blkid.8
FSWfsmisc/reloc/usr/share/man/man8/debugfs.8
FSWfsmisc/reloc/usr/share/man/man8/dumpe2fs.8
FSWfsmisc/reloc/usr/share/man/man8/e2fsck.8
FSWfsmisc/reloc/usr/share/man/man8/e2image.8
FSWfsmisc/reloc/usr/share/man/man8/e2label.8
FSWfsmisc/reloc/usr/share/man/man8/filefrag.8
FSWfsmisc/reloc/usr/share/man/man8/findfs.8
FSWfsmisc/reloc/usr/share/man/man8/fsck.ext2.8
FSWfsmisc/reloc/usr/share/man/man8/fsck.ext3.8
FSWfsmisc/reloc/usr/share/man/man8/libntfs-gnomevfs.8
FSWfsmisc/reloc/usr/share/man/man8/logsave.8
FSWfsmisc/reloc/usr/share/man/man8/mke2fs.8
FSWfsmisc/reloc/usr/share/man/man8/mkfs.ext2.8
FSWfsmisc/reloc/usr/share/man/man8/mkfs.ext3.8
FSWfsmisc/reloc/usr/share/man/man8/mklost+found.8
FSWfsmisc/reloc/usr/share/man/man8/mkntfs.8
FSWfsmisc/reloc/usr/share/man/man8/ntfscat.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsclone.8
FSWfsmisc/reloc/usr/share/man/man8/ntfscluster.8
FSWfsmisc/reloc/usr/share/man/man8/ntfscmp.8
FSWfsmisc/reloc/usr/share/man/man8/ntfscp.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsfix.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsinfo.8
FSWfsmisc/reloc/usr/share/man/man8/ntfslabel.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsls.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsmount.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsprogs.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsresize.8
FSWfsmisc/reloc/usr/share/man/man8/ntfsundelete.8
FSWfsmisc/reloc/usr/share/man/man8/tune2fs.8
root@opensolaris:~/software#
root@opensolaris:~/software# pkgadd -d . FSWfsmisc
root@opensolaris:~/software# rmformat -l
Looking for devices...
     1. Logical Node: /dev/rdsk/c10t0d0p0
        Physical Node: /pci@0,0/pci1458,5006@1d,7/storage@1/disk@0,0
        Connected Device: ST350032 0NS
        Device Type: Removable
        Bus: USB
        Size: 476.9 GB
        Label: <Unknown>
        Access permissions: Medium is not write protected.
     2. Logical Node: /dev/rdsk/c7t0d0p0
        Physical Node: /pci@0,0/pci-ide@1f,2/ide@1/sd@0,0
        Connected Device: PIONEER DVD-RW DVR-212 1.24
        Device Type: DVD Reader/Writer
        Bus: IDE
        Size: <Unknown>
        Label: <Unknown>
        Access permissions: <Unknown>
root@opensolaris:~/software# mount -F ntfs /dev/rdsk/c10t0d0p0 /rmdisk/
root@opensolaris:~/software#
root@opensolaris:~/software# cd /rmdisk/
root@opensolaris:/rmdisk# ls
admin a.txt now System Volume Information three www1 www2
root@opensolaris:/rmdisk#
成功了！
http://blogs.sun.com/mandalika/entry/mounting_windows_ntfs_on_open

疑似ARP attack 常用的cmd

2010-01-31T18:54:00.001-08:00

arp attack原理很簡單，主要是利用arp protocol的弱點，我的理解是，攻擊的機器可以主動申請被攻擊的機器修改自己的 arp cache table, 問題就在這裡，所以，所有的攻擊和反攻擊也是圍繞它來進行

arp 的命令

[~~root@TEST2 ~]#~~ arp #主要是查詢本機內的arp cache table
Address                  HWtype HWaddress           Flags Mask            Iface
server.aaa.com       ether   00:AA:BB:CC:DD:2C   C                     eth0
172.16.1.67              ether   00:1E:4F:C8:66:08   C                     eth0

如何獲得所有的本段的MAC呢？

發起一個廣播

ping –b <ip段>

例如

[root@CRRACTEST2 ~]# ping -b 172.16.1.255
WARNING: pinging broadcast address
PING 172.16.1.255 (172.16.1.255) 56(84) bytes of data.
64 bytes from 172.16.1.68: icmp_seq=1 ttl=64 time=0.320 ms
64 bytes from 172.16.1.124: icmp_seq=1 ttl=64 time=0.326 ms (DUP!)
64 bytes from 172.16.1.112: icmp_seq=1 ttl=64 time=0.501 ms (DUP!)
64 bytes from 172.16.1.17: icmp_seq=1 ttl=64 time=0.506 ms (DUP!)
64 bytes from 172.16.1.83: icmp_seq=1 ttl=64 time=0.530 ms (DUP!)
64 bytes from 172.16.1.31: icmp_seq=1 ttl=255 time=0.553 ms (DUP!)
64 bytes from 172.16.1.25: icmp_seq=1 ttl=64 time=1.12 ms (DUP!)
64 bytes from 172.16.1.200: icmp_seq=1 ttl=64 time=1.45 ms (DUP!)
64 bytes from 172.16.1.254: icmp_seq=1 ttl=64 time=2.46 ms (DUP!)
64 bytes from 172.16.1.250: icmp_seq=1 ttl=64 time=6.71 ms (DUP!)

…

目的是獲得(更新）arp cache table <IP MAC>

[root@CRRACTEST2 ~]# arp
Address                  HWtype HWaddress           Flags Mask            Iface
172.16.1.25              ether   00:15:C7:8F:B6:D0   C                     eth0
172.16.1.67              ether   00:1E:5F:C6:44:08   C                     eth0
172.16.1.83              ether   00:0C:40:72:D4:21   C                     eth0
[root@CRRACTEST2 ~]#

如何根據MAC獲取IP呢？

arp -n |grep EC:4F |awk '{print $1}'

nmap -sP 172.16.1.0/24 |grep arp -n |grep EC:6F |awk '{print $1}'

[root@test ~]# rpm -Uvh fping-2.4-1.b2.2.el5.rf.x86_64.rpm
warning: fping-2.4-1.b2.2.el5.rf.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 6b8d79e6
Preparing... ########################################### [100%]
1:fping ########################################### [100%]

fping -v
fping: Version 2.4b2_to_ipv6 $Date: 2002/01/16 00:33:42 $
fping: comments to david@remote.net
fping -c 1 -g 172.16.1.0/24

如果發現arp cache table中發現2個ip對應MAC相同，或者 gatway的不是缺省設定的，就有要引起懷疑了

另外，在gatway 的設定時儘量不要使用192.168.*.1 or 172.16.*.1類似的 IP地址，而是使用 *.2 這樣也可以繞過一些attack tool

CRS-0184: Cannot communicate with the CRS daemon. 的處理

2010-01-31T18:05:00.001-08:00

有一段時間沒有用RAC的測試環境了，重新啟動後，發現報錯了

~~[oracle@oracle01~~ ~]$ crs_stat -t
CRS-0184: Cannot communicate with the CRS daemon.

我記得itpub上有人處理過類似的問題，今天終於有機會實踐一把了

在/var/tmp/有一個.oracle目錄

將這個目錄中的東西清空

rm –rf *

然後在root用戶下啟動crs

crsctl start crs

等待一段時間發現還是沒有辦法帶動起來crs全部的services

[~~oracle@oracle01~~ ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    OFFLINE
ora....01.lsnr application    ONLINE    OFFLINE
ora....e01.gsd application    ONLINE    OFFLINE
ora....e01.ons application    ONLINE    OFFLINE
ora....e01.vip application    ONLINE    OFFLINE
ora....SM2.asm application    ONLINE    ONLINE    croracle02
ora....02.lsnr application    ONLINE    ONLINE    croracle02
ora....02.lsnr application    ONLINE    OFFLINE
ora....e02.gsd application    ONLINE    OFFLINE
ora....e02.ons application    ONLINE    ONLINE    croracle02
ora....e02.vip application    ONLINE    ONLINE    croracle02
ora....SM3.asm application    ONLINE    OFFLINE
ora....03.lsnr application    ONLINE    OFFLINE
ora....e03.gsd application    ONLINE    OFFLINE
ora....e03.ons application    ONLINE    OFFLINE
ora....e03.vip application    ONLINE    OFFLINE
ora....SM4.asm application    ONLINE    OFFLINE
ora....04.lsnr application    ONLINE    OFFLINE
ora....e04.gsd application    ONLINE    OFFLINE
ora....e04.ons application    ONLINE    OFFLINE
ora....e04.vip application    ONLINE    OFFLINE
ora....02.inst application    ONLINE    OFFLINE
ora....d1.inst application    ONLINE    OFFLINE
ora....d3.inst application    ONLINE    OFFLINE
ora....d4.inst application    ONLINE    OFFLINE
ora.crprod.db application    ONLINE    OFFLINE

看到之後oracle02 這個node的服務啟動了

沒有辦法重新啟動服務器（我的是vmware 呵呵）

reboot後正常

[~~oracle@oracle01~~ ~]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    croracle01
ora....01.lsnr application    ONLINE    ONLINE    croracle01
ora....e01.gsd application    ONLINE    ONLINE    croracle01
ora....e01.ons application    ONLINE    ONLINE    croracle01
ora....e01.vip application    ONLINE    ONLINE    croracle01
ora....SM2.asm application    ONLINE    ONLINE    croracle02
ora....02.lsnr application    ONLINE    ONLINE    croracle02
ora....02.lsnr application    ONLINE    OFFLINE
ora....e02.gsd application    ONLINE    ONLINE    croracle02
ora....e02.ons application    ONLINE    ONLINE    croracle02
ora....e02.vip application    ONLINE    ONLINE    croracle02
ora....SM3.asm application    ONLINE    OFFLINE
ora....03.lsnr application    ONLINE    OFFLINE
ora....e03.gsd application    ONLINE    OFFLINE
ora....e03.ons application    ONLINE    OFFLINE
ora....e03.vip application    ONLINE    ONLINE    croracle01
ora....SM4.asm application    ONLINE    OFFLINE
ora....04.lsnr application    ONLINE    OFFLINE
ora....e04.gsd application    ONLINE    OFFLINE
ora....e04.ons application    ONLINE    OFFLINE
ora....e04.vip application    ONLINE    ONLINE    croracle02
ora....02.inst application    ONLINE    ONLINE    croracle02
ora....d1.inst application    ONLINE    ONLINE    croracle01
ora....d3.inst application    ONLINE    OFFLINE
ora....d4.inst application    ONLINE    OFFLINE
ora.crprod.db application    ONLINE    ONLINE    croracle02
[oracle@croracle01 ~]$

[~~oracle@oracle01~~ ~]$ sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Feb 3 01:50:41 2010

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select * from v$active_instances;

INST_NUMBER
-----------
INST_NAME
--------------------------------------------------------------------------------
1
croracle01.localdomain:crprod1

2
croracle02.localdomain:croracle02

SQL>

看來reboot對oracle也是好使的！

RedHat Linux NFS server and solaris NFS client 實驗

2010-01-22T17:59:00.001-08:00

臨時需要將一個老舊的Solaris2.7上面的數據備份出來，但是這個Sun的server不支持USB,如何處理呢？

想了一個辦法NFS, NFS是sun開發的，估計應該支持，所以找了一個RedHat的server做個NFS server, 這個Solaris nfs方式mount上去

參考鳥哥的nfs server的設定：

RedHat端：

[oracle@oracle03 mnt_usb]$ cat /etc/exports
/mnt_usb *(rw,no_root_squash)
[oracle@oracle03 mnt_usb]$

/mnt_usb是server機器的一個目錄文件

對任何機器都開放

當然前提是server端已經安裝了nfs server的軟件：

/etc/init.d/portmap restart
/etc/init.d/nfs start

驗證：
netstat –ultn

netstat -ultn |grep 111

netstat -ultn |grep 2049

rpcinfo -p localhost

因為沒有設置防火牆，所以沒有安全方面的問題，如果你有，自己檢查一下

如果上述都正常，成功一半了

另一半在Soaris這裡

相對簡單：

root權限

建立一個目錄作為mount的節點：

# mkdir /backup

# mount -F nfs -o rw 172.16.12.24:/mnt_usb /backup

如果沒有報錯就說明成功了！

做一個備份的測試

test>tar cvf - ivantest |gzip -c >/backup/www1/ivantest.tar.gz
ivantest/
ivantest/a.txt
test>

沒有問題，從server哪裡可以看到，解壓也成功了

Awk處理根據行處理文本的例子

2010-01-21T19:12:00.001-08:00

現有一個測試文本

a.txt

107542 A000904
104005 A000426
64636 A000347
54304 A000900
52480 A000901
34814 A000930
14346 A000562
10239 A000929
   9821 A000782
8515 A000417
   7161 A000599
   6961 A000813
   6845 A000422
   5676 A000092
   5329 A000685
   5288 A000547
   4939 A000834
   4829 A000903
   4804 A000011
   4245 A000010
   4161 A000302
   3831 A000550

如何取行號>10的呢？

[root@~~test~~ tmp]# awk 'NR > 10 {print $1 "----" $2}' a.txt >/tmp/b.txt

查看b.txt的文本

b.txt
------------
7161----A000599
6961----A000813
6845----A000422
5676----A000092
5329----A000685
5288----A000547
4939----A000834
4829----A000903
4804----A000011
4245----A000010
4161----A000302
3831----A000550

如何取行號<10的呢？

[root@~~test~~ tmp]# awk 'NR < 10 {print $1 "----" $2}' a.txt >/tmp/c.txt

c.txt
107542----A000904
104005----A000426
64636----A000347
54304----A000900
52480----A000901
34814----A000930
14346----A000562
10239----A000929
9821----A000782

第10行是什麼呢？

10 8515 A000417

[root@~~test~~ tmp]# awk 'NR <= 10 {print $1 "----" $2}' a.txt >/tmp/d.txt
[root@CRRACTEST tmp]# cat d.txt
107542----A000904
104005----A000426
64636----A000347
54304----A000900
52480----A000901
34814----A000930
14346----A000562
10239----A000929
9821----A000782
8515----A000417
[root@~~test~~ tmp]#

記錄一下，這個腳本對於大文本處理相當有用！

帕肯森定律（Parkinson’sLaw）

2010-01-14T20:19:00.001-08:00

工作总是拖延到它所能够允许最迟完成的那一天 .

(Work expands to fit the allotted time. )

學習，自勉！

Oracle tuning goals and techniques

2010-01-14T01:38:00.001-08:00

oracle 9i tuning 教程总结的，不错，记录一下

tuning goals（主要是data buffer cache部分的） :
--servers find data in memory //数据尽量放在内存中
-- no waits on the buffer cache //buffer cache上不要发生wait events
. Diagnostic measures
--wait events //等待事件
--Cache hit ratio //命中率
-- the v$db_cache_advice view //data buffer的建议
. tuning techniques
--reduce the number of blocks requires by sql //sql尽量做到精确
--increase buffer cache size // buffer cache的大小很重要
--use multiple buffer pools //为不同性质的sql使用不同的buffer pool
-- cache tables //将小表放在内存中
-- bypass the cache for sorting and paralled reads. //绕过排序和并发读

solaris 10 自身帶gcc make

2010-01-11T00:04:00.001-08:00

嘗試在solaris10下編譯apache, 儘管已經下載了gcc但是還是不能通過

報錯“make: can not found”

手工運行一把，確實如此，怎麼辦呢？google

發現soalris下確實已經有了gcc和make的program,但是位置沒有在/usr/bin or /sbin/下

gcc 在這裏：

bash-3.00# cd /usr/sfw/bin

bash-3.00# ./gcc -v
Reading specs from /usr/sfw/lib/gcc/sparc-sun-solaris2.10/3.4.3/specs
Configured with: /sfw10/builds/build/sfw10-patch/usr/src/cmd/gcc/gcc-3.4.3/configure --prefix=/usr/sfw --with-as=/usr/ccs/bin/as --without-gnu-as --with-ld=/usr/ccs/bin/ld --without-gnu-ld --enable-languages=c,c++ --enable-shared
Thread model: posix
gcc version 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
bash-3.00#

bash-3.00# cd /usr/ccs/bin

bash-3.00# ./make
make: Fatal error: No arguments to build

不熟悉solaris，發現沒有default home directory, 只好把加載到 /etc/profile文件中

…

PATH=$PATH:/usr/ccs/bin:/usr/sfw/bin
export PATH

…

從新configure;make ;make install

+--------------------------------------------------------+
| You now have successfully built and installed the      |
| Apache 1.3 HTTP server. To verify that Apache actually |
| works correctly you now should first check the         |
| (initially created or preserved) configuration files   |
|                                                        |
|   /user/local/apache/conf/httpd.conf
|                                                        |
| and then you should be able to immediately fire up     |
| Apache the first time by running:                      |
|                                                        |
|   /user/local/apache/bin/apachectl start
|                                                        |
| Thanks for using Apache.       The Apache Group        |
|                                http://www.apache.org/ |
+--------------------------------------------------------+

ok, 記錄一下，備忘！

Solaris 10 上如何安裝c/c++ 等的compilers？

2010-01-10T17:41:00.001-08:00

最近在公司整理一個sun 450的服務器，從新安裝solaris 10, 居然可以成功的安裝10年前的Server，進而想會不會有編譯環境呢？

gcc了一下沒有，我愛想在上面做的開發啥的，怎麼辦呢？google

發現sun 免費發放gcc的compliers

https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_SMI-Site/en_US/-/USD/ViewProductDetail-Start?ProductRef=GCC-4.2.1-G-F@CDS-CDS_SMI

安裝說明參考

http://cooltools.sunsource.net/gcc/4.2.0/install.html

我的實驗：

bash-3.00# ls
SUNW0scgfss421.tar.bz2 SUNWgccfss421.tar.bz2
bash-3.00# /bin/bunzip2 -c SUNWgccfss421.tar.bz2 |/bin/tar xf -
bash-3.00# /bin/bunzip2 -c SUNW0scgfss421.tar.bz2 |/bin/tar xf -

bash-3.00# pwd
/usr/local/gcc/bin
bash-3.00# ls
ats                              gccbug
bit                              gcov
c++                              sparc-sun-solaris2.10-c++
cpp                              sparc-sun-solaris2.10-g++
discover                         sparc-sun-solaris2.10-gcc
g++                              sparc-sun-solaris2.10-gcc-4.2.1
gcc
bash-3.00#

bash-3.00# ./gcc
gcc: no input files
bash-3.00#

參考Advanced Programming in the UNIX 2ed

寫個小例子測試一下：

bash-3.00# cat test.c
#include<stdio.h>
#include<dirent.h>

int main(int argc, char *argv[])
{
DIR *dp;
struct dirent *dirp;

        if(argc != 2)
        {
                printf("usage: ls directory_name \n");
                return 1;
        }

if((dp = opendir(argv[1]))== NULL)
printf("can't open %s", argv[1]);

while((dirp = readdir(dp)) !=NULL)
printf("%s \n", dirp->d_name);

        closedir(dp);
        //exit(0);
        return 0;
}
bash-3.00#

bash-3.00# /usr/local/gcc/bin/gcc -o test test.c
bash-3.00#

bash-3.00# ./test
usage: ls directory_name
bash-3.00# ./test .
.
..
test.c
test.o
test
core
bash-3.00#

貌似可以了，記錄一下備忘！

Oracle - statspack報告中的 log file sync是意義？

2010-01-08T18:16:00.001-08:00

官方文檔中：

redo synch time

The elapsed time of all redo sync writes calls in 10s of milliseconds.

redo sync writes

Usually, redo that is generated and copied into the log buffer need not be flushed out to disk immediately. The log buffer is a circular buffer that LGWR periodically flushes. Redo sync writes increments when changes being applied must be written out to disk due to a commit.

參考eygle的文章：

----------------------------------------------------------------------------

.等待事件

Event                               Waits   Timeouts  Time (cs)    (ms)   /txn
---------------------------- ------------ ---------- ----------- ------ ------
log file sync                      14,466          2       4,150      3    1.0
db file sequential read            17,202          0       2,869      2    1.2
latch free                         24,841     13,489       2,072      1    1.7 
direct path write                     121          0       1,455    120    0.0
db file parallel write              1,314          0       1,383     11    0.1
log file sequential read            1,540          0          63      0    0.1
....
log file switch completion              1          0           3     30    0.0
refresh controlfile command            23          0           1      0    0.0
LGWR wait for redo copy                46          0           0      0    0.0
....
log file single write                   4          0           0      0    0.0

我们看到，这里log file sync和db file parallel write等待同时出现了.

显然log file sync在等待db file parallel write的完成.

这里磁盘IO肯定存在了瓶颈，实际用户的redo和数据文件同时存放在Raid的磁盘上，存在性能问题.

需要调整.

---------------------------------------------------

我猜測的是redo log file 所在的physical disk 有問題,或者io的問題,大體上沒有猜錯。

但是看了一下eygle的文章2004年的，差距啊

準備仔細研究一下statspack!

參考：

http://www.eygle.com/statspack/statspack14-LogFileSync.htm

(RedHat, CentOS,OEL)手動清理memory的實驗

2009-12-30T23:20:00.001-08:00

環境是CentOS5.2

[root@~~test~~ ~]# free –m
                        total       used       free     shared    buffers     cached
Mem:         15721      14056       1664          0        533      11283
-/+ buffers/cache:       2239      13481
Swap:        16386          0      16386
[root@test ~]# sync;sync;sync
[root@test~]# echo 3 > /proc/sys/vm/drop_caches
[root@test~]# free –m
                      total       used       free     shared    buffers     cached
Mem:         15721       1837      13883          0          0         44
-/+ buffers/cache:       1792      13928
Swap:        16386          0      16386
[root@LITHIUM ~]#

explain:

Writing to this file causes the kernel to drop clean caches,
dentries and inodes from memory, causing that memory to become
free.

To free pagecache, use echo 1 > /proc/sys/vm/drop_caches;

to free dentries and inodes, use echo 2 > /proc/sys/vm/drop_caches;
to free pagecache, dentries and inodes, use echo 3 > /proc/sys/vm/drop_caches.

Because this is a non-destructive operation and dirty objects
are not freeable, the user should run sync(8) first.

2009年終總結

2009-12-30T22:16:00.001-08:00

1. 考過ocp(10g,11g)

2.考過oce(RAC expert)

3.學習了一門新的開發語言Python

4.嘗試iPhone的開發（Objective-C)

期望來年：

1. 再次嘗試一下Cissp

2. 嘗試pmp

3. Oracle 技術進一步深化

4. *nix技術進一步深化

5. 嘗試在英語上能進步一些

6.繼續在學習方法上總結

感謝家人，感謝朋友的支持。

學習compare NSSTring Objects

2009-12-21T18:11:00.001-08:00

在Objective-C和COCOA 如何比較兩個NSString 類型的字串是否相等呢?
第一個想到的是"==",但是這個不正確,應該是 isEqualToString

NSString *str1 = @"Homebrew";
NSString *str2 = @"Homebrew";

if(str1 == str2)
{
NSLog(@"str1 equals str2");
}else{
NSLog(@"Str1 does not equal str2");
}

NSLog(@"str1 address in memory : %p", str1);
NSLog(@"str2 address in memory : %p", str2);

char * cStr = "Homebrew";
NSString *str3 = [NSString stringWithUTF8String:cStr];
NSString *str4 = @"Homebrew";

if(str3 == str4)
{
NSLog(@"str3 equals to str4");
}
else{
NSLog(@"str3 does not equals to str4");
}

NSLog(@"str3 address in memory is %p", str3);
NSLog(@"str4 address in memory is %p", str4);

if([str3 isEqualToString: str4])
{
NSLog(@"str3 equals str4");
}else{
NSLog(@"str3 does not equal str4");
}

結果:
[Session started at 2009-12-22 09:58:59 +0800.]
2009-12-22 09:58:59.699 Movie_Player2[34747:10b] str1 equals str2
2009-12-22 09:58:59.710 Movie_Player2[34747:10b] str1 address in memory : 0x2030
2009-12-22 09:58:59.710 Movie_Player2[34747:10b] str2 address in memory : 0x2030
2009-12-22 09:58:59.711 Movie_Player2[34747:10b] str3 does not equals to str4
2009-12-22 09:58:59.711 Movie_Player2[34747:10b] str3 address in memory is 0x105bc0
2009-12-22 09:58:59.712 Movie_Player2[34747:10b] str4 address in memory is 0x2030
2009-12-22 09:58:59.713 Movie_Player2[34747:10b] str3 equals str4

The Debugger has exited with status 0.

參考解釋是:
The reason this works is that the complier can manage strings internally when you define them using the shortcut method(@"stringhere") and will store only one reference internally to duplicates.
You can verify that the strings refer to the same content by looking at the locations in memory where the variables are stored.

The Correct way to compare Strings
the right way to go about this is use the isEqualToString: method in the NSString class

ref:http://iphonedevelopertips.com/cocoa/compare-nsstrings-objects.html

如何正常關閉mysql

2009-12-17T22:29:00.001-08:00

一直以來都是比較野蠻的kill –9 or killall 掉mysqld的進程，終於找到一個可以說的過去的辦法就是 mysql.server stop

[root@localhost mysql]# ./mysql.server
Usage: ./mysql.server {start|stop|restart|reload|force-reload|status} [ MySQL server options ]
[root@localhost mysql]#

位置在

[root@localhost mysql]# pwd
/usr/local/mysql/share/mysql

我這裏是根據原代碼編譯的，”/user/local/mysql” 是default的目錄

參考mysql documents：

“

5.1.4. mysql.server：MySQL服务器启动脚本

在Unix中的MySQL分发版包括mysql.server脚本。它可以用于使用System V-style运行目录来启动和停止系统服务的系统，例如Linux和Solaris。它还用于MySQL的Mac OS X Startup Item。

mysql.server位于MySQL源码树MySQL安装目录下的support-files目录中。

如果你使用Linux 服务器RPM软件包(MySQL-server-VERSION.rpm)，mysql.server脚本将安装到/etc/init.d目录下，名为mysql。你不需要手动安装。关于Linux RPM软件包的详细信息参见2.4节，“在Linux下安装MySQL”。

一些卖方提供的RPM软件包安装的启动脚本用其它名，例如mysqld。

如果你从不自动安装mysql.server的源码分发版或二进制分发版格式安装MySQL，也可以手动安装。相关说明参见2.9.2.2节，“自动启动和停止MySQL”。

mysql.server从 [mysql.server]和选项文件的[mysqld]部分读取选项。(为了保证向后兼容性，它还读取 [safe_mysqld]部分，尽管在MySQL 5.1安装中你应将这部分重新命名为[mysqld_safe]）。

”

ref: http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#mysql-server

看了一下確實是script, 學習！

mysqlimport and load data 實驗

2009-12-14T18:52:00.001-08:00

測試數據：

[~~root@aaaa~~ ~]# cat empl
title,name,nick,tel
ivan,ivanyao,ivan,123
ivan2,ivanyao2,ivan2,123
ivan3,ivanyao3,ivan3,123
ivan4,ivanyao4,ivan4,123
ivan5,ivanyao5,ivan5,123

建表：

mysqlimport實驗：

[~~root@aaaa~~ ~]# mysqlimport --local --fields-terminated-by=',' 'db' 'empl' db.empl: Records: 6 Deleted: 0 Skipped: 0 Warnings: 0
[~~root@aaaa~~ ~]# mysqlimport --local --fields-terminated-by=',' db empl
db.empl: Records: 6 Deleted: 0 Skipped: 0 Warnings: 0

這裏這個--local很重要，不加會報錯,類似：

[~~root@aaaa~~ ~]# mysqlimport --fields-terminated-by=',' db empl
mysqlimport: Error: File '/var/lib/mysql/db/empl' not found (Errcode: 2), when using table: empl

Load data實驗：

mysql> load data local infile '/root/empl' into table empl fields terminated by ',' ignore 1 lines;
Query OK, 5 rows affected (0.00 sec)
Records: 5 Deleted: 0 Skipped: 0 Warnings: 0

記錄一下，備忘！

SP2-0618: Cannot find the Session Identifier. 问题

2009-12-13T22:54:00.001-08:00

在oracle11g下面做一个实验的时候发现包这个错：

SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report

google 发现当前用户权限不够

SQL> grant all on plan_table to u2;

Grant succeeded.

SQL> grant select any dictionary to u2;

Grant succeeded.

再次执行，ok

SQL> set autotrace on

SQL> set timing on
SQL> select owner, count(*) from my_all_objects group by owner;

OWNER                            COUNT(*)
------------------------------ ----------
WKSYS                                 840
MDSYS                                4896
WK_TEST                                36
U2                                    192
PUBLIC                             160218
CTXSYS                                534
OLAPSYS                              1056
SYSTEM                                 54
EXFSYS                                480
ORDSYS                              12606
ORDPLUGINS                             30

OWNER                            COUNT(*)
------------------------------ ----------
XDB                                  1212
FLOWS_030000                          942
SYS                                139512
WMSYS                                 702

15 rows selected.

Elapsed: 00:00:00.22

Execution Plan
----------------------------------------------------------
Plan hash value: 2509106709

--------------------------------------------------------------------------------
------------------

--------------------------------------------------------------------------------
------------------

| 0 | SELECT STATEMENT | | 15 | 90 | 1371
(3)| 00:00:17 |

| 2 | HASH GROUP BY | | 15 | 90 | 1371
(3)| 00:00:17 |

| 3 | TABLE ACCESS FULL| MY_ALL_OBJECTS | 323K| 1894K| 1348
(1)| 00:00:17 |

--------------------------------------------------------------------------------
------------------

Result Cache Information (identified by operation id):
------------------------------------------------------

1 - column-count=2; dependencies=(U2.MY_ALL_OBJECTS); parameters=(nls); name=
"select owner, count(*) from my_all_objects group by owner"

Statistics
----------------------------------------------------------
          1 recursive calls
          0 db block gets
       4869 consistent gets
          0 physical reads
        116 redo size
        863 bytes sent via SQL*Net to client
        524 bytes received via SQL*Net from client
          2 SQL*Net roundtrips to/from client
          0 sorts (memory)
          0 sorts (disk)
         15 rows processed

SQL>

看来在oracle 11g中不用再使用($ORACLE_HOME/sqlplus/admin/plustrce.sql)脚本创建 plustrace了

记录一下。

web tools httprint

2009-12-09T21:28:00.001-08:00

做web一般都比較關注webserver的選型情況，但是有些server做的比較好屏蔽了server的信息，如何處理呢

一個不錯的工具httprint http://www.net-square.com/httprint/

有windows, linux, mac 版本

基於windows版本的測試截圖：

注意有時候有些網站關閉了ICMP,這個會影響測試結果

在Options的選項中，將之去掉即可

記錄一下備忘！

參考：http://net-square.com/httprint/httprint_paper.html

smbclient RHEL 5 mount cmd變化了

2009-12-07T20:20:00.001-08:00

從linux下mount windows下的共享文件：

smbclient在RHEL <=4

這種形式

# mount -t smbfs -o username=test,password=testpass //ntserver/download /mnt/ntserver

在RHEL 5以後變成了

# mount -t cifs //ntserver/download -o username=test,password=testpass /mnt/ntserver

記錄一下，自動mount修改 /etc/fstab

//ntserver/download /mnt/ntserver smbfs username=test,password=testpass 0 0

//ntserver/download /mnt/ntserver cifs user,uid=500,rw,suid,username=test,password=testpass 0 0

更安全一點的辦法

//winbox/getme /mnt/win cifs user,uid=500,rw,noauto,suid,credentials=/root/secret.txt 0 0

And the /root/secret.txt file looks like this:

username=test
password=testpass

ref:

http://wiki.centos.org/TipsAndTricks/WindowsShares

http://www.cyberciti.biz/tips/how-to-mount-remote-windows-partition-windows-share-under-linux.html

http://www.cyberciti.biz/faq/configure-a-system-to-automount-a-samba-share-with-etcfstab/

記錄一下備忘！

sun ZFS學習筆記

2009-12-07T01:08:00.001-08:00

Sun 提供了一個ZFS的免費教程，感覺不錯，講部分內容和自己的實驗記錄下來，備查！

參考：
https://learning.sun.com/solc/files/solc/tblo_selfcontained/1179270410/module1/default.htm

What is ZFS?

ZFS is a revolutionary new file system that fundamentally changes the way file systems are administered, with features and benefits not found in any other file system available today. ZFS has been designed to be robust, scalable, and simple to administer.

Instead of using a storage volume model and its associated limitations, ZFS aggregates storage devices into 'pools.' The storage pool describes the physical characteristics of the system's storage (device layout, data redundancy, and so on) and acts as an general data store from which file systems can be created.

The Benefits of ZFS

ZFS's pooling model has a lot of useful benefits. For example, using pools means that you no longer need to predetermine the size of a file system, as file systems grow automatically within the space allocated to the storage pool.

More Benefits of ZFS

ZFS is also designed to scale easily and can handle extremely large quantities of data. It does this by using 128-bit data addressing and dynamically scaling its metadata.

In addition, ZFS ensures that its data is always consistent on disk. Because ZFS uses checksums with each block of data, it can detect data corruption caused by any element of the storage subsystem, not just disk errors. That means you can use inexpensive disks to provide similar reliability to high-priced storage systems.

Even More Benefits of ZFS

Finally, ZFS provides a greatly simplified administration model. ZFS makes it easy to create and manage file systems without needing multiple commands or editing configuration files.

For example, with ZFS you can easily:

Set quotas or reservations
Turn compression on or off
Manage mount points for numerous file systems with a single command, and
Examine or repair devices without having to understand a separate set of volume manager commands

Now you understand why ZFS is such a popular file system!

the two basic elements of a ZFS file system are:

. Pools and datasets

which kind of storage model does ZFS use?

Pooled storage

summary

In summary , ZFS is an amazing new file system technology that is fast, scalable, and filled with useful features.

Understanding ZFS Basics

Now that you have a general understanding ZFS , let's dive into the details. In this topic we'll cover the basic components of the ZFS file systems, such as pools and datasets. Like always, if you think that you already have a good understanding of these basic concepts, you're welcome to jump to Lesson 2.

If you're ready to proceed, click the Next button.

Pools and Datasets

Conceptually, ZFS is pretty simple. There are two basic elements: Pools and datasets.

Pools consist of storage devices that provide space for datasets. Each pool is comprised of one or more virtual devices. A virtual device is an internal representation of the storage pool that describes the layout of physical storage and its fault characteristics. In a system with multiple devices, often these storage devices are grouped in pairs.

Datasets are groups of information that reside in storage space allocated from the pools.

Think of it this way:

A pool is like a convention center where a tradeshow is taking place.
The storage devices are like convention center rooms that can be opened up to fit the number of people in attendance.
The datasets are attendees from different professional backgrounds. For example, one dataset is made up of the marketing people, another of engineers, etc. These attendees (or datasets) can sit whereever they want in the room until it is full. Then another room can be opened up to accommodate more attendees. When the tradeshow is over, the attendees leave the convention center leaving room for others to use the space.

Pools and Datasets (cont)

Now let's take a closer look at datasets. A “dataset” is a generic name for the following ZFS entities: file systems, volumes, snapshots, or clones.

A file system dataset is just a directory hierarchy for organizing and storing files.
A volume is a dataset that is used to emulate a physical device. For example, ZFS swap and dump volumes are created automatically when the OpenSolaris release is installed.
A snapshot is a read-only image of a file system or volume at a given point in time.
A clone is a file system whose initial contents are identical to the contents of a snapshot.

Examining Pools and Datasets

In ZFS, you can examine pools and datasets with the corresponding administration commands:

“zpool” for pools, and
“zfs” for datasets

Using the ZPOOL Command

First, use the “zpool status tank” command to see the available pools.

This system has just one pool called “tank.”

Take a moment to review the “config” section. This section displays the devices that make up the pool. This is a simple pool that contains a single storage device called “c1t0d0.”

---------- sample---

root@opensolaris:~# zpool status
pool: mypool
state: ONLINE
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        mypool      ONLINE       0     0     0
          c9d0      ONLINE       0     0     0
errors: No known data errors
pool: rpool
state: ONLINE
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        rpool       ONLINE       0     0     0
          c7d0s0    ONLINE       0     0     0
errors: No known data errors
root@opensolaris:~#
root@opensolaris:~# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
       0. c7d0 <DEFAULT cyl 30390 alt 2 hd 255 sec 63>
          /pci@0,0/pci-ide@1f,2/ide@0/cmdk@0,0
1. c8d1 <drive type unknown>
          /pci@0,0/pci-ide@1f,2/ide@1/cmdk@1,0
       2. c9d0 <WDC WD80- WD-WMAM9SH8120-0001-74.50GB>
          /pci@0,0/pci-ide@1f,5/ide@0/cmdk@0,0
3. c10d0 <drive type unknown>
          /pci@0,0/pci-ide@1f,5/ide@1/cmdk@0,0
Specify disk (enter its number): ^D

创建tank pool
root@opensolaris:~# zpool create tank c8d1
root@opensolaris:~#
root@opensolaris:~# zpool list tank
NAME SIZE USED AVAIL CAP HEALTH ALTROOT
tank 696G 106K 696G 0% ONLINE -
root@opensolaris:~#

-----------------

Using the ZFS Command

Now let's use the 'zfs list -r tank' command to review the datasets on the root pool, or “rpool.”

First, let's look at the column names in the output display.

The “NAME” column lists the name of the file system.

The “USED” and ”AVAIL” columns display the amount of space has been used used and the amount of space that is still available respectivey.

The REFER column displays the amount of data accessible within the specific file system, and the amount of data that is accessible by this dataset, which may or may not be shared with other datasets in the pool. When a snapshot or clone is created, it initially references the same amount of space as the file system or snapshot it was created from, since its contents are identical.

The “MOUNTPOINT” column identifies the directory where the file system resides.

The zfs command is used to examine:

.datasets

Summary

ZFS is a new file system technology. It uses pools and datasets. Pools include virtual devices and storage devices. Datasets include file systems, volumes, snapshots, and clones. These components can be explored with the zpool and zfs commands.

Ready to move on? Click the exit button to return to the lesson menu and continue to the next lesson.

https://learning.sun.com/solc/files/solc/tblo_selfcontained/1179270410/module2/default.htm

Introduction

Now that you understand the basics of ZFS, let's discuss how to create a ZFS pool. In this lesson, you'll learn how to create a ZFS pool and why its important to use mirrored pools.

Creating a ZFS Pool

ZFS administration has been designed with simplicity in mind. Among the goals of the ZFS design is to reduce the number of commands needed to create a usable file system. When you create a new pool, a new ZFS file system is created and mounted automatically. Let me show you how its done.

Let's start by creating a simple single-device pool named "tank."

Use the "zpool create" command to create the pool by first identifying the pool name “tank” and then the device, c1t0d0 as follows:

Now use the "zpool status tank" command to see the results.

You now have a single-disk storage pool named tank, with a single storage device called c1t0d0.

Although it is possible to create a single-disk pool, a mirrored pool provides data redundancy and better protection again disk failures. We'll cover how to create a mirrored pool in the next section.

To learn more about mirrors, see Lesson 3: Mirrors.

zfs create
zfs destroy
zfs rollback
zfs rename
zfs list
zfs mount
zfs clone
zfs promote
--- sample -----
zpool create tank cit0d0
zpool status tank
root@opensolaris:~# zpool status tank
pool: tank
state: ONLINE
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          c8d1      ONLINE       0     0     0
errors: No known data errors
root@opensolaris:~#
---

Converting a Single-Device Storage Pool to a Mirrored Storage Pool

Mirrored storage pools are recommended over single-disk pools because mirrored pools can more effectively protect your data. After creating a single-disk pool, its is easy to convert it into a mirrored pool. Let's see how its done.

First, we'll use the “zpool status tank” command to see how the pool is configured.

The output shows us that currently there is only one device in the pool.

To convert this single device pool to a mirror, use the “zpool attach” command followed by the pool name, the existing device name, and the new device name.

Now, rerun the “zpool status tank” command to see if you were successful.

In the output, notice that the status listing includes the “scrub” status. When a new device is attached to a mirror, ZFS automatically duplicates all of the existing pool data onto the mirror device. This is called a “resilver.”

----
zpool attach tank c1t0d0 c1t1d0 做一个mirror
zpool status tank
Although its possible to create a single-disk pool, using mirrored pools is : true!
to convert a single-disk pool to a mirrored pool, you add a storage with which of the following commands?
attach

Summary

Creating ZFS pools is fast and simple. Just use the zpool create command and the device name and ZFS does the rest. However, make sure to follow up to convert the single-disk pool to a mirrored pool. More on this topic, see Lesson 3: Mirrors .

Summary

In a previous lesson, we created a single-device pool called 'tank.' Let's take another look at this pool. Use the “zpool status tank” command to review the pool configuration.

If you need to add more storage to this pool, start with the “zpool attach” command followed by the pool name, an existing device in the pool, and the new device that you want to attach.

Now use the zpool status tank command to see the results.

Review the OpenSolaris output on this page. Notice that both devices are now listed in the pool configuration. Also notice that both devices are now part of a “mirror” as identified in the “config” section. A mirror is a virtual device that stores identical copies of data on two or more disks. See Lesson 3: Mirrors for more information.

zpool status tank

zpool attach tank c1t0d0 c1t1d0

root@opensolaris:~# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
       0. c7d0 <DEFAULT cyl 30390 alt 2 hd 255 sec 63>
          /pci@0,0/pci-ide@1f,2/ide@0/cmdk@0,0
       1. c8d1 <ST375033-         9QK1MYJ-0001-698.63GB>
          /pci@0,0/pci-ide@1f,2/ide@1/cmdk@1,0
       2. c9d0 <WDC WD80- WD-WMAM9SH8120-0001-74.50GB>
          /pci@0,0/pci-ide@1f,5/ide@0/cmdk@0,0
       3. c10d0 <drive type unknown>
          /pci@0,0/pci-ide@1f,5/ide@1/cmdk@0,0
Specify disk (enter its number): ^D
root@opensolaris:~# zpool status tank
pool: tank
state: ONLINE
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          c8d1      ONLINE       0     0     0
errors: No known data errors
root@opensolaris:~# zpool attach tank c8d1 c10d0
root@opensolaris:~# zpool status tank
pool: tank
state: ONLINE
scrub: resilver completed after 0h0m with 0 errors on Mon Dec 7 16:09:21 2009
config:
        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          mirror    ONLINE       0     0     0
            c8d1    ONLINE       0     0     0
            c10d0   ONLINE       0     0     0 73K resilvered
errors: No known data errors
root@opensolaris:~#

---

to add a device to the storage pool, you use the following ZFS command:

attach

Summary

Adding storage to a ZFS pool is easy. Simply use the “zpool attach” command combined with the pool and device names and ZFS does the rest. Simple, isn't it? Let's move on to the next topic.

Introduction

When administering a system, its often necessary to adjust and reconfigure your setup. Often this includes destroying storage pools.

Destroying a ZFS Pool

Sometimes you make a mistake or need to reconfigure your system. To destroy a pool that is no longer needed, simply use the “zpool destroy” command. Let me show you how its done.

First, use the “zpool status tank” command to review the pools on your system.

Review the image of the OpenSolaris output on this page. It looks like we have one pool named “tank” with two devices. Next, use the “zpool destroy” command plus the name of the pool you want to destroy.

Finally, use the “zpool status tank” command to see the results.

Review the image of the OpenSolaris output once again. Notice that the pool called 'tank' has been removed from the system.

---zpool status tank
zpool destroy tank
zpool status tank
----sample---

root@opensolaris:~# zpool destroy tank
root@opensolaris:~# zpool status tank
cannot open 'tank': no such pool
root@opensolaris:~#
---------------------

ZFS provides a safety feature that allows you to recover a destroyed pool if the devices haven't been reused.

For example, suppose we accidentally destroyed the tank pool. We would simply use the “zpool import -D command” followed by the pool name to reimport the pool.

Then you would use the “zpool list” command to see the results.

Notice that the tank pool has been successfully restored.

---------
zpool import -D tank
zpool status tank
-------------sample ----------------
root@opensolaris:~# zpool import -D tank
root@opensolaris:~# zpool status tank
pool: tank
state: ONLINE
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          mirror    ONLINE       0     0     0
            c8d1    ONLINE       0     0     0
            c10d0   ONLINE       0     0     0
errors: No known data errors
root@opensolaris:~#
-------------------------------------
the correct ZFS command to eliminate a pool is:
destroy

Summary

Now you know how to a create a ZFS pool, add storage, and destroy a pool if necessary. You even know how to get it back if you delete it on accident.

https://learning.sun.com/solc/files/solc/tblo_selfcontained/1179270410/module3/default.htm

Traditionally, storage management products use a convention called a “mirror.” A mirror is a virtual device that stores identical copies of data on two or more disks. If any disk in a mirror fails, any other disk in that mirror can provide the same data .

The topics in this lesson will teach you all about using a mirrored ZFS configuration to protect your data. However, you should already know the basic definition of a pool and how to create one. If you've skipped those lessons or are still unsure about them, go back and review.

If you're ready, click Next to continue.

What Is A Mirror?

A “mirror” is a kind of storage pool that keeps identical copies of data on two or more disks.

This redundancy provides basic storage protection because if one device fails, the data is still available from the other device (or devices) in the pool.

What are the Benefits of a Mirrored ZFS Configuration?

The benefit of using a mirrored ZFS configuration is that ZFS can attempt to recover the data in the event of a disk failure.

A ZFS storage pool is really just a tree of blocks. ZFS helps to identify data errors by storing the checksum of each block in its parent block pointer, not in the block itself. Every block in the tree contains the checksums for all its children, so the entire pool is self-validating.

When an error occurs, ZFS is able to automatically checks the other device in the mirror, and if it finds good data, it uses the good copy to repair the bad block.

a mirror is : a system that keeps a copy of the data on each one of the mirrorred devices
ZFS checksum feature allows it to:
check for failed blocks of data

Summary

In this topic you have learned that a mirrored ZFS configuration is a storage pool with built in redundancy. You also learned that a mirrored ZFS configuration is recommended because it can recover data in the event of a disk failure.

Introduction

ZFS uses a process called 'mirroring' to improve data security by creating redundancy in the system. This is done by grouping storage devices in pairs and making sure to that the data on each device is mirrored by the other. This arrangment is called a 'mirrored pool.'

In this lesson you'll learn how to set up a mirrored pool.

Creating a Mirrored ZFS Pool

Suppose want to create a mirrored ZFS storage pool. Here's how you do it.

Simply use the “zpool create” command followed by the pool name and device names. We'll create a pool called “tank” with two attached devices called “c1t0d0” and “c1t1do.”

Now use the “zpool status tank” command to see the results.

Notice that you now have a mirrrored pool named tank with two devices.

--------

zpool create tank mirror c1t0d0 c1t1d0

zpool status tank

Converting a Single-Device Pool to a Mirror

Mirrored storage pools are recommended rather than single-disk pools because mirrored pools can more effectively protect your data. After creating a single-disk pool, its is easy to convert it into a mirrored pool. Let's see how its done.

First, we'll use the “zpool status tank” command to see how the pool is configured.

The output shows us that currently there is only one device in the pool.

To convert this single device pool to a mirror, use the “zpool attach” command plus the pool name, the existing device name, and the name of the device you want to attach.

Now, rerun the “zpool status tank” command to see if you were successful.

---

zpool status tank

zpool attach tank c1t0d0 c1t1d0

zpool status tank

-----sample----

root@opensolaris:~# zpool create tank mirror c8d1 c10d0
root@opensolaris:~# zpool status tank
pool: tank
state: ONLINE
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          mirror    ONLINE       0     0     0
            c8d1    ONLINE       0     0     0
            c10d0   ONLINE       0     0     0
errors: No known data errors
root@opensolaris:~#
--------------------

to convert a single-device pool to multiple-device pool you use which of the following:

Summary

Creating ZFS pools is fast and simple. Just use the zpool attach command and the device name to convert your single-device pool to a mirrored-pool.

Introduction

While managing your ZFS mirror, you might want to modify the configuration. This could mean replacing one device with another or taking a device offline.

This topic will teach you how to manage these tasks.

Taking a Device Offline

ZFS allows individual devices to be taken offline or brought online. When hardware is unreliable or not functioning properly, ZFS continues to read or write data to the device, assuming the condition is only temporary. If the condition is not temporary, it is possible to instruct ZFS to ignore the device by bringing it offline. This is done with the “zpool offline” command.

Again, let's run the “zpool status tank” command to review our mirror configuration.

Suppose you wanted to take the device c1t1d0 offline for maintenance. You would type the following “zpool offline “ command followed by the pool name and then the device name.

Now let's run the “zpool status tank” command again to see what happened.

Notice that in the “Config” section the device is listed as “offline.” Also notice that the mirror's state is listed as “degraded.” This means that the mirror is operating with less than full capacity.

In addition, the “Status” line reports that one of the devices has been taken offline, and the “Action” line provides guidance about how to return the mirror to the normal online state.

zpool status tank

zpool offline tank c1t1d0

------------sample ---------------

root@opensolaris:~# zpool status tank
pool: tank
state: ONLINE
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          mirror    ONLINE       0     0     0
            c8d1    ONLINE       0     0     0
            c10d0   ONLINE       0     0     0
errors: No known data errors
root@opensolaris:~# zpool offline tank c10d0
root@opensolaris:~# zpool status tank
pool: tank
state: DEGRADED
status: One or more devices has been taken offline by the administrator.
        Sufficient replicas exist for the pool to continue functioning in a
        degraded state.
action: Online the device using 'zpool online' or replace the device with
        'zpool replace'.
scrub: none requested
config:
        NAME        STATE     READ WRITE CKSUM
        tank        DEGRADED     0     0     0
          mirror    DEGRADED     0     0     0
            c8d1    ONLINE       0     0     0
            c10d0   OFFLINE      0     0     0
errors: No known data errors
root@opensolaris:~#

-----------------------------------

Bringing a Device Online

Once you have finished your maintenance tasks, you can easily bring the device back online. Simply use the 'zpool online” command accompanied by the pool name and the device name.

Then we'll use the “zpool status tank” command to check the results:

As you can see, the device c1t1d0 is back online and part of the mirrored pool.

zpool online tank c1t1d0

---------------sample-----------

root@opensolaris:~# zpool online tank c10d0
root@opensolaris:~# zpool status tank
pool: tank
state: ONLINE
scrub: resilver completed after 0h0m with 0 errors on Mon Dec 7 16:20:44 2009
config:
        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          mirror    ONLINE       0     0     0
            c8d1    ONLINE       0     0     0
            c10d0   ONLINE       0     0     0 1.50K resilvered
errors: No known data errors
root@opensolaris:~#

---------------------------------

Replacing One Device With Another

Sometimes you might want to replace one device with another. ZFS allows you to do this with a single operation. Just use the “zpool replace” command.

For example, let's look at our mirror called “tank.” We type in the “zpool status tank” command and review the output.

You'll notice that there are two devices in the pool: c1t0d0 and c1t1d0. Now we'll use the “zpool replace” to replace the device c1t10d0 with a new device named c1t2d0.

During this operation ZFS displays the following output showing that the device is being replaced.

Running the “zpool status tank” command again shows the new configuration.

Notice that the new device has replaced the old device in the mirror.

---
zpool status tank
zpool replace tank c1t1d0 c1t2d0
zpool status tank
It takes two commans in ZFS to replace one drive with another drive.
false

Summary

As you can see, managing ZFS pools is very simple. Just master a few simple commands and you can complete a variety of important tasks.

If you have any questions, please click the Back button and review. Otherwise, click the Exit button to return to the Main Menu and proceed to the next lesson.

不勝其煩，將OpenSolaris的sshd改成允許root用戶登錄了

2009-12-07T01:05:00.001-08:00

因為最近學習openSolaris，裝了臺服務器，問題是出於安全考慮，要轉一次才能使用root用戶權限，煩啊！

通過修改/etc/ssh/sshd_config中的

#PermitRootLogin no
PermitRootLogin yes

svcadm restart ssh

再次登錄,ok!

記錄一下。生產環境慎用！

opensolaris comstar iscsi 實驗

2009-12-04T01:22:00.001-08:00

包檢查：

root@opensolaris:~# pkg info SUNWstmf
          Name: SUNWstmf
       Summary: Sun Common Multiprotocol SCSI Target
      Category: System/Hardware
         State: Installed
     Publisher: opensolaris.org
       Version: 0.5.11
Build Release: 5.11
        Branch: 0.111
Packaging Date: Fri May 8 16:37:12 2009
          Size: 2.28 MB
          FMRI: pkg:/SUNWstmf@0.5.11,5.11-0.111:20090508T163712Z
root@opensolaris:~# pkg info SUNWiscsidm
          Name: SUNWiscsidm
       Summary: Sun iSCSI Data Mover
      Category: System/Hardware
         State: Installed
     Publisher: opensolaris.org
       Version: 0.5.11
Build Release: 5.11
        Branch: 0.111
Packaging Date: Fri May 8 16:10:41 2009
          Size: 711.90 kB
          FMRI: pkg:/SUNWiscsidm@0.5.11,5.11-0.111:20090508T161041Z
root@opensolaris:~#
root@opensolaris:~# pkg info SUNWiscsit
          Name: SUNWiscsit
       Summary: Sun iSCSI COMSTAR Port Provider
      Category: System/Hardware
         State: Installed
     Publisher: opensolaris.org
       Version: 0.5.11
Build Release: 5.11
        Branch: 0.111
Packaging Date: Fri May 8 16:10:47 2009
          Size: 647.71 kB
          FMRI: pkg:/SUNWiscsit@0.5.11,5.11-0.111:20090508T161047Z
root@opensolaris:~#

空間創建：

root@opensolaris:~# zfs create -V 1G mypool/vol
root@opensolaris:~# zpool list mypool
NAME     SIZE   USED AVAIL    CAP HEALTH ALTROOT
mypool    74G   475K 74.0G     0% ONLINE -
root@opensolaris:~# zfs list mypool/vol
NAME         USED AVAIL REFER MOUNTPOINT
mypool/vol     1G 71.8G    16K -
root@opensolaris:~#

安裝 storage-server 和SUNWiscsit

root@opensolaris:~# pkg info SUNWiscsit
          Name: SUNWiscsit
       Summary: Sun iSCSI COMSTAR Port Provider
      Category: System/Hardware
         State: Installed
     Publisher: opensolaris.org
       Version: 0.5.11
Build Release: 5.11
        Branch: 0.111
Packaging Date: Fri May 8 16:10:47 2009
          Size: 647.71 kB
          FMRI: pkg:/SUNWiscsit@0.5.11,5.11-0.111:20090508T161047Z
root@opensolaris:~#
root@opensolaris:~# pkg info storage-server
pkg: no packages matching the following patterns you specified are
installed on the system. Try specifying -r to query remotely:
        storage-server
root@opensolaris:~#
root@opensolaris:~# pkg install storage-server
DOWNLOAD                                    PKGS       FILES     XFER (MB)
Completed                                  16/16     845/845   28.58/28.58
PHASE                                        ACTIONS
Install Phase                              1657/1657
root@opensolaris:~#

root@opensolaris:~# svcs -a |grep stmf
disabled 16:10:50 svc:/system/stmf:default
root@opensolaris:~# svcadm enable stmf
root@opensolaris:~# svcs -a |grep stmf
online 16:13:25 svc:/system/stmf:default
root@opensolaris:~#

root@opensolaris:~# stmfadm list-state
Operational Status: online
Config Status : initialized
root@opensolaris:~#

root@opensolaris:/dev/zvol/rdsk/mypool# pwd
/dev/zvol/rdsk/mypool
root@opensolaris:/dev/zvol/rdsk/mypool# ls -al
total 5
drwxr-xr-x 4 root root 4 2009-12-04 16:10 .
drwxr-xr-x 4 root root 4 2009-12-04 11:41 ..
drwxr-xr-x 3 root root 3 2009-12-04 16:10 iscsi
lrwxrwxrwx 1 root root 39 2009-12-04 16:10 vol -> ../../../../devices/pseudo/zfs@0:1c,raw
root@opensolaris:/dev/zvol/rdsk/mypool# sbdadm create-lu /dev/zvol/rdsk/mypool/vol
Created the following LU:
              GUID                    DATA SIZE           SOURCE
-------------------------------- ------------------- ----------------
600144f0d9cf880000004b18c5c30001      1073676288       /dev/zvol/rdsk/mypool/vol
root@opensolaris:/dev/zvol/rdsk/mypool#
l
root@opensolaris:/dev/zvol/rdsk/mypool# stmfadm add-view 600144f0d9cf880000004b18c5c30001
root@opensolaris:/dev/zvol/rdsk/mypool#
root@opensolaris:/dev/zvol/rdsk/mypool# stmfadm list-view -l 600144f0d9cf880000004b18c5c30001
View Entry: 0
    Host group   : All
    Target group : All
    LUN          : 0
root@opensolaris:/dev/zvol/rdsk/mypool#

root@opensolaris:/dev/zvol/rdsk/mypool# svcadm enable iscsi/target
root@opensolaris:/dev/zvol/rdsk/mypool# svcs iscsi/target
STATE STIME FMRI
online 16:21:11 svc:/network/iscsi/target:default
root@opensolaris:/dev/zvol/rdsk/mypool#
root@opensolaris:/dev/zvol/rdsk/mypool# itadm create-target
Target iqn.1986-03.com.sun:02:4a34aae0-f41e-6b82-9af0-eb7e8db6cec1 successfully created
root@opensolaris:/dev/zvol/rdsk/mypool#

測試機是winXP

現在最新的Initiator-2.08-build3825-x86fre.exe

url:http://www.microsoft.com/downloads/details.aspx?familyid=12cb3c1a-15d6-4585-b385-befd1319f825&displaylang=en

安裝之

Discovery –> add-->opensolaris的IP. default port 3260

Target –> “Log On” 如果發現”Connected”就對了

管理工具--》存儲--》磁盤管理--》發現新增的disk。

剩下的內容就是初始化，格式化，不說了

記錄一下！

基本上smb方式， iSCSI都測試了，就是權限問題了。繼續研究

openSolaris ZFS 實現smb共享的實驗

2009-12-03T23:21:00.001-08:00

小弟初學openSolaris 下實現smb 共享，經過幾次失敗終於可以用了，記錄一下：

root@opensolaris:~# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
       0. c7d0 <DEFAULT cyl 30390 alt 2 hd 255 sec 63>
          /pci@0,0/pci-ide@1f,2/ide@0/cmdk@0,0
       1. c9d0 <WDC WD80- WD-WMAM9SH8120-0001-74.50GB>
          /pci@0,0/pci-ide@1f,5/ide@0/cmdk@0,0
Specify disk (enter its number): ^D
root@opensolaris:~#
root@opensolaris:~# zpool create -f mypool c9d0
root@opensolaris:~# zpool list
NAME     SIZE   USED AVAIL    CAP HEALTH ALTROOT
mypool    74G 74.5K 74.0G     0% ONLINE -
rpool    232G 8.99G   223G     3% ONLINE -
root@opensolaris:~#

root@opensolaris:~# zfs create -o casesensitivity=mixed mypool/Demo
root@opensolaris:~# zfs set compression=on mypool/Demo
root@opensolaris:~# zfs set snapdir=visible mypool/Demo
root@opensolaris:~# zfs set sharesmb=name=Demo mypool/Demo
root@opensolaris:~# zfs set quota=1G mypool/Demo
root@opensolaris:~# zfs set reservation=1G mypool/Demo
root@opensolaris:~# zfs get all mypool/Demo |egrep '(NAME|smb|comp|case|quota|reservation)'
NAME         PROPERTY              VALUE                  SOURCE
mypool/Demo compressratio         1.00x                  -
mypool/Demo quota                 1G                     local
mypool/Demo reservation           1G                     local
mypool/Demo compression           on                     local
mypool/Demo casesensitivity       mixed                  -
mypool/Demo sharesmb              name=Demo              local
mypool/Demo refquota              none                   default
mypool/Demo refreservation        none                   default
mypool/Demo usedbyrefreservation 0                      -
root@opensolaris:~#
root@opensolaris:~# useradd -d /mypool/smbtest smbtest
root@opensolaris:~# passwd smbtest
New Password:
Re-enter new Password:
passwd: password successfully changed for smbtest
root@opensolaris:~#
root@opensolaris:~# smbadm join -w Galaxy
After joining Galaxy the smb service will be restarted automatically.
Would you like to continue? [no]: y
Successfully joined Galaxy
root@opensolaris:~#
root@opensolaris:~# sharemgr show -vp
default nfs=()
zfs
    zfs/mypool/myfs nfs=() nfs:sys=(rw="@172.16.X.X/24" root="@172.16.X.X/24")
          /export/zfs1
    zfs/mypool/Demo smb=()
          Demo=/mypool/Demo
    zfs/mypool/myfs2 smb=()
          mypool_myfs2=/mypool/myfs2
root@opensolaris:~#

這是會出現類似這樣的介面：

root@opensolaris:/mypool/Demo# svcs -a |grep smb
online 12:48:40 svc:/network/smb/client:default
online* 12:48:41 svc:/network/smb/server:default
root@opensolaris:/mypool/Demo#

從remote訪問不行

reboot一次，結果ok,可以使用了。

smbd: kernel bind error: No such file or directory 問題處理

2009-12-03T01:16:00.001-08:00

在opensolaris11上配置smb server

root@opensolaris:~# rem_drv smbsrv
root@opensolaris:~# pkg install SUNWsmbskr
DOWNLOAD                                    PKGS       FILES     XFER (MB)
Completed                                    1/1         6/6     0.43/0.43
PHASE                                        ACTIONS
Install Phase                                  20/20
root@opensolaris:~# pkg install SUNWsmbs
DOWNLOAD                                    PKGS       FILES     XFER (MB)
SUNWsmbs                                     0/1        2/29     0.00/1.49
Completed                                    1/1       29/29     1.49/1.49
PHASE                                        ACTIONS
Install Phase                                  70/70
root@opensolaris:~#
root@opensolaris:~# add_drv smbsrv
Driver (smbsrv) is already installed.

root@opensolaris:~# svccfg import /var/svc/manifest/network/smb/server.xml
root@opensolaris:~#

root@opensolaris:~# svcadm enable -r smb/server
svcadm: svc:/milestone/network depends on svc:/network/physical, which has multiple instances.
root@opensolaris:~# svcs -a |grep smb
online 15:40:47 svc:/network/smb/client:default
maintenance 16:38:21 svc:/network/smb/server:default
root@opensolaris:~#

到這裏報錯了，沒有在solaris 上高過smb,不知道哪裏出問題了，怎麼辦？google

原來opensoalris的日誌目錄在

/var/svc/log

root@opensolaris:/var/svc/log# cat network-smb-server\:default.log
[ Dec 3 16:10:52 Disabled. ]
[ Dec 3 16:10:52 Rereading configuration. ]
[ Dec 3 16:36:29 Rereading configuration. ]
[ Dec 3 16:37:44 Rereading configuration. ]
[ Dec 3 16:38:19 Enabled. ]
[ Dec 3 16:38:20 Executing start method ("/usr/lib/smbsrv/smbd start"). ]
smbd: NetBIOS services started
smbd: kernel bind error: No such file or directory
smbd: daemon initialization failed
[ Dec 3 16:38:21 Method "start" exited with status 95. ]
[ Dec 3 16:40:00 Leaving maintenance because disable requested. ]
[ Dec 3 16:40:00 Disabled. ]
[ Dec 3 16:40:17 Enabled. ]
[ Dec 3 16:40:17 Executing start method ("/usr/lib/smbsrv/smbd start"). ]
smbd: NetBIOS services started
smbd: kernel bind error: No such file or directory
smbd: daemon initialization failed
[ Dec 3 16:40:18 Method "start" exited with status 95. ]
root@opensolaris:/var/svc/log#

繼續google之

http://www.opensolaris.org/jive/thread.jspa?threadID=70302&tstart=0中說“A reboot solved the problem.”

reboot機器後，果然

root@opensolaris:~# svcs -a |grep smb
online 17:04:07 svc:/network/smb/client:default
online 17:04:08 svc:/network/smb/server:default

好了，繼續。

OpenSolaris下mount iso文件和安裝包

2009-12-02T18:50:00.001-08:00

如何在openSolaris下mount一個iso的鏡像文件呢？

第一步，決定那個設備用於掛接這個文件

root@opensolaris:~/Downloads# lofiadm -a sol-nv-b125-x86-dvd.iso
/dev/lofi/1
root@opensolaris:~/Downloads#

第二步：

root@opensolaris:~/Downloads# mkdir /mnt2
root@opensolaris:~/Downloads# mount -F hsfs /dev/lofi/1 /mnt2

root@opensolaris:~/Downloads# cd /mnt2
root@opensolaris:/mnt2# ls
autorun.inf Copyright                    License     Solaris_11
autorun.sh   installer                    README.txt Sun_HPC_ClusterTools
boot         JDS-THIRDPARTYLICENSEREADME sddtool
root@opensolaris:/mnt2#

成功了，繼續

root@opensolaris:/mnt2# cd Solaris_11/
root@opensolaris:/mnt2/Solaris_11# ls
Docs Misc Patches Product Tools
root@opensolaris:/mnt2/Solaris_11# cd Product/
root@opensolaris:/mnt2/Solaris_11/Product# cp -rf SUNWjhrt SUNWjhdev SUNWj5dev SUNWj5rt SUNWj6rt SUNWjato SUNWmconr SUNWmcon SUNWmcos SUNWmcosx SUNWmctag SUNWmfrun SUNWzfsgr SUNWzfsgu /var/spool/pkg

root@opensolaris:~# pkgadd

The following packages are available:
1 SUNWj5dev     JDK 5.0 Dev. Tools (1.5.0_20)
                   (i386) 1.5.0,REV=2004.12.06.22.53
2 SUNWj5rt      JDK 5.0 Runtime Env. (1.5.0_20)
                   (i386) 1.5.0,REV=2004.12.06.22.53
3 SUNWj6rt      JDK 6.0 Runtime Env. (1.6.0_15)
                   (i386) 1.6.0,REV=2006.11.29.05.03
4 SUNWjato      Java Studio Enterprise Web Application Framework
                   (all) 2.1.5,REV=2006.07.18.09.36
5 SUNWjhdev     JavaHelp Development Utilities
                   (all) 2.0,REV=2008.10.08
6 SUNWjhrt      JavaHelp Runtime
                   (all) 2.0,REV=2008.10.08
7 SUNWmcon      Sun Java(TM) Web Console 3.1 (Core)
                   (i386) 3.1,REV=2008.08.25.16.44
8 SUNWmconr     Sun Java(TM) Web Console 3.1 (Root)
                   (i386) 3.1,REV=2008.08.25.16.44
9 SUNWmcos      Implementation of Sun Java(TM) Web Console (3.1) services
                   (i386) 3.1,REV=2008.08.25.16.44
10 SUNWmcosx     Implementation of Sun Java(TM) Web Console (3.1) services
                   (i386) 3.1,REV=2008.08.25.16.44

... 4 more menu choices to follow;
<RETURN> for more choices, <CTRL-D> to stop display:

11 SUNWmctag     Sun Java(TM) Web Console 3.1 (Tags & Components)
                   (i386) 3.1,REV=2008.08.25.16.44
12 SUNWmfrun     Motif RunTime Kit
                   (i386) 2.1.4,REV=10.2009.09.07
13 SUNWzfsgr     ZFS Administration for Sun Java(TM) Web Console (Root)
                   (i386) 1.0,REV=2009.09.16.20.27
14 SUNWzfsgu     ZFS Administration for Sun Java(TM) Web Console (Usr)
                   (i386) 1.0,REV=2009.09.16.20.27

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]:

Processing package instance <SUNWj5dev> from </var/spool/pkg>

JDK 5.0 Dev. Tools (1.5.0_20)(i386) 1.5.0,REV=2004.12.06.22.53
Copyright 2009 Sun Microsystems, Inc. All rights reserved.
Use is subject to license terms.
Using </usr> as the package base directory.
## Processing package information.
## Processing system information.
   2 package pathnames are already properly installed.
## Verifying package dependencies.
WARNING:
    The <SUNWj5rt> package "JDK 5.0 Runtime Env.
    (1.5.0_01)" is a prerequisite package and should be
    installed.
WARNING:
    The <SUNWmfrun> package "Motif RunTime Kit" is a
    prerequisite package and should be installed.

Do you want to continue with the installation of <SUNWj5dev> [y,n,?]

一路y下去了

Installation of <SUNWzfsgu> was successful.

root@opensolaris:~# svccfg
svc:> select system/webconsole
svc:/system/webconsole> setprop options/tcp_listen=true
svc:/system/webconsole> quit

root@opensolaris:~# /usr/sbin/smcwebserver restart
Restarting Sun Java(TM) Web Console Version 3.1 ...
The console is running

root@opensolaris:~# netstat -a|grep 6789
*.6789 *.* 0 0 49152 0 LISTEN
*.6789 *.* 0 0 49152 0 LISTEN
root@opensolaris:~#

成功了

diagcollection.pl –collect Mandatory argument 'crshome' is missing. 問題處理

2009-11-24T17:46:00.001-08:00

學習使用RAC diagcollection tools報錯了,我的環境是oracle11g R1

[oracle@croracle01 bin]$ ./diagcollection.pl -collect
Production Copyright 2004, 2007, Oracle. All rights reserved
Cluster Ready Services (CRS) diagnostic collection tool
Mandatory argument 'crshome' is missing.

[oracle@croracle01 bin]$ su
Password:
[root@croracle01 bin]# ./diagcollection.pl -collect -crshome=/u01/app/crs
Production Copyright 2004, 2007, Oracle. All rights reserved
Cluster Ready Services (CRS) diagnostic collection tool
The following CRS diagnostic archives will be created in the local directory.
crsData_croracle01.tar.gz -> logs,traces and cores from CRS home. Note: core files will be packaged only with the -core option.
ocrData_croracle01.tar.gz -> ocrdump, ocrcheck etc
coreData_croracle01.tar.gz -> contents of CRS core files in text format

Collecting crs data
/bin/tar: Removing leading `/' from member names

Collecting OCR data
Collecting information from core files
No corefiles found
The following Oracle Home diagnostic archives will be created in the local directory.
oraData_croracle01.tar.gz -> logs, traces and cores from Oracle Home
Collecting oracle home data
/bin/tar: Removing leading `/' from member names
[root@croracle01 bin]#

[root@croracle01 bin]# ll *.gz
-rw-r--r-- 1 root root 1559181 Nov 26 23:39 crsData_croracle01.tar.gz
-rw-r--r-- 1 root root 11791 Nov 26 23:40 ocrData_croracle01.tar.gz
-rw-r--r-- 1 root root 35400 Nov 26 23:40 oraData_croracle01.tar.gz

其實-help中說的很清楚

[root@croracle01 bin]# ./diagcollection.pl -help
Production Copyright 2004, 2007, Oracle. All rights reserved
Cluster Ready Services (CRS) diagnostic collection tool
diagcollection
    --collect
             [--crs] For collecting crs diag information
             [--oh] For collecting oracle home diag information
             [--adr] For collecting diag information for ADR
             [--all] Default.For collecting all diag information.
             [--core] UNIX only. Package core files with CRS data
             [--afterdate] UNIX only. Collects archives from the specified date. Specify in mm/dd/yyyy format
             [--aftertime] Supported with -adr option. Collects archives after the specified time. Specify in YYYYMMDDHHMISS24 format
             [--beforetime] Supported with -adr option. Collects archives before the specified date. Specify in YYYYMMDDHHMISS24 format
             [--crshome] Argument that specifies the CRS Home location
             NOTE:
             1. You can also do the following
                ./diagcollection.pl --collect --crs --oh
             2. ORACLE_HOME env variable needs to be set.

--clean cleans up the diagnosability
information gathered by this script

     --coreanalyze UNIX only. Extracts information from core files
                    and stores it in a text file
diagcollection
    --collect
             [--crs] For collecting crs diag information
             [--oh] For collecting oracle home diag information
             [--adr] For collecting diag information for ADR
             [--all] Default.For collecting all diag information.
             [--core] UNIX only. Package core files with CRS data
             [--afterdate] UNIX only. Collects archives from the specified date. Specify in mm/dd/yyyy format
             [--aftertime] Supported with -adr option. Collects archives after the specified time. Specify in YYYYMMDDHHMISS24 format
             [--beforetime] Supported with -adr option. Collects archives before the specified date. Specify in YYYYMMDDHHMISS24 format
             [--crshome] Argument that specifies the CRS Home location
             NOTE:
             1. You can also do the following
                ./diagcollection.pl --collect --crs --oh
             2. ORACLE_HOME env variable needs to be set.

--clean cleans up the diagnosability
information gathered by this script

--coreanalyze UNIX only. Extracts information from core files
and stores it in a text file
[root@croracle01 bin]#

記錄一下備忘!

Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/XML/Parser/Expat/Expat.so' for module XML::Parser::Expat: libexpat.so.1: cannot open shared object file: No such file or directory at line 230. 問題處理

2009-11-22T22:36:00.001-08:00

在配置myql-zmanda backup的時候遇到這樣一個問題:

[root@nitrogen cron.daily]# mysql-zrm-reporter --show restore-info --where backup-set=dailyrun
Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/XML/Parser/Expat/Expat.so' for module XML::Parser::Expat: libexpat.so.1: cannot open shared object file: No such file or directory at
line 230.
at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/XML/Parser.pm line 14
Compilation failed in require at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/XML/Parser.pm line 14.
BEGIN failed--compilation aborted at /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/XML/Parser.pm line 18.
Compilation failed in require at /usr/lib/mysql-zrm/XML/RSS.pm line 5.
BEGIN failed--compilation aborted at /usr/lib/mysql-zrm/XML/RSS.pm line 5.
Compilation failed in require at /usr/bin/mysql-zrm-reporter line 55.
BEGIN failed--compilation aborted at /usr/bin/mysql-zrm-reporter line 55.

困擾了半天也沒有找到答案

最後確認是動態庫的問題記錄一下

[root@aaa ~]# vi /etc/ld.so.conf

[root@aaa ~]# cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/local/lib #這個是添加上去了

ldconfig –v

....

        libstdc++.so.6 -> libstdc++.so.6.0.8
        libORBit-2.so.0 -> libORBit-2.so.0.1.0
        libtcl8.4.so -> libtcl8.4.so
        libpanel.so.5 -> libpanel.so.5.5
        libecryptfs.so.0 -> libecryptfs.so.0.0.0
        libnfsidmap.so.0 -> libnfsidmap.so.0.2.0
        libjpeg.so.62 -> libjpeg.so.62.0.0
        libncurses.so.5 -> libncurses.so.5.5
        libXtst.so.6 -> libXtst.so.6.1.0
        libaspell.so.15 -> libaspell.so.15.1.3
        libgdbm.so.2 -> libgdbm.so.2.0.0
        libxml2.so.2 -> libxml2.so.2.6.26
        libgnutls.so.13 -> libgnutls.so.13.0.6
        libmenuw.so.5 -> libmenuw.so.5.5
        libformw.so.5 -> libformw.so.5.5
        libldap-2.3.so.0 -> libldap-2.3.so.0.2.15
        libisccc.so.0 -> libisccc.so.0.2.2
        liboddjob.so.0 -> liboddjob.so.0.0.0
        libXft.so.2 -> libXft.so.2.1.2
        libcairo.so.2 -> libcairo.so.2.9.2
        libgij.so.7rh -> libgij.so.7rh.0.0
        libgcj.so.7rh -> libgcj.so.7rh.0.0
        libcups.so.2 -> libcups.so.2
        libhistory.so.5 -> libhistory.so.5.1
        libsqlite3.so.0 -> libsqlite3.so.0.8.6
        libz.so.1 -> libz.so.1.2.3
        liblber-2.3.so.0 -> liblber-2.3.so.0.2.15
        libXrender.so.1 -> libXrender.so.1.3.0
        libGL.so.1 -> libGL.so.1.2
/lib/i686: (hwcap: 0x0008000000000000)
/lib64/tls: (hwcap: 0x8000000000000000)
/usr/lib64/tls: (hwcap: 0x8000000000000000)
/usr/lib64/sse2: (hwcap: 0x0000000004000000)
/lib/i686/nosegneg: (hwcap: 0x0018000000000000)
        libpthread.so.0 -> libpthread-2.5.so
        libm.so.6 -> libm-2.5.so
        librt.so.1 -> librt-2.5.so
        libc.so.6 -> libc-2.5.so
        libthread_db.so.1 -> libthread_db-1.0.so

應該是動態庫重新加載了一次

再次運行:

[root@/aaa ~]# mysql-zrm-reporter --show restore-info --where backup-set=dailyrun

REPORT TYPE : restore-info

          backup_set backup_date                  backup_level backup_directory                          backup_status         comment
-----------------------------------------------------------------------------------------------------------------------------------------------------
            dailyrun Mon 23 Nov 2009 12:55:15                0 /opt/mysql-zrm/dailyrun/20091123125515    Backup succeeded      ----
                      PM HKT
            dailyrun Mon 23 Nov 2009 12:54:26                0 /opt/mysql-zrm/dailyrun/20091123125426    Backup failed         ----
                      PM HKT
            dailyrun Mon 23 Nov 2009 12:53:16                0 /opt/mysql-zrm/dailyrun/20091123125316    Backup failed         ----
                      PM HKT
            dailyrun Mon 23 Nov 2009 11:04:46                0 /opt/mysql-zrm/dailyrun/20091123110446    Backup failed         ----

ok, 看來在Redhat中對動態庫的管理已經上升到配合文件的程度了.

記錄一下備查!

iPhone UIAlertView Sample

2009-11-20T01:19:00.001-08:00

初学iPhone开发:
用到UIAlertView,以后开发应该能用到记录之
两个例子,
第一个

-(IBAction)buttonPressed:(id)sender
{
NSString *favouriate = [sender titleForState:UIControlStateNormal];
NSString *alertViewText = [[NSString alloc] initWithFormat:@"You choose the %@ as your favouriate Apple computer",favouriate];

UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"Favoriate Mac!"
message:alertViewText
delegate:nil
cancelButtonTitle:@"Go back"
otherButtonTitles:@"Yes!", nil];

[alert show];
[alert release];
}

第二个
-(IBAction)buttonPressed:(id)sender
{
NSString *favouriate = [sender titleForState:UIControlStateNormal];
NSString *alertViewText = [[NSString alloc] initWithFormat:@"You choose the %@ as your favouriate Apple computer",favouriate];
UIAlertView * alert = [[UIAlertView alloc] initWithTitle:@"favoriate Text" message:alertViewText delegate:self cancelButtonTitle:@"OK" otherButtonTitles:nil];

[alert show];
[alert release];
}

* JFolder::create: Could not create directory * Warning! Failed to move file. 問題解決

2009-11-19T19:22:00.001-08:00

在加入joomla extension的時候, 報錯

* JFolder::create: Could not create directory

* Warning! Failed to move file.

如何解決了?google

http://www.jm-tutorials.com/index.php?start=5 ,根據說明找到

“Yes! That is the right decision! Carefully read the log path in configuration.php -var $log_path = '/home/url...../public_html/logs';”

找到

vi configuration.php

…

var $log_path = '/var/www/vhosts/html/m-a-d/logs/';
var $tmp_path = '/var/www/vhosts/html/m-a-d/tmp/';

…

[aaa]#mkdir -p /var/www/vhosts/html/m-a-d/logs/

[aaa]# mkdir -p /var/www/vhosts/html/m-a-d/tmp/
[aaa]# chmod -R 777 /var/www/vhosts/html/m-a-d/tmp/

再次安裝ok

SELinux 還是很害人的

2009-11-18T22:45:00.001-08:00

編譯完php后,make ok

make test 報錯如下:

/root/packages/php-5.2.11/sapi/cli/php: error while loading shared libraries: /usr/local/libpng2/lib/libpng12.so.0: cannot restore segment prot after reloc: Permission denied
make: [test] Error 127 (ignored)

跳過make install 也包類似的錯, 啥問題呢?

原來安裝這部機器的SELinux沒有disable,

將之disable掉 make test ok

make install ok

記錄之, 看來SElinux這個東西還是很害人的.

當然話說回來, 這個東西是security方面要求的, 但是現在還到不了那個高度呢, 先把應用跑起來再說了

Objective-C 學習筆記

2009-11-18T18:58:00.001-08:00

最近正在學習iPhone 開發,記錄一下

常用 Key words

. Messaging
. Import Syntax
. Declaring Method Headers
. Inheritance Synax
. property and synthesize keywords
. interface and implementation Declarations
. protocols
. self keywords.
. Id keyword

Messaging: --可以理解為method (c/c++/java)
Example:
[object message];
similar to :
object.method();
object->method();

Messaging with parameters

Example: 含參數的例子
[object message: param1 withParameter:param2];
Similar to:
object.method(param1, param2);
object->method(param1,param2);

Nestd Messages :

example:嵌套調用
[object secondMessage:[object message]]
Similar to :
object.secondMessage(object.message());
object.secondMessage(object->message());

The import statement
example:
#import <Library.h>
#import "class.h"
Similar to include and import statement in C/C++/Java and no include guards required with Objective-C imports

Method Headers
Example:
-(returnType)methodName:(dataType) param1 //對象方法聲明
Called by:
[object methodName:param1] //對象方法調用
a + rather than - before the method signifies that the method is static //"+"表示靜態方法(class的方法) "-"表示對象的方法
Similar to :
returnType methodName(dataType param1)

Declaring Inheritance //繼承關係
example:
ClassName:ParentClass<Protocol>
Similar to:
ClassName:ParentClass<Interface>
ClassName extends ParentClass implements interface
Note:
There is no mulitiple inheritance in Objective-C //Objective-C 中不存在多繼承

@property declaration
Used to create getters and setters for to specified variable. Place in the implementation of a class //感覺是getter和setter的一個省事的做法
Example:
@property dataType variablename //在*.h文件中declare 在*.m文件中使用@synthesize與之對應

typical usage of variables defined using @property:
className.variable = value
variable = className.variable

@interface
Declare class member variables, and methods in the interface // @interface 作用是聲明類的變量和方法

@interface ClassName: ParentClass <Protocol>
{
dataType variableName;
}
@property data;
-(returnType)methodName:(dataType)param1
@end

@synthesize
Used to synthesize the getter and setter declared with the @property directive //與@property對應
example:
@synthesize variableName

@implementation
This is where you implement the actual class. //具體實現一個類,或者是類的實現

@implementation ClassName
@synthesize data;
-(returnType)methodName:(dataType)param1
{
....Method Details...
}
@end

Protocols
implemented using <> brackets when creating class interface //在創建interface的時候使用的
example:
@interface ClassName:ParentClass <Protocol>
similar to interface in Java, and C++ //類似Java C++的interface/abstract class 的實現

Self Keyword
Example:
[self message]
similar to :
the this keyword used in Java and C++.
Self must be used when calling a non-static method within the same object // self只能調用非靜態的方法

id keyword
The id keyword is used as generic identifier to identify any class
Similar to the Object keyword in java and to void pointer(void*) in C++ //我的理解是最泛的一個標識

記錄一下,備忘!

工作日誌之如何在Mysql上創建用戶

2009-11-18T17:22:00.001-08:00

儘管這些東西很簡單的, google一下也能找到,但是經常使用,一時找不到很影響工作效率,所以做一個日誌, 備忘一下

mysql> create user root@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on mysqlUser.* to mysqluser; --mysqlUser.* 是Database的名字
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to root@'%';
Query OK, 0 rows affected (0.00 sec)

mysql> set password for ~~root@'%'=password('password'~~);
Query OK, 0 rows affected (0.00 sec)

mysql> create user myadmin
-> ;
Query OK, 0 rows affected (0.00 sec)

mysql> set password for myadmin =password('myinno');
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on mydiscuz.* to myadmin;
Query OK, 0 rows affected (0.00 sec)

mysql 數據導出的例子

2009-11-12T23:34:00.001-08:00

select into outfile的例子:

mysql> select * into outfile './user.txt' from AAA_users;
Query OK, 236 rows affected (0.01 sec)

mysql> select name , ',', username,',', email into outfile './user2.txt' from AAA_users;
Query OK, 236 rows affected (0.00 sec)

注意:

這裡生成出來的問題的位置在default mysql的目錄,比如這裡用rpm安裝mysql 位置在 /var/lib/mysql
可以找到這兩個文件.

mysqldump的例子:

[root@aaaa~]# mysqldump -T '/tmp/' --fields-terminated-by=", " db_bbb aaa_users <----db_bbb是database 名字， aaa_users是table name

[root@aaaa tmp]# ll
total 48
-rw-r--r-- 1 root root 1873 Oct 30 18:31 aaa_users.sql
-rw-rw-rw- 1 mysql mysql 44775 Oct 30 18:31 aaa_users.txt

這裡好像其他目錄報錯,用tmp目錄沒有問題.

記錄一下

凡所有相☯皆是虛妄

調整redo log file 的一個script

遭遇 ORA-03232: unable to allocate an extent of 40 blocks from tablespace 5

转 应该告诉儿童什么

realVNC Could not init font path element /usr/X11R6/lib/X11/fonts/misc/, removing from list! 處理

vmware安裝在Centos5.3上的報錯vmware gcc: error trying to exec 'cc1': execvp: No such file or directory

keepalived failover實驗

sendmail “cannot open `/usr/share/sendmail-cf/m4/cf.m4': No such file or directory” 問題處理

apache 中如何添加mod_info.c這個文件

臨時開發vsftpd

apache ab stress tool “apr_socket_recv: Connection reset by peer (104)” 的處理

ORACLE 11g RAC ons offline 處理

apache(2.2.15) +php(5.2.10) 實驗

Apache is running a threaded MPM, but your PHP Module is not compiled to be threadsafe. You need to recompile PHP. Pre-configuration failed 的處理

如何加快make的速度

類似：error while loading shared libraries: libiconv.so.2 問題的處理

apache web server 實驗

如何查找redo file?

solaris 7 force umount cmd

How to Delete a node from RAC test

Awk 做url

BBED complie

add a disk to linux

lower_case_table_names 可以引發mysql replication 不成功

lower_case_table_names=1

oracle exp parfile mode

dbms_job實驗

openSolaris 0906 install GCC

Oracle scn相關

Oracle archive log mode 相關

expdp實驗

opensolaris(solaris5.11)下如何mount ntfs 格式的usb disk?

疑似ARP attack 常用的cmd

CRS-0184: Cannot communicate with the CRS daemon. 的處理

RedHat Linux NFS server and solaris NFS client 實驗

Awk處理根據行處理文本的例子

帕肯森定律（Parkinson’sLaw）

Oracle tuning goals and techniques

solaris 10 自身帶gcc make

Solaris 10 上如何安裝c/c++ 等的compilers？

Oracle - statspack報告中的 log file sync是意義？

官方文檔中：

redo synch time

redo sync writes

(RedHat, CentOS,OEL)手動清理memory的實驗

2009年終總結

學習compare NSSTring Objects

如何正常關閉mysql

5.1.4. mysql.server：MySQL服务器启动脚本

mysqlimport and load data 實驗

SP2-0618: Cannot find the Session Identifier. 问题

web tools httprint

smbclient RHEL 5 mount cmd變化了

sun ZFS學習筆記

不勝其煩，將OpenSolaris的sshd改成允許root用戶登錄了

opensolaris comstar iscsi 實驗

openSolaris ZFS 實現smb共享的實驗

smbd: kernel bind error: No such file or directory 問題處理

OpenSolaris下mount iso文件 和安裝包

diagcollection.pl –collect Mandatory argument 'crshome' is missing. 問題處理

Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/XML/Parser/Expat/Expat.so' for module XML::Parser::Expat: libexpat.so.1: cannot open shared object file: No such file or directory at line 230. 問題處理

iPhone UIAlertView Sample

* JFolder::create: Could not create directory * Warning! Failed to move file. 問題解決

SELinux 還是很害人的

Objective-C 學習筆記

工作日誌 之 如何在Mysql上創建用戶

mysql 數據導出的例子

转应该告诉儿童什么

OpenSolaris下mount iso文件和安裝包

工作日誌之如何在Mysql上創建用戶