| At line 1 added 183 lines |
| [{TableOfContents}] |
|
| !!! 참고 URL |
| *[구굴링 결과중 하나|http://72.14.253.104/search?q=cache:iPHro3NqOmUJ:blogmeme.com/blog/index.php%3Fblog_code%3Dcomdemo%26article_id%3D463+p3006854_9204_LINUX.zip&hl=ko&gl=kr&ct=clnk&cd=1&lr=lang_ko&client=firefox] |
| *[오라클 9i설치|http://blog.empas.com/leejung0/read.html?a=6553024] |
| *[runinstall 에러 관련|http://www.soqool.com/servlet/board?cmd=view&cat=130&subcat=1310&seq=290&page=1&position=1] |
| *[래드햇9설치|http://suny1211.egloos.com/284113] |
| *[오랠리 래드햇9 설치 | http://linux.oreillynet.com/lpt/a/4141] |
| *[OTN문서|http://www.oracle.com/technology/global/kr/pub/articles/hunter_rac_3.html] |
| *[개인홈페이지 문서|http://ccc.mzin.net/lecture/linux/applications/oracle/9i-install.txt] |
|
| !!!ORACLE 9i설치(Redhat 9.0에서 테스트) |
|
| !! 오라클 Group과 유저 생성 |
| {{{ |
| groupadd dba |
| useradd -g dba oracle |
|
| passwd oracle |
|
| mkdir -p /usr/oracle/product/9.2 |
| mkdir /var/opt/oracle |
| chown oracle.dba /var/opt/oracle |
| chown -R oracle.dba /usr/oracle |
| chmod 755 /var/opt/oracle |
| }}} |
|
|
| !! 필수 패키지 설치 |
| {{{ |
| gcc-3.2.2-5 |
| cpp-3.2.2-5 |
| glibc-devel-2.3.2-11.9 |
| binutils-2.13.90.0.18-9 |
| compat-gcc-7.3-2.96.118.i386.rpm |
| compat-libgcj-7.3-2.96.118.i386.rpm |
| compat-libgcj-devel-7.3-2.96.118.i386.rpm |
| 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 100 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 |
| |
| 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 |
| |
| }}} |
|
|
|
|
| !! 환경 변수 설정 |
| {{{ |
| su - oracle |
| vi .bash_profile |
|
| # Oracle Environment |
| export ORACLE_BASE=/usr/oracle |
| export ORACLE_HOME=$ORACLE_BASE/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=$ORACLE_HOME/product/9.2/lib:$LD_LIBRARY_PATH |
| export PATH=$ORACLE_HOME/product/9.2/bin:$PATH |
| export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601; |
|
| }}} |
|
| !! XWindow 상에서 오라클 설치 |
| {{{ |
|
| 언어설정 (한글깨지는거 영문으로) |
| linux#]unset LANG |
|
| 다운로드 : http://www.oracle.com/technology/software/products/oracle9i/htdocs/linuxsoft.html |
| 다운 받은 파일의 압축을 풀어준다. |
| [oracle@localhost oracle]$ zcat ship_9204_linux_disk1.cpio.gz | cpio -idmv |
| [oracle@localhost oracle]$ zcat ship_9204_linux_disk2.cpio.gz | cpio -idmv |
| [oracle@localhost oracle]$ zcat ship_9204_linux_disk3.cpio.gz | cpio -idmv |
| }}} |
|
| !! runinstall수행시 다음과 같은 애러가 났을때 패치 |
|
| symbol __libc_wait, version GLIBC_2.0 not defined in file libc.so.6 with link time reference |
|
| {{{ |
| # su - root |
| # unzip p3006854_9204_LINUX.zip |
| Archive: p3006854_9204_LINUX.zip |
| creating: 3006854/ |
| inflating: 3006854/rhel3_pre_install.sh |
| inflating: 3006854/README.txt |
|
| # cd 3006854 |
| # sh rhel3_pre_install.sh |
| Applying patch... |
| Patch successfully applied |
| }}} |
|
| !! 리스너 생성 |
| {{{ |
| $/usr/oracle/product/9.2/bin/netmgr |
| #디렉토리 서비스 사용 안함 선택 |
| }}} |
|
|
| !! 데이터베이스 생성 |
| {{{ |
| $/usr/oracle/product/9.2/bin/dbca |
| new database 선택 |
| 데이터베이스명과 SID=ORCL |
| 정적선택 |
| 메모리는 기본을 선택 |
| }}} |
|
|
|
| !! 오라클 실행 |
| {{{ |
| [root@miniroko]# su - oracle |
| [oracle@miniroko oracle]$ lsnrctl start |
| [oracle@miniroko oracle]$ sqlplus /nolog |
| |
| SQL*Plus: Release 9.2.0.1.0 - Production on ?et Svi 29 13:52:34 2003 |
| |
| Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. |
| |
| SQL> connect / as sysdba |
| Connected to an idle instance. |
| SQL> startup |
| ORACLE instance started. |
| |
| Total System Global Area 93393176 bytes |
| Fixed Size 450840 bytes |
| Variable Size 75497472 bytes |
| Database Buffers 16777216 bytes |
| Redo Buffers 667648 bytes |
| Database mounted. |
| Database opened. |
| SQL> exit |
| }}} |
| |
| |
| !! 오라클 종료 |
| {{{ |
| [root@miniroko]# su - oracle |
| [oracle@miniroko oracle]$ lsnrctl stop |
| [oracle@miniroko oracle]$ sqlplus /nolog |
| |
| SQL*Plus: Release 9.2.0.1.0 - Production on ?et Svi 29 13:55:32 2003 |
| |
| Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. |
| |
| SQL> connect / as sysdba |
| Connected. |
| SQL> shutdown |
| Database closed. |
| Database dismounted. |
| ORACLE instance shut down. |
| SQL> exit |
| }}} |