{"id":414,"date":"2013-10-08T16:32:01","date_gmt":"2013-10-09T01:32:01","guid":{"rendered":"\/blog\/?p=414"},"modified":"2023-09-21T09:38:51","modified_gmt":"2023-09-21T00:38:51","slug":"oracle-11gr2-%ec%84%a4%ec%b9%98-linux","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=414","title":{"rendered":"Oracle 11gR2 \uc124\uce58 (Linux)"},"content":{"rendered":"\n<p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ucd9c\ucc98 : <\/span><a class=\"tx-link\" target=\"_blank\" href=\"http:\/\/blueray21.tistory.com\/21\" rel=\"noopener\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">http:\/\/blueray21.tistory.com\/21<\/span><\/a><br \/><\/b><\/p><p><b><br \/><\/b><\/p><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">1. Oracle 11g R2<\/span><\/b><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><a href=\"http:\/\/www.oracle.com\/technetwork\/products\/express-edition\/downloads\/index.html\" target=\"_blank\" class=\"tx-link\" rel=\"noopener\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">http:\/\/www.oracle.com\/technetwork\/products\/express-edition\/downloads\/index.html<\/span><\/a><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><ul style=\"list-style-type: disc; \"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">linux_11gR2_database_1of2.zip<\/span><\/p><\/li><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">linux_11gR2_database_2of2.zip<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><br \/><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">2. \ud328\ud0a4\uc9c0 \ud655\uc778<\/span><\/b><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/install.112\/e24323\/toc.htm#autoId8\" target=\"_blank\" class=\"tx-link\" rel=\"noopener\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">http:\/\/docs.oracle.com\/cd\/E11882_01\/install.112\/e24323\/toc.htm#autoId8<\/span><\/a><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border:none;border-collapse:collapse;;font-family:\ub3cb\uc6c0;font-size:12px\" border=\"0\" cellpadding=\"5\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 137px; background-color: rgb(241, 255, 216); color: rgb(0, 0, 0); border-right: 1px solid rgb(210, 238, 161); border-width: 1px; border-style: solid; border-color: rgb(151, 220, 32) rgb(210, 238, 161) rgb(210, 238, 161) rgb(151, 220, 32);\"><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">compat-libstdc++-33-3.2.3-61.i386.rpm<br \/>libaio-devel-0.3.106-5.i386.rpm<br \/>sysstat-7.0.2-12.el5.i386.rpm<br \/>unixODBC-2.2.11-10.el5.i386.rpm<br \/>unixODBC-libs-2.2.11-10.el5.i386.rpm<br \/>unixODBC-devel-2.2.11-10.el5.i386.rpm<br \/>pdksh-5.2.14-37.el5_8.1.i386.rpm<br \/><\/span><\/p><\/td><\/tr><\/tbody><\/table><br \/><ul style=\"list-style-type: disc; \"><li><span style=\"color: rgb(255, 0, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uc124\uce58 \uc2dc \uc624\ub958\ub97c \ud53c\ud558\uae30 \uc704\ud574\uc11c \ubaa8\ub4e0 \ubaa8\ub4c8\uc744 \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \uc720\uc9c0<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><br \/><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">3. Oracle&nbsp;\uacc4\uc815 \ubc0f \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131<\/span><\/b><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">3.1 Oracle \uacc4\uc815 \uc0dd\uc131<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo groupadd oinstall<\/span><br \/><\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo groupadd dba<\/span><br \/><\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo useradd -m -g oinstall -G dba oracle<\/span><br \/><\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo passwd oracle<\/span><\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">3.2&nbsp;\ub514\ub809\ud1a0\ub9ac \uc0dd\uc131<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); height: 55px; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo&nbsp;mkdir \/oracle<\/span><br \/><\/span><span style=\"color: rgb(255, 255, 255); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/span><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo chown -R oracle.dba \/oracle<\/span><br \/><\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo chmod -R 755 \/oracle<\/span><\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><br \/><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">4. \ucee4\ub110 \ud30c\ub77c\ubbf8\ud130 \uc124\uc815<\/span><\/b><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">4.1 \ucee4\ub110 \uc218\uc815<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo vi \/etc\/sysctl.conf<\/span><\/span><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/p><div><div id=\"highlighter_888111\" class=\"syntaxhighlighter  text\"><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><td class=\"gutter\"><div class=\"line number1 index0 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">1<\/span><\/div><div class=\"line number2 index1 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">2<\/span><\/div><div class=\"line number3 index2 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">3<\/span><\/div><div class=\"line number4 index3 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">4<\/span><\/div><div class=\"line number5 index4 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">5<\/span><\/div><div class=\"line number6 index5 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">6<\/span><\/div><div class=\"line number7 index6 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7<\/span><\/div><div class=\"line number8 index7 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">8<\/span><\/div><div class=\"line number9 index8 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">9<\/span><\/div><div class=\"line number10 index9 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">10<\/span><\/div><div class=\"line number11 index10 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">11<\/span><\/div><\/td><td class=\"code\"><div class=\"container\"><div class=\"line number1 index0 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">kernel.shmall = 2097152<\/span><\/code><\/div><div class=\"line number2 index1 alt1\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">kernel.shmmax = 536870912<\/span><\/code><\/div><div class=\"line number3 index2 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">kernel.shmmni = 4096<\/span><\/code><\/div><div class=\"line number4 index3 alt1\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">fs.aio-max-nr = 1048576<\/span><\/code><\/div><div class=\"line number5 index4 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">fs.file-max = 6815744<\/span><\/code><\/div><div class=\"line number6 index5 alt1\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">kernel.sem = 250 32000 100 128<\/span><\/code><\/div><div class=\"line number7 index6 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">net.ipv4.ip_local_port_range = 9000 65500<\/span><\/code><\/div><div class=\"line number8 index7 alt1\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">net.core.rmem_default = 262144<\/span><\/code><\/div><div class=\"line number9 index8 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">net.core.rmem_max = 4194304<\/span><\/code><\/div><div class=\"line number10 index9 alt1\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">net.core.wmem_default = 262144<\/span><\/code><\/div><div class=\"line number11 index10 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">net.core.wmem_max = 1048586<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><ul style=\"list-style-type: disc; \"><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ud30c\uc77c \ub9e8 \ud558\ub2e8\uc5d0 \ucd94\uac00\ud558\ub418 \uc5c6\ub294 \uac83\ub9cc \ucd94\uac00<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">4.2&nbsp;\ucee4\ub110 \uc218\uc815 \ub0b4\uc5ed \uc801\uc6a9<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><span style=\"font-family: 'Courier New'; color: rgb(0, 255, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo&nbsp;<\/span><\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(255, 216, 216);\">\/sbin\/sysctl -p<\/span><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><br \/><span id=\"callbacknestblueray21tistorycom216651\" style=\"width:1px; height:1px; float:right\"><\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">5. Oracle \uc0ac\uc6a9\uc790 \uacc4\uc815 Shell Limit \uc124\uc815<\/span><\/b><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">5.1 \/etc\/security\/limits.conf&nbsp;\ud30c\uc77c \uc218\uc815<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><font color=\"#ffffff\"><span style=\"font-family: 'Courier New'; color: rgb(0, 255, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo vi&nbsp;<\/span><\/span><\/font><font color=\"#ffffff\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/etc\/security\/limits.conf<\/span><\/font><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><div><div id=\"highlighter_851071\" class=\"syntaxhighlighter  text\"><div class=\"toolbar\"><span><br \/><\/span><\/div><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><td class=\"gutter\"><div class=\"line number1 index0 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">1<\/span><\/div><div class=\"line number2 index1 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">2<\/span><\/div><div class=\"line number3 index2 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">3<\/span><\/div><div class=\"line number4 index3 alt1\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">4<\/span><\/div><div class=\"line number5 index4 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">5<\/span><\/div><\/td><td class=\"code\"><div class=\"container\"><div class=\"line number1 index0 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">#&lt;domain&gt; &lt;type&gt;&nbsp;&nbsp;&nbsp; &lt;item&gt;&nbsp;&nbsp;&nbsp; &lt;value&gt;<\/span><\/code><\/div><div class=\"line number2 index1 alt1\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">oracle&nbsp; soft&nbsp;&nbsp;&nbsp; nproc&nbsp;&nbsp; 2047<\/span><\/code><\/div><div class=\"line number3 index2 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">oracle&nbsp; hard&nbsp;&nbsp;&nbsp; nproc&nbsp;&nbsp; 16384<\/span><\/code><\/div><div class=\"line number4 index3 alt1\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">oracle&nbsp; soft&nbsp;&nbsp;&nbsp; nofile&nbsp; 1024<\/span><\/code><\/div><div class=\"line number5 index4 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">oracle&nbsp; hard&nbsp;&nbsp;&nbsp; nofile&nbsp; 65536<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">5.2&nbsp;\/etc\/pam.d\/login \ud30c\uc77c \uc218\uc815<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><font color=\"#ffffff\"><span style=\"font-family: 'Courier New'; color: rgb(0, 255, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo vi&nbsp;<\/span><\/span><\/font><font color=\"#ffffff\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/etc\/pam.d\/login<\/span><\/font><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><div><div id=\"highlighter_366688\" class=\"syntaxhighlighter  text\"><div class=\"toolbar\"><span><br \/><\/span><\/div><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><td class=\"gutter\"><div class=\"line number1 index0 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">1<\/span><\/div><\/td><td class=\"code\"><div class=\"container\"><div class=\"line number1 index0 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">session required&nbsp;&nbsp;&nbsp; pam_limits.so<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><div><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ud30c\uc77c \ub9e8 \ud558\ub2e8\uc5d0 \ucd94\uac00<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">5.3 SELinux \ube44\ud65c\uc131\ud654<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><font color=\"#ffffff\"><span style=\"font-family: 'Courier New'; color: rgb(0, 255, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo vi&nbsp;<\/span><\/span><\/font><font color=\"#ffffff\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/etc\/selinux\/config<\/span><\/font><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><div><div id=\"highlighter_161761\" class=\"syntaxhighlighter  text\"><div class=\"toolbar\"><span><br \/><\/span><\/div><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><td class=\"gutter\"><div class=\"line number1 index0 alt2\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">1<\/span><\/div><\/td><td class=\"code\"><div class=\"container\"><div class=\"line number1 index0 alt2\"><code class=\"text plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">SELINUX=disabled<\/span><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><div><ul><li><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\ud30c\uc77c \ub9e8 \ud558\ub2e8\uc5d0 \ucd94\uac00<\/span><\/li><\/ul><\/div><\/div><div><br \/><\/div><div><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">6. \ud658\uacbd\ubcc0\uc218<\/span><\/b><\/div><div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[ray@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><font color=\"#ffffff\"><span style=\"font-family: 'Courier New'; color: rgb(0, 255, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sudo vi&nbsp;<\/span><\/span><\/font><font color=\"#ffffff\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/home\/oracle\/.bash_profile<\/span><\/font><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><div><div id=\"highlighter_156634\" class=\"syntaxhighlighter  bash\"><div class=\"toolbar\"><span><br \/><\/span><\/div><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><td style=\"width: 437px;\" class=\"code\"><div class=\"container\"><span style=\"font-family: Courier New;\"># .bash_profile<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Get the aliases and functions<\/span><br \/><span style=\"font-family: Courier New;\">if [ -f ~\/.bashrc ]; then<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; . ~\/.bashrc<\/span><br \/><span style=\"font-family: Courier New;\">fi<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># User specific environment and startup programs<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Oracle<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_HOSTNAME=localhost.localdomain<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_BASE=\/oracle<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_HOME=$ORACLE_BASE\/product\/db\/11.2.0<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_TERM=xterm<\/span><br \/><span style=\"font-family: Courier New;\">export PATH=$PATH:\/sbin:\/bin:\/usr\/bin:$HOME\/bin:$ORACLE_HOME\/bin<\/span><br \/><br \/><span style=\"font-family: Courier New;\">export LANG=ko_KR.UTF-8<\/span><br \/><span style=\"font-family: Courier New;\">export NLS_LANG=AMERICAN_AMERICA.AL32UTF8<\/span><br \/><br \/><span style=\"font-family: Courier New;\">export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME\/lib<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=SID_TEST<\/span><br \/><br \/><span style=\"font-family: Courier New;\">ulimit -u 16384 -n 65536<\/span><br \/><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div><span style=\"font-family: Courier New;\"> \n\n\n\n\n\n<\/span><\/div><span style=\"font-family: Courier New;\">\n\n\n\n\n\n\n<\/span><ul style=\"list-style-type: disc; \"><li><span style=\"color: rgb(255, 0, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\uacbd\ub85c\uc640 SID \ub4f1\uc740 \ub4a4\uc5d0 Oracle \uc124\uce58 \uc2dc \ub3d9\uc77c\ud558\uac8c \uc801\uc6a9\ub418\uc5b4\uc57c \ud568.<\/span><\/li><\/ul><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><br \/><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><b><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7. \uc124\uce58<\/span><\/b><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.1 \ub2e4\uc6b4\ub85c\ub4dc\ud55c \ud30c\uc77c\uc744 oracle \uacc4\uc815\uc73c\ub85c FTP \uc811\uc18d\ud558\uc5ec \uc11c\ubc84\uc5d0 \uc5c5\ub85c\ub4dc<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.2 oracle \uacc4\uc815\uc73c\ub85c \ubcc0\uacbd<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[ray@centos ~]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">su - oracle<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;Password:<\/span><\/span><font color=\"#00ff00\" face=\"'Courier New'\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><\/font><br \/><font color=\"#00ff00\" face=\"'Courier New'\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[oracle@centos ~]$<\/span><\/font><font color=\"#00ff00\" face=\"'Courier New'\"><br \/><\/font><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.3 \uc555\ucd95 \ud30c\uc77c \ud574\uc81c<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[oracle@centos ~]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ls -l<\/span><\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;total&nbsp;2227312<\/span><br \/><\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;-rw-r--r--. 1 oracle&nbsp;oinstall&nbsp;1285396902 Apr &nbsp;4 17:06 linux_11gR2_database_1of2.zip<\/span><br \/><\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;-rw-r--r--. 1 oracle&nbsp;oinstall&nbsp; 995359177 Apr &nbsp;4 17:06 linux_11gR2_database_2of2.zip<\/span><br \/><\/span><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[oracle@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;<\/span><\/font><font color=\"#00ff00\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">unzip linux_11gR2_database_1of2.zip<\/span><br \/><\/font><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;[oracle@centos ~]<\/span><\/font><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">$<\/span><font color=\"#ffffff\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif; color: rgb(0, 255, 0);\">&nbsp;<\/span><\/font><font color=\"#00ff00\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">unzip linux_11gR2_database_2of2.zip<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[oracle@centos ~]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ls -l<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;total 2227316<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;drwxr-xr-x. 8 oracle oinstall &nbsp; &nbsp; &nbsp; 4096 Aug 19 &nbsp;2009 database<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;-rw-r--r--. 1 oracle oinstall 1285396902 Apr &nbsp;4 17:06 linux_11gR2_database_1of2.zip<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;-rw-r--r--. 1 oracle oinstall &nbsp;995359177 Apr &nbsp;4 17:06 linux_11gR2_database_2of2.zip<\/span><br \/><\/font><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.4 \uc124\uce58\ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[oracle@centos ~]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">cd database<\/span><\/span><br \/><font color=\"#00ff00\" face=\"'Courier New'\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[oracle@centos database]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">.\/runInstaller<\/span><\/font><font color=\"#00ff00\" face=\"'Courier New'\"><br \/><\/font><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.5 \uc124\uce58\ud654\uba74<\/span><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0214.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0395.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0893.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0235.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0647.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0435.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0944.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0401.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0313.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0953.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0115.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0898.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0241.png\" alt=\"\" \/><\/p><p><br \/><\/p><p style=\"text-align: left; clear: none; float: none;\"><img decoding=\"async\" editor_component=\"image_link\" src=\"\/blog\/wp-content\/uploads\/cms_xe\/img0064.png\" alt=\"\" \/><\/p><p><br \/><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.6 \uc124\uce58 \uc644\ub8cc \ud6c4 ROOT \uad8c\ud55c\uc73c\ub85c \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589<\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[root@centos ~]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/oracle\/oraInventory\/orainstRoot.sh<\/span><\/span><br \/><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[root<\/span><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">@centos ~]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/oracle\/product\/11g\/root.sh<\/span><\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><\/td><\/tr><\/tbody><\/table><p style=\"text-align: left; clear: none; float: none; \"><span class=\"imageblock\" style=\"display:inline-block;width:630px;;height:auto\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/cfile6.uf.tistory.com\/image\/183C124B4F7C567336209D\" style=\"cursor: pointer;\" height=\"521\" width=\"630\"><\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.7 \uc790\ub3d9\uc2e4\ud589 \uc124\uc815<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"color: rgb(0, 255, 0); font-family: 'Courier New'; \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[root@centos ~]$ <\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">vi&nbsp;<\/span><\/span><font color=\"#00ff00\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/etc\/oratab<\/span><\/font><\/p><\/td><\/tr><\/tbody><\/table><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><div><div id=\"highlighter_162077\" class=\"syntaxhighlighter  bash\"><div class=\"toolbar\"><span><br \/><\/span><\/div><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tbody><tr><td style=\"height: 18px; width: 6px;\" class=\"gutter\"><br \/><\/td><td style=\"height: 18px; background-color: rgb(250, 236, 197); width: 162px;\" class=\"code\"><div class=\"container\"><div class=\"line number1 index0 alt2\"><code class=\"bash plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">ora11:<\/span><\/code><code class=\"bash plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\/oracle\/product\/11g<\/span><\/code><code class=\"bash plain\"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">:Y<\/span><br \/><\/code><\/div><\/div><\/td><\/tr><\/tbody><\/table><\/div><\/div><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> \n\n\n\n\n\n<\/span><\/div><br \/><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Create a file called \"\/etc\/rc.d\/init.d\/dbora\" as the root user, containing the following.<\/span><\/p><p><table class=\"txc-table\" style=\"border:none;border-collapse:collapse;;font-family:\ub3cb\uc6c0;font-size:12px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"764\"><tbody><tr><td style=\"width:764;height:24;border-bottom:1px solid #ccc;border-right:1px solid #ccc;border-top:1px solid #ccc;border-left:1px solid #ccc;;\"><p> <span style=\"font-family: Courier New;\">#!\/bin\/sh<\/span><br \/><span style=\"font-family: Courier New;\"># chkconfig: 345 99 10<\/span><br \/><span style=\"font-family: Courier New;\"># description: Oracle auto start-stop script.<\/span><br \/><span style=\"font-family: Courier New;\">#<\/span><br \/><span style=\"font-family: Courier New;\"># Set ORA_OWNER to the user id of the owner of the<\/span><br \/><span style=\"font-family: Courier New;\"># Oracle database software.<\/span><br \/><br \/><span style=\"font-family: Courier New;\">ORA_OWNER=oracle<\/span><br \/><span style=\"font-family: Courier New;\">SCRIPTS_DIR=\/opt\/oracle\/app\/script<\/span><br \/><br \/><span style=\"font-family: Courier New;\">case \"$1\" in<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp; 'start')<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # Start the Oracle databases:<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # The following command assumes that the oracle login<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # will not prompt the user for any values<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"Starting Oracle Database Server...\"<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; su $ORA_OWNER -c \"$SCRIPTS_DIR\/startup.sh &gt;&gt; $SCRIPTS_DIR\/startup_shutdown.log 2&gt;&amp;1\"<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; touch \/var\/lock\/subsys\/dbora<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;;<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp; 'stop')<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # Stop the Oracle databases:<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # The following command assumes that the oracle login<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # will not prompt the user for any value<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"Shutting down Oracle Database Server...\"<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; su $ORA_OWNER -c \"$SCRIPTS_DIR\/shutdown.sh &gt;&gt; $SCRIPTS_DIR\/startup_shutdown.log 2&gt;&amp;1\"<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rm -f \/var\/lock\/subsys\/dbora<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;;<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp; restart)<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0 stop<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0 start<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;;<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp; *)<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; echo \"Usage: dbora {start|stop|restart}\"<\/span><br \/><span style=\"font-family: Courier New;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; exit 1<\/span><br \/><span style=\"font-family: Courier New;\">esac<\/span><br \/><\/p><\/td>\n<\/tr>\n<\/tbody><\/table><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Use the <\/span><code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">chmod<\/span><\/code><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"> command to set the privileges to 750.<\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><blockquote><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">chmod 750 \/etc\/rc.d\/init.d\/dbora<\/span><\/pre><\/blockquote><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Associate the dbora service with the appropriate run levels and set it to auto-start using the following command.<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><blockquote><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">chkconfig --add dbora<\/span><\/pre><\/blockquote><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Next, we must create the \"startup.sh\" and \"shutdown.sh\" scripts in the \"\/home\/oracle\/scripts\". First create the directory.<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><blockquote><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"># mkdir -p \/home\/oracle\/scripts\n# chown oracle.oinstall \/home\/oracle\/scripts<\/span><\/pre><\/blockquote><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">The \"\/home\/oracle\/scripts\/startup.sh\" script should contain the following commands.<\/span><\/p><p><table class=\"txc-table\" style=\"border:none;border-collapse:collapse;;font-family:\ub3cb\uc6c0;font-size:12px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"764\"><tbody><tr><td style=\"width:764;height:24;border-bottom:1px solid #ccc;border-right:1px solid #ccc;border-top:1px solid #ccc;border-left:1px solid #ccc;;\"><p> <span style=\"font-family: Courier New;\">#!\/bin\/bash<\/span><br \/><br \/><span style=\"font-family: Courier New;\">export TMP=\/tmp<\/span><br \/><span style=\"font-family: Courier New;\">export TMPDIR=$TMP<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_BASE=\/opt\/oracle\/app\/oracle<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_HOSTNAME=localhost<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_UNQNAME=DB11G<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_HOME=$ORACLE_BASE\/11g<\/span><br \/><span style=\"font-family: Courier New;\">export PATH=\/usr\/sbin:$ORACLE_HOME\/bin:$PATH:\/usr\/local\/bin<\/span><br \/><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=orcl<\/span><br \/><span style=\"font-family: Courier New;\">ORAENV_ASK=NO<\/span><br \/><span style=\"font-family: Courier New;\">. oraenv<\/span><br \/><span style=\"font-family: Courier New;\">ORAENV_ASK=YES<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Start Listener<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Starting lsnrctl...\"<\/span><br \/><span style=\"font-family: Courier New;\">lsnrctl start<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Start Database<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=orcl<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Starting ${ORACLE_SID} Database...\"<\/span><br \/><span style=\"font-family: Courier New;\">sqlplus \/ as sysdba &lt;&lt; EOF<\/span><br \/><span style=\"font-family: Courier New;\">STARTUP;<\/span><br \/><span style=\"font-family: Courier New;\">EXIT;<\/span><br \/><span style=\"font-family: Courier New;\">EOF<\/span><br \/><br \/><span style=\"font-family: Courier New;\">sleep 2<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Start Database<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=MYDATABASE1<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Starting ${ORACLE_SID} Database...\"<\/span><br \/><span style=\"font-family: Courier New;\">sqlplus \/ as sysdba &lt;&lt; EOF<\/span><br \/><span style=\"font-family: Courier New;\">STARTUP;<\/span><br \/><span style=\"font-family: Courier New;\">EXIT;<\/span><br \/><span style=\"font-family: Courier New;\">EOF<\/span><br \/><br \/><span style=\"font-family: Courier New;\">sleep 2<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Start Database<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=MYDATABASE2<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Starting ${ORACLE_SID} Database...\"<\/span><br \/><span style=\"font-family: Courier New;\">sqlplus \/ as sysdba &lt;&lt; EOF<\/span><br \/><span style=\"font-family: Courier New;\">STARTUP;<\/span><br \/><span style=\"font-family: Courier New;\">EXIT;<\/span><br \/><span style=\"font-family: Courier New;\">EOF<\/span><br \/><\/p><\/td>\n<\/tr>\n<\/tbody><\/table><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"><br \/>The \"\/home\/oracle\/scripts\/shutdown.sh\" script is similar.<\/span><br \/><br \/><p><table class=\"txc-table\" style=\"border:none;border-collapse:collapse;;font-family:\ub3cb\uc6c0;font-size:12px\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"764\"><tbody><tr><td style=\"width: 764px; height: 865px; border-width: 1px; border-style: solid; border-color: rgb(204, 204, 204);\"><p> <span style=\"font-family: Courier New;\">#!\/bin\/bash<\/span><br \/><br \/><span style=\"font-family: Courier New;\">export TMP=\/tmp<\/span><br \/><span style=\"font-family: Courier New;\">export TMPDIR=$TMP<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_BASE=\/opt\/oracle\/app\/oracle<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_HOSTNAME=localhost<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_UNQNAME=DB11G<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_HOME=$ORACLE_BASE\/11g<\/span><br \/><span style=\"font-family: Courier New;\">export PATH=\/usr\/sbin:$ORACLE_HOME\/bin:$PATH:\/usr\/local\/bin<\/span><br \/><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=orcl<\/span><br \/><span style=\"font-family: Courier New;\">ORAENV_ASK=NO<\/span><br \/><span style=\"font-family: Courier New;\">. oraenv<\/span><br \/><span style=\"font-family: Courier New;\">ORAENV_ASK=YES<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Stop Database<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=MYDATABASE2<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Shutting down ${ORACLE_SID} Database...\"<\/span><br \/><span style=\"font-family: Courier New;\">sqlplus \/ as sysdba &lt;&lt; EOF<\/span><br \/><span style=\"font-family: Courier New;\">SHUTDOWN IMMEDIATE;<\/span><br \/><span style=\"font-family: Courier New;\">EXIT;<\/span><br \/><span style=\"font-family: Courier New;\">EOF<\/span><br \/><br \/><span style=\"font-family: Courier New;\">sleep 2<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Stop Database<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=MYDATABASE1<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Shutting down ${ORACLE_SID} Database...\"<\/span><br \/><span style=\"font-family: Courier New;\">sqlplus \/ as sysdba &lt;&lt; EOF<\/span><br \/><span style=\"font-family: Courier New;\">SHUTDOWN IMMEDIATE;<\/span><br \/><span style=\"font-family: Courier New;\">EXIT;<\/span><br \/><span style=\"font-family: Courier New;\">EOF<\/span><br \/><br \/><span style=\"font-family: Courier New;\">sleep 2<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Stop Database<\/span><br \/><span style=\"font-family: Courier New;\">export ORACLE_SID=orcl<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Shutting down ${ORACLE_SID} Database...\"<\/span><br \/><span style=\"font-family: Courier New;\">sqlplus \/ as sysdba &lt;&lt; EOF<\/span><br \/><span style=\"font-family: Courier New;\">SHUTDOWN IMMEDIATE;<\/span><br \/><span style=\"font-family: Courier New;\">EXIT;<\/span><br \/><span style=\"font-family: Courier New;\">EOF<\/span><br \/><br \/><span style=\"font-family: Courier New;\">sleep 3<\/span><br \/><br \/><span style=\"font-family: Courier New;\"># Stop Listener<\/span><br \/><span style=\"font-family: Courier New;\">echo \"&nbsp;&nbsp;&nbsp; Shutting down lsnrctl...\"<\/span><br \/><span style=\"font-family: Courier New;\">lsnrctl stop<\/span><br \/><\/p><\/td>\n<\/tr>\n<\/tbody><\/table><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Note. You could move the environment settings into the \"dbora\" file \nor into a separate file that is sourced in the startup and shutdown \nscript. I kept it local to the script so you could see the type of \nthings that need to be set in case you have to write a script to deal \nwith multiple installations, instances and listeners.<\/span><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">Make sure the permissions and ownership of the files is correct.<\/span><\/p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><blockquote><pre><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\"># chmod u+x \/home\/oracle\/scripts\/startup.sh \/home\/oracle\/scripts\/shutdown.sh\n# chown oracle.oinstall \/home\/oracle\/scripts\/startup.sh \/home\/oracle\/scripts\/shutdown.sh<\/span><\/pre><\/blockquote><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n<\/span><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">The listener and database will now start and stop automatically with \nthe machine. You can test them using the following command as the \"root\"\n user.<\/span><\/p><br \/><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">7.8&nbsp;\uc815\uc0c1\uc801\uc73c\ub85c \uae30\ub3d9\ub418\uc5c8\ub294\uc9c0 \ud655\uc778<\/span><\/p><p><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n<\/span><table class=\"txc-table\" style=\"border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-image: initial; border-collapse: collapse; font-size: 12px; \" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"594\"><tbody><tr><td style=\"width: 594px; height: 24px; border-bottom-width: 1px; border-bottom-style: solid; border-bottom-color: rgb(204, 204, 204); border-right-width: 1px; border-right-style: solid; border-right-color: rgb(204, 204, 204); border-top-width: 1px; border-top-style: solid; border-top-color: rgb(204, 204, 204); border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(0, 0, 0); \"><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n<\/span><p><span style=\"color: rgb(0, 255, 0); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;[oracle@centos ~]$&nbsp;<\/span><font color=\"#00ff00\" face=\"'Courier New'\"><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">sqlplus \/ as sysdba<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 4 23:48:43 2012<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;Copyright (c) 1982, 2009, Oracle. &nbsp;All rights reserved.<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;Connected to:<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span><br \/><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;SQL&gt;&nbsp;<\/span><span style=\"color: rgb(255, 216, 216); font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">select instance_name from v$instance;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;INSTANCE_NAME<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;----------------<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;ora11<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;<\/span><br \/><span style=\"font-family: Gulim,\uad74\ub9bc,AppleGothic,sans-serif;\">&nbsp;SQL&gt;<\/span><\/font><\/p><\/td><\/tr><\/tbody><\/table><\/p><p><br \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ucd9c\ucc98 : http:\/\/blueray21.tistory.com\/21 1. Oracle 11g R2 http:\/\/www.oracle.com\/technetwork\/products\/express-edition\/downloads\/index.html linux_11gR2_database_1of2.zip linux_11gR2_database_2of2.zip 2. \ud328\ud0a4\uc9c0 \ud655\uc778 http:\/\/docs.oracle.com\/cd\/E11882_01\/install.112\/e24323\/toc.htm#autoId8 compat-libstdc++-33-3.2.3-61.i386.rpmlibaio-devel-0.3.106-5.i386.rpmsysstat-7.0.2-12.el5.i386.rpmunixODBC-2.2.11-10.el5.i386.rpmunixODBC-libs-2.2.11-10.el5.i386.rpmunixODBC-devel-2.2.11-10.el5.i386.rpmpdksh-5.2.14-37.el5_8.1.i386.rpm \uc124\uce58 \uc2dc \uc624\ub958\ub97c \ud53c\ud558\uae30 \uc704\ud574\uc11c \ubaa8\ub4e0 \ubaa8\ub4c8\uc744 \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \uc720\uc9c0 3. Oracle&nbsp;\uacc4\uc815 \ubc0f \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131 3.1 Oracle \uacc4\uc815 \uc0dd\uc131 &nbsp;[ray@centos ~]$&nbsp;sudo groupadd oinstall&nbsp;[ray@centos ~]$&nbsp;sudo groupadd dba&nbsp;[ray@centos ~]$&nbsp;sudo useradd -m -g oinstall -G dba oracle&nbsp;[ray@centos ~]$&nbsp;sudo passwd oracle 3.2&nbsp;\ub514\ub809\ud1a0\ub9ac \uc0dd\uc131 &nbsp;[ray@centos [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-414","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=414"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/414\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}