{"id":2554,"date":"2009-02-10T01:02:32","date_gmt":"2009-02-10T01:02:32","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=2554"},"modified":"2009-02-10T01:02:32","modified_gmt":"2009-02-10T01:02:32","slug":"%ed%8e%8c-%eb%a6%ac%eb%88%85%ec%8a%a4%ec%97%90%ec%84%9c-%ec%98%a4%eb%9d%bc%ed%81%b4-rpm-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=2554","title":{"rendered":"[\ud38c] \ub9ac\ub205\uc2a4\uc5d0\uc11c \uc624\ub77c\ud074 rpm \uc124\uce58 – PHP \uc5f0\ub3d9 \ucd94\uac00"},"content":{"rendered":"

\ucd9c\ucc98 http:\/\/newgifted.tistory.com\/entry\/Oracle-10g-Express-%EC%84%A4%EC%B9%98%EB%A6%AC%EB%88%85%EC%8A%A4<\/A>

\uc624\ub77c\ud074\uc744 \uae54\uae30\uc804\uc5d0 \ucd5c\uc18c\uc0ac\uc591\uc744 \ub9cc\uc871 \ud558\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.

\ucd5c\uc18c \uc0ac\uc591\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/P>
\n

Oracle 10g Express\ucd5c\uc18c\uc0ac\uc591<\/FONT>
<\/FONT>
RAM   256MB(\uad8c\uc7a5 512MB)

Disk space  1.5GByte

Packages   glibc – 2.3.2
  libaio – 0.3.96

Swap Space 0~256MB (RAM\uc758 3\ubc30 \uc774\uc0c1)
  256~512MB (RAM\uc758 2\ubc30 \uc774\uc0c1)
  512MB \uc774\uc0c1 (1024GB \uc774\uc0c1)<\/DIV>
\n

\uc704 \uc0ac\uc591\uc744 \ub9cc\uc871 \ud558\uc9c0 \uc54a\uc73c\uba74 \uc124\uce58 \uc790\uccb4\uac00 \ubd88\uac00\ub2a5 \ud569\ub2c8\ub2e4.

\ub9cc\uc57d \uc124\uce58\uc911 glibc\ub098 libaio\ud328\ud0a4\uc9c0 \uc124\uce58\ub97c \uc694\uad6c\ud558\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc124\uce58\ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.

<\/P>
\n

yum install glibc
yum install libaio<\/DIV>
\n



\ub610\ub294 \uc9c1\uc811 \ub2e4\uc6b4 \ubc1b\uc73c\uc2e0\ud6c4 rpm -Uvh ~~~.rpm\uc744 \ud1b5\ud574 \uc124\uce58 \ud558\uc154\ub3c4\ub429\ub2c8\ub2e4.

\uc6b0\uc120 \uc624\ub77c\ud074 \ud648\ud398\uc774\uc9c0\uc5d0\uc11c Oracle 10g Express \ub97c \ubc1b\uc740 \ud6c4

root\uacc4\uc815\uc73c\ub85c \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud558\uc2dc\uba74 \uc124\uce58\uac00 \uc9c4\ud589\ub429\ub2c8\ub2e4.

<\/P>
\n

[root@localhost \uc2e0\uc601\uc7ac]# rpm -Uvh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
\uc900\ube44 \uc911…               ########################################### [100%]
   1:oracle-xe-univ         ########################################### [100%]
Executing Post-install steps…
You must run ‘\/etc\/init.d\/oracle-xe configure’ as the root user to
configure the database.
<\/DIV>
\n


\uc124\uce58\uac00 \uc644\ub8cc\ub41c\ud6c4 \ub370\uc774\ud0c0 \ubca0\uc774\uc2a4 \uc124\uc815\uc744 \ud574\uc57c \ub429\ub2c8\ub2e4.

\uc544\ub798\uc640 \uac19\uc774 \uc785\ub825\ud558\uc2dc\uba74 \uc124\uc815\uc744 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc124\uc815\uc774 \uc644\ub8cc\ub41c\ud6c4 \uc5b8\uc81c\ub77c\ub3c4 \ub2e4\uc2dc \uc124\uc815\uc744 \ubc14\uafb8\uace0 \uc2f6\ub2e4\uba74 \ub611\uac19\uc774 \uc785\ub825 \ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4.

<\/P>
\n


\n

[root@localhost \uc2e0\uc601\uc7ac]# \/etc\/init.d\/oracle-xe configure<\/P>
\n

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.<\/P>
\n

Specify the HTTP port that will be used for Oracle Application Express [8080]:HTTP\ub97c \ud1b5\ud574 \ud3b8\ub9ac\ud558\uac8c \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ud560 http\ud3ec\ud2b8\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. \ud1b0\ucea3 \uc11c\ubc84\uc640 \ud3ec\ud2b8\uac00 \uac19\uc73c\ubbc0\ub85c \ud1b0\ucea3 \uc11c\ubc84\ub97c \uc0ac\uc6a9\ud558\uc2e0\ub2e4\uba74 \ub2e4\ub978 \ud3ec\ud2b8\ub97c \uc774\uc6a9\ud558\uae30 \uc704\ud574 \ub2e4\ub978 \ud3ec\ud2b8 \ubc88\ud638\ub97c \uc785\ub825 \ud558\uc2ed\uc2dc\uc694.<\/P>
\n

Specify a port that will be used for the database listener [1521]: \ub2e4\ub978 \uc11c\ubc84\uc5d0\uc5b4\uc11c DB\uc11c\ubc84\uc5d0 \uc811\uadfc\ud558\uae30 \uc704\ud55c \ud3ec\ud2b8\uc785\ub2c8\ub2e4.<\/FONT><\/P>
\n

Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration: \uc554\ud638\ub97c \uc785\ub825 \ud569\ub2c8\ub2e4. \uc774 \uc554\ud638\ub85c SYS, SYSTEM\uc720\uc800\ub85c \ub85c\uadf8\uc778 \uac00\ub2a5\ud569\ub2c8\ub2e4.
<\/FONT>Confirm the password:<\/P>
\n

Do you want Oracle Database 10g Express Edition to be started on boot (y\/n) [y]: \ubd80\ud305\ud6c4 \uc790\ub3d9\uc73c\ub85c \uc624\ub77c\ud074 DB\ub97c \uc2e4\ud589\ud560\uc9c0 \uc5ec\ubd80\uc785\ub2c8\ub2e4.
\uc774\uc81c \uc7a0\uc2dc\uae30\ub2e4\ub9ac\uc2dc\uba74.. \uc124\uc815\uc774 \uc644\ub8cc\ub429\ub2c8\ub2e4.
<\/FONT>Starting Oracle Net Listener…Done
Configuring Database…Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to “http:\/\/127.0.0.1:8080\/apex<\/FONT><\/A>“
[root@localhost \uc2e0\uc601\uc7ac]#<\/P><\/DIV>
\n



\ub2e4\uc74c\uc73c\ub85c \uc624\ub77c\ud074 \ud658\uacbd\ubcc0\uc11c \uc124\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \ub2e4\uc74c \ub514\ub809\ud1a0\ub9ac\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.

<\/P>
\n

[root@localhost 10.2.0]# cd \/usr\/lib\/oracle\/xe\/app\/oracle\/product\/10.2.0\/server\/bin
<\/DIV>
\n


oracle_env.sh\ub610\ub294 oracle_env.csh\uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4. \ubd80\ud305\uc2dc \uacc4\uc18d \ud574\uc11c \uc790\ub3d9\uc73c\ub85c \uc2e4\ud589\ud558\uace0 \uc790 \ud558\uc2e0\ub2e4\uba74, .bash_profile \ub610\ub294 .bash_rc\uc5d0 \uba85\ub839\uc744 \ub123\uc5b4 \uc8fc\uc2dc\uba74 \ub429\ub2c8\ub2e4.

<\/P>
\n

[root@localhost bin]# . .\/oracle_env.sh<\/DIV>
\n




\uc774\uc81c \uc124\uce58\uac00 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc640 \uac19\uc774 \uc785\ub825\ud558\uba74 DB\uc5d0 \uc811\uadfc \uac00\ub2a5\ud569\ub2c8\ub2e4. \ub610\ub294 \uc6f9\ube0c\ub77c\uc6b0\uc838\uc5d0\uc11c http:\/\/127.0.0.1:8080\/apex<\/FONT><\/A>\ub85c \uc811\uadfc\ud558\uba74 \uc544\ub798\uc640 \uac19\uc740 GUI\ud658\uacbd\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4.


<\/P>
\n


\n

[root@localhost ~]# sqlplus<\/P>
\n

SQL*Plus: Release 10.2.0.1.0 – Production on \ubaa9 1\uc6d4 25 12:51:05 2007<\/P>
\n

Copyright (c) 1982, 2005, Oracle.  All rights reserved.<\/P>
\n

\uc0ac\uc6a9\uc790\uba85 \uc785\ub825:<\/P><\/DIV>
\n




\n


\n




\n
\uc6c5\ud30c \ucd94\uac00 (2009. 2. 10)~~~

\uc704 \ubd80\ubd84\uc740 \ub9ac\ub205\uc2a4\uc5d0\uc11c rpm\uc73c\ub85c \uc624\ub77c\ud074 \uc14b\ud305, \uc124\uce58\ud558\ub294 \ubd80\ubd84\uc785\ub2c8\ub2e4.
\uc544\ub798\ub294 php\uc640 \uc5f0\ub3d9\ubd80\ubd84\uc785\ub2c8\ub2e4.
\uc608\uc804\ubcf4\ub2e4 \uc5f0\ub3d9\uc740 \ubb34\ucc99 \uac04\ub2e8\ud574\uc84c\uc2b5\ub2c8\ub2e4.

\ud301 \ud558\ub098

\n
==================================================================
Oracle Database 10g Express Edition Release 10.2.0.1.0 – Production
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE); <= \uc774\uac70 \uba85\ub839\uc5b4\ub2e4.

PL\/SQL \ucc98\ub9ac\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.

SQL>
===================================================================

–> \uc678\ubd80\uc5d0\uc11c \uc544\uc774\ud53c:8080\/apex \ub85c \uc811\uc18d\uc774 \uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4. \uc124\uc815\ud6c4\uc5d4 FALSE \ub300\uc2e0 TRUE\ub85c \ubc14\uafd4\uc8fc\uba74 \ub429\ub2c8\ub2e4.<\/DIV>
\ub09c centos5.2\uc5d0 \uc124\uce58\ud588\ub294\ub370 php-devel\uc774 \uc124\uce58 \uc548\ub418\uc5b4\uc788\uc5b4\uc11c phpize\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc5c8\ub2e4.
\uadf8\ub798\uc11c yum install php-devel \ud6c4
yum install php-pear \uae4c\uc9c0 \uc124\uce58\ud55c\ud6c4\uc5d0
pecl install oci8
\uadf8\ub9ac\uace0 php.ini\uc5d0 extention=oci8.so <\/STRONG>\ub9cc \ucd94\uac00\ud574\uc8fc\uace0 \uc544\ud30c\uce58 \uc7ac\uc2dc\uc791 \ud558\uba74 \uc5f0\ub3d9 \ub05d
phpinfo(); \ud568\uc218\ub85c \ud655\uc778\ud574 \ubcf4\ub2c8 oci8 \uc774\ub77c\uace0 \ud56d\ubaa9\uc774 \ucd94\uac00\ub410\ub2e4.

\"User<\/DIV><\/DIV><\/A><\/DIV>
mysql\uacfc oracle \ub458\ub2e4 \uc774\uc0c1\uc5c6\uc774 \uc791\ub3d9.<\/p>\n","protected":false},"excerpt":{"rendered":"

\ucd9c\ucc98 http:\/\/newgifted.tistory.com\/entry\/Oracle-10g-Express-%EC%84%A4%EC%B9%98%EB%A6%AC%EB%88%85%EC%8A%A4\uc624\ub77c\ud074\uc744 \uae54\uae30\uc804\uc5d0 \ucd5c\uc18c\uc0ac\uc591\uc744 \ub9cc\uc871 \ud558\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.\ucd5c\uc18c \uc0ac\uc591\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. Oracle 10g Express\ucd5c\uc18c\uc0ac\uc591RAM   256MB(\uad8c\uc7a5 512MB) Disk space  1.5GByte Packages   glibc – 2.3.2  libaio – 0.3.96Swap Space 0~256MB (RAM\uc758 3\ubc30 \uc774\uc0c1)  256~512MB (RAM\uc758 2\ubc30 \uc774\uc0c1)  512MB \uc774\uc0c1 (1024GB \uc774\uc0c1) \uc704 \uc0ac\uc591\uc744 \ub9cc\uc871 \ud558\uc9c0 \uc54a\uc73c\uba74 \uc124\uce58 \uc790\uccb4\uac00 \ubd88\uac00\ub2a5 \ud569\ub2c8\ub2e4.\ub9cc\uc57d \uc124\uce58\uc911 glibc\ub098 libaio\ud328\ud0a4\uc9c0 \uc124\uce58\ub97c \uc694\uad6c\ud558\uba74 \uc544\ub798\uc640 \uac19\uc774 […]<\/p>\n","protected":false},"author":1,"featured_media":2555,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[459,402,460,461,462,463],"class_list":{"0":"post-2554","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-papa-php","8":"tag-oracle-10g","9":"tag-php","11":"tag-rpm","12":"tag-462","13":"tag-463"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/2554","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2554"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/2554\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/media\/2555"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2554"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2554"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2554"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}