oracle9i installation on fedora core 6

oracle linux install

fedora core 6
oracle 9i

参见文档

http://ivan.kartik.sk/oracle/install_ora9_fedora.html

google搜索关键字

Installation of Oracle 9i (R2) on Fedora Core Linux 2, 3, 4, 5 and 6

1. Create oracle User Account 建立oracle用户

 Login as root and create te user oracle which belongs to dba group.
 以root用户登录 建立组 授权oracle用户

 $su -
 # groupadd dba
 # useradd -g dba oracle

2. Setting System parameters 设置系统参数
 
 Edit the /etc/sysctl.conf and add following lines:
 编辑 /etc/sysctl.conf添加下列属性

 #vi /etc/sysctl.conf

 kernel.sem = 250 32000 100 128
 kernel.shmmax = 536870912
 kernel.shmmni = 4096
 kernel.shmall = 2097152
 kernel.msgmnb = 65536
 kernel.msgmni = 2878
 fs.file-max = 65536
 net.ipv4.ip_local_port_range = 1024 65000

 Note: You need execute "sysctl -p" or reboot system to apply above settings.
 注意：sysctl  -p 或者reboot上环境生效

 Edit the /etc/security/limits.conf file and add following lines:
 编辑 /etc/scurity/limits.conf 添加如下行

 #vi /etc/security/limits.conf

 * - nproc 16384
 * - nofile 16384

3. Setting Oracle Enviroment 设置oracle环境
 
 Edit the /home/oracle/.bash_profile file and add following lines:
 编辑 /home/oracle/.bash_profile 添加如下行

 Settings for Fedora Core 5 and 6 only.
 fc5,6设置如下 其中jre为你的路径ORACLE_SID自定义

 #vi /home/oracle/.bash_profile
 ORACLE_BASE=/opt/oracle
 ORACLE_HOME=$ORACLE_BASE/920
 ORACLE_SID=MY_ORACLE
 LD_LIBRARY_PATH=$ORACLE_HOME/lib
 ORACLE_OEM_JAVARUNTIME=/opt/jre1.3.1_15
 PATH=$PATH:$ORACLE_HOME/bin

 export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH ORACLE_OEM_JAVARUNTIME PATH

 Save the .bash_profile and execute following commands for load new enviroment:
 保存上环境生效

 #cd /home/oracle
 #. .bash_profile
 两点之间有空格

4. Create base directory for Oracle 创建一个oracle安装的目录

 Login as root and create base directory for Oracle ($ORACLE_BASE).
 以root用户登录创建一个目录

 su -
 # cd /opt
 # mkdir oracle
 # chown oracle:dba oracle

5、Download & Install
 
 1. Download and install required .rpm packages
 下载和安装
 
  a、 Some additional packages are required for succesful instalation of Oracle software. To check whether   required packages are installed on your operating system use following command:
  检查是否已安装有这些软件

  #rpm -q gcc glibc-headers glibc-kernheaders glibc-devel compat-libstdc++ cpp compat-gcc

  Note: You don't need glibc-kernheaders installed on FC6 as this package is not shipped with FC6.
  注意：glibc-kernheaders这个软件在fc6下可以不安装 compat-libstdc++我也没安装但最好还是安装成功了。

  b、 If some package is not installed download it from Fedora project website or direct from Core 2, Core 3,    Core 4, Core 5, Core 6 locations.
  如果有些包没有可以去fedora官方网站下载http://fedora.redhat.com/Download/
   compat-gcc-7.3-2.96.126.i386.rpm
  可以从这里下载 http://ivan.kartik.sk/oracle/download_from.php?site_id=2

 
  c、 For Fedora Core 4, 5 and 6 only:Install the required additional packages using the rpm command:
  安装下面几个包

  # rpm -ivh compat-libgcc-296-2.96-___.rpm \
  compat-libstdc++-33-3.2.3-___.rpm \
  compat-libstdc++-296-2.96-___.rpm

 2. Download the Java Runtime Enviroment (j2re-1_3_1_15-linux-i586.bin) from the Sun website. Keep in mind you need    to download j2re1.3.1_11 or higher (Note: Install JRE 1.3.1_1x version only).
  注意：下载jre jre1.3.1_1x 其中x为任意，但前面的版本不可改。
 
  Login as root and make the the file executable and then execute it. When the JRE is exracted move the    "jre1.3.1_15" di rectory to "/opt" directory.
  以root用户的登录执行下面的

  # chmod +x j2re-1_3_1_19-linux-i586.bin
  # ./j2re-1_3_1_19-linux-i586.bin

  # mv jre1.3.1_19 /opt/

 3. Download the Oracle 9i (9.2.0.4) software from Oracle website.
  Extract the files using following command:
  下载解压

  #gunzip ship_9204_linux_disk1.cpio.gz
  #gunzip ship_9204_linux_disk2.cpio.gz
  #gunzip ship_9204_linux_disk3.cpio.gz

  #cpio -idmv < ship_9204_linux_disk1.cpio
  #cpio -idmv < ship_9204_linux_disk2.cpio
  #cpio -idmv < ship_9204_linux_disk3.cpio

  When all archives were extracted you've got three directories Disk1, Disk2 and Disk3.
  Edit the Disk1/install/linux/oraparam.ini and modify JRE_LOCATION variable and set path to our JRE    installation from Step 2.
  解压后可以得到Disk1, Disk2 and Disk3三个文件夹然后修改Disk1/install/linux/oraparam.ini
 
  JRE_LOCATION=/opt/jre1.3.1_19

 4. Start the Oracle software installation process.

  Now the system is prepared for Oracle software installation. To start the installation process execute the    following commands:

  准备好后开始安装注销以oracle用户登录安装

  cd Disk1
  ./runInstaller

  When network configuration assistant and database configuration assistant has failed during startup then do    following steps:
  当网络助手配置助手启动失败后执行下边

  #cd /opt/oracle/920
  #rm JRE
  #ln -s /opt/jre1.3.1_15 JRE
  #su -
  # cd /opt/oracle/920/JRE/bin
  # ln -s java jre
  # cd i386/native_threads
  # ln -s java jre

*****Common Installation Errors***********
常见错误以及解决方法
*************************************************************************************************************************
 Unable to load native library: /tmp/OraInstall2005-01-08_11-11-34AM/jre/lib/i386/libjava.so: symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference
------------------------------------------------------------------------------------------------------------------------
 Solution: Install new JRE 1.3.1 version. Edit the Disk1/install/linux/oraparam.ini and set path to new JRE for JRE_LOCATION variable. For more information see Download & Install section.
************************************************************************************************************************

 /tmp/OraInstall2005-04-26_11-38-19AM/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
------------------------------------------------------------------------------------------------------------------------
Solution: Install the xorg-x11-deprecated-libs package (for >=FC4 versions). For FC5 and later install libXp package.
************************************************************************************************************************

 /tmp/OraInstall2005-06-14_03-46-25PM/jre/bin/i386/native_threads/java: error while loading shared libraries: /tmp/OraInstall2005-06-14_03-46-25PM/jre/lib/i386/native_threads/libhpi.so: cannot restore segment prot after reloc: Permission denied
------------------------------------------------------------------------------------------------------------------------
 Solution: Modify /etc/selinux/config and change value of SELINUX to "disabled" and reboot computer.
************************************************************************************************************************

 Starting Oracle Intelligent Agent.../opt/oracle/920/bin/dbsnmpwd: line 156: 1393 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/920/bin/dbsnmpwd: line 156: 1405 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/920/bin/dbsnmpwd: line 156: 1416 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/920/bin/dbsnmpwd: line 156: 1427 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
------------------------------------------------------------------------------------------------------------------------
 Solution: Download and apply patch nr.: 3238244 from http://metalink.oracle.com.
************************************************************************************************************************

 Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using 'localhost:0.0' as the value of the DISPLAY variable.
---------------------------------------------------------------------------------------------------------------------------
 Solution: Execute "export DISPLAY=:0.0" (as oracle user) and "xhost +" as user who has opened X session (for example logged in KDE, GNOME, etc.). If the value is other than 127.0.0.1 or localhost you should "xhost +" on client machine.
************************************************************************************************************************

 Error in invoking target install of makefile /opt/oracle/920/ctx/lib/ins_ctx.mk
Error in invoking target install of makefile /opt/oracle/920/precomp/lib/ins_precomp.mk
Error in invoking target install of makefile /opt/oracle/920/plsql/lib/ins_plsql.mk
Error in invoking ntcontab.o of makfile /opt/oracle/920/network/lib/ins_net_client.mk
************************************************************************************************************************

 Solution: Install the compat-gcc-7.3-2.96.126.i386.rpm (gcc 2.96) package and change the GCC binaries. For more information see Download & Install section. In case of Fedora Core 5 take look at next error message.

sed: -e expression #1, char 7: unterminated `s' command error in $ORACLE_HOME/install/make.log
------------------------------------------------------------------------------------------------------------------------
 Solution: There is probably bug in bash (FC5 only). Download and install bash package from FC4. I have prepared this package (builded from FC4 src.rpm) for FC5 - Download.
Install it using "rpm -ivh bash-3.0-31.i386.rpm --force".
************************************************************************************************************************

 Initializing Java Virtual Machine from /tmp/OraInstall2006-10-25_01-43-30PM/jre/bin/java. Please wait... /tmp/OraInstall2006-10-25_01-43-30PM/jre/bin/i386/native_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory - after ./runInstaller execution.
------------------------------------------------------------------------------------------------------------------------
 Solution:
su -
# cd /usr/lib
# ln -s libstdc++-3-libc6.2-2-2.10.0.so libstdc++-libc6.1-1.so.2

Start ./runInstaller again.

中间出现错误的话：没有在一上的错误信息。则
按照错误信息提示：如果提示需要就新开个终端执行脚本，需要敲如如：/usr/bin敲入安装它的提示照抄就行了。

修改oracle配置：

 注意：sid jre jre版本 路径名称 Disk1里面那个文件的路径 fc2 3 4 和fc5 fc6的步骤 防火墙设置 端口

 $dbca新增个数据库

 $netmgr网络管理

 $netca

$oracle_home/920/network/admin/listener.ora修改如下

SID只需要SID_NAME ORACLE_HOME两个参数
LISTENER需要修改host为 ip

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORACLE)
      (ORACLE_HOME = /opt/oracle/920)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
      )
    )
  )

 

启动监听：
 $lsnrctl start
打开sqlplus

 $sqlplus /nolog
连接
 $connect / as sysdba
启动
 $startup