《Oracle9 在 RedHat9 上完全安装手册》 RedHat 9 语言En,中文 ,默认中文, Text 方式登陆 使用root登陆
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle mkdir -p /opt/ora9/product/9.2
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chown -R oracle.dba /opt/ora9
chown -R oracle.dba /var/opt/oracle cd /mnt/cdrom
cd RedHat
cd RPMS
rpm -ivh compat-gcc-7.3-2.96.118.i386.rpm
rpm -ivh compat-libgcj-7.3-2.96.118.i386.rpm
rpm -ivh compat-libgcj-devel-7.3-2.96.118.i386.rpm
rpm -ivh nss_db-compat-2.2-20.i386.rpm vi /etc/sysctl.conf
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 128 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000 vi /etc/security/limits.conf
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384 ##解开压缩文件:
$gunzip Linux9i_Disk1.cpio.gz Linux9i_Disk2.cpio.gz Linux9i_Disk3.cpio.gz
##解开打包文件(你下载的文件文件名字可能和我的有少许不同):
cpio -idmv < Linux9i_withjre_Disk1.cpio
cpio -idmv < Linux9i_nojre_Disk2.cpio
cpio -idmv < Linux9i_nojre_Disk3.cpio
#解开后,会生成Disk1、Disk2、Disk3三个目录
reboot
使用oracle用户登陆su到root
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range #oracle 9i
回到oracle用户
(su - oracle)
vi ~/.bashrc 创建一个文件 #vi .bashrc (在oracle用户当前的目录下)
export ORACLE_BASE=/opt/ora9
export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID= ora9
export ORACLE_TERM=vt100
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=/opt/ora9/product/9.2/lib:$LD_LIBRARY_PATH
export PATH=/opt/ora9/product/9.2/bin:$PATH
#export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
export NLS_LANG=' AMERICAN_AMERICA.US7ASCII '用oracle登入kde(startx) su - (切换到root用户)
xhost + (进入kde界面)
exit
用oracle身份运行./runInstaller
安装的时候报错:cannot execute binary file
解决方法: bash-2.05b-5.src.rpm
Upgrade to bash version 2.05.
It can be downloaded from GNU's website http://www.gnu.org
#rpm –ivh bash-2.05b-5.src.rpm注意:选择创建自定义数据库
即将出现的错误会有两个:
1 . 关于“ins_oemagent.mk” ,选择ignore,我们将在postinstallation修复它。
2 . 关于“$ORACLE_HOME/ctx/lib/ins_ctx.mk” ,当出现这个情况的时候,我们打开一个console,使用oracle操作。 cd $ORACLE_HOME/bin
gcc -o ctxhx -L/opt/ora9/product/9.2/ctx/lib/ -L/opt/ora9/product/9.2/lib/ -L/opt/ora9/product/9.2/lib/stubs/ /opt/ora9/product/9.2/ctx/lib/ctxhx.o -L/opt/ora9/product/9.2/ctx/lib/ -lm -lsc_ca -lsc_fa -lsc_ex -lsc_da -lsc_ut -lsc_ch -lsc_fi -lctxhx -lc -Wl,-rpath,/opt/ora9/product/9.2/ctx/lib -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -ldl 选择ignore继续安装。 安装oracle 成功,netconfig配置完成后,不能正常关闭,console提示退出代码“0”,因此下一个dbca界面不能弹出来,只能手工创建数据库。
打开一个console,运行dbca (我选择的是new database,晕倒,我p3 800 1G 的机器居然用了3个半小时才创建完毕。如果没有特殊需要就选择数据仓库吧,创 建很快的。)
. Postinstall
---------------------------
Open up a console and login as oracle user. Execute these lines:
打开一个新的console,使用oracle用户登陆
cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk install
vi $ORACLE_HOME/ctx/lib/ins_ctx.mk
把
ctxhx: $(CTXHXOBJ)
$(LINK) $(CTXHXOBJ) $(INSO_LINK)
改成
ctxhx: $(CTXHXOBJ)
$(LINK) -ldl $(CTXHXOBJ) $(INSO_LINK) 然后
make -f $ORACLE_HOME/ctx/lib/ins_ctx.mk install 最后
做一个启动脚本:
vi /etc/rc.d/init.d/ora9
#!/bin/bash
#
# (c) [email protected]
#
# name: /etc/rc.d/init.d/ora9
# description: starts and stops oracle 9i database, TNS listener
# http server, and fixes kernel parameters for oracle
#oracle environment export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
###export NLS_LANG='SIMPLIFIED CHINESE.ZHS16GBK'
export ORACLE_SID=gaokao
export DISPLAY=:0
oracle_user=oracle # see how we're called case $1 in
start)
# fix kernel parameters
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/kernel/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
# start listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl start
apachectl start
sqlplus /nolog<<EOS
connect / as sysdba
startup
EOS
EOO
;; stop)
# stop listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl stop
apachectl stop
sqlplus /nolog<<EOS
connect / as sysdba
shutdown immediate
EOS
EOO
;; *)
echo "Usage: ora9 [start|stop]"
;; esac 现在用ln -s /etc/rc.d/init.d/ora9 /etc/rc3.d/S98ora9 加入到启动脚本里面。 (各位:如果我想在输入init 0 时,系统会自动去关闭数据库后再关机,我因该如何做呢?请给位来信告诉我。[email protected])
参考:http://codah.net/install-oracle9iR2-on-redhat9.html
(完全按照这个E文的来做,会有权限问题的)
03-05-29 00:32
fable_cao
中级会员
注册日期: 2001 Dec
来自: 上海
发帖数量: 134 一个建议:
你把写的脚本分成两份
vi /etc/rc.d/init.d/ora9start
#!/bin/bash
#
# (c) [email protected]
#
# name: /etc/rc.d/init.d/ora9
# description: starts and stops oracle 9i database, TNS listener
# http server, and fixes kernel parameters for oracle
#oracle environment export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
###export NLS_LANG='SIMPLIFIED CHINESE.ZHS16GBK'
export ORACLE_SID=gaokao
export DISPLAY=:0
oracle_user=oracle # fix kernel parameters
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/kernel/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
# start listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl start
apachectl start
sqlplus /nolog<<EOS
connect / as sysdba
startup
EOS
EOO
;; ln -s /etc/rc.d/init.d/ora9start /etc/rc3.d/S98ora9 vi /etc/rc.d/init.d/ora9stop
#!/bin/bash
#
# (c) [email protected]
#
# name: /etc/rc.d/init.d/ora9
# description: starts and stops oracle 9i database, TNS listener
# http server, and fixes kernel parameters for oracle
#oracle environment export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
###export NLS_LANG='SIMPLIFIED CHINESE.ZHS16GBK'
export ORACLE_SID=gaokao
export DISPLAY=:0
oracle_user=oracle # fix kernel parameters
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/kernel/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range # stop listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl stop
apachectl stop
sqlplus /nolog<<EOS
connect / as sysdba
shutdown immediate
EOS
EOO
;; ln -s /etc/rc.d/init.d/ora9stop /etc/rc0.d/K02ora9 shell脚本不是很熟悉,如有谬误,请见谅
参考以下详细文档:
http://linux.oreillynet.com/lpt/a/4141
groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle
passwd oracle mkdir -p /opt/ora9/product/9.2
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle
chown -R oracle.dba /opt/ora9
chown -R oracle.dba /var/opt/oracle cd /mnt/cdrom
cd RedHat
cd RPMS
rpm -ivh compat-gcc-7.3-2.96.118.i386.rpm
rpm -ivh compat-libgcj-7.3-2.96.118.i386.rpm
rpm -ivh compat-libgcj-devel-7.3-2.96.118.i386.rpm
rpm -ivh nss_db-compat-2.2-20.i386.rpm vi /etc/sysctl.conf
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 250 32000 128 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000 vi /etc/security/limits.conf
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384 ##解开压缩文件:
$gunzip Linux9i_Disk1.cpio.gz Linux9i_Disk2.cpio.gz Linux9i_Disk3.cpio.gz
##解开打包文件(你下载的文件文件名字可能和我的有少许不同):
cpio -idmv < Linux9i_withjre_Disk1.cpio
cpio -idmv < Linux9i_nojre_Disk2.cpio
cpio -idmv < Linux9i_nojre_Disk3.cpio
#解开后,会生成Disk1、Disk2、Disk3三个目录
reboot
使用oracle用户登陆su到root
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range #oracle 9i
回到oracle用户
(su - oracle)
vi ~/.bashrc 创建一个文件 #vi .bashrc (在oracle用户当前的目录下)
export ORACLE_BASE=/opt/ora9
export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export ORACLE_OWNER=oracle
export ORACLE_SID= ora9
export ORACLE_TERM=vt100
export LD_ASSUME_KERNEL=2.4.1
export THREADS_FLAG=native
export LD_LIBRARY_PATH=/opt/ora9/product/9.2/lib:$LD_LIBRARY_PATH
export PATH=/opt/ora9/product/9.2/bin:$PATH
#export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
export NLS_LANG=' AMERICAN_AMERICA.US7ASCII '用oracle登入kde(startx) su - (切换到root用户)
xhost + (进入kde界面)
exit
用oracle身份运行./runInstaller
安装的时候报错:cannot execute binary file
解决方法: bash-2.05b-5.src.rpm
Upgrade to bash version 2.05.
It can be downloaded from GNU's website http://www.gnu.org
#rpm –ivh bash-2.05b-5.src.rpm注意:选择创建自定义数据库
即将出现的错误会有两个:
1 . 关于“ins_oemagent.mk” ,选择ignore,我们将在postinstallation修复它。
2 . 关于“$ORACLE_HOME/ctx/lib/ins_ctx.mk” ,当出现这个情况的时候,我们打开一个console,使用oracle操作。 cd $ORACLE_HOME/bin
gcc -o ctxhx -L/opt/ora9/product/9.2/ctx/lib/ -L/opt/ora9/product/9.2/lib/ -L/opt/ora9/product/9.2/lib/stubs/ /opt/ora9/product/9.2/ctx/lib/ctxhx.o -L/opt/ora9/product/9.2/ctx/lib/ -lm -lsc_ca -lsc_fa -lsc_ex -lsc_da -lsc_ut -lsc_ch -lsc_fi -lctxhx -lc -Wl,-rpath,/opt/ora9/product/9.2/ctx/lib -lnls9 -lcore9 -lnls9 -lcore9 -lnls9 -lxml9 -lcore9 -lunls9 -lnls9 -ldl 选择ignore继续安装。 安装oracle 成功,netconfig配置完成后,不能正常关闭,console提示退出代码“0”,因此下一个dbca界面不能弹出来,只能手工创建数据库。
打开一个console,运行dbca (我选择的是new database,晕倒,我p3 800 1G 的机器居然用了3个半小时才创建完毕。如果没有特殊需要就选择数据仓库吧,创 建很快的。)
. Postinstall
---------------------------
Open up a console and login as oracle user. Execute these lines:
打开一个新的console,使用oracle用户登陆
cd $ORACLE_HOME/network/lib
make -f ins_net_client.mk install
vi $ORACLE_HOME/ctx/lib/ins_ctx.mk
把
ctxhx: $(CTXHXOBJ)
$(LINK) $(CTXHXOBJ) $(INSO_LINK)
改成
ctxhx: $(CTXHXOBJ)
$(LINK) -ldl $(CTXHXOBJ) $(INSO_LINK) 然后
make -f $ORACLE_HOME/ctx/lib/ins_ctx.mk install 最后
做一个启动脚本:
vi /etc/rc.d/init.d/ora9
#!/bin/bash
#
# (c) [email protected]
#
# name: /etc/rc.d/init.d/ora9
# description: starts and stops oracle 9i database, TNS listener
# http server, and fixes kernel parameters for oracle
#oracle environment export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
###export NLS_LANG='SIMPLIFIED CHINESE.ZHS16GBK'
export ORACLE_SID=gaokao
export DISPLAY=:0
oracle_user=oracle # see how we're called case $1 in
start)
# fix kernel parameters
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/kernel/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
# start listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl start
apachectl start
sqlplus /nolog<<EOS
connect / as sysdba
startup
EOS
EOO
;; stop)
# stop listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl stop
apachectl stop
sqlplus /nolog<<EOS
connect / as sysdba
shutdown immediate
EOS
EOO
;; *)
echo "Usage: ora9 [start|stop]"
;; esac 现在用ln -s /etc/rc.d/init.d/ora9 /etc/rc3.d/S98ora9 加入到启动脚本里面。 (各位:如果我想在输入init 0 时,系统会自动去关闭数据库后再关机,我因该如何做呢?请给位来信告诉我。[email protected])
参考:http://codah.net/install-oracle9iR2-on-redhat9.html
(完全按照这个E文的来做,会有权限问题的)
03-05-29 00:32
fable_cao
中级会员
注册日期: 2001 Dec
来自: 上海
发帖数量: 134 一个建议:
你把写的脚本分成两份
vi /etc/rc.d/init.d/ora9start
#!/bin/bash
#
# (c) [email protected]
#
# name: /etc/rc.d/init.d/ora9
# description: starts and stops oracle 9i database, TNS listener
# http server, and fixes kernel parameters for oracle
#oracle environment export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
###export NLS_LANG='SIMPLIFIED CHINESE.ZHS16GBK'
export ORACLE_SID=gaokao
export DISPLAY=:0
oracle_user=oracle # fix kernel parameters
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/kernel/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
# start listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl start
apachectl start
sqlplus /nolog<<EOS
connect / as sysdba
startup
EOS
EOO
;; ln -s /etc/rc.d/init.d/ora9start /etc/rc3.d/S98ora9 vi /etc/rc.d/init.d/ora9stop
#!/bin/bash
#
# (c) [email protected]
#
# name: /etc/rc.d/init.d/ora9
# description: starts and stops oracle 9i database, TNS listener
# http server, and fixes kernel parameters for oracle
#oracle environment export ORACLE_HOME=/opt/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export NLS_LANG='SIMPLIFIED CHINESE.ZHS16CGB231280'
###export NLS_LANG='SIMPLIFIED CHINESE.ZHS16GBK'
export ORACLE_SID=gaokao
export DISPLAY=:0
oracle_user=oracle # fix kernel parameters
echo 250 32000 100 128 > /proc/sys/kernel/sem
echo 536870912 > /proc/sys/kernel/shmmax
echo 4096 > /proc/sys/kernel/shmmni
echo 2097152 > /proc/sys/kernel/shmall
echo 65536 > /proc/sys/kernel/fs/file-max
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range # stop listener, apache and database
su - "$oracle_user"<<EOO
lsnrctl stop
apachectl stop
sqlplus /nolog<<EOS
connect / as sysdba
shutdown immediate
EOS
EOO
;; ln -s /etc/rc.d/init.d/ora9stop /etc/rc0.d/K02ora9 shell脚本不是很熟悉,如有谬误,请见谅
参考以下详细文档:
http://linux.oreillynet.com/lpt/a/4141
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货