服务器维护,服务器代维,安全设置,漏洞扫描,入侵检测服务

dirtysea 发表于 2010-12-21 10:23:10

Centos 5.5安装oracle 10G数据库

操作系统版本CentOS release 5.5 (Final) 64bit
数据库版本Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 64bit
一、依赖包
如果在安装操作系统时,没有安装以下的依赖包,可以用yum yum groupinstall命令再次安装
yum groupinstall “Administration Tools”
yum groupinstall “Base”
yum groupinstall “Development Libraries”
yum groupinstall “Development Tools”
yum groupinstall “Editors”
yum groupinstall “GNOME Desktop Environment”
yum groupinstall “Graphical Internet”
yum groupinstall “Legacy Software Development”
yum groupinstall “Legacy Software Support”
yum groupinstall “Network Server”
yum groupinstall “Server Configuration Tools”
yum groupinstall “System Tools”
yum groupinstall “Text-based Internet”
yum groupinstall “X Window System”
libXp.i386 图形依赖包,如果不安装会导致系统报错libawt.so libxp.so不能找到
yum install -y libXp.i386
二、修改系统配置文件
1、/etc/hosts
192.168.0.1 oracle10g.localdomain oracle10g
2、/etc/sysctl.conf
#kernel.shmall = 2097152#kernel.shmmax = 2147483648kernel.shmmni = 4096# semaphores: semmsl, semmns, semopm, semmnikernel.sem = 250 32000 100 128#fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=262144net.core.rmem_max=262144net.core.wmem_default=262144net.core.wmem_max=262144

执行sysctl -p,使内核参数生效。
3、/etc/security/limits.conf
*               soft    nproc   2047*               hard    nproc   16384*               soft    nofile1024*               hard    nofile65536

三、oracle用户、组、环境
groupadd oinstall
groupadd dba
groupadd oper
useradd -g oinstall -G dba oracle
passwd oracle
编辑oracle用户环境变量
/home/oracle/.bash_profile
# Oracle SettingsTMP=/tmp; export TMPTMPDIR=$TMP; export TMPDIR ORACLE_BASE=/home/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOMEORACLE_SID=orcl; export ORACLE_SIDORACLE_TERM=xterm; export ORACLE_TERMPATH=/usr/sbin:$PATH; export PATHPATH=$ORACLE_HOME/bin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH if [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; then    ulimit -p 16384    ulimit -n 65536else    ulimit -u 16384 -n 65536fifi

四、修改标识
/etc/redhat-release
CentOS release 5.5 (Final) => redhat-4
为的是骗过oracle安装检查,安装完oracle别忘记改回来!
五、下载、解压
su – oracle
wget 10201_database_linux_x86_64.cpio.gz
gzip -dc 10201_database_linux_x86_64.cpio.gz | cpio -idmv
六、安装
1、GUI模式
su – oracle
cd /home/oracle/database
./runInstaller
按提示安装即可
2、silent模式
su – oracle
cd /home/oracle/database

安装数据库软件
./runInstaller -silent -responseFile /home/oracle/database/response/enterprise.rsp ORACLE_HOME=/home/oracle/product/10.2.0/db_1 ORACLE_HOME_NAME=orcl n_configurationOption=3
以root权限执行以下两条语句
/home/oracle/oraInventory/orainstRoot.sh
/home/oracle/product/10.2.0/db_1/root.sh
建立数据库实例orcl
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname ORCL -sid ORCL -responseFile NO_VALUE -sysPassword passwd -systemPassword passwd -characterSet AL32UTF8 -memoryPercentage 70

删除数据库实例orcl
dbca -silent -deleteDatabase -sourceDB ORCL
七、修改数据库运行脚本、建立自启动
sed -i “s/\/ade\/vikrkuma_new\/oracle/\$ORACLE_HOME/g” /home/oracle/product/10.2.0/db_1/bin/dbstart
vim /etc/oratab
ORCL:/home/oracle/product/10.2.0/db_1:N
=>
ORCL:/home/oracle/product/10.2.0/db_1:Y
echo “su – oracle -c dbstart” >> /etc/rc.local
dbstart

dirtysea 发表于 2010-12-21 10:25:58

oracle 10g em 按钮乱码解决 <BR><BR><BR>
<P>修改jdk 下面的字体。</P>
<BLOCKQUOTE>
<P>$ cd $ORACLE_HOME/jdk/jre/lib/<BR>$ mv font.properties font.properties_bak<BR>$ cp font.properties.zh_CN.Redhat font.properties </P></BLOCKQUOTE>
<P>修改jre 下面的字体</P>
<BLOCKQUOTE>
<P>$ cd $ORACLE_HOME/jre/1.4.2/lib<BR>$ mv font.properties font.properties_bak<BR>$ cp font.properties.zh_CN.Redhat font.properties </P></BLOCKQUOTE>
<P>清除em的cache</P>
<BLOCKQUOTE>
<P>$ cd $ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs<BR>$ rm *.gif </P></BLOCKQUOTE>
<P>重启em</P>
<BLOCKQUOTE>
<P>$ emctl stop dbconsole<BR>$ emctl start dbconsole </P></BLOCKQUOTE><BR>
页: [1]
查看完整版本: Centos 5.5安装oracle 10G数据库