Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-1) was last changed on 17-May-2021 01:15 by UnknownAuthor  

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

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
}}}
Version Date Modified Size Author Changes ... Change note
17-May-2021 01:15 4.536 kB UnknownAuthor
« This page (revision-) was last changed on 17-May-2021 01:15 by UnknownAuthor