博客out了吗?
|
解决java.lang.UnsatisfiedLinkError libXp.so.6找不到的问题
centos安装oracle 11g注意的问题
1.磁盘空间6G以上
2.创建用户和组
groupadd dba
groupadd oinstall
useradd -g oinstall -G oinstall,dba -d /home/oracle -m oracle
3.设置静态IP
4.修改或添加内核参数
vi /etc/sysctl.conf
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.sem =250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default =4194304
net.core.rmem_max =4194304
net.core.wmem_default = 262144
net.core.wmem_max = 262144
fs.file-max = 6553600
生效 /sbin/sysctl -p
5.修改 .bash_profile
export PATH=$PATH:$HOME/bin
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/11g
export ORA_CRS_HOME=$ORACLE_BASE/crs
export ORACLE_PATH=$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin
export ORACLE_SID=orcl1
export PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:${PATH}:$HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/oracm/lib:$ORACLE_HOME/lib
export LIBPATH=$LIBPATH:$ORA_CRS_HOME/lib:$ORACLE_HOME/lib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/jlib:$ORACLE_HOME/network/jlib:$ORACLE_HOME/JRE
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
export NLS_LANG=american_america.WE8ISO8859P1
alias sysdba="sqlplus '/as sysdba'"
export EDITOR=vi
6.使用yum安装一下文件
glibc-devel-2.3.9.4-2.19
libstdc++-devel-3.4.5-2
sysstat-5.0.5
unixODBC-2.2.11
unixODBC-devel-2.2.11
机器不同,缺的包可能也不一样,安装时看检测报告,缺什么一定要添加完毕之后再继续安装。
7.执行./runInstaller开始安装
8.测试
# sqlplus /nolog
SQL> conn / as sysdba
SQL> select * from scott.emp;
SQL> quit
9.修改 /etc/oratab
orcl1:/home/oracle/11g:Y
10.创建启动脚本
# !/bin/bash
ORACLE_DESC="Oracle 11g"
case "$1" in
'start')
echo "Starting ${ORACLE_DESC} "
lsnrctl start
dbstart $ORACLE_HOME
emctl start dbconsole
echo
;;
'stop')
echo "shutting down ${ORACLE_DESC}"
emctl stop dbconsole
lsnrctl stop
dbshut $ORACLE_HOME
echo
;;
'restart')
echo "restarting ${ORACLE_DESC}"
$0 stop
$0 start
echo
;;
*)
echo "usage: $0 { start | stop | restart }"
exit 1
esac
exit 0
分类: | (共有0条评论)



