|
|
[ÀϹÝ] ·¹µåÇÞ ¿£ÅÍÇÁ¶óÀÌÁî4¿¡ ¿À¶óŬ9i(9.2.0.4)¼³Ä¡ |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:1817 |
|
|
·¹µåÇÞ ¿£ÅÍÇÁ¶óÀÌÁî4¿¡ ¿À¶óŬ9i(9.2.0.4)¼³Ä¡
Installing Oracle9iR2(9.2.0.4) on RH AS4
¸ñÂ÷
[1] oracle ´Ù¿î·Îµå ¹× ¾ÐÃàÇØÁ¦
[2] oracle À¯Àú»ý¼º ¹× ±ÇÇѺο©
[3] pre-install RPM
[4] jdk ¼³Ä¡
[5] °øÀ¯¸Þ¸ð¸® ¹× ¼¼¸¶Æ÷¼³Á¤
[6] ¿À¶óŬ»ç¿ëÀÚ ÃʱâÈÆÄÀϱ¸¼º
[7] ¿À¶óŬ ¼Â¾÷
[8] ¿¡·¯Á¶Ä¡
[9] TIP & TECH
[1] oracle ´Ù¿î·Îµå ¹× ¾ÐÃàÇØÁ¦
zcat ship_lnx_920_disk1.cpio.gz | cpio -idmv
zcat ship_lnx_920_disk2.cpio.gz | cpio -idmv
zcat ship_lnx_920_disk3.cpio.gz | cpio -idmv
Disk1, Disk2, Disk3 ÀÌ »ý±â°í »ý±ä ÆÄÀϵéÀº /home/oracle·Î À̵¿.
mv Disk* /home/oracle/
Âü°í. ¿À¶óŬ»çÁ¦°ø¾ÐÃàÇØÁ¦ ¹æ¹ý
Directions to extract the files
1. Run "gunzip <filename>" on all the files.
¿¹). gunzip ship_9204_linux_disk1.cpio.gz
2. Extract the cpio archives with the command "cpio -idmv < <filename>"
¿¹). cpio -idmv < ship_9204_linux_disk1.cpio
[2] oracle À¯Àú»ý¼º ¹× ±ÇÇѺο©
groupadd dba
useradd oracle -g dba
passwd oracle
mkdir /home/oracle
mkdir /home/oracle/oracle
mkdir /home/oracle/oracle/product
mkdir /home/oracle/oracle/product/9.2.0
pwd /home/oracle
chown -R oracle.dba /home/oracle
chmod 777 /home
chmod 777 /home/oracle
mkdir /var/opt/oracle
chown oracle.dba /var/opt/oracle/
chmod 755 /var/opt/oracle/
[3] pre-install RPM
¸µÅ©¿¡·¯¸¦ ¾ø¾Ö±â À§ÇØ »ðÁúÀ» °ÅµìÇÑ ³¡¿¡ RPM¿¡¼ °á·Ð¿¡ µµ´Þ.
ÆÐÅ°Áö ¼³Ä¡ À¯¹« È®ÀÎ
rpm -aq | grep packagenameÀ¸·Î ¾Ë¼ö ÀÖ½À´Ï´Ù.
¿¹). rpm -aq | grep compat-db-4.1.25-9
compat-db-4.1.25-9
compat-gcc-32-c++-3.2.3-47.3
compat-gcc-32-3.2.3-47.3
compat-libgcc-296-2.96-132.7.2
compat-libstdc++-296-2.96-132.7.2
compat-libstdc++-33-3.2.3-46.1
java-1.4.2-gcj-compat-1.4.2.0-26jpp
nss_db-compat-2.2-28
gnome-libs-1.4.1.2.90-44.1.i386.rpm
xorg-x11-deprecated-libs-devel-6.8.1-23.EL.i386.rpm
libaio-0.3.102-1
libaio-devel-0.3.102-1
libpng10-1.0.13-13.i386.rpm
sysstat-5.0.1-2.i386.rpm
openmotif21-2.1.30-9.i386.rpm
pdksh-5.2.14-24.i386.rpm
¾Æ·¡ µÎ ÆÄÀÏÀº ¸ÞŸ¸µÅ© p4198954_21_LINUX.zip ÆÐÄ¡ ¾È¿¡ µé¾îÀÖ½À´Ï´Ù.
compat-oracle-rhel4-1.0-5.i386.rpm
compat-libcwait-2.0-2.i386.rpm
RPM¼³Ä¡½Ã ÀÇÁ¸¼º¿¡ °É¸®´Â°Ç ´ç¿¬È÷ °°ÀÌ ¼³Ä¡.
rpm -iUvh packagename ¸í·É¾î·Î ¼³Ä¡
SuLinuxÀÇ °æ¿ì ¼³Ä¡ ÆÐÅ°Áö
http://ftp.superuser.co.kr/pub/SULinux/1.0/os/i386/SULinux/RPMS/
SuLinux´Â Centos±â¹ÝÀ̹ǷΠSuLinux¿¡ ¾ø´Â ÆÐÅ°Áö´Â Centos¿¡¼ °¡Á®¿Í¼ ¼³Ä¡
http://ftp.superuser.co.kr/pub/centos/4.2/os/i386/CentOS/RPMS/
compat-db-4.1.25-9.i386.rpm
compat-gcc-32-3.2.3-47.3.i386.rpm
compat-gcc-32-c++-3.2.3-47.3.i386.rpm
compat-glibc-2.3.2-95.30.i386.rpm
compat-glibc-headers-2.3.2-95.30.i386.rpm
compat-libgcc-296-2.96-132.7.2.i386.rpm
compat-libstdc++-296-2.96-132.7.2.i386.rpm
compat-libstdc++-33-3.2.3-47.3.i386.rpm
openmotif-2.2.3-10.RHEL4.1.i386.rpm
openmotif-devel-2.2.3-10.RHEL4.1.i386.rpm
openmotif21-2.1.30-11.RHEL4.5.i386.rpm
xorg-x11-deprecated-libs-devel-6.8.2-1.EL.13.20.i386.rpm
gnome-libs-1.4.1.2.90-44.1.i386.rpm
nss_db-compat-2.2-29.i386.rpm
java-1.4.2-gcj-compat-1.4.2.0-27jpp.noarch.rpm
sysstat-5.0.5-1.i386.rpm
pdksh-5.2.14-30.3.i386.rpm
libpng10-1.0.16-1.i386.rpm
libaio-0.3.103-3.i386.rpm
libaio-devel-0.3.103-3.i386.rpm
* »ç½Ç ¸î¸îÀº »©µµ ¼³Ä¡µÇ°ÚÁö¸¸ ¿¡·¯³ª´Â°Íº¸´Ü ³ªÀ»°Í °°¾Æ¼
±ò¾Æ¹ö·È½¿´Ï´Ù ¤Ñ.,¤Ñ;
* ·¹µåÇÞ 9¿¡¼µµ ¼³Ä¡Çغôµ¥ ¾Æ·¡ rpmµé ¾È±ò¾Æµµ Àß ±ò¸®µ¥¿ä ` `;
xorg-x11-deprecated-libs-devel-6.8.1-23.EL.i386.rpm
compat-libgcc-296-2.96-132.7.2
openmotif21-2.1.30-8.i386.rpm
- gcc296 °ú g++296 À» ´ÙÀ½°ú °°ÀÌ ½Éº¼¸¯ ¸µÅ© ÇÕ´Ï´Ù.
mv /usr/bin/gcc /usr/bin/gcc323
mv /usr/bin/g++ /usr/bin/g++323
ln -s /usr/bin/gcc296 /usr/bin/gcc
ln -s /usr/bin/g++296 /usr/bin/g++
[4] jdk ¼³Ä¡
´Ù¿î·Îµå :
https://jsecom16.sun.com/ECom/EComActionServlet;jsessionid=809FCB97DF13018EB55AFF8187294C0B
RPM in self-extracting file (j2sdk-1_4_2_08-linux-i586-rpm.bin, 33.64 MB)
chmod +x¸¦ ÁÖ°í ½ÇÇàÈÄ
rpm -Uvh ·Î ¼³Ä¡
/usr/java/j2sdk_1.4_2_08 ¿¡¼ /usr/local/j2sdk_1.4_2_08·Î À̵¿ÈÄ
$/usr/local/¿¡¼ ln -s j2sdk_1.4_2_08 java
/etc/profile¿¡ ´ÙÀ½³»¿ëÀ» ¼³Á¤
# For Java
export JAVA_HOME=/usr/local/java
export PATH=$JAVA_HOME/bin:.:$PATH
[5] °øÀ¯¸Þ¸ð¸® ¹× ¼¼¸¶Æ÷¼³Á¤
/etc/sysctl.conf ¿¡¼
kernel.sysrq=0
¶óÀξƷ¡¿¡
kernel.shmmax=1073741812(¶Ç´Â ÃÖ´ë°ªÀ¸·Î 2147483648)
kernel.sem=250 32000 100 128
¼³Á¤ÈÄ ÀçºÎÆÃ
oracle ¼³Ä¡½Ã dbca ½ÇÇàÀ» À§ÇÑ °øÀ¯¸Þ¸ð¸® ¼³Á¤
[root@domain oracle]# cat /proc/sys/kernel/shmmax
33554432
[root@domain oracle]# echo `expr 1024 \* 1024 \* 1024` > /proc/sys/kernel/shmmax
[root@domain oracle]# cat /proc/sys/kernel/shmmax
1073741824
- À§¿Í°°ÀÌ °øÀ¯¸Þ¸ð¸®°¡ Áõ°¡µÇ¾úÀ½À» ¾Ë¼ö ÀÖ½À´Ï´Ù.
[6] ¿À¶óŬ»ç¿ëÀÚ ÃʱâÈÆÄÀϱ¸¼º
oracle$ vi .bash_profile
# Set the LD_ASSUME_KERNEL environment variable only for Red Hat 9 and
# for Red Hat Enterprise Linux Advanced Server 3 (RHEL AS 3) !!
# Use the "Linuxthreads with floating stacks" implementation instead of NPTL:
export LD_ASSUME_KERNEL=2.4.1
# Oracle Environment
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_OWNER=oracle
export ORACLE_SID=ora9
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/demo:/lib:/usr/lib
export LD_LIBRARY_PATH
export TEMPDIR=/tmp
export EDITOR=vi
#set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/JRE/bin
# Set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin
#vi /etc/ld.so.conf
/lib
/usr/lib
/usr/local/lib => ¼¼°¡Áö °æ·Î Ãß°¡
#reboot
[7] ¿À¶óŬ ¼Â¾÷
x-windows¿¡ oracle°èÁ¤À¸·Î ·Î±×ÀÎ
oracle¿¡¼ ./runinstaller
¾ð¾î°¡ ±úÁö°Å³ª ½ÇÇàÀÌ ¾ÈµÉ°æ¿ì´Â ´ÙÀ½¸í·É ½ÇÇà.
unset LANG
Unix Group Name -> oinstall ¶Ç´Â dba
sid-> ÀϹÝÀûÀ¸·Î ora9
Global Database Name -> ora9.µµ¸ÞÀÎ
¹®ÀÚ¼ÂÀº [6] »ç¿ëÀÚÃʱâÈ ÆÄÀÏ¿¡¼ ¼³Á¤ÇÑ°Í°ú °°¾Æ¾ß ÇÑ´Ù.
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
¼³Ä¡Áß°£¿¡ orainstRoot.sh Æ˾÷ÀÌ ³ª¿Ã½Ã
»õâ¿¡¼ su -root
cd /tmp
./orainstRoot.sh½ÇÇà
¿Ï·áÈÄ ÁøÇà
¼³Ä¡ÁøÇà 100%ÈÄ
*/oracle/ora92/root.sh ½ÇÇà ´ëÈ»óÀÚ Æ˾÷
$su - root
#cd /oracle/ora92
#./root.sh
½Ã½ºÅÛ ±âº» µð·ºÅ丮 ¹¯´Â´Ù. /usr/bin À¸·Î ¼³Á¤
[8] ¿¡·¯Á¶Ä¡
agent configuration assistance°¡ Á¤»óÀûÀ¸·Î ¼³Ä¡µÇÁö ¾Ê°í
´ÙÀ½°ú °°Àº ¿¡·¯¸¦ ³¾¶§,
Parameter "orahome"=/home/oracle/product/9.2.0
Parameter "nodeinfo"=NO_VALUE
agnet serivce failed
¿À¶óŬ DB¿î¿ë°ú´Â »ó°ü¾ø´Â ºÎºÐÀÌÁö¸¸ ¼³Ä¡¿¡·¯0%¸¦ À§ÇÏ¿© ¼³Ä¡ÈÄ ÆÐÄ¡ÇÒ°ÍÀÔ´Ï´Ù.
ÀÏ´Ü ³Ñ¾î°¨.
ÀνºÅç·¯Á¾·áÈÄ
$ agentctl start ÇßÀ»½Ã
DBSNMP for Linux: Version 9.2.0.4.0 - Production on 07-JAN-2004 19:11:14
Copyright (c) 2003 Oracle Corporation. All rights reserved.
Starting Oracle Intelligent Agent.../opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1855 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $*
>>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1868 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1880 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
/opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1892 Segmentation fault nohup $ORACLE_HOME/bin/dbsnmp $* >>$DBSNMP_WDLOGFILE 2>&1
Á¤»ó±¸µ¿½Ã´Â ÀÌ»ó¾øÀÌ ¼³Ä¡°¡ µÈ °æ¿ìÀÌ°í À§¿Í °°À»°æ¿ì
¸ÞŸ¸µÅ©¿¡¼ p3238244_9204_LINUX.zip ´Ù¿î·Îµå ¹Þ°í ´ÙÀ½ ÀÛ¾÷ ÁøÇà.
¹Ýµå½Ã Instance Á¾·áÈÄ ÀÛ¾÷ ÁøÇà
p2617419_10102_GENERIC.zip(OpatchÆÄÀÏ)À» ÀÌ¿ë
p3238244_9204_LINUX.zip ÆÐÄ¡½ÇÇàÈÄ
orlace°èÁ¤À¸·Î
$ find $ORACLE_HOME -name "*.mk" | xargs grep -l dbsnmp
/opt/oracle/product/9.2.0/network/lib/ins_oemagent.mk
/opt/oracle/product/9.2.0/network/lib/env_oemagent.mk
$
$ cd $ORACLE_HOME/network/lib
$ make -f ins_oemagent.mk install
$ agentctl start
agent started.
[9] TIP & TECH
- ¼³Ä¡·Î±×º¸±â -
tail -f $ORA_HOME/app/oracle/product/orainventory/logs/installactions.log
- oracle »èÁ¦ -
$ORACLE_HOME µð·ºÅ丮¿¡ ÀÖ´Â ¼³Ä¡ÈÀÏÀ» ÀüºÎ»èÁ¦
/etc¹Ø¿¡ orainst.loc, oratab »èÁ¦
/usr/local/bin/oraenv ÆÄÀÏ»èÁ¦
/tmpµð·ºÅ丮¿¡¼ °ü·ÃÆÄÀÏ»èÁ¦
elete the /etc/oratab file. If using 9iAS delete the /etc/emtab file also.
# rm /etc/oratab /etc/emtab
³¡ À缳ġ ÇϸéµË´Ï´Ù.
[10] ¿À¶óŬ9i ºÎÆÃÇÒ¶§ ÀÚµ¿À¸·Î ½ÃÀÛÇϱâ
¸ÕÀú ¿À¶óŬÀ» ¼³Ä¡ÇÑ µð·ºÅ͸®·Î °¡ÀÚ. ³ªÀÇ °æ¿ì´Â /opt/oracle/product/9.2.0/bin/ Àε¥ ÀÌ°÷¿¡ dbstart ¿Í dbshut °¡ ÀÖ´Ù. ÀÌÁß dbstart ¸¦ vi /etc/rc.d/rc.local (¸®´ª½ºÀÇ ÃʱâºÎÆü³Á¤ÈÀÏ DOSÀÇ Autoexec.bat °°Àº °Í)¿¡ Àû¾îÁÖ¸é ºÎÆÃÇÒ ¶§ ÀÚµ¿À¸·Î ¿À¶óŬÀ» ½ÇÇàÇÑ´Ù. ±×·¯³ª ÀÌ·¸°Ô ÇÏ´Â °Ç start¸¸ °¡´ÉÇÒ »ÓÀÌ´Ù. Á¾·á±îÁö ÇÏ·Á¸é ½ºÅ©¸³Æ®ÆÄÀÏÀ» ÀÛ¼ºÇؾ߸¸ ÇÑ´Ù. /etc/oratab Àº ¿À¶óŬÀ» ÀÚµ¿ ½ÃÀÛ ±â´ÉÀ» »ç¿ëÇÒÁö ¿©ºÎ¸¦ °áÁ¤ÇÏ´Â ÆÄÀÏÀÌ´Ù. µðÆúÆ® °ªÀº No Àε¥ Yes·Î ¹Ù²ãÁÖ¸é dbstart, dbshut ¸¦ »ç¿ëÇÒ ¼ö ÀÖ´Ù.
vi /etc/oratab ¶ó°í Ãĺ¸ÀÚ. ¸Ç ¾Æ·¡¿¡ ³ªÀÇ °æ¿ì SID À̸§À» ora1 À̶ó ÁÖ¾ú±â ¶§¹®¿¡
ora1:/opt/oracle/product/9.2.0:N ÀÌ ÀÖÀ» °Í Àε¥ ¹®Àå ³¡¿¡ N ÀÌ º¸ÀÏ °Í ÀÌ´Ù. ÀÌ°É Y·Î °íÄ¡ÀÚ. ora1:/opt/oracle/product/9.2.0:Y ÀÌ·¸°Ô ¸»ÀÌ´Ù.
±× ´ÙÀ½ SID¸¦ À§ÇÑ ÃʱâÈ ÆÄÀÏÀ» º¹»çÇؾ߸¸ ÇÑ´Ù. ³ªÀÇ SID À̸§ÀÌ ora1 À̹ǷΠinitora1.ora.642002224936¶ó´Â ÆÄÀÏÀÌ /opt/oracle/admin/ora1/pfile/ ¿¡ Á¸ÀçÇÒ °Í ÀÌ´Ù. ÃʱâÈ ÆÄÀϸíÀº SID À̸§¿¡ µû¶ó ´Þ¶óÁö´Â °ÍÀÌ´Ù. ¿¹·Î ¸¸ÀÏ SID ¸¦ test ·Î Çß´Ù¸é inittest.ora.642002224936°¡ ÀÖÀ» °Í ÀÌ´Ù.
/opt/oracle/admin/test/pfile/initora1.ora.642002224936 À»
/opt/oracle/product/9.2.0/dbs/ µð·ºÅ͸®·Î initora1.ora ·Î rename Çؼ ¿Å±ä´Ù.
ÀÚ ÀÌÁ¦ ¸¶Áö¸·À¸·Î
su - oracle -c /opt/oracle/product/9.2.0/bin/dbstart (¿À¶óŬ ½ÃÀÛ !)
su - oracle -c /opt/oracle/product/9.2.0/bin/lsnrctl start (¸®½º³Ê ½ÃÀÛ !)
À̶ó°í Ãļ ½ÇÁ¦·Î °¡µ¿µÇ´ÂÁö test Çغ¸ÀÚ. (À§ÀÇ ³»¿ëÀ» /etc/rc.d/rc.local ¿¡ ÀÔ·ÂÇϸé ÄÄÇ»ÅÍ°¡ óÀ½ ºÎÆÃÇÒ ¶§ ÀÚµ¿À¸·Î ¿À¶óŬ°ú ¸®½º³Ê¸¦ ½ÃÀÛÇÑ´Ù. ´Ü ¸®½º³ÊÀÇ °æ¿ì¿£ ½ºÅ©¸³Æ®¿¡ ÀÔ·ÂÇÒ ¶§ µû¿ÈÇ¥·Î ¹¾î¾ß start ¸í·ÉÀÌ Àû¿ëµÈ´Ù. ÀÌ·¸°Ô
su - oracle -c /opt/oracle/product/9.2.0/bin/¡°lsnrctl start¡±)
Âü°í) ¿À¶óŬ ¸®½º³Ê ¼³Á¤¹ý
¸ÕÀú vi /etc/services¸¦ Çؼ ¿À¶óŬÀ» À§ÇÑ Æ÷Æ®¸¦ µî·ÏÇØÁØ´Ù.
Xtel 1313/tcp # French minitel
LISTENER 1521/tcp # Oracle Listener by TCP
LISTENER 1521/udp #Oracle Listener by UDP
Support 1529/tcp #GNATS, Cygnus bug tracker
À§ÀÇ ¹ØÁ٠ģ ºÎºÐÀ» Ãß°¡ÇØ ÁÖ¸é µÈ´Ù.
±×¸®°í /opt/oracle/product/9.2.0/bin/¿¡ ÀÖ´Â netmgrÀ» ½ÇÇàÇؼ ¸®½º³Ê¸¦ ¼³Á¤ÇÑ´Ù.(¾Æ¸¶ µðÆúÆ® °ªÀÌ ÀÖÀ» °ÍÀÌ´Ù. ±×³É »ç¿ëÇصµ ¹«¹æÇÏ´Ù.) ÀÌ·¸°Ô Çϸé
/opt/orqacle/product/9.2.0/network/admin/ µð·ºÅ͸®¿¡ listener.ora °¡ ÀÖÀ» °ÍÀÌ´Ù. È®ÀÎÇ϶ó.
ÀÌÁ¦ ¸¶Áö¸·À¸·Î /opt/oracle/product/9.2.0/bin/¿¡ ¸®½º³Ê ±¸µ¿ ÇÁ·Î±×·¥ÀÎ lsnrctlÀÌ ÀÖ´Ù. oracle°èÁ¤À¸·Î ·Î±×ÀÎ ÇÑ ÈÄ lsnrctl start¸¦ ÃÄ ¸®½º³Ê¸¦ ½ÃÀÛÇÏÀÚ. ÁßÁöÇÒ ¶§´Â lsnrctl stop ÀÌ´Ù. ÀÚ ÀÌÁ¦ ¿ÜºÎ¿¡¼ Á¢¼ÓÀÌ °¡´ÉÇÒ °ÍÀÌ´Ù. http://www.sqlgate.com ¿¡¼ sqlgate ¸¦ ±¸ÇØ ¿ÜºÎ¿¡¼ ½ÃÇè Á¢¼ÓÀ» Çغ¸ÀÚ.
|
|
|
|
|
|