{"id":840,"date":"2023-01-17T00:22:19","date_gmt":"2023-01-16T15:22:19","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=840"},"modified":"2023-01-17T00:22:19","modified_gmt":"2023-01-16T15:22:19","slug":"install-oracle-11g-on-centos7","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2023\/01\/17\/install-oracle-11g-on-centos7\/","title":{"rendered":"install Oracle 11g on CentOS7"},"content":{"rendered":"
\n

[21.02.02 \uc218\uc815] CentOS 7\uc5d0 Oracle 11g \uc124\uce58 \uc644\ubcbd\uc815\ub9ac!<\/h1>\n
\ub775\uc6a9<\/span>\u00a02021. 2. 2. 13:30<\/span><\/div>\n<\/div>\n
\n
\n

– \uc0ac\uc804\uc900\ube44<\/h2>\n

Oracle 11g \ud30c\uc77c\uc744 \uc900\ube44\ud569\ub2c8\ub2e4.<\/p>\n

https:\/\/www.oracle.com\/database\/technologies\/oracle-database-software-downloads.html<\/a><\/p>\n

\n
<\/div>\n
\n

Database Software Downloads | Oracle<\/p>\n

Oracle Database 11g Release 2 Standard Edition, Standard Edition One, and Enterprise Edition 7\/13: Patch Set 11.2.0.4 for Linux and Solaris is now available on support.oracle.com. Note: it is a full installation (you do not need to download 11.2.0.1 first)<\/p>\n

www.oracle.com<\/p>\n<\/div>\n<\/figure>\n

\ub4e4\uc5b4\uac08\ub54c\ub9c8\ub2e4 \ud398\uc774\uc9c0 \uad6c\uc131\uc774 \ubc14\ub00c\ub294 \uc624\ub77c\ud074 \ud648\ud398\uc774\uc9c0\uc5d0\uc11c\u00a0Oracle Database 11g Release 2\u00a0<\/b>\uc911\u00a0Linux x86-64<\/b>(64\ube44\ud2b8) \ud639\uc740\u00a0Linux-x86<\/b>(32\ube44\ud2b8)\ub97c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc2b5\ub2c8\ub2e4.<\/p>\n

<\/span><\/figure>\n

File1, File2 \ubaa8\ub450 \ub2e4\uc6b4\ubc1b\uc544\uc8fc\uc138\uc5ec<\/p>\n

 <\/p>\n

\uc18c\uc720\ud55c \ub9ac\ub205\uc2a4\uc758 \ube44\ud2b8\ub97c \ud655\uc778\ud558\ub294 \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0getconf LONG_BIT<\/b><\/p>\n

<\/span><\/figure>\n<\/blockquote>\n

<\/h2>\n

– \uc124\uce58 \uc2dc\uc791<\/h2>\n

1. \uc758\uc874 \ub77c\uc774\ube0c\ub7ec\ub9ac \uc124\uce58<\/h3>\n

root \uacc4\uc815\uc73c\ub85c \uc124\uce58\ud569\ub2c8\ub2e4.<\/i><\/p>\n

yum -y install compat-libstdc++-33.x86_64 binutils elfutils-libelf elfutils-libelf-devel<\/b>
\nyum -y install glibc glibc-common glibc-devel glibc-headers gcc gcc-c++ libaio-devel<\/b>
\nyum -y install libaio libgcc libstdc++ libstdc++ make sysstat unixODBC unixODBC-devel<\/b>
\nyum -y install unzip<\/b>
\nyum -y install compat-libstdc++-33.x86_64 binutils elfutils-libelf elfutils-libelf-devel<\/b><\/p><\/blockquote>\n

\ub9c8\uc9c0\ub9c9\uc5d0\u00a0Complete!<\/b>\u00a0\ubb38\uad6c\uac00 \ucd9c\ub825\ub410\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2f9.<\/p>\n

(Nothing to do<\/b>\u00a0\ub77c\uace0 \ucd9c\ub825\uc774 \ub418\uba74 \uc774\ubbf8 \ucd5c\uc2e0\ubc84\uc804\uc73c\ub85c \ub2e4\uc6b4\ub85c\ub4dc\uac00 \ub418\uc5b4\uc788\ub294\uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4.)<\/p>\n

** 21.02.02 \ucd94\uac00 **<\/b><\/i><\/p>\n

[ \uc624\ub958 \ub0b4\uc6a9 ]<\/b>
\n\uc704\uc758 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud560\ub54c \ub2e4\uc74c\uacfc \uac19\uc740 \uc624\ub958\uac00 \ubc1c\uc0dd\ud560 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

YumRepo\u00a0Error:\u00a0All\u00a0mirror\u00a0URLs\u00a0are\u00a0not\u00a0using\u00a0ftp,\u00a0http[s]\u00a0or\u00a0file.<\/b>
\nEg.\u00a0Invalid\u00a0release\/repo\/arch\u00a0combination\/<\/b>
\nremoving\u00a0mirrorlist\u00a0with\u00a0no\u00a0valid\u00a0mirrors:\u00a0\/var\/cache\/yum\/x86_64\/6\/base\/mirrorlist.txt<\/b>
\nError:\u00a0Cannot\u00a0find\u00a0a\u00a0valid\u00a0baseurl\u00a0for\u00a0repo:\u00a0base<\/b>
\n\u00a0<\/b>
\nYumRepo\u00a0Error:\u00a0All\u00a0mirror\u00a0URLs\u00a0are\u00a0not\u00a0using\u00a0ftp,\u00a0http[s]\u00a0or\u00a0file.\u00a0Eg.\u00a0Invalid\u00a0release\/repo\/arch\u00a0combination\/removing\u00a0mirrorlist\u00a0with\u00a0no\u00a0valid\u00a0mirrors:\u00a0\/var\/cache\/yum\/i386\/6\/base\/mirrorlist.txt<\/b>
\nError:\u00a0Cannot\u00a0find\u00a0a\u00a0valid\u00a0baseurl\u00a0for\u00a0repo:\u00a0base<\/b><\/p>\n

CentOS6 \ubc84\uc804 \uc5c5\ub370\uc774\ud2b8 \uc9c0\uc6d0\uc774 \uc885\ub8cc\ub418\uba74\uc11c yum update \ub4f1 \uba85\ub839\uc5b4 \uc0ac\uc6a9 \uc2dc \ubc1c\uc0dd\ud569\ub2c8\ub2e4.
\n\uc774\ub54c, \ud574\uacb0\ubc29\ubc95\uc744 \uc54c\ub824\ub4dc\ub9ac\uaca0\uc2b5\ub2c8\ub2e4.
\n32bit, 64bit \uc5d0 \ub530\ub77c \uba85\ub839\uc5b4\uac00 \ub2e4\ub974\ub2c8\u00a0getconf LONG_BIT<\/b><\/i>\uba85\ub839\uc5b4\ub97c \ud1b5\ud574 \ub9ac\ub205\uc2a4\uc758 \ube44\ud2b8\ub97c \ud655\uc778\ud574\uc8fc\uc138\uc5ec!<\/p>\n

<\/u>[ \ud574\uacb0\ubc29\ubc95 ]<\/b>
\n<\/u>\/\/ 32bit
\n[root@localhost ~]#\u00a0echo “https:\/\/vault.centos.org\/6.10\/os\/i386\/” > \/var\/cache\/yum\/i386\/6\/base\/mirrorlist.txt<\/b>
\n[root@localhost ~]#\u00a0\u00a0echo “http:\/\/vault.centos.org\/6.10\/extras\/i386\/” > \/var\/cache\/yum\/i386\/6\/extras\/mirrorlist.txt<\/b>
\n[root@localhost ~]#\u00a0echo “http:\/\/vault.centos.org\/6.10\/updates\/i386\/” > \/var\/cache\/yum\/i386\/6\/updates\/mirrorlist.txt<\/b><\/p>\n

\/\/ 64bit
\n[root@localhost ~]#\u00a0echo “https:\/\/vault.centos.org\/6.10\/os\/x86_64\/” > \/var\/cache\/yum\/x86_64\/6\/base\/mirrorlist.txt<\/b>
\n[root@localhost ~]#\u00a0echo “http:\/\/vault.centos.org\/6.10\/extras\/x86_64\/” > \/var\/cache\/yum\/x86_64\/6\/extras\/mirrorlist.txt<\/b>
\n[root@localhost ~]#\u00a0echo “http:\/\/vault.centos.org\/6.10\/updates\/x86_64\/” > \/var\/cache\/yum\/x86_64\/6\/updates\/mirrorlist.txt<\/p>\n

<\/b>\uba85\ub839\uc5b4 \uc785\ub825 \ud6c4, \ub2e4\uc74c \uba85\ub839\uc5b4 \uc2e4\ud589\ud574\uc8fc\uc138\uc5fc
\n[root@localhost ~]#\u00a0yum update<\/b><\/p>\n

\ucc38\uace0\ub85c \uc5f4\ub77c \uc624\ub798\uac78\ub9ac\ub354\ub77c\uace0\uc5ec…
\nupdate\uac00 \ubaa8\ub450 \ub05d\ub098\uba74 \uc5d0\ub7ec\ub0ac\ub358 \uc704\uc758 yum install \uc124\uce58 \uba85\ub839\uc5b4\ub4e4 \ub2e4\uc2dc \uc785\ub825\ud558\uba74 \uc798 \uc124\uce58\ub429\ub2c8\ub2e4!<\/p><\/blockquote>\n

<\/h3>\n

2. \ud30c\ub77c\ubbf8\ud130 \ubc0f \uc720\uc800 \ub9ac\uc18c\uc2a4 \uc124\uc815<\/h3>\n

1) \ucee4\ub110 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0vi \/etc\/sysctl.conf<\/b><\/p><\/blockquote>\n

\ub2e4\uc74c\uacfc \uac19\uc740 \uac12\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n

# Controls the maximum shared segment size, in bytes
\nkernel.shmmax = 68719476736<\/b><\/p>\n

# Controls the maximum number of shared memory segments, in pages
\nkernel.shmall = 10523004<\/b>
\nkernel.shmmni = 4096<\/b>
\nkernel.sem = 250 32000 100 128<\/b><\/p>\n

fs.aio-max-nr = 1048576<\/b>
\nfs.file-max = 6815744<\/b><\/p>\n

net.ipv4.ip_local_port_range = 9000 65500<\/b><\/p>\n

net.core.rmem_default = 262144<\/b>
\nnet.core.rmem_max = 4194304<\/b>
\nnet.core.wmem_default = 262144<\/b>
\nnet.core.wmem_max = 1048586<\/b><\/p><\/blockquote>\n

\ubcc0\uacbd \ud6c4 \ucee4\ub110 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc801\uc6a9\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0\/sbin\/sysctl -p<\/b><\/p><\/blockquote>\n

2) \uc720\uc800\uc758 \uc790\uc6d0 \uc0ac\uc6a9 \uc81c\ud55c\uac12\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0vi \/etc\/security\/limits.conf<\/b><\/p><\/blockquote>\n

\ud574\ub2f9 \ud30c\uc77c \ub9e8 \ubc11\uc5d0 \ucd94\uac00\ud574\uc8fc\uc138\uc5fc<\/p>\n

oracle soft nproc 2048<\/b>
\noracle hard nproc 65536<\/b>
\noracle soft nofile 1024<\/b>
\noracle hard nofile 65536<\/b><\/p><\/blockquote>\n

3) SELINUX \uc124\uc815\uc744 \ud574\uc81c\ud569\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0vi \/etc\/selinux\/config<\/b><\/p><\/blockquote>\n

\ub2e4\uc74c\uacfc \uac19\uc774 \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n

# This file controls the state of SELinux on the system.
\n# SELINUX= can take one of these three values:
\n#\u00a0 \u00a0 \u00a0enforcing – SELinux security policy is enforced.
\n#\u00a0 \u00a0 \u00a0permissive – SELinux prints warnings instead of enforcing.
\n#\u00a0 \u00a0 \u00a0disabled – No SELinux policy is loaded.
\nSELINUX=disabled<\/b><\/p><\/blockquote>\n

3. \uc720\uc800 \uc0dd\uc131, \ud658\uacbd\ubcc0\uc218 \uc124\uc815, \uad8c\ud55c \uc124\uc815<\/h3>\n

\uc624\ub77c\ud074\uc744 \uc0ac\uc6a9\ud560 \uc720\uc800\ub97c \uc0dd\uc131\ud558\uace0 \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0groupadd dba<\/b>
\n[root@localhost ~]#\u00a0useradd -g dba oracle<\/b>
\n[root@localhost ~]#\u00a0passwd oracle<\/b><\/p><\/blockquote>\n

\uc624\ub77c\ud074\uc744 \uc124\uce58\ud560 \ub514\ub809\ud130\ub9ac\ub97c \uc0dd\uc131\ud558\uace0 \uc704\uc5d0\uc11c \ub9cc\ub4e0 oracle \uacc4\uc815\uc5d0 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0mkdir -p \/app\/oracle<\/b>
\n[root@localhost ~]#\u00a0chown -R oracle:dba \/app<\/b>
\n[root@localhost ~]#\u00a0chmod -R 775 \/app<\/b><\/p><\/blockquote>\n

oracle \uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud558\uc5ec \ubcc0\uc218\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0su – oracle<\/b>
\n[oracle@localhost ~]$\u00a0vi .bash_profile<\/b><\/p><\/blockquote>\n

export ORACLE_BASE=\/app\/oracle<\/b>
\nexport ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/dbhome_1<\/b>
\nexport ORACLE_SID=orcl<\/b>
\nexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8<\/b>
\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib:\/usr\/local\/lib<\/b>
\nexport PATH=$PATH:$ORACLE_HOME\/bin<\/b><\/p>\n

# alias
\nalias ss=’sqlplus \/ as sysdba’<\/b><\/p><\/blockquote>\n

4. ORACLE \uc124\uce58\ud558\uae30<\/h2>\n

FileZilla\ub098 MobaXterm\uc744 \uc774\uc6a9\ud574\uc11c \ub85c\uceec \ucef4\ud4e8\ud130\uc5d0\uc11c \ub2e4\uc6b4\ubc1b\uc740 \uc624\ub77c\ud074 \ud30c\uc77c\uc744 \ub9ac\ub205\uc2a4 \uc11c\ubc84\ub85c \uc27d\uac8c \uc62e\uae38\uc218 \uc788\uc9c0\ub9cc<\/p>\n

\ubaa8\ub974\uc2dc\ub294 \ubd84\ub4e4\uc740 \ubc11\uc5d0\u00a0\ub354\ubcf4\uae30<\/b><\/i>\u00a0\ub780\uc744 \ucc38\uace0\ud574\uc11c \uba85\ub839 \ud504\ub86c\ud504\ud2b8(cmd)\ub97c \uc774\uc6a9\ud574 \ud30c\uc77c\uc744 \uc62e\uaca8\uc8fc\uc138\uc5fc<\/p>\n

\ub354\ubcf4\uae30<\/a><\/div>\n

 <\/p>\n

 <\/p>\n

\ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740 \uc124\uce58\ud30c\uc77c\uc758 \uc555\ucd95\uc744 \ud574\uc81c\ud569\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0unzip linux.x64_11gR2_database_1of2.zip<\/b>
\n[oracle@localhost ~]$\u00a0unzip linux.x64_11gR2_database_2of2.zip<\/b><\/p><\/blockquote>\n

\uc555\ucd95 \ud574\uc81c\ud55c \ub4a4 \uc124\uce58 \ub514\ub809\ud130\ub9ac\uc5d0\uc11c \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0su – root<\/b>
\n\uc554\ud638 :
\n[root@localhost ~]#\u00a0xhost +
\n<\/b>[root@localhost ~]#\u00a0su – oracle
\n<\/b>[oracle@localhost ~]$\u00a0cd database
\n<\/b>[oracle@localhost database]$\u00a0.\/runInstaller
\n<\/b><\/p><\/blockquote>\n

\u203b\u00a0xhost +<\/b>\u00a0\ud588\uc744 \ub54c\u00a0command not found<\/b>\u00a0\ub610\ub294\u00a0unable to open display “”<\/b>\u00a0\ub728\uc2dc\ub294 \ubd84\ub4e4\uc740<\/p>\n

[root@localhost ~]#\u00a0yum install xorg*
\n<\/b>[root@localhost ~]#\u00a0export<\/b>\u00a0DISPLAY=localhost:0.0<\/b>
\n[root@localhost ~]#\u00a0su – oracle<\/b>
\n[oracle@localhost ~]$\u00a0export DISPLAY=localhost:0.0<\/b>
\n[oracle@localhost ~]$\u00a0cd database<\/b>
\n[oracle@localhost database]$\u00a0.\/runInstaller<\/b><\/p>\n

>>>> Could not execute auto check for display colors using command \/usr\/bin\/xdpyinfo. Check if the DISPLAY variable is set. Failed <<<<<\/i>
\n\uc5d0\ub7ec\uac00 \ub0a0 \uacbd\uc6b0 \ucf1c\uc838\uc788\ub294 \ub9ac\ub205\uc2a4 \uc11c\ubc84\ub97c \ubaa8\ub450 \uc885\ub8cc\ud558\uace0 \ub2e4\uc2dc \uc2e4\ud589\ud574\uc8fc\uc138\uc694<\/i><\/p>\n

[oracle@localhost ~]$\u00a0cd database<\/b>
\n[oracle@localhost database]$\u00a0.\/runInstaller<\/b><\/p><\/blockquote>\n

<\/span><\/figure>\n

\uc704\uc5d0\ucc98\ub7fc \ud55c\uae00\uc774 \uae68\uc9c0\uba74 \ubc11\uc5d0 \uc0ac\uc9c4\uc744 \ucc38\uace0\ud574\uc11c \uc6b0\uc120 \uc885\ub8cc\ud574\uc90d\ub2c8\ub2e4.<\/p>\n

<\/span><\/figure>\n

\uc601\uc5b4 \uc124\uc815\ud558\uace0 \ub2e4\uc2dc \uc2e4\ud589 \ud574\uc904\uac8c\uc5ec<\/p>\n

[oracle@localhost database]$\u00a0export LANG=C<\/b>
\n[oracle@localhost database]$\u00a0export LC_ALL=C<\/b>
\n[oracle@localhost database]$\u00a0.\/runInstaller<\/b><\/p><\/blockquote>\n

\uccb4\ud06c \ud574\uc81c\ud558\uace0 Next (\ubb50\ub77c \ucc3d \ub728\uba74 \uac4d yes\ud558\uace0 \ub118\uaca8\ub3c4\ub429\ub2c8\ub2e4)<\/p>\n

<\/span><\/figure>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub9cc \uc124\uce58\ud558\ub294\uac83\uc73c\ub85c \uc124\uc815\ud558\uace0 Next<\/p>\n

<\/span><\/figure>\n

Single instance<\/b><\/i>\u00a0\uc6c5\uc575\uc6c5 \uccb4\ud06c Next<\/p>\n

<\/span><\/figure>\n

\ud56d\uad6c\uac70 \ucd94\uac00 \ud6c4 \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

Enterprise Edition<\/b><\/i>\u00a0\uc120\ud0dd \ud6c4 \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\uc544\uae4c \uc704\uc5d0\uc11c ORACLE_HOME \ubcc0\uc218 \uc120\uc5b8\ud574\uc92c\uc96c? \uacbd\ub85c\uac12 \ud655\uc778 \ud6c4 \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\uc774\uac83\ub3c4 \uc544\uae4c \uc704\uc5d0\uc11c \uc720\uc800 \uc0dd\uc131\ud560\ub300 \ubd80\uc5ec\ud55c Group\uacfc Inventory \uacbd\ub85c \ud655\uc778 \ud6c4 \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\uadf8\ub8f9\uba85 \ud655\uc778 \ud6c4 \u3134\u3145\u314c<\/p>\n

 <\/p>\n

<\/span><\/figure>\n

Ignore All<\/b><\/i>\u00a0\uccb4\ud06c \ud6c4 \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\ucd5c\uc885 \uc124\uc815 \uac12 \ud655\uc778 \ud6c4 Finish<\/p>\n

<\/span><\/figure>\n

\uc544\ub798\uc640 \uac19\uc774 \uc124\uce58\uac00 \uc798 \ub418\ub2e4\uac00<\/p>\n

<\/span><\/figure>\n

84% \ucbe4\uc5d0 \uc544\ub798\uc640 \uac19\uc740 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\uae38\ub798<\/p>\n

<\/span><\/figure>\n

\uc124\uce58\uc911\uc778 \ucc3d\uc744 \ub044\uc9c0\ub9d0\uace0 \uc0c8\ub85c \ucc3d\uc744 \uc5f4\uc5b4\uc11c oracle \uacc4\uc815\uc744 \ub85c\uadf8\uc778\ud558\uace0 \uc800\uae30 \uacbd\ub85c\ub85c \uac11\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0cd \/app\/product\/11.2.0\/dbhome_1\/ctx\/lib<\/b>
\n[oracle@localhost lib]$\u00a0vi ins_ctx.mk<\/b><\/p><\/blockquote>\n

\uc544\ub798\uc640 \uac19\uc740 \uad6c\ubb38\uc744 \ucc3e\uc2b5\ub2c8\ub2e4.<\/p>\n

ctxhx: $(CTXHXOBJ)
\n$(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK)<\/p><\/blockquote>\n

\uc544\ub798\uc640 \uac19\uc774 \uc218\uc815\ud558\uace0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n

ctxhx: $(CTXHXOBJ)
\n-static<\/b>\u00a0$(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK)<\/p><\/blockquote>\n

Retry<\/b><\/i>\u00a0\ubc84\ud2bc\uc744 \uc120\ud0dd\ud574\uc11c \uc7ac\uc2dc\ub3c4\ud569\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

\uc798\ub418\ub2e4\uac00 \ub610 \ub2e4\ub978 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub124\uc5fc<\/p>\n

<\/span><\/figure>\n

\ub610 \uc800\uae30 \uacbd\ub85c\ub85c \uac00\uc11c \ud30c\uc77c\uc744 \uc218\uc815\ud574\uc90d\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0cd \/app\/product\/11.2.0\/dbhome_1\/sysman\/lib<\/b>
\n[oracle@localhost lib]$\u00a0vi ins_emagent.mk<\/b><\/p><\/blockquote>\n

\uc544\ub798\uc640 \uac19\uc740 \uad6c\ubb38\uc744 \ucc3e\uc544\uc11c<\/p>\n

$(SYSMANBIN) emdctl:
\n$(MK_EMAGENT_NMECTL)<\/p><\/blockquote>\n

\uc544\ub798\uc640 \uac19\uc774 \uc218\uc815\ud558\uace0 \uc800\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n

$(SYSMANBIN) emdctl:
\n$(MK_EMAGENT_NMECTL)\u00a0-lnnz11<\/b><\/p><\/blockquote>\n

Retry<\/b><\/i>\u00a0\ubc84\ud2bc\uc744 \uc120\ud0dd\ud574\uc11c \uc7ac\uc2dc\ub3c4\ud569\ub2c8\ub2e4. \uc798\ub418\ub294\uad70\uc5fc<\/p>\n

 <\/p>\n

\uc644\ub8cc\ub420\ub54c\ucbe4 \uc258 \uc2a4\ud06c\ub9bd\ud2b8 \uc2e4\ud589\ud558\ub77c\ub294 \uc548\ub0b4\ucc3d\uc774 \ub739\ub2c8\ub2e4.<\/p>\n

<\/span><\/figure>\n

\ud558\ub77c\ub294\ub300\ub85c \ub530\ub77c\ud558\uba74\ub429\ub2c8\ub2e4. \uc0c8 \ucc3d\uc744 \uc5f4\uc5b4\uc11c root \uacc4\uc815\uc73c\ub85c \uc2e4\ud589\ud574\uc90d\ub2c8\ub2e4.<\/p>\n

[root@localhost ~]#\u00a0\/usr\/oracle\/oraInventory\/orainstRoot.sh<\/b>
\nChanging permissions of \/app\/oraInventory.
\nAdding read,write permissions for group.
\nRemoving read,write,execute permissions for world.<\/p>\n

Changing groupname of \/app\/oraInventory to dba.
\nThe execution of the script is complete.
\n[root@localhost ~]#\u00a0\/usr\/oracle\/app\/product\/11.2.0\/dbhome_1\/root.sh<\/b>
\nRunning Oracle 11g root.sh script…<\/p>\n

The following environment variables are set as:
\nORACLE_OWNER= oracle
\nORACLE_HOME= \u00a0\/app\/oracle\/product\/11.2.0\/dbhome_1<\/p>\n

Enter the full pathname of the local bin directory: [\/usr\/local\/bin]:\u00a0[ENTER]\ud0a4 \ub204\ub974\uc138\uc6a9<\/b>
\nCopying dbhome to \/usr\/local\/bin …
\nCopying oraenv to \/usr\/local\/bin …
\nCopying coraenv to \/usr\/local\/bin …<\/p>\n

Creating \/etc\/oratab file…
\nEntries will be added to the \/etc\/oratab file as needed by
\nDatabase Configuration Assistant when a database is created
\nFinished running generic part of root.sh script.
\nNow product-specific root actions will be performed.
\nFinished product-specific root actions.<\/p><\/blockquote>\n

\uc124\uce58\uac00 \uc644\ub8cc\ub418\uba74 \ucc3d\uc744 \uc885\ub8cc\ud558\uace0 \ud658\uacbd\ubcc0\uc218\ub97c \uc801\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n

[oracle@localhost database]$\u00a0source ~\/.bash_profile<\/b><\/p><\/blockquote>\n

5. \ub9ac\uc2a4\ub108 \uc0dd\uc131<\/h3>\n

\ub2e4\uc74c \uba85\ub839\uc5b4\ub85c \ub9ac\uc2a4\ub108\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n

[oracle@localhost database]$\u00a0netca<\/b><\/p><\/blockquote>\n

\u203b\u00a0netca command not found<\/b>\u00a0\uc6c5\uc575\uc6c5 \uc5d0\ub7ec \ub730 \uacbd\uc6b0 \ub2e4\uc74c\uacfc \uac19\uc740 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uc138\uc5fc<\/p>\n

\uc704\uc5d0\uc11c \ud658\uacbd\ubcc0\uc218\uac00 \uc801\uc6a9\uc774 \uc548\ub418\uc5c8\uac70\ub098 \uc624\ub77c\ud074\uc774 \uc124\uce58\ub41c path\uac00 \uc798\ubabb\ub420 \uacbd\uc6b0 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0cd \/app\/oracle\/product\/11.2.0\/dbhome_1\/bin<\/b>
\n[oracle@localhost ~]$\u00a0.\/netca<\/b><\/p><\/blockquote>\n

Listener configuration<\/b><\/i>\u00a0\uccb4\ud06c \ud6c4 Next<\/p>\n

<\/span><\/figure>\n

\ucd5c\ucd08 \uad6c\uc131\uc774\ubbc0\ub85c\u00a0Add<\/b><\/i>\u00a0\uc120\ud0dd \ud6c4 Next<\/p>\n

<\/span><\/figure>\n

\uc544\ubb3b\ub530 Next<\/p>\n

<\/span><\/figure>\n

\ud655\uc778 \ud6c4 \ub125\uc2a4\ud2b8<\/p>\n

<\/span><\/figure>\n

\uc624\ub77c\ud074 \uae30\ubcf8\ud3ec\ud2b8 1521 \ud655\uc778 \ud6c4 \ub125\uc2a4\ud2b8<\/p>\n

<\/span><\/figure>\n

\ub2e4\ub978 \ub9ac\uc2a4\ud130 \ucd94\uac00 \ud560\uac70\ub2c8? \uc544\ub2c8 > \ub125\uc2a4\ud2b8<\/p>\n

<\/span><\/figure>\n

\ub05d\ub0ac\ub2f9 \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

Finish \uc120\ud0dd\ud574\uc11c \ucc3d \uc885\ub8cc<\/p>\n

<\/span><\/figure>\n

6. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131<\/h3>\n

\ub2e4\uc74c \uba85\ub839\uc5b4\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0dbca<\/b><\/p><\/blockquote>\n

\uc0dd\uc131\uc2dc\uc791 Next<\/p>\n

<\/span><\/figure>\n

Create a Database<\/b><\/i>\u00a0\uc120\ud0dd\ud558\uace0 Next<\/p>\n

<\/span><\/figure>\n

\uc6c5\uc6c5 \uc54c\uaca0\uc5b4\uc5fc \ud655\uc778\ud558\uad6c Next<\/p>\n

<\/span><\/figure>\n

ORACLE SID\ub97c\u00a0orcl<\/b>\ub85c \uc124\uc815\ud558\uace0 \ub125\uc2a4\ud2b8<\/p>\n

(SID\ub97c orcl \ub9d0\uace0 \ub2e4\ub978\uac78\ub85c \ubcc0\uacbd\ud558\uace0 \uc2f6\uc73c\uba74 .bash_profile\uc758 ORACLE_SID \ubcc0\uc218 \uac12\ub3c4 \ubcc0\uacbd\ud574\uc8fc\uc5b4\uc57c\ud574\uc5ec)<\/p>\n

<\/span><\/figure>\n

\uace0\ub300\ub85c \ub125\uc2a4\ud2b8<\/p>\n

<\/span><\/figure>\n

\uad00\ub9ac\uc790 \uc804\uccb4 \uacc4\uc815\uc5d0 \ub3d9\uc77c \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud55c\ub2e4\ub294 \uc635\uc158 \uccb4\ud06c \ud6c4 \ud328\uc2a4\uc6cc\ub4dc \uc124\uc815<\/p>\n

(\uae4c\uba39\uc73c\uba74 \uadc0\ucc2e\uc544\uc9c0\ub2c8\uae4c \uc26c\uc6b4\uac78\ub85c \uc124\uc815\ud558\uc138\uc5fc)<\/p>\n

<\/span><\/figure>\n

\ud328\uc2a4\uc6cc\ub4dc\ub97c \ub2e8\uc21c\ud558\uac8c \uc124\uc815\ud558\uba74 \ub728\ub294 \ud655\uc778\ucc3d\uc784\ub2e4\u00a0Yes<\/b><\/i>\ub97c \uc120\ud0dd\ud574\uc11c \ubb34\uc2dc\ud558\uace0 \ub118\uc5b4\uac00\uc2dc\uc838<\/p>\n

<\/span><\/figure>\n

\ub125\uc2a4\ud2b8<\/p>\n

<\/span><\/figure>\n

\u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\uc11c\ubc84 \uba54\ubaa8\ub9ac \uc0ac\uc591\uc5d0 \ub530\ub77c \uc124\uc815\ub41c \uac12\uc784\ub2e4 \uadf8\ub300\ub85c \uc124\uc815\ud558\uace0 [Sizing<\/b>] \ud0ed\uc744 \uc120\ud0dd\ud574\uc8fc\uc138\uc5ec<\/p>\n

<\/span><\/figure>\n

\ud655\uc778\ud558\uace0 [Character Sets] \ud0ed \uc120\ud0dd\ud558\uc138\uc5ec<\/p>\n

<\/span><\/figure>\n

UTF-8\uc774\ub791 \ud56d\uad6c\uac70\ub85c \uc124\uc815\ud558\uace0 [Connection Mode<\/b>] \uc120\ud0dd<\/p>\n

<\/span><\/figure>\n

\uae30\ubcf8 \uc124\uc815\uac12 \uace0\ub300\ub85c \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\uc124\uc815\ub41c \uac12 \ud655\uc778\ud558\uace0 \u3134\u3145\u314c<\/p>\n

<\/span><\/figure>\n

\ud53c\ub2c8\uc26c<\/p>\n

<\/span><\/figure>\n

\ub9c8\uc9c0\ub9c9\uc73c\ub85c \uc124\uce58 \uc804\uc5d0 \ud655\uc778\ud558\uace0 OK<\/p>\n

<\/span><\/figure>\n

\uc544\ub798\uc640 \uac19\uc774 \uc124\uce58\ub429\ub2c8\ub2e4<\/p>\n

(\ub098\ub9cc\uadf8\ub7f0\uac00 \uc124\uce58 \uc5f4\ub77c\ub290\ub9bc)<\/p>\n

<\/span><\/figure>\n

\uc544\ub798\uc640 \uac19\uc740 \ucc3d \ub728\uba74 \uc124\uce58 \uc644\ub8cc\ub41c\uac81\ub2c8\ub2e4.<\/p>\n

<\/span><\/figure>\n

 <\/p>\n

\u314e\u314f,, \uc774\uc81c \ubaa8\ub450 \uc124\uce58 \uc644\ub8cc\uac00 \ub410\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774\uc81c \uc2e4\ud589\ud558\ub294 \uac83\ub9cc \ub0a8\uc558\uad70\uc5ec,,,<\/p>\n

7. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc0f \ub9ac\uc2a4\ub108 \uc2e4\ud589<\/h3>\n

\uc544\uae4c \uc704\uc5d0\uc11c .bash_profile\uc5d0 alias\ub85c sysdba\ub85c \uc811\uc18d\ud558\ub294 \ubcc4\uce6d\uc744 \uc8fc\uc5c8\uae30 \ub54c\ubb38\uc5d0 \uc544\ub798\uc640 \uac19\uc740 \uba85\ub839\uc5b4\ub85c \uc811\uc18d\ud569\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0ss<\/b><\/p>\n

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jan 31 13:56:58 2020<\/p>\n

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

Connected to:
\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<\/p>\n

SQL>\u00a0startup<\/b>
\nORA-01081: cannot start already-running ORACLE – shut it down first
\nSQL>\u00a0shutdown immediate<\/b>
\nDatabase closed.
\nDatabase dismounted.
\nORACLE instance shut down.
\nSQL>\u00a0startup<\/b>
\nORACLE instance started.<\/p>\n

Total System Global Area\u00a0 \u00a0768294912 bytes
\nFixed Size\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02217304 bytes
\nVariable Size\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0486541992 bytes
\nDatabase Buffers\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 276824064 bytes
\nRedo Buffers\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02711552 bytes
\nDatabase mounted.
\nDatabase opened.
\nSQL >\u00a0exit<\/b><\/p><\/blockquote>\n

\ub9ac\uc2a4\ub108 \uae30\ub3d9 \uc0c1\ud0dc\ub97c \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n

[oracle@localhost ~]$\u00a0lsnrctl status<\/b><\/p>\n

LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 31-JAN-2020 14:01:07<\/p>\n

Copyright (c) 1991, 2009, Oracle. All rights reserved.<\/p>\n

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx)(PORT=1521)))
\nSTATUS of the LISTENER
\n————————
\nAlias\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 LISTENER
\nVersion\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TNSLSNR for Linux: Version 11.2.0.1.0 – Production
\nStart Date\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a030-JAN-2020 17:28:30
\nUptime\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a00 days 20 hr. 32 min. 36 sec
\nTrace Level\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 off
\nSecurity\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 ON: Local OS Authentication
\nSNMP\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 OFF
\nListener Parameter File\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/app\/oracle\/product\/11.2.0\/dbhome_1\/network\/admin\/listener.ora
\nListener Log File\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \/app\/oracle\/diag\/tnslsnr\/localhost\/listener\/alert\/log.xml
\nListening Endpoints Summary…
\n(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.xx)(PORT=1521)))
\n(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
\nServices Summary…
\nService “orcl” has 1 instance(s).
\nInstance “orcl”, status UNKNOWN, has 1 handler(s) for this service…
\nThe command completed successfully<\/p><\/blockquote>\n

\ub9ac\uc2a4\ub108\ub294\u00a0lsnrctl start<\/b>\u00a0\ub610\ub294\u00a0lsnrctl stop<\/b>\u00a0\uba85\ub839\uc5b4\ub97c \uc774\uc6a9\ud574\uc11c \ub044\uace0 \ucf1c\uace0\ub97c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

8. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uacc4\uc815 \uc0dd\uc131<\/h3>\n

\uc774\uc81c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uacc4\uc815\uc744 \uc0dd\uc131\ud574\uc11c SQLDeveloper\uc5d0 \ubd99\uc5b4\ubcfc\uac81\ub2c8\ub2e4.<\/p>\n

 <\/p>\n

\uc800\ub294 \uc81c \ud2f0\uc2a4\ud1a0\ub9ac \uc8fc\uc18c\uc778 xxsiyoung \uc774\ub984\uc73c\ub85c \uacc4\uc815\uc744 \ub9cc\ub4e4\uace0 \uad8c\ud55c\uae4c\uc9c0 \uc918\ubcf4\uaca0\uc2b4\ub2e4.<\/p>\n

\ucc38\uace0\ub85c \uc800\ub294 \uadc0\ucc2e\uc544\uc11c \uacc4\uc815 \uc544\ub514\ub791 \ube44\ubc88\uc744 \ub611\uac19\uc774 \ub9cc\ub4e4\uc5b4\uc694<\/p>\n

\ubc11\uc5d0 \uba85\ub839\uc5b4\uc911\uc5d0\u00a0identified by<\/b>\u00a0\ub4a4\uc5d0\ub294 \ube44\ubc00\ubc88\ud638\ub97c \uc124\uc815\ud558\ub294 \uac81\ub2c8\ub2e4.<\/p>\n

\uad8c\ud55c\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\ud558\ub294\ub370 \ud544\uc694\ud55c \uad8c\ud55c\uc740 \ub2e4 \uc92c\uc5b4\uc694<\/p>\n

\uc790\uc138\ud55c \uad8c\ud55c \uc124\uba85\uc740 \uad6c\uae00\ub9c1 \ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4,,<\/p>\n

[oracle@localhost ~]#\u00a0ss<\/b>
\n…<\/p>\n

SQL>\u00a0CREATE USER xxsiyoung identified by xxsiyoung;<\/b><\/p>\n

User created.<\/p>\n

SQL>\u00a0GRANT resource, connect, dba to xxsiyoung;<\/b><\/p>\n

Grant succeeded.<\/p><\/blockquote>\n

\ub2e4\uc74c\uacfc \uac19\uc740 \uba85\ub839\uc5b4\ub85c \uc0dd\uc131\ud55c \uacc4\uc815\uc774 \uc798 \ub9cc\ub4e4\uc5b4\uc84c\ub294\uc9c0 \ud655\uc778\ud574\uc8fc\uc138\uc5ec<\/p>\n

SQL>\u00a0SELECT * FROM ALL_USERS;
\n<\/b><\/p>\n

<\/span><\/figure>\n<\/blockquote>\n

9. SQLDeveloper\uc5d0 \uc5f0\uacb0\ud558\uae30 (\uc678\ubd80\uc811\uc18d\ud558\uae30)<\/h3>\n

\uc774\uc81c \uc0dd\uc131\uc744 \ud588\uc73c\uba74 \uc0ac\uc6a9\ud558\uae30 \uc27d\uac8c SQLDeveloper\uc5d0 \uc5f0\uacb0\ud560\uac81\ub2c8\ub2e4.<\/p>\n

$ORACLE_HOME\/network\/admin<\/b>\u00a0\ud3f4\ub354\uc5d0 \uc788\ub294\u00a0listener.ora<\/b>\u00a0\ud30c\uc77c\uacfc\u00a0tnsnames.ora<\/b>\u00a0\ud30c\uc77c\uc744 \uc218\uc815\ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

\uc6b0\uc120 \uc5ec\ub7ec\ubd84\uc758 .ora \ud30c\uc77c\ub4e4\uc740 \ubc31\uc5c5\ud574\uc8fc\uc2dc\uace0 \uc81c \ud30c\uc77c\uc744 \ucc38\uace0\ud574\uc8fc\uc138\uc6a4<\/p>\n

 <\/p>\n

listener.ora \ud30c\uc77c<\/p>\n

(\uc5ec\ub7ec\ubd84 \uc11c\ubc84 ip\ub97c xx.xx.xx.xx \uc790\ub9ac\uc5d0 \ub123\uc5b4\uc8fc\uc138\uc5ec)<\/p>\n

…<\/p>\n

SID_LIST_LISTENER =<\/b>
\n\u00a0 \u00a0(SID_LIST =<\/b>
\n\u00a0 \u00a0 \u00a0(SID_DESC =<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0(SID_NAME = orcl)<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0(ORACLE_HOME = \/app\/oracle\/product\/11.2.0\/dbhome_1)<\/b>
\n\u00a0 \u00a0 \u00a0)<\/b>
\n\u00a0 \u00a0)<\/b><\/p>\n

LISTENER =<\/b>
\n\u00a0 \u00a0(DESCRIPTION_LIST =<\/b>
\n\u00a0 \u00a0 \u00a0(DESCRIPTION =<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<\/b>
\n\u00a0 \u00a0 \u00a0)<\/b>
\n\u00a0 \u00a0)<\/b><\/p>\n

ADR_BASE_LISTENER = \/app\/oracle<\/b><\/p><\/blockquote>\n

 <\/p>\n

tnsnames.ora \ud30c\uc77c<\/p>\n

(\uc5ec\ub7ec\ubd84 \uc11c\ubc84 ip\ub97c xx.xx.xx.xx \uc790\ub9ac\uc5d0 \ub123\uc5b4\uc8fc\uc138\uc5ec)<\/p>\n

…<\/p>\n

LISTENER_ORCL =<\/b>
\n\u00a0 \u00a0(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))<\/b><\/p>\n

ORACLR_CONNECTION_DATA =<\/b>
\n\u00a0 \u00a0 (DESCRIPTION =<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 (ADDRESS_LIST =<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 )<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 (CONNECT_DATA =<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0(SID = CLRExtProc)<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0(PRESENTATION = RO)<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 )<\/b>
\n\u00a0 \u00a0 )<\/b><\/p>\n

ORCL =<\/b>
\n\u00a0 \u00a0 (DESCRIPTION =<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 (CONNECT_DATA =<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 (SERVER = DEDICATED)<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 (SERVICE_NAME = orcl)<\/b>
\n\u00a0 \u00a0 \u00a0 \u00a0 )<\/b>
\n\u00a0 \u00a0 )<\/b><\/p><\/blockquote>\n

\uc800\uc7a5\ud558\uace0 \ub9ac\uc2a4\ub108\ub97c \uaed0\ub2e4\uac00 \ub2e4\uc2dc \ucf2d\ub2c8\ub2e4.<\/p>\n

[oracle@localhost admin]$\u00a0lsnrctl stop<\/b>
\n[oracle@localhost admin]$\u00a0lsnrctl start<\/b><\/p><\/blockquote>\n

 <\/p>\n

\uc774\uc81c SQLDeveloper\ub97c \uc2e4\ud589\ud574\uc11c \uc0c8 \uc811\uc18d\uc744 \ud569\ub2c8\ub2e4.<\/p>\n

[\ud14c\uc2a4\ud2b8<\/b>] \ubc84\ud2bc\uc744 \ub20c\ub7ec\uc11c [\uc131\uacf5<\/b>] \uc774 \ubc14\ub85c \ub728\uba74 \uc88b\uaca0\uc9c0\ub9cc,,<\/p>\n

\ub9cc\uc57d\uc5d0 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5d0\ub7ec\uac00 \ub09c\ub2e4,,?<\/p>\n

<\/span><\/figure>\n

\uc811\uc18d\uc5d0\ub7ec\uac00 \ub09c\uac81\ub2c8\ub2e4,, \ud55c\ubc88 \ud574\uacb0\ud574\ubd05\uc2dc\ub2e4 \u3160<\/p>\n

 <\/p>\n

1) \ubc29\ud654\ubcbd\uc744 \uc5fd\ub2c8\ub2e4<\/p>\n

[root@localhost ~]#\u00a0firewall-cmd –permanent –zone=public –add-port=1521\/tcp<\/b>
\nsuccess<\/p><\/blockquote>\n

SQLDeveloper\uc5d0\uc11c \ud14c\uc2a4\ud2b8\ub97c \ud574\ubd05\ub2c8\ub2e4. \uadf8\ub798\ub3c4 \uc5d0\ub7ec\uac00 \ub098\uba74,, \u2193\u2193\u2193<\/p>\n

 <\/p>\n

2) \ub9ac\uc2a4\ub108 \uc885\ub8cc- \ub514\ube44 \uc885\ub8cc – \ub514\ube44 \uc5f0\uacb0 – \ub9ac\uc2a4\ub108 \uc5f0\uacb0 – \ub9ac\uc2a4\ub108 \ub3d9\uc791\ud655\uc778 – sqlplus\ub85c \ubd99\uace0 – SQLDeveloper\uc5d0 \uc5f0\uacb0<\/p>\n

[oracle@localhost ~]$\u00a0lsnrctl stop<\/b>
\n[oracle@localhost ~]$\u00a0lsnrctl start<\/b>
\n[oracle@localhost ~]$\u00a0sqlplus \/nolog<\/b>
\n…<\/p>\n

SQL>\u00a0conn \/as sysdba<\/b>
\nSQL>\u00a0shutdown immediate<\/b>
\n…
\nSQL>\u00a0startup<\/b>
\n…
\nSQL>\u00a0exit<\/b>
\n[oracle@localhost ~]$\u00a0lsnrctl stop<\/b>
\n[oracle@localhost ~]$\u00a0lsnrctl start
\n<\/b>[oracle@localhost ~]$\u00a0lsnrctl status<\/b><\/p><\/blockquote>\n

SQLDeveloper\uc5d0\uc11c \ud14c\uc2a4\ud2b8\ub97c \ud574\ubd05\ub2c8\ub2e4. \uc800\ub294 \uc774\ucf00 \ud558\ub2c8\uae4c \ub418\ub354\ub77c\uad6c\uc5ec \uc624\uc608~<\/p>\n

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

[21.02.02 \uc218\uc815] CentOS 7\uc5d0 Oracle 11g \uc124\uce58 \uc644\ubcbd\uc815\ub9ac! \ub775\uc6a9\u00a02021. 2. 2. 13:30 – \uc0ac\uc804\uc900\ube44 Oracle 11g \ud30c\uc77c\uc744 \uc900\ube44\ud569\ub2c8\ub2e4. https:\/\/www.oracle.com\/database\/technologies\/oracle-database-software-downloads.html Database Software Downloads | Oracle Oracle Database 11g Release 2 Standard Edition, Standard Edition One, and Enterprise Edition 7\/13: Patch Set 11.2.0.4 for Linux and Solaris is now available on support.oracle.com. Note: it is a full […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-840","post","type-post","status-publish","format-standard","hentry","category-about-linux"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=840"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/840\/revisions"}],"predecessor-version":[{"id":841,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/840\/revisions\/841"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}