Gentookorea: /* web interface */

2013-03-20T09:09:58Z

web interface

Onionmixer: Oracle11g For Gentoo 페이지 추가

2013-03-19T10:52:56Z

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

== 준비 ==

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

=== /opt/oracle/env ===

<pre>
#!/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
</pre>

=== 권한 ===

<pre>
cd /opt/oracle
chown -R oracle:oinstall .
</pre>

=== libstdc++.so.6 ===

* 링크가 잘못되어 있다.
<pre>
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 .
</pre>

=== DISPLAY ===

* 설치할 때만 필요하다.
* startx 에서 -no-listen tcp 를 뺀다. (X 재시동 필요)<pre>xhost +</pre>

== 설치 ==

=== 실행 ===

* 압축해제
<pre>
su - oracle
cd unzipped directory
source /opt/oracle/env
export DISPLAY=:0.0
./runInstaller -ignoreSysPrereqs</pre>
* http://kekedie.tistory.com/tag/ubuntu GUI 옵션 스샷참조

=== 오류 ===

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

<pre>
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
</pre>

<pre>
bin/relink all
</pre>

== init ==

=== /etc/init.d/ora.database ===

<pre>
#!/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 $?
}
</pre>

=== /etc/init.d/ora.listener ===

<pre>
#!/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 $?
}
</pre>

=== /etc/init.d/ora.console ===

<pre>
#!/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 $?
}
</pre>

=== chmod ===

<pre>
chmod +x /etc/init.d/ora.*
</pre>

=== /etc/oratab ===

* N 을 Y 로 수정

== web interface ==
* https://localhost:1158/em/

[[Category:GenooKRDoc]]

← 이전 판		2013년 3월 20일 (수) 09:09 판
240번째 줄:		240번째 줄:


−	[[Category:~~GenooKRDoc~~]]	+	[[Category:GentooKRDoc]]

Oracle11g For Gentoo - 편집 역사

Gentookorea: /* web interface */

Onionmixer: Oracle11g For Gentoo 페이지 추가