python
临时:http://www.51testing.com/?uid-437299-action-viewspace-itemid-828833
oracle
oracle10g_x86 RAC
Oracle cluterware
表空间
表空间学习
临时表空间的集中用法和意义
error:
oracle_err1
Sharedpool深入分析及性能调整
Oracle 中文环境SQLPLUS乱码问题:
增加swap空间
# cd /usr //这里建议在/usr里建swap,你也可以自己决定,最好是个单独的分区# dd if=/dev/zero of=swap bs=1024 count=2097152//bs是设定块的大小,这里的意思就是1块的大小是1024,count是由1024*2048(2G)得来的# /sbin/mkswap swap //创建交换文件# /sbin/swapon swap //激活当前swap文件# /sbin/swapon -s //查看swap是否激活# vi /etc/fstab //编辑fstab文件,让开机时自动启动-,在行尾加上-如下语句/var/swapfile swap swap defaults 0 04. 修改参数,这里我就不多说了,网上这样的介绍多的是。
3. 安装如下包:
compat-libstdc++-7.3-2.96.118.i386.rpm
compat-db-3.3.11-4.i386.rpm
compat-gcc-7.3-2.96.118.i386.rpm
4、To assure that Oracle will install and run, download and install libctypefixup using the following commands (as root).
tar xfz libctypefixup-1.0.tar.gz
cd libctypefixup-1.0
make
make install
5、To assure that the Oracle installer will run, download and install libwaitfixup using the following commands (as root).
tar xfz libwaitfixup-1.0.tar.gz
cd libwaitfixup-1.0
make
make install
echo "/lib/libwaitfixup.so" >> /etc/ld.so.preload
6、出现如下提示:Error in invoking target install of makefile
$ORACLE_HOME/product/9.2.0/network/lib/ins_oemagent.mk
解决方法如下:
将$ORACLE_HOME/product/9.2.0/network/lib/env_oemagent.mk中,
LDLIBS=$(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(EXSYSLIBS) $(MATHLIB) $(USRLIBS)
改为:
LDLIBS=$(EXPDLIBS) $(EXOSLIBS) $(SYSLIBS) $(EXSYSLIBS) $(MATHLIB) $(USRLIBS) –lctypefixup
7、出现如下错误:
Error in invoking target install of makefile
$ORACLE_HOME/product/9.2.0/rdbms/lib/ins_rdbms.mk
解决方法如下:
将$ORACLE_HOME/product/9.2.0/rdbms/lib/env_rdbms.mk中
LINK=$(PURECMDS) gcc $(LDFLAGS) $(COMPSOBJS)
改为:
LINK=$(PURECMDS) gcc296 $(LDFLAGS) $(COMPSOBJS)
并将ORACLE_LINKER=$(ADE_DEL_FILE_CMD) $(PURECMDS) gcc $(OLAPPRELINKOPTS) $(LDFLAGS) $(COMPSOBJS)
改为:
ORACLE_LINKER=$(ADE_DEL_FILE_CMD) $(PURECMDS) gcc296 $(OLAPPRELINKOPTS) $(LDFLAGS) $(COMPSOBJS)
之后点retry
8、出现如下错误:
Error in invoking target install of makefile
$ORACLE_HOME/product/9.2.0/ctx/lib/ins_ctx.mk
解决方法如下:
打开文件$ORACLE_HOME/ctx/lib/env_ctx.mk,把"$(LDLIBFLAG)dl"加到INSO_LINK参数中:
INSO_LINK = -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc_ca $(LDLIBFLAG)sc_fa $(LDLIBFLAG)sc_ex $(LDLIBFLAG)sc_da $(LDLIBFLAG)sc_ut $(LDLIBFLAG)sc_ch $(LDLIBFLAG)sc_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)
然后回到安装界面按重试,就可以继续安装。
9、在提示操作 $ORACLE_HOME/product/9.2.0/root.sh
的时候出现如下错误:
Before you install the Oracle9i Real Application Cluster 9.2.0.1.0 software (RAC software + database software), you have to make sure that the pdksh and ncurses4 RPMs are installed on all RAC nodes! If these RPMs are not installed, you will get the following error message when you run $ORACLE_HOME/root.sh on each RAC node during the software installation:
...
error: failed dependencies:
libncurses.so.4 is needed by orclclnt-nw_lssv.Build.71-1
error: failed dependencies:
rclclnt = nw_lssv.Build.71-1 is needed by orcldrvr-nw_lssv.Build.71-1
error: failed dependencies:
rclclnt = nw_lssv.Build.71-1 is needed by orclnode-nw_lssv.Build.71-1
rcldrvr = nw_lssv.Build.71-1 is needed by orclnode-nw_lssv.Build.71-1
libscsi.so is needed by orclnode-nw_lssv.Build.71-1
libsji.so is needed by orclnode-nw_lssv.Build.71-1
error: failed dependencies:
rclclnt = nw_lssv.Build.71-1 is needed by orclserv-nw_lssv.Build.71-1
rclnode = nw_lssv.Build.71-1 is needed by orclserv-nw_lssv.Build.71-1
/bin/ksh is needed by orclserv-nw_lssv.Build.71-1
package orclman-nw_lssv.Build.71-1 is already installed
** Installation of LSSV did not succeed. Please refer
** to the Installation Guide at [url]http://www.legato.com/LSSV[/url]
** and contact Oracle customer support if necessary.
rpm -q pdksh ncurses4
To install these RPMs, run:
su - root
rpm -Uvh pdksh-5.2.14-13.i386.rpm ncurses4-5.0-5.i386.rpm
data_guard:
Oracle 11g Data Guard 物理备库快速配置指南(上)
other knowloage:
install
top-3.6-sol9-sparc-local.gz 下载
KVM安装 KVM里装windows虚拟机 KVM里装ubuntu虚拟机
rpm_source
日常错误:
vsftp 登录报错:500 OOPS: cannot change directory:/home/*******
操作系统
unix系统信息收集参考(hp-ux,solaris,aix)
DB2
DB2的增量备份及恢复
某些命令:
--前滚到上面登记的时间戳,并完成前滚
db2 rollforward database mydb1 to 2012-07-25-23.22.53.757978 using local time and stop
PIANO
mysql
MySQL字段之时间字段
Ubuntu源码编译安装MySQL
sudo apt-get install build-essential
sudo apt-get install libncurses5-dev
sudo apt-get install sysv-rc-conf
sudo apt-get install cmake
http://www.voweber.com/news/news/detail/type_id/23/id/36
在ubuntu下使用源码包安装mysql