{"id":59,"date":"2023-09-16T22:36:35","date_gmt":"2023-09-16T14:36:35","guid":{"rendered":"http:\/\/blog.yiyilearning.com\/?p=59"},"modified":"2023-10-21T11:36:41","modified_gmt":"2023-10-21T03:36:41","slug":"centos%e4%b8%8boracle%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e5%ae%89%e8%a3%85","status":"publish","type":"post","link":"https:\/\/airlive.online\/index.php\/2023\/09\/16\/centos%e4%b8%8boracle%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9a%84%e5%ae%89%e8%a3%85\/","title":{"rendered":"CentOS\u4e0bOracle\u6570\u636e\u5e93\u7684\u5b89\u88c5"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5e38\u7528\u547d\u4ee4\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>\u91cd\u542fOracle\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u6b65\u9aa4<\/code><br><code><strong>0.\u8fdb\u5165Oracle\u7528\u6237:su - oracle<\/strong><br>1.\u67e5\u770b\u76d1\u542c\u5668\u72b6\u6001\uff1alsnrctl status<br><strong>2.\u505c\u6b62\u76d1\u542c\u5668\uff1alsnrctl stop<\/strong><br><strong>3.\u8fde\u63a5\u6570\u636e\u5e93\uff1asqlplus sys\/Fyy19940722 as sysdba<br>4.\u505c\u6b62\u6570\u636e\u5e93\uff1ashutdown immediate<\/strong><br>5.\u542f\u52a8\u6570\u636e\u5e93\uff1astartup<br><strong>6.\u9000\u51fa\u6570\u636e\u5e93\uff1aexit<\/strong><br>7.\u542f\u52a8\u76d1\u542c\uff1alsnrctl start<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u53c2\u8003\u6587\u7ae0\uff1a<a href=\"https:\/\/zhuanlan.zhihu.com\/p\/111710672\">https:\/\/zhuanlan.zhihu.com\/p\/111710672<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u53c2\u8003\u6587\u7ae0\uff1a<a href=\"https:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html\">https:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u53c2\u8003\u6587\u7ae0\uff1a<a href=\"https:\/\/blog.csdn.net\/huangbaokang\/article\/details\/83857026\">https:\/\/blog.csdn.net\/huangbaokang\/article\/details\/83857026<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u672c\u6587\u8fd8\u989d\u5916\u63d0\u4f9b\u4e86\u5b89\u88c5\u4ee5\u53ca\u6700\u540e\u7684\u4e00\u4e9b\u6570\u636e\u5e93\u81ea\u542f\u52a8\u914d\u7f6e\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle\u8f6f\u4ef6\u5305\u5730\u5740\uff1a<a rel=\"noreferrer noopener\" href=\"https:\/\/pan.baidu.com\/s\/1rQFXCsL44Nl-cXaLWVY9jQ?pwd=d8ns\" target=\"_blank\">https:\/\/pan.baidu.com\/s\/1rQFXCsL44Nl-cXaLWVY9jQ?pwd=d8ns<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u524d\u7f6e\u5de5\u5177\u5b89\u88c5\uff08\u5b89\u88c5\u8fc7\u53ef\u4ee5\u5ffd\u7565\uff09\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>yum -y install vim<\/code><br><code>yum -y install unzip<\/code><br><code>yum -y install lrzsz<\/code><br><code>yum -y update<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u64cd\u4f5c\u7cfb\u7edf\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>[root<\/code><code>@localhost<\/code>&nbsp;<code>~]# cat \/etc\/redhat-release<\/code><code>CentOS Linux release&nbsp;<\/code><code>7.4<\/code><code>.<\/code><code>1708<\/code>&nbsp;<code>(Core)<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html#_labelTop\">\u56de\u5230\u9876\u90e8<\/a><a><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001\u5b89\u88c5Oracle11GR2\u6240\u9700\u8981\u7684\u4f9d\u8d56\u5305<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;\u4e00\u952e\u5b89\u88c5\u547d\u4ee4\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>yum -y install gcc gcc-c++ make binutils compat-libstdc++-<\/code><code>33<\/code>&nbsp;<code>elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-<\/code><code>static<\/code>&nbsp;<code>glibc glibc-common glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel numactl-devel sysstat unixODBC unixODBC-devel kernel-headers pcre-devel readline rlwrap\u3000<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e00\u4e2a\u4e00\u4e2a\u8fdb\u884c\u5b89\u88c5\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install gcc<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101016064-589414403.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install gcc-c++<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101047980-1267227231.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install make<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101112085-1720709806.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install binutils<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101311901-2078210050.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install compat-libstdc++-33<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101339875-732054533.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install elfutils-libelf<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101522645-405508076.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install elfutils-libelf-devel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101550690-156376447.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install elfutils-libelf-devel-static<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101635065-1944131020.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install glibc<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101747882-2136156506.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install glibc-common<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101733616-2039790684.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install glibc-devel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101813974-853645032.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install ksh<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101841952-1935530418.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install libaio<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801101913221-1776805770.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install libaio-devel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102046749-1821152278.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install libgcc<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102216087-201343621.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install libstdc++<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102242305-2074801873.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install libstdc++-devel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102317265-2098736205.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install sysstat<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102409071-885197293.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install unixODBC<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102512038-1671066288.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install unixODBC-devel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102536028-653212860.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install kernel-headers<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102720155-667816520.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install ksh<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102844613-553407483.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install pcre-devel<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102909515-2007398319.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>&nbsp;yum -y install readline*<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801102939716-1332451467.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>yum -y install rlwrap<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801104528720-1607290674.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html#_labelTop\">\u56de\u5230\u9876\u90e8<\/a><a><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001\u521b\u5efa\u7528\u6237\u7ec4\u53ca\u6587\u4ef6\u5939<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u521b\u5efa\u7528\u6237\u7ec4\uff1a<strong>groupadd oinstall<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u521b\u5efa\u7528\u6237\u7ec4\uff1a<strong>groupadd dba<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u521b\u5efa\u7528\u6237\u5e76\u6dfb\u52a0\u5230\u7528\u6237\u7ec4\uff1a<strong>useradd -g oinstall -G dba oracle<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bbe\u7f6eoracle\u7528\u6237\u5bc6\u7801\uff1a<strong>echo &#8220;Fyy19940722&#8221; | passwd &#8211;stdin oracle<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u521b\u5efa\u5b89\u88c5\u76ee\u5f55\u53ca\u6743\u9650\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>mkdir -p \/data\/robert\/app\/oracle\/product\/11.2.0\/dbhome_1<\/code><br><code>mkdir \/data\/<code>robert<\/code>\/app\/oracle\/{oradata,inventory,fast_recovery_area}<\/code><br><code>chown -R oracle:oinstall \/data\/<code>robert<\/code>\/app\/oracle<\/code><br><code>chmod -R&nbsp;775<\/code>&nbsp;<code>\/data\/<code>robert<\/code>\/app\/oracle<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html#_labelTop\">\u56de\u5230\u9876\u90e8<\/a><a><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001\u9759\u9ed8\u5b89\u88c5Oracle11GR2\u6570\u636e\u5e93<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u4f20\u6570\u636e\u5e93\u6587\u4ef6\u5230\uff1a\/data\/<code>robert<\/code>\/software\u4e0b<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>mkdir -p \/data\/<code>robert<\/code>\/software<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u89e3\u538b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>cd \/data\/<code>robert<\/code>\/software<\/code><br><code>unzip linux.x64_11gR2_database_1of2.zip<\/code><br><code>unzip linux.x64_11gR2_database_2of2.zip<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">1\u3001\u4fee\u6539\u5185\u6838\u914d\u7f6e\u6587\u4ef6<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>vim \/etc\/sysctl.conf<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u5c3e\u90e8\u6dfb\u52a0\u4e0b\u9762\u914d\u7f6e\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>fs.aio-max-nr = 1048576<br>fs.file-max = 6815744<br>kernel.shmall = 2097152<br>kernel.shmmax = 1073741824<br>kernel.shmmni = 4096<br>kernel.sem = 250 32000 100 128<br>net.ipv4.ip_local_port_range = 9000 65500<br>net.core.rmem_default = 262144<br>net.core.rmem_max = 4194304<br>net.core.wmem_default = 262144<br>net.core.wmem_max = 1048576<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801113844393-1015891332.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u914d\u7f6e\u6587\u4ef6\u751f\u6548\uff1a<strong>sysctl -p<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801113959530-1515274939.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">2\u3001\u4fee\u6539\u7528\u6237\u9650\u5236<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>vim \/etc\/security\/limits.conf<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>oracle soft nproc 2047<br>oracle hard nproc 16384<br>oracle soft nofile 1024<br>oracle hard nofile 65536<br>oracle soft stack 10240<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801114104001-1125432249.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">3\u3001\u4fee\u6539\/etc\/pam.d\/login \u6587\u4ef6<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>vim \/etc\/pam.d\/login<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>session required \/lib64\/security\/pam_limits.so<\/code><br><code>session required pam_limits.so<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801114255638-197476229.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">4\u3001\u4fee\u6539\u73af\u5883\u53d8\u91cf<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>vim \/etc\/profile<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>if [ $USER = &#8220;oracle&#8221; ]; then<br>if [ $SHELL = &#8220;\/bin\/ksh&#8221; ]; then<br>ulimit -p 16384<br>ulimit -n 65536<br>else<br>ulimit -u 16384 -n 65536<br>fi<br>fi<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801145814296-37484695.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">5\u3001<strong>\u8bbe\u7f6eoracle\u7528\u6237\u73af\u5883\u53d8\u91cf<\/strong><\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>su - oracle<\/code><br><code>vim .bash_profile<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u6dfb\u52a0\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>export ORACLE_BASE=\/data\/<code>robert<\/code>\/app\/oracle<br>export ORACLE_HOME=\/data\/<code>robert<\/code>\/app\/oracle\/product\/11.2.0\/dbhome_1<br>export ORACLE_SID=orcl<br>export ORACLE_UNQNAME=$ORACLE_SID<br>export PATH=$ORACLE_HOME\/bin:$PATH<br>export NLS_LANG=american_america.AL32UTF8<br>alias sqlplus='rlwrap sqlplus'<br>alias rman='rlwrap rman'<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801143654031-1306770913.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u914d\u7f6e\u751f\u6548\uff1a<strong>source .bash_profile<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">6\u3001\u4fee\u6539\u9759\u9ed8\u5b89\u88c5\u54cd\u5e94\u6587\u4ef6<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u62f7\u8d1d\u4e00\u4efd\u54cd\u5e94\u6587\u4ef6\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>cp -R \/data\/<code>robert<\/code>\/software\/database\/response\/ .cd response\/<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u6267\u884c\uff1a<strong>vim db_install.rsp<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4fee\u6539\u5185\u5bb9\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">oracle.install.option=INSTALL_DB_SWONLY<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801145151402-37418131.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">ORACLE_HOSTNAME=\u81ea\u5df1\u4e3b\u673a\u540d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e3b\u673a\u540d\u53ef\u901a\u8fc7\u547d\u4ee4\u83b7\u53d6\uff1ahostname<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801144204655-1181086159.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">UNIX_GROUP_NAME=oinstall<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">INVENTORY_LOCATION=\/data\/<code>robert<\/code>\/app\/oracle\/inventory<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801144417508-1617340504.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">SELECTED_LANGUAGES=en,zh_CN<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORACLE_HOME=\/data\/<code>robert<\/code>\/app\/oracle\/product\/11.2.0\/dbhome_1<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORACLE_BASE=\/data\/<code>robert<\/code>\/app\/oracle<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">oracle.install.db.InstallEdition=EE<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801144538045-1172047633.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">oracle.install.db.DBA_GROUP=dba<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">oracle.install.db.OPER_GROUP=dba<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801144626674-1469272042.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">DECLINE_SECURITY_UPDATES=true<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801144741354-1163886793.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4fdd\u5b58\u9000\u51fa<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">7\u3001\u6267\u884c\u5b89\u88c5<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u5207\u6362\u5230\u89e3\u538b\u7684\u5b89\u88c5\u5305\u76ee\u5f55\uff1a<strong>cd \/data\/<code>robert<\/code>\/software\/database\/<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6267\u884c\uff1a<strong>.\/runInstaller -silent -responseFile \/home\/oracle\/response\/db_install.rsp -ignorePrereq<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b64\u5904\u6267\u884c\u4e8b\u4ef6\u9700\u8981\u51e0\u5206\u949f\uff0c\u8010\u5fc3\u7b49\u5f85\u4e0b\uff1b<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u5b89\u88c5oracle \u62a5<strong>Checking swap space: 0 MB available, 150 MB required. Failed<\/strong>\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">[oracle@localhost database]$ .\/runInstaller -silent -responseFile \/home\/oracle\/db_install.rsp<br>Starting Oracle Universal Installer\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Checking Temp space: must be greater than 120 MB. Actual 150565 MB Passed<br>Checking swap space: 0 MB available, 150 MB required. Failed &lt;&lt;&lt;&lt;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some requirement checks failed. You must fulfill these requirements before<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">continuing with the installation,<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Exiting Oracle Universal Installer, log for this session can be found at \/tmp\/OraInstall2017-06-07_02-08-39PM\/installActions2017-06-07_02-08-39PM.log<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u89e3\u51b3\u65b9\u6cd5\uff1a<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3001\u68c0\u67e5 Swap \u7a7a\u95f4\u5728\u8bbe\u7f6e Swap \u6587\u4ef6\u4e4b\u524d\uff0c\u6709\u5fc5\u8981\u5148\u68c0\u67e5\u4e00\u4e0b\u7cfb\u7edf\u91cc\u6709\u6ca1\u6709\u65e2\u5b58\u7684 Swap \u6587\u4ef6\u3002\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>swapon -s<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u8fd4\u56de\u7684\u4fe1\u606f\u6982\u8981\u662f\u7a7a\u7684\uff0c\u5219\u8868\u793a Swap \u6587\u4ef6\u4e0d\u5b58\u5728\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3001\u68c0\u67e5\u6587\u4ef6\u7cfb\u7edf\u5728\u8bbe\u7f6e Swap \u6587\u4ef6\u4e4b\u524d\uff0c\u540c\u6837\u6709\u5fc5\u8981\u68c0\u67e5\u4e00\u4e0b\u6587\u4ef6\u7cfb\u7edf\uff0c\u770b\u770b\u662f\u5426\u6709\u8db3\u591f\u7684\u786c\u76d8\u7a7a\u95f4\u6765\u8bbe\u7f6e Swap \u3002\u8fd0\u884c\u4ee5\u4e0b\u547d\u4ee4\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>df -hal<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3\u3001\u521b\u5efa\u5e76\u5141\u8bb8 Swap \u6587\u4ef6\u4e0b\u9762\u4f7f\u7528 dd \u547d\u4ee4\u6765\u521b\u5efa Swap \u6587\u4ef6\u3002\u68c0\u67e5\u8fd4\u56de\u7684\u4fe1\u606f\uff0c\u8fd8\u5269\u4f59\u8db3\u591f\u7684\u786c\u76d8\u7a7a\u95f4\u5373\u53ef\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code> <strong>dd if=\/dev\/zero of=\/swapfile bs=1024 count=512k<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u53c2\u6570\u89e3\u8bfb\uff1aif=\u6587\u4ef6\u540d\uff1a\u8f93\u5165\u6587\u4ef6\u540d\uff0c\u7f3a\u7701\u4e3a\u6807\u51c6\u8f93\u5165\u3002\u5373\u6307\u5b9a\u6e90\u6587\u4ef6\u3002&lt; if=input file &gt;of=\u6587\u4ef6\u540d\uff1a\u8f93\u51fa\u6587\u4ef6\u540d\uff0c\u7f3a\u7701\u4e3a\u6807\u51c6\u8f93\u51fa\u3002\u5373\u6307\u5b9a\u76ee\u7684\u6587\u4ef6\u3002&lt; of=output file &gt;bs=bytes\uff1a\u540c\u65f6\u8bbe\u7f6e\u8bfb\u5165\/\u8f93\u51fa\u7684\u5757\u5927\u5c0f\u4e3abytes\u4e2a\u5b57\u8282count=blocks\uff1a\u4ec5\u62f7\u8d1dblocks\u4e2a\u5757\uff0c\u5757\u5927\u5c0f\u7b49\u4e8ebs\u6307\u5b9a\u7684\u5b57\u8282\u6570\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4\u3001\u683c\u5f0f\u5316\u5e76\u6fc0\u6d3b Swap \u6587\u4ef6\u4e0a\u9762\u5df2\u7ecf\u521b\u5efa\u597d Swap \u6587\u4ef6\uff0c\u8fd8\u9700\u8981\u683c\u5f0f\u5316\u540e\u624d\u80fd\u4f7f\u7528\u3002\u8fd0\u884c\u547d\u4ee4\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>mkswap \/swapfile<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6fc0\u6d3b Swap \uff0c\u8fd0\u884c\u547d\u4ee4\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>swapon \/swapfile<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4ee5\u4e0a\u6b65\u9aa4\u505a\u5b8c\uff0c\u518d\u6b21\u8fd0\u884c\u547d\u4ee4\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>swapon -s<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f60\u4f1a\u53d1\u73b0\u8fd4\u56de\u7684\u4fe1\u606f\u6982\u8981\uff1a<code>Filename Type Size Used Priority \/swapfile file 524284 0 -1<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>\u5982\u679c\u8981\u673a\u5668\u91cd\u542f\u7684\u65f6\u5019\u81ea\u52a8\u6302\u8f7d Swap<\/strong><\/em> \uff0c\u90a3\u4e48\u8fd8\u9700\u8981\u4fee\u6539 fstab \u914d\u7f6e\u3002\u7528 vim \u6253\u5f00 \/etc\/fstab \u6587\u4ef6\uff0c\u5728\u5176\u6700\u540e\u6dfb\u52a0\u5982\u4e0b\u4e00\u884c\uff1a<code> <\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>\/swapfile swap swap defaults 0 0<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6700\u540e\uff0c\u8d4b\u4e88 Swap \u6587\u4ef6\u9002\u5f53\u7684\u6743\u9650\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>chown root:root \/swapfile <\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code><strong>chmod 0600 \/swapfile<\/strong><\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7136\u540e\u53ef\u4ee5\u7ee7\u7eed\u5b89\u88c5\u8fd0\u884cOracle\u5b89\u88c5\u7a0b\u5e8f\uff0c<strong>\u8bb0\u5f97\u5207\u6362\u7528\u6237Oracle\u548c\u76ee\u5f55\u81f3database<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801145535747-842015313.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b89\u88c5\u5b8c\u6210\uff0c\u6210\u529f\u767b\u5f55<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801145856489-744881577.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html#_labelTop\">\u56de\u5230\u9876\u90e8<\/a><a><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u521b\u5efa\u6570\u636e\u5e93\u5b9e\u4f8b<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4fee\u6539\u54cd\u5e94\u914d\u7f6e\u6587\u4ef6\uff1a<strong>vim \/home\/oracle\/response\/dbca.rsp<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">GDBNAME = &#8220;orcl&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801150104484-96370803.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">SID= &#8220;orcl&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801150207188-432269246.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">SYSPASSWORD = &#8220;Fyy19940722&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SYSTEMPASSWORD = &#8220;Fyy19940722&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SYSMANPASSWORD = &#8220;Fyy19940722&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">DBSNMPPASSWORD = &#8220;Fyy19940722&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801150543166-1912275930.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">DATAFILEDESTINATION =\/data\/<code>robert<\/code>\/app\/oracle\/oradata<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">RECOVERYAREADESTINATION=\/data\/<code>robert<\/code>\/app\/oracle\/fast_recovery_area<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801150713720-94560182.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">CHARACTERSET = &#8220;AL32UTF8&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801150806798-1179518045.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">TOTALMEMORY = &#8220;2048&#8221;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801150832170-94382770.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u4fdd\u5b58\u9000\u51fa\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u68c0\u67e5\u914d\u7f6e\uff1a<strong>egrep -v &#8220;(^#|^$)&#8221; \/home\/oracle\/response\/dbca.rsp<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801150935984-1676258498.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b89\u88c5\u521b\u5efa\uff1a<strong>dbca -silent -responseFile \/home\/oracle\/response\/dbca.rsp<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801151515331-1536336419.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u67e5\u770b\u9ed8\u8ba4\u5b9e\u4f8b\uff1a<strong>env|grep ORACLE_UNQNAME<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u542f\u52a8\u76d1\u542c\uff1a<strong>lsnrctl start<\/strong><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u91cd\u542fOracle\u6b65\u9aa4<\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>\u91cd\u542fOracle\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u6b65\u9aa4<br>1.\u67e5\u770b\u76d1\u542c\u5668\u72b6\u6001\uff1alsnrctl status<br>2.\u505c\u6b62\u76d1\u542c\u5668\uff1alsnrctl stop<br>3.\u8fde\u63a5\u6570\u636e\u5e93\uff1asqlplus sys\/Fyy19940722 as sysdba<br>4.\u505c\u6b62\u6570\u636e\u5e93\uff1ashutdown immediate<br>5.\u542f\u52a8\u6570\u636e\u5e93\uff1astartup<br>6.\u9000\u51fa\u6570\u636e\u5e93\uff1aexit<br>7.\u542f\u52a8\u76d1\u542c\uff1alsnrctl start<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u6b63\u5e38\u7684\u76d1\u542c\u542f\u52a8\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230824103925729-1979221618.png\" alt=\"\"\/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u8fde\u63a5\u6d4b\u8bd5\uff1a\u3000<\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801151903151-562856855.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html#_labelTop\">\u56de\u5230\u9876\u90e8<\/a><a><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e94\u3001\u914d\u7f6eoracle\u5f00\u673a\u81ea\u542f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">root.sh \u662f\u4e00\u4e2a\u811a\u672c\u6587\u4ef6\uff0c\u7528\u4e8e\u5728Oracle\u6570\u636e\u5e93\u5b89\u88c5\u7684\u8fc7\u7a0b\u4e2d\u5b8c\u6210\u4e00\u4e9b\u7684\u540e\u7eed\u914d\u7f6e\u548c\u8bbe\u7f6e\u64cd\u4f5c<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">root\u7528\u6237\u6267\u884c\uff1a<strong>sh \/data\/<code>robert<\/code>\/app\/oracle\/product\/11.2.0\/dbhome_1\/root.sh<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">oracle\u7528\u6237\u6267\u884c\uff1a<strong>vim \/etc\/oratab\uff0c\u683c\u5f0f\u4e3a\uff1a\u2018\u5b9e\u4f8b\u540d:$ORACLE_HOME:Y\u2019<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><code>orcl:\/data\/<code>robert<\/code>\/app\/oracle\/product\/11.2.0\/dbhome_1:Y<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801152338370-1603407452.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">root\u7528\u6237\u6dfb\u52a0\u5f00\u673a\u81ea\u542f\u7b56\u7565\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>chmod 777 \/etc\/rc.local<br>vim \/etc\/rc.local<br>#oracle\u5f00\u673a\u81ea\u542f<br>su &#8211; oracle -c &#8220;dbstart&#8221;<br>su &#8211; oracle -c &#8220;lsnrctl start&#8221;<br>su &#8211; oracle -c &#8220;lsnrctl start listenerl&#8221;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/img2023.cnblogs.com\/blog\/2126720\/202308\/2126720-20230801152602907-390281651.png\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">sqlplus \/ as sysdba<br>alter user sys account unlock;<br>grant sysdba to sys;<br>create user Robert identified by Fyy19940722;<br>password Robert<br>grant resource to Robert;<br>grant create session to Robert;<br>grant CONNECT to Robert;<br>grant sysdba to Robert;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6062\u590d\u540e\u5982\u679c\u65e0\u6cd5\u542f\u52a8\u76d1\u542c<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u4fee\u6539hostname\u4e3a\u5b89\u88c5\u65f6\u5019\u7684<strong>ecm-24d4<\/strong>\nLast login: Tue Sep 26 14:32:36 2023 from 127.0.0.1\n&#91;root@ecm-24d4 ~]# hostname\necm-24d4\n&#91;root@ecm-24d4 ~]# lsnrctl status\n-bash: lsnrctl: command not found\n&#91;root@ecm-24d4 ~]# su - oracle \nLast login: Tue Sep 26 14:36:00 CST 2023\nLast failed login: Tue Sep 26 14:36:31 CST 2023 from 41.191.116.18 on ssh:notty\nThere was 1 failed login attempt since the last successful login.\n&#91;oracle@ecm-24d4 ~]$ lsnrctl status\n\nLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 26-SEP-2023 14:37:10\n\nCopyright (c) 1991, 2009, Oracle.  All rights reserved.\n\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production\nStart Date                26-SEP-2023 14:36:00\nUptime                    0 days 0 hr. 1 min. 10 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Log File         \/data\/u01\/app\/oracle\/diag\/tnslsnr\/ecm-24d4\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ecm-24d4)(PORT=1521)))\nServices Summary...\nService \"orcl\" has 1 instance(s).\n  Instance \"orcl\", status READY, has 1 handler(s) for this service...\nService \"orclXDB\" has 1 instance(s).\n  Instance \"orcl\", status READY, has 1 handler(s) for this service...\nThe command completed successfully\n&#91;oracle@ecm-24d4 ~]$ \n\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">THE END<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5e38\u7528\u547d\u4ee4\uff1a \u91cd\u542fOracle\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u6b65\u9aa40.\u8fdb\u5165Oracle\u7528\u6237:su &#8211; oracle1.\u67e5\u770b\u76d1\u542c\u5668\u72b6\u6001\uff1alsnrctl status2.\u505c\u6b62\u76d1\u542c\u5668\uff1alsnrctl stop3.\u8fde\u63a5\u6570\u636e\u5e93\uff1asqlplus sys\/Fyy19940722 as sysdba4.\u505c\u6b62\u6570\u636e\u5e93\uff1ashutdown immediate5.\u542f\u52a8\u6570\u636e\u5e93\uff1astartup6.\u9000\u51fa\u6570\u636e\u5e93\uff1aexit7.\u542f\u52a8\u76d1\u542c\uff1alsnrctl start \u53c2\u8003\u6587\u7ae0\uff1ahttps:\/\/zhuanlan.zhihu.com\/p\/111710672 \u53c2\u8003\u6587\u7ae0\uff1ahttps:\/\/www.cnblogs.com\/zhangzhixi\/p\/17595686.html \u53c2\u8003\u6587\u7ae0\uff1ahttps:\/\/blog.csdn.net\/huangbaokang\/article\/details\/83857026 \u672c\u6587\u8fd8\u989d\u5916\u63d0\u4f9b\u4e86\u5b89\u88c5\u4ee5\u53ca\u6700\u540e\u7684\u4e00\u4e9b\u6570\u636e\u5e93\u81ea\u542f\u52a8\u914d\u7f6e\u64cd\u4f5c\u3002 Oracle\u8f6f\u4ef6\u5305\u5730\u5740\uff1ahttps:\/\/pan.baidu.com\/s\/1rQFXCsL44Nl-cXaLWVY9jQ?pwd=d8ns \u524d\u7f6e\u5de5\u5177\u5b89\u88c5\uff08\u5b89\u88c5\u8fc7\u53ef\u4ee5\u5ffd\u7565\uff09\uff1a yum -y install vimyum -y install unzipyum -y install lrzszyum -y update \u64cd\u4f5c\u7cfb\u7edf\uff1a [root@localhost&nbsp;~]# cat \/etc\/redhat-releaseCentOS Linux release&nbsp;7.4.1708&nbsp;(Core) \u56de\u5230\u9876\u90e8 \u4e00\u3001\u5b89\u88c5Oracle11GR2\u6240\u9700\u8981\u7684\u4f9d\u8d56\u5305 &nbsp;\u4e00\u952e\u5b89\u88c5\u547d\u4ee4\uff1a yum -y install gcc gcc-c++ make binutils compat-libstdc++-33&nbsp;elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static&nbsp;glibc glibc-common glibc-devel ksh libaio libaio-devel libgcc libstdc++ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":16,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"predecessor-version":[{"id":466,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/posts\/59\/revisions\/466"}],"wp:attachment":[{"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/airlive.online\/index.php\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}