{"id":6307,"date":"2012-10-18T23:41:00","date_gmt":"2012-10-19T04:41:00","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=6307"},"modified":"2013-11-01T11:27:37","modified_gmt":"2013-11-01T16:27:37","slug":"amazon-ec2-linux-6-3-install-oracle-database-11gr2","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=6307","title":{"rendered":"Amazon EC2 Linux 6.3: Install Oracle Database 11gR2"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tLinux Box Info<\/a>\n\t<\/li>\n\t
  2. \n\t\tInstall Dependencies<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tX11 Dependencies<\/a>\n\t\t\t<\/li>\n\t\t\t
    2. \n\t\t\t\tLibrary Dependencies<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    3. \n\t\tPrepare Swap File<\/a>\n\t<\/li>\n\t
    4. \n\t\tSetup Kernel Parameters<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tCheck Kernel Parameters<\/a>\n\t\t\t<\/li>\n\t\t\t
      2. \n\t\t\t\tConfigure New Kernel Parameters<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      3. \n\t\tSetup Oracle User and Groups<\/a>\n\t\t
          \n\t\t\t
        1. \n\t\t\t\tCreate OS Groups and Users<\/a>\n\t\t\t<\/li>\n\t\t\t
        2. \n\t\t\t\tCheck oracle User Limits<\/a>\n\t\t\t<\/li>\n\t\t\t
        3. \n\t\t\t\tAdjust User Limits<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
        4. \n\t\tCreate Directory Structure<\/a>\n\t\t
            \n\t\t\t
          1. \n\t\t\t\tSetup oracle User Env<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
          2. \n\t\tInstall Oracle<\/a>\n\t\t
              \n\t\t\t
            1. \n\t\t\t\tScreens<\/a>\n\t\t\t<\/li>\n\t\t\t
            2. \n\t\t\t\tUpdate Env Variables<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
            3. \n\t\tCheck Install<\/a>\n\t\t
                \n\t\t\t
              1. \n\t\t\t\tEM Console<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
              2. \n\t\tSetup Auto Start<\/a>\n\t\t
                  \n\t\t\t
                1. \n\t\t\t\tLogin as oracle<\/em> user<\/a>\n\t\t\t<\/li>\n\t\t\t
                2. \n\t\t\t\tLogin as root User<\/a>\n\t\t\t<\/li>\n\t\t\t
                3. \n\t\t\t\tTest<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
                4. \n\t\tUninstall<\/a>\n\t<\/li>\n\t
                5. \n\t\tSilent Mode<\/a>\n\t<\/li>\n\t
                6. \n\t\tIssues<\/a>\n\t\t
                    \n\t\t\t
                  1. \n\t\t\t\tcannot restore segment prot after reloc: Permission denied<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
                  2. \n\t\tReferences<\/a>\n\t<\/li>\n<\/ol>\n<\/ol>\n<\/div>\n
                     <\/div>\n

                    Linux Box Info<\/h2><\/span>\n
                    \r\n# uname -m\r\nx86_64\r\n\r\n# uname -r\r\n2.6.32-276.el6.x86_64\r\n\r\n# cat \/proc\/version \r\nLinux version 2.6.32-276.el6.x86_64 (mockbuild@x86-012.build.bos.redhat.com) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Tue May 29 17:38:19 EDT 2012\r\n\r\n# grep MemTotal \/proc\/meminfo\r\nMemTotal:       35127936 kB\r\n\r\n# cat \/etc\/redhat-release \r\nRed Hat Enterprise Linux Server release 6.3 (Santiago)\r\n\r\n# free\r\n             total       used       free     shared    buffers     cached\r\nMem:      35127936    4363596   30764340          0     107384    3662592\r\n-\/+ buffers\/cache:     593620   34534316\r\nSwap:            0          0          0\r\n\r\n# df -h \/dev\/shm\r\nFilesystem            Size  Used Avail Use% Mounted on\r\nnone                   17G     0   17G   0% \/dev\/shm\r\n<\/pre>\n
                    Install Dependencies<\/h2><\/span>\n
                    X11 Dependencies<\/h3><\/span>\n
                    \r\nyum install xorg-x11-xauth.x86_64 xorg-x11-server-utils.x86_64\r\n<\/pre>\n
                    Library Dependencies<\/h3><\/span>\n
                    \r\nyum install binutils-* compat-libcap* compat-libstdc++-* compat-libstdc++-* gcc-* gcc-c++-* glibc-* glibc-* glibc-devel-* glibc-devel-* ksh libgcc-* libgcc-* libstdc++-* libstdc++-* libstdc++-devel-* libstdc++-devel-* libaio-* libaio-* libaio-devel-* libaio-devel-* make-* sysstat-* \r\n<\/pre>\n
                    Prepare Swap File<\/h2><\/span>\n
                    * Prepare swap if needed:<\/p>\n
                    \r\n# Remote swap file if installed\r\nswapoff \/swapfile\r\nrm \/swapfile\r\n\r\n# Add 6 GB swap space. 1024 * 6000 = 6144000\r\ndd if=\/dev\/zero of=\/swapfile bs=1024 count=6144000\r\n\/sbin\/mkswap \/swapfile\r\n\/sbin\/swapon \/swapfile\r\n\/sbin\/swapon -s\r\n\r\n# Add to \/etc\/fstab<\/em>:\r\n\/swapfile swap swap defaults 0 0\r\n\r\n# Check new swap\r\nfree -m\r\ngrep SwapTotal \/proc\/meminfo\r\n<\/pre>\n
                    Setup Kernel Parameters<\/h2><\/span>\n
                    Check Kernel Parameters<\/h3><\/span>\n
                    * Create a shell script checkkm.sh<\/em> with content:<\/p>\n
                    \r\n#!\/bin\/sh\r\n\/sbin\/sysctl -a | grep sem\r\n\/sbin\/sysctl -a | grep shm\r\n\/sbin\/sysctl -a | grep file-max\r\n\/sbin\/sysctl -a | grep ip_local_port_range\r\n\/sbin\/sysctl -a | grep rmem_default\r\n\/sbin\/sysctl -a | grep rmem_max\r\n\/sbin\/sysctl -a | grep wmem_default\r\n\/sbin\/sysctl -a | grep wmem_max\r\n<\/pre>\n
                    * Run it to get current kernel parameters:<\/p>\n
                    \r\nchmod u+x checkkm.sh \r\n.\/checkkm.sh \r\n\r\nkernel.sem = 250        32000   32      128\r\nkernel.shmmax = 68719476736\r\nkernel.shmall = 4294967296\r\nkernel.shmmni = 4096\r\nkernel.shm_rmid_forced = 0\r\nvm.hugetlb_shm_group = 0\r\nfs.file-max = 3465274\r\nnet.ipv4.ip_local_port_range = 32768    61000\r\nnet.core.rmem_default = 229376\r\nnet.core.rmem_max = 131071\r\nnet.core.wmem_default = 229376\r\nnet.core.wmem_max = 131071\r\n<\/pre>\n
                    Configure New Kernel Parameters<\/h3><\/span>\n
                    * Adjust kernel parameters by adding to \/etc\/sysctl.conf<\/em>:<\/p>\n
                    \r\nkernel.sem = 250 32000 100 128\r\nfs.aio-max-nr = 1048576\r\nfs.file-max = 6815744\r\nnet.ipv4.ip_local_port_range = 9000 65500\r\nnet.core.rmem_default = 262144\r\nnet.core.rmem_max = 4194304\r\nnet.core.wmem_default = 262144\r\nnet.core.wmem_max = 1048576\r\n<\/pre>\n
                    * Restart box<\/p>\n
                    \r\nshutdown -r now\r\n<\/pre>\n
                    Setup Oracle User and Groups<\/h2><\/span>\n
                    Create OS Groups and Users<\/h3><\/span>\n
                    \r\ngroupadd -g 500 oinstall\r\ngroupadd -g 501 dba\r\nuseradd -u 500 -g oinstall -G dba -d \/home\/oracle oracle -s \/bin\/bash\r\n\r\n# Set oracle password (mycom1)\r\npasswd oracle\r\n<\/pre>\n
                    Check oracle User Limits<\/h3><\/span>\n
                    * Create a new shell script named oralimits.sh<\/em>:<\/p>\n
                    \r\n#!\/bin\/sh\r\n\r\necho ulimit -Sn\r\nulimit -Sn\r\n\r\necho ulimit -Hn\r\nulimit -Hn\r\n\r\necho ulimit -Su\r\nulimit -Su\r\n\r\necho ulimit -Hu\r\nulimit -Hu\r\n\r\necho ulimit -Ss\r\nulimit -Ss\r\n\r\necho ulimit -Hs\r\nulimit -Hs\r\n<\/pre>\n
                    * Run it to get current user limits:<\/p>\n
                    \r\nchmod u+x oralimits.sh\r\n.\/oralimits.sh\r\n\r\nulimit -Sn\r\n1024\r\nulimit -Hn\r\n4096\r\nulimit -Su\r\n1024\r\nulimit -Hu\r\n274060\r\nulimit -Ss\r\n10240\r\nulimit -Hs\r\nunlimited\r\n<\/pre>\n
                    Adjust User Limits<\/h3><\/span>\n
                    * Adjust user limits by adding to \/etc\/security\/limits.conf<\/em>:<\/p>\n
                    \r\noracle              soft    nproc   2047\r\noracle              hard    nproc   16384\r\noracle              soft    nofile  1024\r\noracle              hard    nofile  65536\r\noracle              soft    stack   10240\r\n<\/pre>\n
                    Create Directory Structure<\/h2><\/span>\n
                    \r\nmkdir -p \/u01\/app\/\r\nchown -R oracle:oinstall \/u01\/app\/\r\nchmod -R 775 \/u01\/app\/\r\n<\/pre>\n
                    Setup oracle User Env<\/h3><\/span>\n
                    * Add to oracle user ~\/.bashrc<\/em> file:<\/p>\n
                    \r\nexport ORACLE_BASE=\/u01\/app\/oracle\r\nexport ORACLE_SID=orcl\r\n<\/pre>\n
                    Install Oracle<\/h2><\/span>\n
                    * Download Oracle 11gR2 for Linux x86-64 from Oracle download site<\/a>.
                    \n* Unzip both zip files to the same<\/em> directory:<\/p>\n
                    \r\nunzip linux.x64_11gR2_database_1of2.zip\r\nunzip linux.x64_11gR2_database_2of2.zip\r\n<\/pre>\n
                    * Start installer<\/p>\n
                    \r\ncd database\r\n.\/runInstaller\r\n<\/pre>\n
                    Screens<\/h3><\/span>\n
                    * Uncheck I wish to receive security updates via My Oracle Support<\/em>.
                    \n* Click Yes<\/em> on Email not specified warning.
                    \n* Select Create and configure database<\/em>.<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Select Server class<\/em>.
                    \n* Select Single instance database<\/em>.
                    \n* Select Advanced install<\/em>.
                    \n* Select English<\/em>
                    \n* Select Enterprise Edition<\/em>
                    \n* Accept Oracle base: \/u01\/app\/oracle<\/em>
                    \n* Accept Oracle home: \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1<\/em>
                    \n* Accept Inventory directory: \/u01\/app\/oraInventory<\/em><\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Select General purpose \/ Transaction processing<\/em>
                    \n* Enter Global database name: orcl.mycom.com<\/em>
                    \n* Select SID: orcl<\/em>
                    \n* Select File System<\/em>, not Enable Automatic Memory Management<\/em><\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Memory setting:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Character set:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Security setting:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Check Create database with sample schemas<\/em>
                    \n* Select Use Database Control for database management<\/em>
                    \n* Accept default data file directory.
                    \n* Select Do not enable automatic backups<\/em>.
                    \n* Select Use same password for all accounts<\/em>: mycom1
                    \n* Accept default groups.<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * You may see check failed:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Ignore check fails:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Summary:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Unlock user if needed:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    * Run two shell scrips as root user:<\/p>\n
                    \"\"<\/a><\/h6><\/span>\n
                    Update Env Variables<\/h3><\/span>\n
                    \r\nexport ORACLE_BASE=\/u01\/app\/oracle\r\nexport ORACLE_SID=orcl\r\nexport ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0\/dbhome_1\r\nexport PATH=$ORACLE_HOME\/bin:$PATH\r\n<\/pre>\n
                    Check Install<\/h2><\/span>\n
                    * Start database:<\/p>\n
                    \r\nsqlplus \/ as sysdba\r\nstartup\r\n<\/pre>\n
                    * Start listener:<\/p>\n
                    \r\nlsnrctl\r\nstart\r\n<\/pre>\n
                    * Use sqlplus<\/em>:<\/p>\n
                    \r\nsqlplus \/ as sysdba\r\n\r\nsqlplus scott\/tiger\r\n<\/pre>\n
                    EM Console<\/h3><\/span>\n
                    * Start EM Console:<\/p>\n
                    \r\nemctl start dbconsole\r\n<\/pre>\n
                    * EM Console cannot be access outside of EC2.
                    \n* EM Console URL:
                    \nhttps:\/\/www.my.com:1158\/em\/console<\/a>
                    \n* See                     this post<\/a> on how to reconfigure EM<\/p>\n
                    Setup Auto Start<\/h2><\/span>\n
                    Login as oracle<\/em> user<\/h3><\/span>\n
                    * Create \/home\/oracle\/scripts<\/em> directory to hold startup scripts:<\/p>\n
                    \r\nmkdir -p \/home\/oracle\/scripts\r\n<\/pre>\n
                    * Create startup.sh<\/em><\/p>\n
                    \r\ncd \/home\/oracle\/scripts\r\nvi startup.sh\r\n<\/pre>\n
                    \r\n#!\/bin\/bash\r\n\r\n# Oracle SID value needs to match in \/etc\/oratab and is case sensitive\r\nexport ORACLE_SID=orcl\r\nORAENV_ASK=NO\r\n. oraenv\r\nORAENV_ASK=YES\r\n\r\n# Start Listener\r\nlsnrctl start\r\n\r\n# Start Database\r\nsqlplus \/ as sysdba << EOF\r\nSTARTUP;\r\nEXIT;\r\nEOF\r\n\r\n# Start EM\r\nemctl start dbconsole\r\n<\/pre>\n
                    * Create shutdown.sh<\/em>
                    \nvi shutdown.sh<\/p>\n
                    \r\n#!\/bin\/bash\r\n\r\n# Oracle SID value needs to match in \/etc\/oratab and is case sensitive\r\nexport ORACLE_SID=orcl \r\nORAENV_ASK=NO\r\n. oraenv\r\nORAENV_ASK=YES\r\n\r\n# Stop EM\r\nemctl stop dbconsole\r\n\r\n# Stop Database\r\nsqlplus \/ as sysdba << EOF\r\nSHUTDOWN IMMEDIATE;\r\nEXIT;\r\nEOF\r\n\r\n# Stop Listener\r\nlsnrctl stop\r\n<\/pre>\n
                    * Set permissions:<\/p>\n
                    \r\nchmod u+x \/home\/oracle\/scripts\/startup.sh \/home\/oracle\/scripts\/shutdown.sh\r\n<\/pre>\n
                    Login as root User<\/h3><\/span>\n
                    * sudo to root user<\/p>\n
                    \r\nsu -\r\n<\/pre>\n
                    * Turn on orcl<\/em> in \/etc\/oratab<\/em> file.<\/p>\n
                    \r\norcl:\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1:Y\r\n<\/pre>\n
                    * Create \/etc\/init.d\/dbora<\/em><\/p>\n
                    \r\nvi \/etc\/init.d\/dbora\r\n<\/pre>\n
                    \r\n#!\/bin\/sh\r\n# chkconfig: 345 99 10\r\n# description: Oracle auto start-stop script.\r\n#\r\n\r\nORA_OWNER=oracle\r\n\r\ncase \"$1\" in\r\n    'start')\r\n        # Start the Oracle databases:\r\n        # The following command assumes that the oracle login \r\n        # will not prompt the user for any values\r\n        su - $ORA_OWNER -c \"\/home\/oracle\/scripts\/startup.sh >> \/home\/oracle\/scripts\/startup_shutdown.log 2>&1\"\r\n        touch \/var\/lock\/subsys\/dbora\r\n        ;;\r\n    'stop')\r\n        # Stop the Oracle databases:\r\n        # The following command assumes that the oracle login \r\n        # will not prompt the user for any values\r\n        su - $ORA_OWNER -c \"\/home\/oracle\/scripts\/shutdown.sh >> \/home\/oracle\/scripts\/startup_shutdown.log 2>&1\"\r\n        rm -f \/var\/lock\/subsys\/dbora\r\n        ;;\r\nesac\r\n<\/pre>\n
                    * Set file permission:<\/p>\n
                    \r\nchmod 750 \/etc\/init.d\/dbora\r\n<\/pre>\n
                    * Add service with chkconfig command:<\/p>\n
                    \r\nchkconfig --add dbora\r\n<\/pre>\n
                    Test<\/h3><\/span>\n
                    * Test dbora script:<\/p>\n
                    \r\nservice dbora stop\r\nservice dbora start\r\n<\/pre>\n
                    * Reboot to test<\/p>\n
                    * See this article<\/a> for more details.<\/p>\n
                    Uninstall<\/h2><\/span>\n
                    \r\ncd \/opt\/app\/oracle\/product\/11.2.0\/dbhome_1\/deinstall\r\n.\/deinstall\r\n\r\n# Accept all defaults\r\n<\/pre>\n
                    Silent Mode<\/h2><\/span>\n
                    * Save a response file, e.g. db.rsp<\/strong>, from previous install
                    \n* Run installer in silent mode and point to response file:<\/p>\n
                    \r\n.\/runInstaller -silent -responseFile ~\/db.rsp\r\n<\/pre>\n
                    * Login as root and execute the following commands to finish the install: <\/p>\n
                    \r\n#!\/bin\/sh\r\n#Root scripts to run\r\n\r\n\/u01\/app\/oraInventory\/orainstRoot.sh\r\n\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/root.sh\r\n<\/pre>\n
                    Issues<\/h2><\/span>\n
                    cannot restore segment prot after reloc: Permission denied<\/h3><\/span>\n
                    * Cause: SELinux is turned on
                    \n* Possible solution: set SELinix to permissive mode
                    \n- Temporarily: <\/p>\n
                    \r\n#setenforce 0\r\n<\/pre>\n
                    - Permanently:
                    \nvi \/etc\/sysconfig\/selinux<\/p>\n
                    \r\nSELINUX=permissive\r\n<\/pre>\n
                    References<\/h2><\/span>\n
                    * Quick Installation Guide 11g Release 2 (11.2) for Linux x86-64<\/a>
                    \n*                     Oracle Database 11g Release 2 (11.2) Document Library<\/a>
                    \n*                     Oracle Database Download Site<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
                    Linux Box Info # uname -m x86_64 # uname -r 2.6.32-276.el6.x86_64 # cat \/proc\/version Linux version 2.6.32-276.el6.x86_64 (mockbuild@x86-012.build.bos.redhat.com) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Tue May 29 17:38:19 EDT 2012 # grep MemTotal \/proc\/meminfo MemTotal: … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[89],"tags":[141,270],"class_list":["post-6307","post","type-post","status-publish","format-standard","hentry","category-11g","tag-install","tag-oracle11gr2"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-1DJ","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/6307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6307"}],"version-history":[{"count":31,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/6307\/revisions"}],"predecessor-version":[{"id":9368,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/6307\/revisions\/9368"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}