{"id":467,"date":"2015-08-08T09:18:06","date_gmt":"2015-08-08T01:18:06","guid":{"rendered":"http:\/\/www.821121.com\/?p=467"},"modified":"2020-12-18T11:13:20","modified_gmt":"2020-12-18T03:13:20","slug":"oracle11g%e5%8d%95%e5%ae%9e%e4%be%8bfor%e5%8d%95%e5%ae%9e%e4%be%8bdg%e6%90%ad%e5%bb%ba","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=467","title":{"rendered":"oracle10.2.0.1\u5728linux5\u90e8\u7f72"},"content":{"rendered":"
\u670d\u52a1\u5668\u57fa\u672c\u4fe1\u606f\uff1a\nip\uff1a10.1.100.10     \u7cfb\u7edf\uff1alinux5.7   \u6570\u636e\u5e93\uff1aoracle10.2.0.1    sys\u5bc6\u7801\uff1aoracle\n\u4e3b\u673a\u540d\uff1aoracle<\/code><\/pre>\n
1\u3001\u6302\u5149\u76d8\uff0c\u88c5yum\u5305\uff0c\u88c5\u6240\u9700\u7684rpm\u3002<\/h1>\n
mkdir \/mnt\nmount  \/dev\/cdrom \/mnt\n\nvi \/etc\/yum.repos.d\/ol.repo\n\n[local-source]\nname=ol\nbaseurl=file:\/\/\/mnt\/Server\nenabled=1\ngpgcheck=0\n\nyum install -y libXau*  libxcb*  libX11* libXext* libICE*  libuuid* libSM*  libXt* libXi* libXtst* libXp* glibc-devel* libaio-devel* libaio* compat-libstdc++* libXpm* libXp-devel* libXpm-devel* compat-libstdc++* compat-libstdc++* compat-libstdc++* gcc-4.4.6* gcc-c++* unixODBC-*\nyum install -y libXp.so.6\nyum install -y libXt.so.6\nyum install -y libXtst.so.6\nyum install -y unzip zip\n<\/code><\/pre>\n
2\u3001\u521b\u5efa\u7528\u6237\u3001\u7ec4\u3001\u76ee\u5f55\u3002<\/h1>\n
\u521b\u5efa\u7528\u6237\u3001\u7ec4\ngroupadd -g 1005 oinstall\ngroupadd -g 1001 dba\nuseradd -u 1101 -g oinstall -G dba oracle\n\n\u521b\u5efa\u76ee\u5f55\u3001\u8d4b\u6743\nmkdir -p  \/u01\/app\/oracle\nchown -R oracle:oinstall \/u01\nchmod -R 775 \/u01\/\npasswd oracle\n<\/code><\/pre>\n
3\u3001\u914d\u7f6e\u7cfb\u7edf\u53c2\u6570\u3002<\/h1>\n
3.1\u3001\u4fee\u6539\u4e3b\u673a\u540d<\/h2>\n
vi \/etc\/hosts\n10.1.100.10 oracle\uff08\u6b64\u5904\u4e3a\u4e3e\u4f8b\uff0c\u5b9e\u9645\u9700\u914d\u7f6e\u5f53\u524d\u865a\u62df\u673a\u7684IP\u4e0eHOSTNAME\uff09\n\nvi \/etc\/sysconfig\/network  \n  oracle\n\nhostname oracle<\/code><\/pre>\n
3.2\u3001\u4fee\u6539\u7248\u672c\u3002<\/h2>\n
vi \/etc\/redhat-release\n\u628a6.8\u6539\u62104.8\u5373\u53ef<\/code><\/pre>\n
3.3\u3001\u914d\u7f6e\u7cfb\u7edf\u6587\u4ef6<\/h2>\n
\u914d\u7f6e\u7cfb\u7edf\u5185\u6838\u53c2\u6570(64G)\nvi \/etc\/sysctl.conf\nkernel.shmmni = 4096\nkernel.sem = 250 32000 100 128\nfs.file-max = 6815744\nnet.ipv4.ip_local_port_range = 1024  65000\nnet.core.rmem_default = 262144\nnet.core.rmem_max = 4194304\nnet.core.wmem_default = 262144\nnet.core.wmem_max = 1048576\nkernel.shmall = 16777216\nkernel.shmmax = 41231686041\nkernel.shmmni = 4096\nkernel.sem = 250 32000 100 128\nfs.aio-max-nr=3145728\n[root@ten1 ~]# sysctl -p\n\n\u914d\u7f6e\u6587\u4ef6\u6253\u5f00\u6570\nvi \/etc\/security\/limits.conf\noracle soft nproc 2047\noracle hard nproc 16384\noracle soft nofile 1024\noracle hard nofile 65536\n\nvi \/etc\/pam.d\/login\nsession required \/lib\/security\/pam_limits.so\nsession required pam_limits.so\n\nvi \/etc\/profile\nif [ $USER = "oracle" ]; then\n    if [ $SHELL = "\/bin\/ksh" ]; then\n       ulimit -u 16384\n       ulimit -n 65536\n    else\n       ulimit -u 16384 -n 65536\n    fi\nfi<\/code><\/pre>\n
3.4\u3001\u7981\u7528selinux\u3001iptable<\/h2>\n
\u5efa\u8bae\u7981\u7528\u6b64\u529f\u80fd\u3002\nvi \/etc\/selinux\/config\nSELINUX=disabled\n\u9700\u8981\u91cd\u542f\u3002\n\nservice   iptables stop\nchkconfig iptables off\n<\/code><\/pre>\n
3.5\u3001\u8bbe\u7f6eoracle\u7528\u6237\u73af\u5883\u53d8\u91cf<\/h2>\n
vi ~\/.bash_profile\n\noracle\u7528\u6237 \nexport TMP=\/tmp \nexport TMPDIR=$TMP \nexport ORACLE_SID=ten1   #\u8282\u70b91\u7684\u914d\u7f6e\nexport ORACLE_BASE=\/u01\/app\/oracle \nexport ORACLE_HOME=$ORACLE_BASE\/product\/10.2.0\/db_1\nexport TNS_ADMIN=$ORACLE_HOME\/network\/admin \nexport PATH=\/usr\/sbin:$PATH \nexport PATH=$ORA_CRS_HOME\/bin:$ORACLE_HOME\/bin:$PATH \nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib \nexport CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib \numask 022\n\nsource ~\/.bash_profile<\/code><\/pre>\n
4\u3001\u4f7f\u7528ftp\u4f20\u5305\u5230\u4e00\u4e2a\/u01\uff08\u5176\u4ed6\u76ee\u5f55\u4e5f\u884c\uff0c\u81ea\u5df1\u8bb0\u5f97\uff09\u4e0b\u89e3\u538b\u5b89\u88c5\u5305\u3002<\/h1>\n
ll\n10201_database_linux_x86_64.cpio.gz\ngunzip 10201_database_linux_x86_64.cpio.gz\ncpio -idmv <10201_database_linux_x86_64.cpio\nchown -R oracle:oinstall database\/\nchmod -R 775 database\n<\/code><\/pre>\n
5\u3001\u5b89\u88c5\u6570\u636e\u5e93\u3002<\/h1>\n
\u8f6f\u4ef6\u524d\u63d0\u9700\u8981\uff1aXmanager 5\u3001Xmanager 6\u6216VNC\uff0c\u80fd\u591f\u53ef\u89c6\u5316\u5b89\u88c5\n\n\u4ee5\u4e0b\u64cd\u4f5c\u5728Xmananger\u53ef\u89c6\u5316\u4e2d\u8fdb\u884c\n\ncd database\/\nsh runInstaller\n\n\u8fd9\u91cc\u56fe\u7565\u8fc7\uff0c\u53c2\u7167\u666e\u901a\u5b89\u88c5\u6570\u636e\u5e93\u7684\u6d41\u7a0b\u4e00\u6837\u3002<\/code><\/pre>\n
6\u3001\u5f00\u542f\u76d1\u542c<\/h1>\n
lsnrctl start\nlsnrctl status<\/code><\/pre>\n
7.\u521b\u5efa\u6570\u636e\u5e93\u5b9e\u4f8bdbca<\/h1>\n
\u4ee5\u4e0b\u64cd\u4f5c\u5728Xmananger\u53ef\u89c6\u5316\u4e2d\u8fdb\u884c\uff0cdbca\n\n\u8fd9\u91cc\u56fe\u7565\u8fc7\uff0c\u53c2\u7167\u666e\u901a\u521b\u5efa\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u6d41\u7a0b\u4e00\u6837\n<\/code><\/pre>\n
8.\u68c0\u6d4boracle\u6570\u636e\u5e93\u662f\u5426\u5df2\u7ecf\u5b89\u88c5\u6210\u529f\u3002<\/h1>\n
sqlplus \/ as sysdba\nselect * from dual;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u670d\u52a1\u5668\u57fa\u672c\u4fe1\u606f\uff1a ip\uff1a10.1.100.10 \u7cfb<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,36],"tags":[],"class_list":["post-467","post","type-post","status-publish","format-standard","hentry","category-oracle-10g","category-36"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/467","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=467"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/467\/revisions"}],"predecessor-version":[{"id":486,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/467\/revisions\/486"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=467"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}