Oracle11g For Gentoo

Oracle11g For Gentoo

Oracle11g For Gentoo

• 실행 되는듯.

참고

• http://gentoo-wiki.com/HOWTO_Install_Oracle_10g
• http://kekedie.tistory.com/tag/ubuntu
• http://zarick.blogspot.com/search/label/oracle
• http://ubuntuforums.org/showthread.php?t=592064

준비

mkdir /opt/oracle/oraInventory -p
groupadd dba
groupadd oinstall
useradd -m oracle -g oinstall -G dba -s /bin/bash -d /opt/oracle

/opt/oracle/env

#!/bin/bash
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/11.1.0.6.0
export ORACLE_SID=orcl11
export ORACLE_OWNER=oracle
export oraInventory=$ORACLE_HOME/oraInventory
export PATH=$PATH:$ORACLE_HOME/bin
export LANG=C
export LC_ALL=C

권한

cd /opt/oracle
chown -R oracle:oinstall .

libstdc++.so.6

• 링크가 잘못되어 있다.

cd /usr/lib64
ln -sf /usr/lib/gcc/x86_64-pc-linux-gnu/4.3.1/libstdc++.so.6 .
cd /usr/lib32
ln -sf /usr/lib/gcc/x86_64-pc-linux-gnu/4.3.1/32/libstdc++.so.6 .

DISPLAY

• 설치할 때만 필요하다.
• startx 에서 -no-listen tcp 를 뺀다. (X 재시동 필요)

  xhost +

설치

실행

• 압축해제

su - oracle
cd unzipped directory
source /opt/oracle/env
export DISPLAY=:0.0
./runInstaller -ignoreSysPrereqs

• http://kekedie.tistory.com/tag/ubuntu GUI 옵션 스샷참조

오류

• 오류가 발생하면 아래를 실행한 후 Retry 를 한다.
• 절대 GUI 를 종료하지 않는다.

cd $ORACLE_HOME
sed -ie 's/$/ -lrt/' lib/sysliblist
sed -ie 's/$/ -lrt/' lib32/sysliblist
perl -pi -e 's/(LDFLAGS32=.*?@)/$1 -L\/usr\/lib32/g' ctx/lib/env_ctx.mk
perl -pi -e 's/(REDEFINES32=.*?@)/$1 -L\/usr\/lib32/g' rdbms/lib/env_rdbms.mk
perl -pi -e 's/(LD="gcc.*?relax)/$1 ${USRLIB32}/g' bin/genclntsh
perl -pi -e 's/(LD="gcc.*?relax)/$1 \${USRLIB32}/g' bin/genclntsh
perl -pi -e 's/(NON64_LDOPT=\n)/$1USRLIB32=\n/g' bin/genagtsh
perl -pi -e 's/(NON64_LDOPT=.*?"\n)/$1USRLIB32=-L\/usr\/lib32\n/g' bin/genagtsh
perl -pi -e 's/(LD="gcc.*?shared)/$1 \${USRLIB32}/g' bin/genagtsh

bin/relink all

init

/etc/init.d/ora.database

#!/sbin/runscript
# ----------------------------------------------------------------------
# File:    /etc/init.d/ora.database
# Purpose:  Startup Oracle Database(s) defined in /etc/oratab
# ----------------------------------------------------------------------

depend() {
	use logger
    need net hostname clock
}

start() {
	source /opt/oracle/env

    if [ ! -f $ORACLE_HOME/bin/dbstart ]
    then
        ewarn "Oracle not started (no dbstart script)"
        return 1
    fi

    ebegin "Starting Oracle"
    /bin/su - $ORACLE_OWNER -c "source /opt/oracle/env; $ORACLE_HOME/bin/dbstart" >> /dev/null
    eend $?
}

stop() {
	source /opt/oracle/env

    if [ ! -f $ORACLE_HOME/bin/dbshut ]
    then
        ewarn "Oracle not stopped (no dbshut script)"
        return 1
    fi

    ebegin "Stopping Oracle"
    /bin/su - $ORACLE_OWNER -c "source /opt/oracle/env; $ORACLE_HOME/bin/dbshut" >> /dev/null
    eend $?
}

/etc/init.d/ora.listener

#!/sbin/runscript
#----------------------------------------------------------------------
# file /etc/init.d/ora.listener
# Startup Oracle Listeners
# ----------------------------------------------------------------------

depend() {
    need net
    after ora.database
}

start() {
	source /opt/oracle/env
    ebegin "Start Oracle Listeners"
    /bin/su $ORACLE_OWNER -c "source /opt/oracle/env; $ORACLE_HOME/bin/lsnrctl start LISTENER" >> /dev/null
    eend $?
}

stop() {
	source /opt/oracle/env
    ebegin "Stopping Oracle Listeners"
    /bin/su $ORACLE_OWNER -c "source /opt/oracle/env; $ORACLE_HOME/bin/lsnrctl stop LISTENER" >> /dev/null
    eend $?
}

/etc/init.d/ora.console

#!/sbin/runscript
# ----------------------------------------------------------------------
# File:    /etc/init.d/ora.console
# Purpose:  Startup Oracle Enterprise Manager DB Console and ISQL
# ----------------------------------------------------------------------

depend() {
    need net
    after ora.listener
}

start() {
	source /opt/oracle/env
    ebegin "Start Oracle Enterprise Manager DB Console"
    /bin/su $ORACLE_OWNER -c "source /opt/oracle/env; $ORACLE_HOME/bin/emctl start dbconsole" >> /dev/null
    #/bin/su $ORACLE_OWNER -c "$ORACLE_HOME/bin/isqlplusctl start"
    eend $?
}

stop() {
	source /opt/oracle/env
    ebegin "Stopping Oracle Enterprise Manager DB Console"
    /bin/su $ORACLE_OWNER -c "source /opt/oracle/env; $ORACLE_HOME/bin/emctl stop dbconsole" >> /dev/null
    #/bin/su $ORACLE_OWNER -c "$ORACLE_HOME/bin/isqlplusctl stop"
    eend $?
}

chmod

chmod +x /etc/init.d/ora.*

/etc/oratab

• N 을 Y 로 수정

web interface

• https://localhost:1158/em/