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

學習使用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. 問題處理

 

在配置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

初学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. 問題解決

在加入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 還是很害人的

編譯完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 學習筆記

最近正在學習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上創建用戶

儘管這些東西很簡單的, 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 數據導出的例子

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目錄沒有問題.

記錄一下

ORA-28002: the password will expire within 7 days 問題

在做一個實驗,發現原來的user,失效了,如何處理呢

[oracle@croracle01 ~]$ sqlplus ractest/password

SQL*Plus: Release 11.1.0.6.0 - Production on Sat Nov 14 01:55:18 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ERROR:
ORA-28002: the password will expire within 7 days

問題原因:

SQL*Plus

[oracle@croracle01 ~]$ oerr ora 28002
28002, 00000, "the password will expire within %s days"
// *Cause:   The user's account is about to about to expire and the password
//           needs to be changed
// *Action:  change the password or contact the DBA
//

Release 11.1.0.6.0 - Production on Sat Nov 14 01:56:34 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

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 profile from dba_users where username='RACTEST';

PROFILE
------------------------------
DEFAULT

SQL> select LIMIT, RESOURCE_NAME from dba_profiles where RESOURCE_NAME in ('PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME','PASSWORD_REUSE_MAX','PASSWORD_REUSE_TIME') and PROFILE=(select profile from dba_users where username='RACTEST');

LIMIT                                    RESOURCE_NAME
---------------------------------------- --------------------------------
180                                      PASSWORD_LIFE_TIME
UNLIMITED                                PASSWORD_REUSE_TIME
UNLIMITED                                PASSWORD_REUSE_MAX
7                                        PASSWORD_GRACE_TIME

SQL>

應該是過期了

SQL> select ctime, ptime from sys.user$ where name='RACTEST';

CTIME     PTIME
--------- ---------
15-MAY-09 15-MAY-09

SQL>

也可以這樣:

SQL>  SELECT CREATED FROM DBA_USERS WHERE USERNAME = 'RACTEST';

CREATED
---------
15-MAY-09

SQL>

問題的解決方法一: change password

SQL> conn ractest/password
ERROR:
ORA-28002: the password will expire within 7 days

Connected.
SQL> password
Changing password for RACTEST
Old password:
New password:
Retype new password:
Password changed
SQL>

 

SQL>  select ctime, ptime from sys.user$ where name='RACTEST';

CTIME     PTIME
--------- ---------
15-MAY-09 14-NOV-09

另一個比較徹底的辦法就是不限制用戶的使用時間:

SQL> alter profile default limit password_life_time unlimited;

Profile altered.

SQL> select LIMIT, RESOURCE_NAME from dba_profiles where RESOURCE_NAME in ('PASSWORD_GRACE_TIME','PASSWORD_LIFE_TIME','PASSWORD_REUSE_MAX','PASSWORD_REUSE_TIME') and PROFILE=(select profile from dba_users where username='RACTEST');

LIMIT                                    RESOURCE_NAME
---------------------------------------- --------------------------------
UNLIMITED                                PASSWORD_LIFE_TIME
UNLIMITED                                PASSWORD_REUSE_TIME
UNLIMITED                                PASSWORD_REUSE_MAX
7                                        PASSWORD_GRACE_TIME

SQL>

 

參考:http://arjudba.blogspot.com/2008/07/solution-of-ora-28002-password-will.html

max os 上使用的 VNC VIEWER Chicken of the VNC 不錯

昨天參加一個WORKSHOP,要求用VNC登錄AMAZON'S EC的CLOUD, 要求有一個VNC CLIENT,在MAC 上不知道內置有沒有,情急之下,決定下載一個
GOOGLE之, 發現一個 http://sourceforge.net/projects/cotvnc/
Chicken of the VNC
free的, 趕緊DOWNLOAD下來,測試一下, 還不錯用起來.

另外體驗了一下 AMAZON'S CLOUD, EC2
http://aws.amazon.com/ec2/
據說是收費的, 好像$2/HOURS,看來AMAZON已經走到CLOUD裡面去了,通過VNC體驗了一下CLOUD :)

Fatal error: Call to undefined function mb_internal_encoding() in /dir/ administrator/components/com_k2/tables/k2category.php on line 46

試用k2 cck  extentsion 發現在增加categories的時候報 類似上述的錯誤, google,發現php編譯的時候少了一個參數 --enable-mbstring

我的腳本

./configure --prefix=/usr/local/php --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/usr/local/mysql --with-gd=/usr/local/gd2 --with-freetype-dir=/usr/local/freetype --with-jpeg-dir=/usr/local/jpeg6 --with-zlib-dir=/usr/local/lib --with-png-dir=/usr/local/libpng2 --with-ttf --enable-soap --with-gd --enable-gd-native-ttf --enable-magic-quotes --enable-mbstring

重新編譯

漫長的等待后,再次測試,ok

numactl

numactl是硬件的一種重要的特性, 具體的說應該是cpu相關的,參考fenng 大神的blog, http://www.dbanotes.net/database/numa.html ,

在自己的環境中做了一個實驗發現Enterprise RedHat 5.1 還不是default支持, 5.2之後就支持了

記錄一下結果,備查:

--Enterprise RedHat 5.1  env

[oracle@oracle01 ~]$ numactl --show
physcpubind: 0 1 2 3
No NUMA support available on this system.

OEL 5.2

[oracle@oracle03 ~]# numactl --show
policy: default
preferred node: current
physcpubind: 0 1 2 3 4 5 6 7
cpubind: 0
nodebind: 0
membind: 0

OEL 5.4(vmware) :)

[root@localhost bin]# numactl --show
policy: default
preferred node: current
physcpubind: 0
cpubind: 0
nodebind: 0
membind: 0

參考 http://www.dbanotes.net/database/numa.html

Site Forms - jSeblod CCK :: The Content Type is missing or unpublished. 錯誤解決

 

在joolma上安裝了jSeblod CCK這個extension 還有 例子包 jSeblod_CCK_Simple_Demo_Pack_2009_08_31.zip 

看似一切順利, 但是在頁面上顯示上面的那條信息:

Site Forms - jSeblod CCK :: The Content Type is missing or unpublished.

google了一下居然沒有人遇到過, 無奈下在 jSeblod的forum上去找找看,果然找到了

在 extensions ->moudles manager –> 找到Site Forms - jSeblod CCK, 在右側的  Module Parameters, 中將 content type 和 jSeblod templete 設置一下,就ok了

參考:

http://www.jseblod.com/forum/41-bug-report/917-displaying-error-message-on-all-pages.html#917

Try to change parameters in Site Forms module, select an other Content Type and select the default submission template.

另外,joolma 在IE和firefox下的表現不同, ie下的表現似乎好一點, 有點震驚

同步mac iCal ,google calendar and iPod touch

學習一下先進的工作經驗, 剛搞好,配置出乎意料的簡單， 感覺不錯.

參考

http://sammy.hk/2009/02/12/iphone-and-google-calendar-sync?wscr=1680x1050

http://www.iusesoft.info/2009/08/02/google-calendar-sync/

joomla add extentsion jSeblod CCK error "Warning! - Failed to move file" 處理

領導要增加一個joomla extension jSeblod CCK, 一直添加報錯

Warning! - Failed to move file

檢查version沒有問題1.5.14

咋整呢, google發現有應該是權限的問題

1. 進入joomla administrator panel

2. –>help –> system info

3 有兩個目錄

Log Directory ($log_path) /var/www/vhosts/html/m-a-d/logs//
unWritable

Temp Directory ($tmp_path) /var/www/vhosts/html/m-a-d/tmp//
unWritable

因為是測試環境,不管那麼多了

[root@vm-linux64-server1 beta.m-a-d.asia]# mkdir -p /var/www/vhosts/html/m-a-d/logs/
[root@vm-linux64-server1 beta.m-a-d.asia]# mkdir -p /var/www/vhosts/html/m-a-d/tmp/
[root@vm-linux64-server1 beta.m-a-d.asia]# chmod -R 777 /var/www/vhosts/html/m-a-d/tmp/
[root@vm-linux64-server1 beta.m-a-d.asia]# chmod -R 777 /var/www/vhosts/html/m-a-d/logs/

再次安裝成功!

繼續研究