{"id":873,"date":"2010-06-21T16:43:28","date_gmt":"2010-06-21T16:43:28","guid":{"rendered":"http:\/\/pchero21.com\/?p=873"},"modified":"2010-06-21T16:43:28","modified_gmt":"2010-06-21T16:43:28","slug":"%ec%9a%b0%eb%b6%84%ed%88%ac10-04%ec%97%90-%ec%98%a4%eb%9d%bc%ed%81%b4-11g-%ec%84%a4%ec%b9%98%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/pchero21.com\/?p=873","title":{"rendered":"\uc6b0\ubd84\ud22c(10.04)\uc5d0 \uc624\ub77c\ud074 11g \uc124\uce58\ud558\uae30."},"content":{"rendered":"

 \uc774 \uae00\uc740 \ub2e4\uc74c\uc758 \uc0ac\uc774\ud2b8\ub97c \ubca0\uc774\uc2a4\ub85c \uc6b0\ubd84\ud22c(10.04)\ub97c \uae30\ubc18\uc73c\ub85c \uc624\ub77c\ud074 11g(linux_11gR1_database_1013.zip) \ubc84\uc804\uc744 \uc124\uce58\ud558\uc5ec proc \ub97c \uc774\uc6a9\ud55c \ud504\ub85c\uadf8\ub7a8\uc758 \ucef4\ud30c\uc77c\uae4c\uc9c0\uc758 \ub0b4\uc6a9\uc744 \ud3b8\uc9d1\ud55c \uac83\uc774\ub2e4.
<\/font><\/p>\n

\n

 \uc6d0\uae00\ub2d8: \ud5c8\ub2c8\ubaac\uc758 \uc790\ubc14Guru
http:\/\/java.ihoney.pe.kr\/39<\/a><\/font><\/font><\/p><\/blockquote>\n

<\/div>\n

 #1. \uba3c\uc800 \uc624\ub77c\ud074 11g\ub97c \uc124\uce58\ud558\uae30\uc5d0 \uc55e\uc11c \ud544\uc694\ud55c \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud558\ub294 \uc791\uc5c5\uc774 \ud544\uc694\ud558\ub2e4.<\/p>\n

 \ub2e4\uc74c\uc758 \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud558\ub3c4\ub85d \ud558\uc790.<\/p>\n

 # sudo apt-get install gcc make binutils lesstif2 rpm libmotif3 libaio gawk alien ksh<\/p>\n

\ud544\uc694\ud55c \ud328\ud0a4\uc9c0 \ubc84\uc804(\ub2f9\uc5f0\ud788 \uadf8 \uc774\uc0c1 \ubc84\uc804\ub3c4 \uac00\ub2a5) -> \ub300\ubd80\ubd84 \uc124\uce58\ub418\uc5b4 \uc788\uc74c.
binutils-2.15.92.0.2-10
\ncompat-db-4.1.25-9
\ncontrol-center-2.8.0-12
\ngcc-3.4.3-9
\ngcc-c++-3.4.3-9
\nglibc-2.3.4-2
\nglibc-common-2.3.4-2
\ngnome-libs-1.4.1.2.90-44.1
\nlibstdc++-3.4.3-9
\nlibstdc++-devel-3.4.3-9
\nmake-3.80-5
\npdksh-5.2.14-30
\nsysstat-5.0.5-1
\nxscreensaver-4.18-5<\/p>\n

\n

[\ucd9c\ucc98]<\/strong> \ub9ac\ub205\uc2a4 \uc624\ub77c\ud074
\n11g \uc124\uce58<\/a>|<\/span>\uc791\uc131\uc790<\/strong> \ubf40\uc3ed<\/a><\/p>\n<\/div>\n<\/blockquote>\n

 \uc544\ub798\uc758 \ud328\ud0a4\uc9c0\ub97c \ub354 \uc124\uce58\ud558\ub3c4\ub85d \ud558\uc790.

 # apt-get install gcc
\nbinutils libaio1 lesstif2 lesstif2-dev make rpm libc6 libstdc++5
\nbuild-essential<\/font><\/font>
<\/p>\n

\n

[\ucd9c\ucc98]<\/strong> \uc6b0\ubd84\ud22c\uc5d0
\n\uc624\ub77c\ud074 \uc124\uce58\ud558\uae30<\/a>|<\/span>\uc791\uc131\uc790<\/strong> \ub9cc\uc7ac<\/a><\/p>\n<\/div>\n

<\/font><\/font>
** \ub2e4\uc74c\uc758 \uc704\uce58\uc5d0\uc11c oracle\uc744 \ub2e4\uc6b4\ubc1b\ub3c4\ub85d \ud558\uc790. \ud544\uc790\ub294 11.1.0.6.0<\/span><\/strong> \ubc84\uc804\uc73c\ub85c \uc124\uce58\ub97c \uc9c4\ud589\ud558\uc600\ub2e4.
http:\/\/www.oracle.com\/technetwork\/database\/enterprise-edition\/downloads\/index.html<\/a><\/p>\n

 #2. \ud328\ud0a4\uc9c0\uc758 \uc124\uce58\uac00 \ub05d\ub0ac\uc73c\uba74 \uc124\uce58\ub97c \uc704\ud55c \uc0ac\uc6a9\uc790 \uadf8\ub8f9\uacfc \uc720\uc800\ub97c \ub9cc\ub4e4\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

# addgroup oinstall
\n# addgroup dba
\n# addgroup nobody
\n# useradd -m oracle -g oinstall -G dba -s \/bin\/bash
\n# usermod -g nobody nobody
\n# passwd oracle  (oracle \uacc4\uc815\uc758 \ube44\ubc00\ubc88\ud638 \uc124\uc815)<\/p><\/blockquote>\n

#3. \ub9ac\ub205\uc2a4 \ucee4\ub110\uc758 \uc18c\uc2a4\ub3c4 \ud544\uc694\ud558\ub2e4.<\/p>\n

 # sudo apt-get install linux-headers<\/p><\/blockquote>\n

 #4. Oracle \uc5d0\uc11c \ud544\uc694\ud55c \uba54\ubaa8\ub9ac\uc640 CPU \ub9ac\uc18c\uc2a4\ub97c \uc704\ud574 \ucee4\ub110 \ud30c\ub77c\ubbf8\ud130\ub97c \uc218\uc815\ud55c\ub2e4.
 \ud30c\uc77c\uc744 \uc5f4\uace0 \uac00\uc7a5 \uc544\ub798\ucabd\uc5d0 \ub2e4\uc74c\uc758 \ub0b4\uc6a9\uc744 \uc0bd\uc785\ud55c\ub2e4.<\/p>\n

 # sudo vi \/etc\/sysctl.conf<\/p>\n

fs.file-max = 65535
\nkernel.shmall = 2097152
\nkernel.shmmax = 2147483648
\nkernel.shmmni = 4096
\nkernel.sem = 250 32000 100 128
\nnet.ipv4.ip_local_port_range = 1024 65000
\nnet.core.rmem_default = 1048576
\nnet.core.rmem_max = 1048576
\nnet.core.wmem_default = 262144
\nnet.core.wmem_max = 262144<\/p><\/blockquote>\n

 #5.  \/etc\/sysctl.conf \ud30c\uc77c\uc740 \uc6b0\ubd84\ud22c \uc2dc\uc2a4\ud15c\uc774 \ubd80\ud305\uc2dc \ucc98\uc74c \uc77d\uc5b4\uc624\ub294 \uc815\ubcf4\uc774\ub2e4. \uc774\uac83\uc744 \uc801\uc6a9\uc2dc\ud0a4\uae30 \uc704\ud574\uc11c \uc7ac\ubd80\ud305\uc744 \ud55c\ub2e4.
 
 \ud639\uc740 \uc7ac\ubd80\ud305\uc774 \uadc0\ucc2e\uc73c\uba74 \ub2e4\uc74c\uc744 \uc785\ub825\ud55c\ub2e4. sysctl.conf \uc124\uc815\uc744 \ub2e4\uc2dc \uc77d\uc5b4\ub4e4\uc774\ub294 \uba85\ub839\uc5b4\uc774\ub2e4.<\/p>\n

 # sudo sysctl -p<\/p><\/blockquote>\n

 #6. \ub2e4\uc74c\uc73c\ub85c limit.conf \ud30c\uc77c\uc744 \uc218\uc815\ud55c\ub2e4.<\/p>\n

 \ub2e4\uc74c\uc758 \ub0b4\uc6a9\uc744 \/etc\/security\/limits.conf \ud30c\uc77c\uc5d0 \uc0bd\uc785\ud55c\ub2e4.<\/p>\n

# sudo vi \/etc\/security\/limits.conf<\/p>\n

oracle soft nproc 2047<\/p>\n

oracle hard nproc 16383<\/p>\n

oracle soft nofile 1023<\/p>\n

oracle hard nofile 65535<\/p><\/blockquote>\n

 \/etc\/security\/limits.conf \ud30c\uc77c\uc758 \uc218\uc815\uc774 \uc644\ub8cc\ub418\uc5c8\uc73c\uba74 \ub2e4\uc74c\uc73c\ub85c<\/p>\n

 \/etc\/pam.d\/login \ud30c\uc77c\uc744 \uc5f4\uc5b4\uc11c \ub2e4\uc74c \ub77c\uc778\uc744 \ucd94\uac00\ud55c\ub2e4.<\/p>\n

 # sudo vi \/etc\/pam.d\/login<\/p>\n

 session required \/lib\/security\/pam_limits.so
 session required pam_limits.so<\/p><\/blockquote>\n

 #7. \ud658\uacbd\ubcc0\uc218 \uc124\uc815.
 \ub2e4\uc74c\uc73c\ub85c \uc624\ub77c\ud074 \uae30\ub3d9\uc5d0 \uad00\ub828\ud55c \ud658\uacbd\ubcc0\uc218\ub97c \uc124\uc815\ud55c\ub2e4.<\/p>\n

\n

$ln -s \/usr\/bin\/awk \/bin\/awk<\/font><\/p>\n

$ln -s \/usr\/bin\/rpm \/bin\/rpm<\/font><\/p>\n

$ln -s \/lib\/libgcc_s.so.1 \/lib\/libgcc_s.so<\/font><\/p>\n

$ln -s \/usr\/bin\/basename \/bin\/basename
\n\/bin\/basename<\/p>\n

\n

[\ucd9c\ucc98]<\/strong> \uc6b0\ubd84\ud22c\uc5d0
\n\uc624\ub77c\ud074 \uc124\uce58\ud558\uae30<\/a>|<\/span>\uc791\uc131\uc790<\/strong> \ub9cc\uc7ac<\/a><\/font><\/p>\n<\/div>\n

<\/font><\/p>\n<\/div>\n

<\/p>\n

\n

Oracle 11g\uac00 \uc124\uce58\ub420 \ud3f4\ub354 \uc0dd\uc131\ud558\uae30(\ubcf8\uc778\uc740 11g\ub97c \uc124\uce58\ud558\uc5ec 11g\ub85c \ubcc0\uacbd\ud568)<\/p>\n

$mkdir \/oracle<\/font><\/p>\n

$mkdir \/oracle\/11g<\/font><\/p>\n

$chown -R oracle:oinstall \/oracle<\/font><\/p>\n

$chmod -R 775 \/oracle<\/p>\n

\n

[\ucd9c\ucc98]<\/strong> \uc6b0\ubd84\ud22c\uc5d0
\n\uc624\ub77c\ud074 \uc124\uce58\ud558\uae30<\/a>|<\/span>\uc791\uc131\uc790<\/strong> \ub9cc\uc7ac<\/a><\/font><\/p>\n<\/div>\n

<\/font><\/p>\n<\/div>\n

<\/p>\n

\n

\uadf8\ub2e4\uc74c \ud658\uacbd\ubcc0\uc218 \uc124\uc815\uc744 \uc704\ud574 etc\ubc11\uc5d0 profile\uc744
\ngedit\ub85c \uc5f0\ub2e4(vi\ub85c\uc5f4\uc5b4\ub3c4 \uc0c1\uad00\uc5c6\uc74c)<\/p>\n

$sudo vi \/etc\/profile<\/font><\/p>\n

\ud30c\uc77c\uc744 \uc5f4\uc5c8\uc73c\uba74.. \ud30c\uc77c \uac00\uc7a5 \uc544\ub7ab\ubd80\ubd84\ud14c \ubc11\uc5d0 \uc815\ubcf4\ub97c
\n\ubcf5\uc0ac\ud574\uc11c \ub123\ub294\ub2e4.. \ud30c\uc77c\uc758 \uac00\uc7a5 \ub9c8\uc9c0\ub9c9!<\/p>\n

export ORACLE_BASE=\/oracle<\/font><\/p>\n

export ORACLE_HOME=\/oracle\/11g<\/font><\/p>\n

export ORACLE_SID=oracle<\/font><\/p>\n

export PATH=$PATH:$ORACLE_HOME\/bin<\/p>\n

\n

[\ucd9c\ucc98]<\/strong> \uc6b0\ubd84\ud22c\uc5d0
\n\uc624\ub77c\ud074 \uc124\uce58\ud558\uae30<\/a>|<\/span>\uc791\uc131\uc790<\/strong> \ub9cc\uc7ac<\/a><\/font><\/p>\n<\/div>\n

<\/font><\/p>\n<\/div>\n

<\/p>\n

\n\uc5ec\uae30\uae4c\uc9c0 \ud588\uc73c\uba74.. \ud658\uacbd\ubcc0\uc218\uac00 \uc81c\ub300\ub85c \ub4f1\ub85d\ub418\uc5c8\ub098.. \ud130\ubbf8\ub110\uc744 \uc5f4\uc5b4\uc11c \ud655\uc778\uc744 \ud574\ubcf8\ub2e4..<\/p>\n

$ su – oracle<\/font><\/p>\n

password:<\/font><\/p>\n

$ echo $ORACLE_BASE<\/font><\/p>\n

\/oracle<\/font><\/p>\n

$ echo $ORACLE_HOME<\/font><\/p>\n

\/oracle\/11g<\/font><\/p>\n

$ echo $<\/font>ORACLE_SID<\/font><\/p>\n

oracle
<\/font><\/p>\n

 \uc81c\ub300\ub85c \ub098\uc624\uba74 \uc774\uc0c1\uc5c6\uc74c..<\/p>\n

\n

[\ucd9c\ucc98]<\/strong> \uc6b0\ubd84\ud22c\uc5d0
\n\uc624\ub77c\ud074 \uc124\uce58\ud558\uae30<\/a>|<\/span>\uc791\uc131\uc790<\/strong> \ub9cc\uc7ac<\/a><\/font><\/p>\n<\/div>\n<\/div>\n

\n<\/div>\n

 #8. \uc624\ub77c\ud074 \uc555\ucd95 \ud480\uae30.<\/p>\n

\n

# cd \/path\/to\/zipfile (Oracle \uc555\ucd95 \ud30c\uc77c\uc744 \ubc1b\uc740 \ud3f4\ub354\ub85c \uc774\ub3d9\ud55c\ub2e4).
\n# sudo chown oracle:oinstall Oracle11*.zip
\n# sudo Oracle11*.zip \/home\/oracle
\n# su – oracle
\n# unzip linux_11gR1b5_database.zip – \ud30c\uc77c\uba85\uc740 \ubc84\uc804\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \n<\/p>\n

# chown -R oracle:oinstall database<\/p>\n<\/blockquote>\n

 #9.Turn on the display – runInstaller\ub97c \uc2e4\ud589\ud558\uae30 \uc804\uc5d0 xdisplay\ub97c \uc77c\uce58\uc2dc\ucf1c\uc918\uc57c
\n\ud55c\ub2e4\ub294
\n\uad70\uc694… <\/p>\n

 root \uacc4\uc815\uc774\ub098 oracle \uc5d0\uc11c xdisplay\ub97c \uc0ac\uc6a9\ud558\ub824\uace0 \ud558\uba74 \uc2e4\ud589\ub418\uc9c0 \uc54a\ub294 \ubd80\ubd84\uc744 \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc544\ub798\uc758
\n\uba85\ub839\uc5b4\ub97c \ubcf8\uc778\uc758 \uc0ac\uc6a9\uacc4\uc815\uc5d0\uc11c \uc124\uc815\ud574\uc918\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

 \uaf2d!! \uc548\uadf8\ub7ec\uba74 \uc2e4\ud589 \uc911 \uc624\ub958\uac00 \ub739\ub2c8\ub2e4.<\/strong><\/p>\n

 # sudo -i
 #
\nxhost +
 # su – oracle
 # DISPLAY=:0.0; export DISPLAY<\/p><\/blockquote>\n

 
 #10. \uc624\ub77c\ud074 \uc124\uce58 \uc2dc\uc791.<\/p>\n

# su – oracle
\n# export LANC=C  \/\/ \uadf8\ub0e5 \uc2e4\ud589\ud558\uba74 \ud55c\uae00\uc774 \uae68\uc9c4 \uc124\uce58\ud654\uba74\uc73c\ub85c \ub098\uc635\ub2c8\ub2e4. \uc18d\ud3b8\ud558\uac8c \uc601\uc5b4\ub85c~!!
\n$ cd \/path_to_extracted_files
\n$ .\/runInstaller<\/p><\/blockquote>\n

#11. \uc624\ub77c\ud074 \uc124\uce58.<\/p>\n

\uc544\ub798 \uadf8\ub9bc\uc5d0\uc11c \ubcf4\uc2dc\ub294 \uac83\ucc98\ub7fc
\n<\/strong><\/p>\n


<\/strong><\/p>\n

Oracle Base Location : \/oracle<\/strong><\/p>\n


<\/strong><\/p>\n

Oracle Home Location : \/oracle\/11g<\/strong><\/p>\n


<\/strong><\/p>\n

Global DataBase Name : oracle<\/strong><\/p>\n

(\uc8fc\uc758: \ub2e4\ub978 \uac12\uc744 \ub123\uace0 \uc2f6\uc740 \uacbd\uc6b0, \uc704\uc758 <\/strong>“export ORACLE_SID=oracle” \uc124\uc815\uacfc \ub611\uac19\uc740 \uac12\uc744 \ub123\uc5b4\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.)
<\/font><\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Inventory directory \ub294 \/oracle\/oraInventory\ub85c \uc124\uc815<\/p>\n

System group name \uc740 dba\ub85c \uc124\uc815<\/p>\n

\"\"
\ub098\uba38\uc9c0 \uacfc\uc815\uc740 Next~ Next~~\ub97c \ub20c\ub7ec\uc8fc\uba74 \ub41c\ub2e4.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

 !! \uc8fc\uc758 !!<\/p>\n

 \ud544\uc790\uc758 \ud658\uacbd – \uc6b0\ubd84\ud22c 10.04 – Desktop \uc5d0\uc11c \uc624\ub77c\ud074 \uc124\uce58\ub97c \uc9c4\ud589\ud560 \uacbd\uc6b0, \uc65c\uc778\uc9c0 \uc911\uac04\uc5d0 Assistant \ud504\ub85c\uc138\uc2a4\ub97c \uc9c4\ud589\ud560 \ub54c hang\uc774 \uac78\ub9ac\ub294 \ubb38\uc81c\uac00 \uc788\uc5c8\ub2e4.
\"\"\uc67c\ucabd\uc758 \ud654\uba74\ucc98\ub7fc \ucc3d\uc774 \ud558\ub098 \ub728\uace0 \ucc3d\uc758 \uc548\ucabd\uc5d0\ub294 \uc544\ubb34\ub7f0 \ud654\uba74\uc774\ub098 \uba54\uc2dc\uc9c0\uac00 \ub098\ud0c0\ub098\uc9c0 \uc54a\ub294 \ubb38\uc81c\uc600\ub2e4.<\/p>\n

 \ubd84\uba85 \uc800\ubc88\uc5d0 \uc5b4\ub5bb\uac8c \ud574\uacb0\ud55c \uac83 \uac19\uc558\ub294\ub370, \ub3c4\uc800\ud788 \uae30\uc5b5\uc774 \ub098\uc9c8 \uc54a\uc558\ub2e4. \ud55c\ucc38\uc744 \uace0\ubbfc\ud558\ub2e4\uac00 \ub2f5\uc744 \ucc3e\uc558\ub2e4. \uc544\ub9c8\ub3c4 \ub370\uc2a4\ud06c\ud0d1 \ud658\uacbd\uc5d0\uc11c \uc2e4\ud589\uc911\uc778 \ud55c \ud328\ud0a4\uc9c0(\ud639\uc740 \ub77c\uc774\ube0c\ub7ec\ub9ac) \uc911\uc5d0\uc11c \ud654\uba74\uc744 \ub744\uc6b0\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac\uc640 \ubb54\uac00 \uc0c1\uc131(?)\uc774 \ub9de\uc9c0 \uc54a\uc544\uc11c \uc0dd\uae30\ub294 \ubb38\uc81c\uc778 \ub4ef \ud588\ub2e4.<\/p>\n

 \uadf8\ub798\uc11c \uc6b0\ubd84\ud22c \ucc98\uc74c \uc2dc\uc791\uc2dc, \ub85c\uadf8\uc778\uc744 \ud560\ub54c \uc2dc\uc791\uc744 Xterm \ubaa8\ub4dc\ub85c \ub85c\uadf8\uc778\uc744 \ud558\uc5ec \ub370\uc2a4\ud06c\ud0d1 \uc124\uc815\uacfc \uad00\ub828\ub41c \ub300\ubd80\ubd84\uc758 \ub77c\uc774\ube0c\ub7ec\ub9ac\/\ud504\ub85c\uc138\uc2a4 \uc2e4\ud589\uc744 \uba48\ucd94\uac8c \ud558\uc600\ub2e4.<\/p>\n

 \uadf8\ub9ac\uace0 \uc124\uce58\ub97c \uc9c4\ud589\ud558\ub2c8 \uc815\uc0c1\uc801\uc73c\ub85c \uc124\uce58\uac00 \ub418\ub294 \uac83\uc744 \ud655\uc778\ud558\uc600\ub2e4…<\/p>\n

 <\/p>\n

\"\" <\/p>\n

 \ucb48\uc6b1 \ub125\uc2a4\ud2b8\uac00 \ub098\uc624\uace0 \ub2e4\uc74c \ucc3d\uc774 \ub098\uc624\uba74, Script to be executed : \uacbd\ub85c\uc5d0 \uc788\ub294 \uacf3\uc73c\ub85c \uac00\uc11c sh(\uc2a4\ud06c\ub9bd\ud2b8
\n\ud30c\uc77c)\uc744 \uc2e4\ud589\uc2dc\ud0a4\uc790. <\/p>\n

 \uc704\ucabd\uc5d0 \uc368 \uc788\ub4ef\uc774, root \uacc4\uc815\uc73c\ub85c \uc2e4\ud589\uc2dc\ucf1c\uc57c \ud55c\ub2e4.<\/p>\n

\"\"<\/p>\n

 #12. Complete Install And System Reboot.<\/strong><\/p>\n

\ubcf8\uc778 \uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778 \ud6c4 \ud130\ubbf8\ub110\uc744 \uc2e4\ud589\ud558\uc5ec \/etc\/oratab\ud30c\uc77c \ubd80\ubd84\uc744 \uc218\uc815<\/strong><\/p>\n


<\/strong><\/p>\n

\"\"\ubcf4\uc774\ub294 \uac83\ucc98\ub7fc oracle:\/oracle\/11g:N \uc744 oracle:\/oracle\/11g:Y \ub85c \ubcc0\uacbd\ud558\uba74 \ub41c\ub2e4.<\/strong><\/p>\n

#13. \uc624\ub77c\ud074 \ub9ac\uc2a4\ub108\uc758 \uc808\ub300 \ud328\uc2a4 \uc218\uc815<\/span><\/p>\n

# gedit \/oracle\/11g\/bin\/dbstart <\/p><\/blockquote>\n

\"\"
 ORACLE_HOME_LISTNER= \ubd80\ubd84\uc744<\/p>\n

 ORACLE_HOME_LISTNER=\/oracle\/11g <\/span>\ub85c \uc124\uc815\ud574 \uc8fc\uba74 \ub418\uaca0\ub2e4.<\/p>\n

\n\uc774
\n\uc81c……………….. \uc624\ub77c\ud074 \uc2e4\ud589\ud574\ubcf4\uc790…<\/font><\/p>\n

oracle \uacc4\uc815\uc5d0\uc11c \n<\/p>\n

$ lsnrctl start<\/font> \n<\/p>\n

\ub9ac\uc2a4\ub108 \uc2dc\uc791 \ud6c4\uc5d0 \n<\/p>\n

SQL> conn oracle as sysdba
Enter password:
Connected to an idle instance.
SQL> startup
ORACLE instance started.<\/p>\n

<\/p>\n

\n

[\ucd9c\ucc98]<\/strong> \uc6b0\ubd84\ud22c\uc5d0
\n\uc624\ub77c\ud074 \uc124\uce58\ud558\uae30<\/a>|<\/span>\uc791\uc131\uc790<\/strong> \ub9cc\uc7ac<\/a><\/p>\n<\/div>\n

<\/font><\/p>\n<\/div>\n

 
 #.14 \uc5ec\uae30\uae4c\uc9c0\uac00 oracle \uc758 \uc124\uce58\ubd80\ubd84\uc774\ub2e4. \uc774\uc81c proc\ub97c \uc774\uc6a9\ud55c \ud504\ub85c\uadf8\ub7a8\uc758 \ucef4\ud30c\uc77c\uc744 \uc704\ud55c \ubd80\ubd84\uc744 \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uc790.<\/p>\n

 \uc608\uc81c proc \ud504\ub85c\uadf8\ub7a8\uc744 \uc774\uc6a9\ud558\uc5ec \ucef4\ud30c\uc77c\uc744 \uc2dc\ub3c4\ud574\ubcf4\uc790.<\/p>\n

 \ub098\ub294 \uc0ac\ub0b4\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 Pro \ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud588\ub2e4.<\/p>\n

 \ub2e4\ub978 \ubd84\ub4e4\uc740 \uc774\uacf3
 http:\/\/www.joinc.co.kr\/modules\/moniwiki\/wiki.php\/Site\/Database\/dbms_programing\/OracleProcPrograming_Start <\/a><\/p>\n

 \uc744 \ucc38\uace0\ud558\uc5ec \uc54c\ub9de\uc740 \uc608\uc81c \uc18c\uc2a4\ub97c \uad6c\ud558\ub3c4\ub85d \ubc14\ub780\ub2e4.(\uc0ac\uc2e4 \uc800\uacf3\uc5d0 \ub098\uba38\uc9c0 \ub0b4\uc6a9\uc774 \ub2e4 \ub098\uc640\uc788\ub2e4.)<\/p>\n

 \ud544\uc790\uc758 \uacbd\uc6b0 proc \ud504\ub85c\uadf8\ub7a8 \ucef4\ud30c\uc77c\uc744 \uc2e4\ud589\ud558\uba74 \uc544\ub798\uc758 \uc624\ub958 \uba54\uc2dc\uc9c0\uac00 \ub098\uc654\ub2e4.<\/p>\n

 \/oracle\/11g\/bin\/proc: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory<\/p><\/blockquote>\n

 libclntsh.so.11.1 \ud30c\uc77c\uc744 \ucc3e\uc744 \uc218\uac00 \uc5c6\ub2e4\ub294 \ub0b4\uc6a9\uc778\ub370 \uc774\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac \ud328\uc2a4\uc640 \uc2ec\ubcfc\ub9ad \ub9c1\ud06c \uc124\uc815\uc73c\ub85c \ud574\uacb0 \ud560 \uc218 \uc788\ub2e4.
 <\/p>\n

\uba3c\uc800 .bash_profile \uc5d0 \ub2e4\uc74c\uc744 \ucd94\uac00\ud55c\ub2e4. (\ud544\uc790\uc758 \uacbd\uc6b0 ~\/.bashrc) \uc600\ub2e4.<\/p>\n

\n

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME\/lib<\/p>\n<\/div>\n

<\/p>\n

\uadf8\ub798\ub3c4 \uc548\ub418\uba74 $ORACLE_HOME\/lib \uc5d0 \ud30c\uc77c \uc774 \uc788\ub294\uc9c0 \ud655\uc778\ud6c4 \uc5c6\uc73c\uba74 \ub9c1\ud06c\ud55c\ub2e4.<\/p>\n<\/p>\n

[oracle@localhost lib]$ ln -s
\nlibclntsh.so.10.1  libclntsh.so <\/div>\n

 <\/p>\n

 \uadf8\ub9ac\uace0 \ucd94\uac00\ub85c \ub2e4\uc74c\uc758 \ubb38\uc81c\ub3c4 \ubc1c\uc0dd\ud588\uc5c8\ub294\ub370…<\/p>\n

Error at line 34, column 11 in file \/usr\/include\/stdio.h
# include <stddef.h>
……….1
PCC-S-02015, unable to open include file
Error at line 15, column 10 in file \/usr\/include\/_G_config.h
#include <stddef.h>
………1
–More–make: *** [oraquery.o] Error 1
PCC-S-02015, unable to open include file
Error at line 52, column 11 in file \/usr\/include\/wchar.h
# include <stddef.h>
……….1
PCC-S-02015, unable to open include file
Error at line 53, column 11 in file \/usr\/include\/libio.h
# include <stdarg.h>
……….1
PCC-S-02015, unable to open include file
Syntax error at line 332, column 3, file \/usr\/include\/libio.h:
Error at line 332, column 3 in file \/usr\/include\/libio.h
  size_t __pad5;
..1
PCC-S-02201, Encountered the symbol “size_t” when expecting one of the following
:<\/p><\/blockquote>\n

 \uc774\ub294 \/oracle\/11g\/precomp\/admin\/pcscfg.cfg \uc124\uc815\uc744 \ubc14\uafd4\uc90c\uc73c\ub85c\uc368 \ud574\uacb0 \ud560 \uc218 \uc788\uc5c8\ub2e4.<\/p>\n

 \/oracle\/11g\/precomp\/admin\/pcscfg.cfg \ud30c\uc77c\uc548\uc5d0  \/usr\/lib\/gcc\/i486-linux-gnu\/4.4\/include \uc124\uc815\uc744 \ucd94\uac00\ud558\ub3c4\ub85d \ud55c\ub2e4.<\/p>\n

 \ub2e8, \uc774 \uc124\uc815\uc740 \ubc30\ud3ec\ud310, gcc \ubc84\uc804 \ub4f1\uc5d0 \ub530\ub77c \ubc14\uafd4\uc9c8 \uc218 \uc788\uc73c\ubbc0\ub85c \uacbd\ub85c\ub97c \ud655\uc778\ud574\uc11c \uc785\ub825\ud558\uc5ec\ub9cc \ud55c\ub2e4.
 
 \uc5ec\uae30\uae4c\uc9c0 \uc124\uc815\uc774 \ub05d\ub0ac\ub2e4\uba74 \uc774\uc81c Proc \ub97c \uc0ac\uc6a9\ud558\uba74 \ub41c\ub2e4. \ud83d\ude42<\/p>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

 \uc774 \uae00\uc740 \ub2e4\uc74c\uc758 \uc0ac\uc774\ud2b8\ub97c \ubca0\uc774\uc2a4\ub85c \uc6b0\ubd84\ud22c(10.04)\ub97c \uae30\ubc18\uc73c\ub85c \uc624\ub77c\ud074 11g(linux_11gR1_database_1013.zip) \ubc84\uc804\uc744 \uc124\uce58\ud558\uc5ec proc \ub97c \uc774\uc6a9\ud55c \ud504\ub85c\uadf8\ub7a8\uc758 \ucef4\ud30c\uc77c\uae4c\uc9c0\uc758 \ub0b4\uc6a9\uc744 \ud3b8\uc9d1\ud55c \uac83\uc774\ub2e4.  \uc6d0\uae00\ub2d8: \ud5c8\ub2c8\ubaac\uc758 \uc790\ubc14Guruhttp:\/\/java.ihoney.pe.kr\/39  #1. \uba3c\uc800 \uc624\ub77c\ud074 11g\ub97c \uc124\uce58\ud558\uae30\uc5d0 \uc55e\uc11c \ud544\uc694\ud55c \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud558\ub294 \uc791\uc5c5\uc774 \ud544\uc694\ud558\ub2e4.  \ub2e4\uc74c\uc758 \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud558\ub3c4\ub85d \ud558\uc790.  # sudo apt-get … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[241,298,395,590],"_links":{"self":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/873"}],"collection":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=873"}],"version-history":[{"count":0,"href":"http:\/\/pchero21.com\/index.php?rest_route=\/wp\/v2\/posts\/873\/revisions"}],"wp:attachment":[{"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=873"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pchero21.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}