Chinaunix首页 | 论坛 | 博客
  • 博客访问: 89746
  • 博文数量: 28
  • 博客积分: 1400
  • 博客等级: 上尉
  • 技术积分: 280
  • 用 户 组: 普通用户
  • 注册时间: 2009-07-14 21:55
文章分类

全部博文(28)

文章存档

2011年(1)

2010年(13)

2009年(14)

我的朋友

分类: Oracle

2009-11-26 16:36:20

            How to install oracle 10g R2 (10.2.0.1) on SUSE linux enterprise server
[refer to documents of NOVELL site]
1. required software
    1). SUSE linux enterprise server 10 sp3
    2). ORACLE Database 10 Release 2 (10.2.0.1) Enterprise Edition
    3). Oracle Server Base (orarun)
    4). C/C++ compliler

2. requirements
    1). make sure enough space of disk
    2). verify SuSE-release. Modify as follows
    #vi /etc/SuSE-release
    SUSE Linux Enterprise Server 10 (x86_64)
    VERSION = 10
    [modify it, set all 10 to 9]
    3). verify hostname, coordinated server's IP with hostname, as follows:
    #vi /etc/hosts
    *.*.*.*        $HOSTNAME
    4). After install orarun, the user oracle will be set. Make sure user oracle has the characteristic as bellows:
    uid < 500, default group = oinstall, secondily group = dba, bash = /bin/bash, [home = /opt/oracle]
    5). Change file "/etc/profile.d/orale.sh"
    set ORACLE_BASE=/opt/oracle
    set ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1
    set ORACLE_SID=***    [your preferred name, and it is very important!(That night I was hurt by it)]
    6). Run "/usr/sbin/rcoracle start" to modify kernel parameters

3. install
    1). log on as user "oracle"
    2). decompression Oracle 10g R2
    #gunzip 10201_database_linux_x86_67.cpio.gz
    #cpio -idmv < 10201_database_linux_x86_67.cpio
//    3). Can modify "data/base/install/opaparam.ini" to support SuSe edition 10
    4). ./sunInstaller -ignoreSysPrereqs.

4. remove
    1). remove /usr/local/bin/{coraenv, dbhome, oraenv}
    2). remove /etc/oratab, /etc/oracle, /etc/oracle/
    3). remove /opt/oracle/

5. Oracle database start at boot time
    1). #vi /etc/sysconfig/oracle
     set parameter START_ORACLE_DB="yes"
     set parameter START_ORACLE_DB_LISTENER="yes"
     [set parameter START_ORACLE_DB_EMANAGER="yes"]
    2). #vi /etc/oratab
     set entery corressponding to the database to "Y"
    3). #vi $ORACLE_HOME/bin/dbstart $ORACLE_HOME/bin/dbshut $ORACLE_HOME/bin/dbhome
     set scripts to reflect correct location for ORATAB entry
     ORATAB=/etc/oratab
//    4). May be the parameter ORACLE_HOME will be modify in specified scriptfile.

6. test
    1). server
     $sqlplus /nolog
     SQL> conn / as sysdba
     SQL> startup/shutdown
    2). client
     $sqlplus sys/$pwd@$database as sysdba
     ...
阅读(1255) | 评论(0) | 转发(1) |
给主人留下些什么吧!~~