{"id":1658,"date":"2021-10-12T16:42:24","date_gmt":"2021-10-12T23:42:24","guid":{"rendered":"https:\/\/www.xh86.me\/?p=1658"},"modified":"2021-10-12T16:42:24","modified_gmt":"2021-10-12T23:42:24","slug":"centos7-%e9%9d%99%e9%bb%98%e5%ae%89%e8%a3%85-oracle-11g","status":"publish","type":"post","link":"https:\/\/www.xh86.me\/?p=1658","title":{"rendered":"CentOS7 \u9759\u9ed8\u5b89\u88c5 Oracle 11g"},"content":{"rendered":"<blockquote><p>\u5728 Linux \u4e0a\u901a\u8fc7\u547d\u4ee4\u884c\u9759\u9ed8\u5b89\u88c5 Oracle 11g \u6570\u636e\u5e93<\/p><\/blockquote>\n<h2 id=\"\u73af\u5883\">\u73af\u5883<\/h2>\n<p><strong>\u547d\u4ee4\u884c\u524d\u7f00\u8bf4\u660e\uff1a<\/strong><\/p>\n<ul>\n<li><code>#<\/code>\u00a0\u8868\u793a\u4f7f\u7528 root \u8d26\u53f7\u6267\u884c\u547d\u4ee4<\/li>\n<li><code>$<\/code>\u00a0\u8868\u793a\u4f7f\u7528\u975e root \u8d26\u53f7\uff08\u4f8b\u5982\uff1aoracle\uff09\u6267\u884c\u547d\u4ee4<\/li>\n<li><code>SQL&gt;<\/code>\u00a0\u8868\u793a\u5728 SQLPlus \u4e2d\u6267\u884c\u7684 SQL \u547d\u4ee4<\/li>\n<\/ul>\n<p>\u6d4b\u8bd5\u865a\u62df\u673a<\/p>\n<ul>\n<li>CPU\uff1a4\u6838<\/li>\n<li>\u5185\u5b58\uff1a8G<\/li>\n<li>\u64cd\u4f5c\u7cfb\u7edf<br \/>\n<figure id=\"code-1634082096527838\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> cat \/etc\/redhat-release<\/span><\/span>\r\n<span class=\"line\">CentOS Linux release 7.5.1804 (Core)<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<\/ul>\n<p>\u4e0b\u8f7d Oracle 11g\uff1a<a href=\"https:\/\/www.oracle.com\/database\/technologies\/oracle-database-software-downloads.html\" target=\"_blank\" rel=\"noopener\" data-pjax-state=\"\">Oracle\u5b98\u65b9\u7f51\u7ad9<\/a><\/p>\n<p>\u9009\u62e9\u4e0e\u4f60\u7cfb\u7edf\u548c\u67b6\u6784\u76f8\u540c\u7684\u7248\u672c<\/p>\n<p>\u4e0b\u8f7d\u5b8c\u6210\u540e\uff0c\u6709\u4e24\u4e2a\u538b\u7f29\u6587\u4ef6<\/p>\n<figure id=\"code-1634082096527111\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> ll<\/span><\/span>\r\n<span class=\"line\">-rw-r--r--. 1 root root 1.2G Mar 17 10:44 linux.x64_11gR2_database_1of2.zip<\/span>\r\n<span class=\"line\">-rw-r--r--. 1 root root 1.1G Mar 17 10:44 linux.x64_11gR2_database_2of2.zip<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h2 id=\"\u5b89\u88c5\u4f9d\u8d56\u5305\">\u5b89\u88c5\u4f9d\u8d56\u5305<\/h2>\n<h3 id=\"\u4fee\u6539-yum-\u6e90\">\u4fee\u6539 yum \u6e90<\/h3>\n<p>\u4fee\u6539 yum \u6e90\u4e3a<a href=\"https:\/\/developer.aliyun.com\/mirror\/centos?spm=a2c6h.13651102.0.0.3e221b11wKKDdn\" target=\"_blank\" rel=\"noopener\" data-pjax-state=\"\">\u963f\u91cc\u4e91\u6e90<\/a>\uff0c\u52a0\u901f\u4e0b\u8f7d\u5305\u6587\u4ef6<\/p>\n<p>CentOS7 \u66ff\u6362\u963f\u91cc\u4e91\u6e90<\/p>\n<figure id=\"code-1634082096528495\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> mv \/etc\/yum.repos.d\/CentOS-Base.repo \/etc\/yum.repos.d\/CentOS-Base.repo.backup<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> curl -o \/etc\/yum.repos.d\/CentOS-Base.repo http:\/\/mirrors.aliyun.com\/repo\/Centos-7.repo<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> yum clean all &amp;&amp; yum makecache<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h3 id=\"\u5b89\u88c5\u4f9d\u8d56\u5305-1\">\u5b89\u88c5\u4f9d\u8d56\u5305<\/h3>\n<ul>\n<li>\u5b89\u88c5<br \/>\n<figure id=\"code-1634082096528323\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel \\<\/span><\/span>\r\n<span class=\"line\">expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel \\<\/span>\r\n<span class=\"line\">libgcc libstdc++ libstdc++-devel make pdksh sysstat unixODBC unixODBC-devel<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u68c0\u67e5\u4f9d\u8d56\u662f\u5426\u5b89\u88c5\u5b8c\u6574<br \/>\n<figure id=\"code-1634082096528560\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel \\<\/span><\/span>\r\n<span class=\"line\">expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio \\<\/span>\r\n<span class=\"line\">libaio-devel libgcc libstdc++ libstdc++-devel make pdksh sysstat unixODBC \\<\/span>\r\n<span class=\"line\">unixODBC-devel | grep \"not installed\"<\/span>\r\n\r\n<span class=\"line\">package pdksh is not installed<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u53d1\u73b0\u00a0<code>pdksh<\/code>\u00a0\u6ca1\u6709\u5b89\u88c5\u6210\u529f<\/p>\n<p>\u6267\u884c\u00a0<code>yum -y install pdksh<\/code>\u00a0\u518d\u6b21\u5b89\u88c5\uff0c\u53d1\u73b0 CentOS 7 \u6ca1\u6709\u76f8\u5173\u7684\u5b89\u88c5\u5305<\/p>\n<figure id=\"code-1634082096528533\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> yum -y install pdksh<\/span><\/span>\r\n<span class=\"line\">Loaded plugins: fastestmirror, langpacks<\/span>\r\n<span class=\"line\">Loading mirror speeds from cached hostfile<\/span>\r\n<span class=\"line\"> * base: mirrors.aliyun.com<\/span>\r\n<span class=\"line\"> * extras: mirrors.aliyun.com<\/span>\r\n<span class=\"line\"> * updates: mirrors.aliyun.com<\/span>\r\n<span class=\"line\">No package pdksh available.<\/span>\r\n<span class=\"line\">Error: Nothing to do<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u901a\u8fc7\u00a0<code>wget<\/code>\u00a0\u547d\u4ee4\u76f4\u63a5\u4e0b\u8f7d\u00a0<code>pdksh<\/code>\u00a0\u7684\u00a0<code>rpm<\/code>\u00a0\u5305<\/p>\n<figure id=\"code-1634082096528707\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> wget http:\/\/vault.centos.org\/5.11\/os\/x86_64\/CentOS\/pdksh-5.2.14-37.el5_8.1.x86_64.rpm<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5b89\u88c5\u00a0<code>pdksh<\/code><\/p>\n<figure id=\"code-1634082096528742\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> yum -y install pdksh-5.2.14-37.el5_8.1.x86_64.rpm<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u518d\u6b21\u68c0\u67e5<strong>\u4f9d\u8d56\u5305<\/strong>\u5b89\u88c5\u5b8c\u6574\u6027\uff0c\u65e0\u63d0\u793a\u5219\u901a\u8fc7\u3002<\/p>\n<figure id=\"code-1634082096528823\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> rpm -q pdksh | grep <span class=\"hljs-string\">\"not installed\"<\/span><\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<\/ul>\n<h2 id=\"\u6dfb\u52a0-oracle-\u7528\u6237\u53ca\u7ec4\">\u6dfb\u52a0 oracle \u7528\u6237\u53ca\u7ec4<\/h2>\n<ol>\n<li>\u521b\u5efa oracle \u7528\u6237\u7ec4<br \/>\n<figure id=\"code-1634082096529896\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> groupadd oinstall<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> groupadd dba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> groupadd asmadmin<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> groupadd asmdba<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u521b\u5efa oracle \u7528\u6237\u5e76\u52a0\u5165\u5230\u7ec4<br \/>\n<figure id=\"code-1634082096529820\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> useradd -g oinstall -G dba,asmdba oracle -d \/home\/oracle<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u6dfb\u52a0\u5b8c\u6210\u540e\u67e5\u770b oracle \u7528\u6237<\/p>\n<figure id=\"code-1634082096529235\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> id oracle<\/span><\/span>\r\n<span class=\"line\">uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba),1003(asmdba)<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u521d\u59cb\u5316 oracle \u7528\u6237\u7684\u5bc6\u7801<br \/>\n<figure id=\"code-163408209652940\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> passwd oracle<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<\/ol>\n<h2 id=\"\u914d\u7f6e-hostname-\u53ca\u9632\u706b\u5899\">\u914d\u7f6e hostname \u53ca\u9632\u706b\u5899<\/h2>\n<p>\u5173\u95ed\u00a0<code>SELinux<\/code><\/p>\n<figure id=\"code-1634082096530976\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> setenforce 0<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> sed -i <span class=\"hljs-string\">\"s\/SELINUX=enforcing\/SELINUX=disabled\/g\"<\/span> \/etc\/selinux\/config<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5f00\u653e\u9632\u706b\u5899\u7aef\u53e3<\/p>\n<figure id=\"code-1634082096530265\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> firewall-cmd --zone=public --permanent --add-port=1521\/tcp<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> firewall-cmd --reload<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fee\u6539\u00a0<code>hostname<\/code><\/p>\n<figure id=\"code-1634082096530171\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> hostnamectl <span class=\"hljs-built_in\">set<\/span>-hostname centos-oracle<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fee\u6539\u5b8c\u6210\u540e\u9000\u51fa\u7ec8\u7aef\u5e76\u91cd\u65b0\u767b\u5f55<\/p>\n<p>\u6dfb\u52a0\u672c\u673a IP \u6620\u5c04\u5230\u00a0<code>\/etc\/hosts<\/code><\/p>\n<figure id=\"code-1634082096530779\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">echo<\/span> <span class=\"hljs-string\">'192.168.1.96 centos-oracle'<\/span> &gt;&gt; \/etc\/hosts<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u6d4b\u8bd5hostname<\/p>\n<figure id=\"code-1634082096530616\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> ping -c 2 centos-oracle<\/span><\/span>\r\n<span class=\"line\">PING centos-oracle (192.168.1.96) 56(84) bytes of data.<\/span>\r\n<span class=\"line\">64 bytes from centos-oracle (192.168.1.96): icmp_seq=1 ttl=64 time=0.065 ms<\/span>\r\n<span class=\"line\">64 bytes from centos-oracle (192.168.1.96): icmp_seq=2 ttl=64 time=0.037 ms<\/span>\r\n\r\n<span class=\"line\">--- centos-oracle ping statistics ---<\/span>\r\n<span class=\"line\">2 packets transmitted, 2 received, 0% packet loss, time 999ms<\/span>\r\n<span class=\"line\">rtt min\/avg\/max\/mdev = 0.037\/0.051\/0.065\/0.014 ms<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h2 id=\"\u4f18\u5316-OS-\u5185\u6838\u53c2\u6570\">\u4f18\u5316 OS \u5185\u6838\u53c2\u6570<\/h2>\n<figure id=\"code-1634082096530372\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> vim \/etc\/sysctl.conf<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u6dfb\u52a0\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<figure id=\"code-1634082096530623\" class=\"highlight properties hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>\/etc\/sysctl.conf<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">fs.aio-max-nr<\/span>=<span class=\"hljs-string\">1048576<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">fs.file-max<\/span>=<span class=\"hljs-string\">6815744<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">kernel.shmall<\/span>=<span class=\"hljs-string\">2097152<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">kernel.shmmni<\/span>=<span class=\"hljs-string\">4096<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">kernel.shmmax<\/span>=<span class=\"hljs-string\">4294967296<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">kernel.sem<\/span>=<span class=\"hljs-string\">250 32000 100 128<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">net.ipv4.ip_local_port_range<\/span>=<span class=\"hljs-string\">9000 65500<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">net.core.rmem_default<\/span>=<span class=\"hljs-string\">262144<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">net.core.rmem_max<\/span>=<span class=\"hljs-string\">4194304<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">net.core.wmem_default<\/span>=<span class=\"hljs-string\">262144<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">net.core.wmem_max<\/span>=<span class=\"hljs-string\">1048586<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p><strong>\u53c2\u6570\u8be6\u89e3\uff1a<\/strong><\/p>\n<ul>\n<li><strong>fs.aio-max-nr<\/strong>\uff1a\n<p>\u540c\u65f6\u53ef\u4ee5\u62e5\u6709\u7684\u7684\u5f02\u6b65IO\u8bf7\u6c42\u6570\u76ee\u3002<\/p>\n<p>\u63a8\u8350\u503c\u662f\uff1a<strong>1048576<\/strong>\u00a0\u5176\u5b9e\u5b83\u7b49\u4e8e\u00a0<span id=\"MathJax-Element-1-Frame\" class=\"mjx-chtml MathJax_CHTML\" style=\"box-sizing: inherit; font-style: normal; font-weight: normal; display: inline-block; line-height: 0; text-indent: 0px; text-align: left; text-transform: none; font-size: 15.4px; letter-spacing: normal; overflow-wrap: normal; word-spacing: normal; white-space: nowrap; float: none; direction: ltr; max-width: none; max-height: none; min-width: 0px; min-height: 0px; border: 0px; margin: 0px; padding: 1px 0px; position: relative;\" tabindex=\"0\" role=\"presentation\" data-mathml=\"&lt;math xmlns=&quot;http:\/\/www.w3.org\/1998\/Math\/MathML&quot;&gt;&lt;mn&gt;1024&lt;\/mn&gt;&lt;mo&gt;&amp;#x00D7;&lt;\/mo&gt;&lt;mn&gt;1024&lt;\/mn&gt;&lt;mo&gt;=&lt;\/mo&gt;&lt;mn&gt;1048576&lt;\/mn&gt;&lt;\/math&gt;\"><span id=\"MJXc-Node-1\" class=\"mjx-math\" aria-hidden=\"true\"><span id=\"MJXc-Node-2\" class=\"mjx-mrow\"><span id=\"MJXc-Node-3\" class=\"mjx-mn\"><span class=\"mjx-char MJXc-TeX-main-R\">1024<\/span><\/span><span id=\"MJXc-Node-4\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00d7<\/span><\/span><span id=\"MJXc-Node-5\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">1024<\/span><\/span><span id=\"MJXc-Node-6\" class=\"mjx-mo MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">=<\/span><\/span><span id=\"MJXc-Node-7\" class=\"mjx-mn MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">1048576<\/span><\/span><\/span><\/span><span class=\"MJX_Assistive_MathML\" role=\"presentation\">1024\u00d71024=1048576<\/span><\/span>\u00a0\u4e5f\u5c31\u662f 1024K \u4e2a\u3002<\/li>\n<li><strong>fs.file-max<\/strong>\uff1a\n<p>\u8868\u793a\u4e00\u4e2a\u8fdb\u7a0b\u53ef\u4ee5\u6253\u5f00\u7684\u6587\u4ef6\u53e5\u67c4\u7684\u6700\u5927\u6570\u91cf\u3002<\/li>\n<li><strong>kernel.shmall<\/strong>\u00a0\u7684\u5355\u4f4d\u662f\u9875\u3002\n<p>\u7b80\u8ff0\uff1a<strong>2097152<\/strong>\u00a0=8G \uff0c<strong>4194304<\/strong>=16G<\/p>\n<p>\u8be6\u8ff0\uff1a\u5bf9\u4e8e X86 \u7684 linux \u7cfb\u7edf\uff0c\u4e00\u9875=4k\uff0c\u4e5f\u5c31\u662f4096\u5b57\u8282\u3002<code>kernel.shmall = 2097152<\/code>\u00a0\u5c31\u662f\u00a0<span id=\"MathJax-Element-2-Frame\" class=\"mjx-chtml MathJax_CHTML\" style=\"box-sizing: inherit; font-style: normal; font-weight: normal; display: inline-block; line-height: 0; text-indent: 0px; text-align: left; text-transform: none; font-size: 15.4px; letter-spacing: normal; overflow-wrap: normal; word-spacing: normal; white-space: nowrap; float: none; direction: ltr; max-width: none; max-height: none; min-width: 0px; min-height: 0px; border: 0px; margin: 0px; padding: 1px 0px; position: relative;\" tabindex=\"0\" role=\"presentation\" data-mathml=\"&lt;math xmlns=&quot;http:\/\/www.w3.org\/1998\/Math\/MathML&quot;&gt;&lt;mn&gt;8&lt;\/mn&gt;&lt;mi&gt;G&lt;\/mi&gt;&lt;mo&gt;&amp;#x00D7;&lt;\/mo&gt;&lt;mn&gt;1024&lt;\/mn&gt;&lt;mo&gt;&amp;#x00D7;&lt;\/mo&gt;&lt;mn&gt;1024&lt;\/mn&gt;&lt;mo&gt;&amp;#x00F7;&lt;\/mo&gt;&lt;mn&gt;4&lt;\/mn&gt;&lt;mi&gt;k&lt;\/mi&gt;&lt;mo&gt;=&lt;\/mo&gt;&lt;mn&gt;2097152&lt;\/mn&gt;&lt;\/math&gt;\"><span id=\"MJXc-Node-8\" class=\"mjx-math\" aria-hidden=\"true\"><span id=\"MJXc-Node-9\" class=\"mjx-mrow\"><span id=\"MJXc-Node-10\" class=\"mjx-mn\"><span class=\"mjx-char MJXc-TeX-main-R\">8<\/span><\/span><span id=\"MJXc-Node-11\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">G<\/span><\/span><span id=\"MJXc-Node-12\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00d7<\/span><\/span><span id=\"MJXc-Node-13\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">1024<\/span><\/span><span id=\"MJXc-Node-14\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00d7<\/span><\/span><span id=\"MJXc-Node-15\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">1024<\/span><\/span><span id=\"MJXc-Node-16\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00f7<\/span><\/span><span id=\"MJXc-Node-17\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">4<\/span><\/span><span id=\"MJXc-Node-18\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">k<\/span><\/span><span id=\"MJXc-Node-19\" class=\"mjx-mo MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">=<\/span><\/span><span id=\"MJXc-Node-20\" class=\"mjx-mn MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">2097152<\/span><\/span><\/span><\/span><span class=\"MJX_Assistive_MathML\" role=\"presentation\">8G\u00d71024\u00d71024\u00f74k=2097152<\/span><\/span>\u00a0\u5c31\u662f\u8bf4\u53ef\u7528\u5171\u4eab\u5185\u5b58\u4e00\u5171 8G\u3002<\/p>\n<p>\u4e00\u4e2a\u5171\u4eab\u5185\u5b58\u6bb5\u7684\u6700\u5927\u5927\u5c0f\u662f16G\uff0c\u90a3\u4e48\u9700\u8981\u5171\u4eab\u5185\u5b58\u9875\u6570\u662f\u00a0<span id=\"MathJax-Element-3-Frame\" class=\"mjx-chtml MathJax_CHTML\" style=\"box-sizing: inherit; font-style: normal; font-weight: normal; display: inline-block; line-height: 0; text-indent: 0px; text-align: left; text-transform: none; font-size: 15.4px; letter-spacing: normal; overflow-wrap: normal; word-spacing: normal; white-space: nowrap; float: none; direction: ltr; max-width: none; max-height: none; min-width: 0px; min-height: 0px; border: 0px; margin: 0px; padding: 1px 0px; position: relative;\" tabindex=\"0\" role=\"presentation\" data-mathml=\"&lt;math xmlns=&quot;http:\/\/www.w3.org\/1998\/Math\/MathML&quot;&gt;&lt;mn&gt;16&lt;\/mn&gt;&lt;mi&gt;G&lt;\/mi&gt;&lt;mi&gt;B&lt;\/mi&gt;&lt;mo&gt;&amp;#x00F7;&lt;\/mo&gt;&lt;mn&gt;4&lt;\/mn&gt;&lt;mi&gt;K&lt;\/mi&gt;&lt;mi&gt;B&lt;\/mi&gt;&lt;mo&gt;=&lt;\/mo&gt;&lt;mn&gt;16777216&lt;\/mn&gt;&lt;mi&gt;K&lt;\/mi&gt;&lt;mi&gt;B&lt;\/mi&gt;&lt;mo&gt;&amp;#x00F7;&lt;\/mo&gt;&lt;mn&gt;4&lt;\/mn&gt;&lt;mi&gt;K&lt;\/mi&gt;&lt;mi&gt;B&lt;\/mi&gt;&lt;mo&gt;=&lt;\/mo&gt;&lt;mn&gt;4194304&lt;\/mn&gt;&lt;\/math&gt;\"><span id=\"MJXc-Node-21\" class=\"mjx-math\" aria-hidden=\"true\"><span id=\"MJXc-Node-22\" class=\"mjx-mrow\"><span id=\"MJXc-Node-23\" class=\"mjx-mn\"><span class=\"mjx-char MJXc-TeX-main-R\">16<\/span><\/span><span id=\"MJXc-Node-24\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">G<\/span><\/span><span id=\"MJXc-Node-25\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">B<\/span><\/span><span id=\"MJXc-Node-26\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00f7<\/span><\/span><span id=\"MJXc-Node-27\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">4<\/span><\/span><span id=\"MJXc-Node-28\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">K<\/span><\/span><span id=\"MJXc-Node-29\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">B<\/span><\/span><span id=\"MJXc-Node-30\" class=\"mjx-mo MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">=<\/span><\/span><span id=\"MJXc-Node-31\" class=\"mjx-mn MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">16777216<\/span><\/span><span id=\"MJXc-Node-32\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">K<\/span><\/span><span id=\"MJXc-Node-33\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">B<\/span><\/span><span id=\"MJXc-Node-34\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00f7<\/span><\/span><span id=\"MJXc-Node-35\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">4<\/span><\/span><span id=\"MJXc-Node-36\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">K<\/span><\/span><span id=\"MJXc-Node-37\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">B<\/span><\/span><span id=\"MJXc-Node-38\" class=\"mjx-mo MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">=<\/span><\/span><span id=\"MJXc-Node-39\" class=\"mjx-mn MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">4194304<\/span><\/span><\/span><\/span><span class=\"MJX_Assistive_MathML\" role=\"presentation\">16GB\u00f74KB=16777216KB\u00f74KB=4194304<\/span><\/span>\u00a0\uff08\u9875\uff09\uff0c\u4e5f\u5c31\u662f 64Bit \u7cfb\u7edf\u4e0b 16GB \u7269\u7406\u5185\u5b58\uff0c\u8bbe\u7f6e\u00a0<code>kernel.shmall = 4194304<\/code>\u00a0\u624d\u7b26\u5408\u8981\u6c42(\u51e0\u4e4e\u662f\u539f\u6765\u8bbe\u7f6e\u503c 2097152 \u7684<strong>\u4e24\u500d<\/strong>)\u3002\u8fd9\u65f6\u53ef\u4ee5\u5c06\u00a0<code>shmmax<\/code>\u00a0\u53c2\u6570\u8c03\u6574\u5230 16G \u4e86\uff0c\u540c\u65f6\u53ef\u4ee5\u4fee\u6539\u00a0<code>SGA_MAX_SIZE<\/code>\u00a0\u548c\u00a0<code>SGA_TARGET<\/code>\u00a0\u4e3a 12G\uff08\u60a8\u60f3\u8bbe\u7f6e\u7684 SGA \u6700\u5927\u5927\u5c0f\uff0c\u5f53\u7136\u4e5f\u53ef\u4ee5\u662f 2G~14G \u7b49\uff0c\u8fd8\u8981\u534f\u8c03 PGA \u53c2\u6570\u53ca OS \u7b49\u5176\u4ed6\u5185\u5b58\u4f7f\u7528\uff0c\u4e0d\u80fd\u8bbe\u7f6e\u592a\u6ee1\uff0c\u6bd4\u598216G\uff09\u3002<\/li>\n<li><strong>kernel.shmmni<\/strong>\uff1a\n<p>\u5171\u4eab\u5185\u5b58\u6bb5\u7684\u6700\u5927\u6570\u91cf\uff0c<code>shmmni<\/code>\u00a0\u7f3a\u7701\u503c\u00a0<strong>4096<\/strong>\u00a0\uff0c\u4e00\u822c\u80af\u5b9a\u662f\u591f\u7528\u4e86\u3002<\/li>\n<li><strong>kernel.shmmax<\/strong>\uff1a\n<p>\u8be5\u53c2\u6570\u53ef\u8bbe\u7f6e\u4e3a<strong>\u7269\u7406\u5185\u5b58<\/strong>\u7684\u4e00\u534a\u3002<\/p>\n<p><code>Shmmax<\/code>\u00a0\u662f\u6838\u5fc3\u53c2\u6570\u4e2d\u6700\u91cd\u8981\u7684\u53c2\u6570\u4e4b\u4e00\uff0c\u7528\u4e8e\u5b9a\u4e49<strong>\u5355\u4e2a\u5171\u4eab\u5185\u5b58\u6bb5\u7684\u6700\u5927\u503c<\/strong>\uff08\u4ee5\u5b57\u8282\u4e3a\u5355\u4f4d\uff09\uff0c\u8bbe\u7f6e\u5e94\u8be5\u8db3\u591f\u5927\uff0c\u80fd\u5728\u4e00\u4e2a\u5171\u4eab\u5185\u5b58\u6bb5\u4e0b\u5bb9\u7eb3\u4e0b\u6574\u4e2a\u7684 SGA\uff0c\u8bbe\u7f6e\u7684\u8fc7\u4f4e\u53ef\u80fd\u4f1a\u5bfc\u81f4\u9700\u8981\u521b\u5efa\u591a\u4e2a\u5171\u4eab\u5185\u5b58\u6bb5\uff0c\u8fd9\u6837\u53ef\u80fd\u5bfc\u81f4\u7cfb\u7edf\u6027\u80fd\u7684\u4e0b\u964d\uff0c\u6700\u5927\u503c\u4e3a 16GB (\u5728\u5927\u591a\u6570\u60c5\u51b5\u4e0b\uff0c\u8be5\u503c\u5e94\u8be5\u6bd4 SGA \u5927)\u3002<\/p>\n<p>\u5176\u503c\u5e94\u00a0<code>&gt;=sag_max_size<\/code>\u00a0\u521d\u59cb\u5316\u53c2\u6570\u7684\u5927\u5c0f,\u5426\u5219 SAG \u7531\u591a\u4e2a\u5185\u5b58\u6bb5\u6784\u6210\uff0c\u6548\u7387\u964d\u4f4e\uff0c<strong>\u8fd8\u8981\u4e0d\u5c0f\u4e8e\u7269\u7406\u5185\u5b58\u7684\u4e00\u534a<\/strong>\uff0c\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5728\u00a0<strong>32\u4f4dx86\u7cfb\u7edf<\/strong>\u00a0\u4e2d,Oracle SGA \u6700\u5927\u4e0d\u80fd\u8d85\u8fc7 1.7GB\u3002\u7f3a\u7701\u4e3a 32M\uff0c\u5bf9\u4e8e Oracle \u6765\u8bf4\uff0c\u8be5\u7f3a\u7701\u503c\u592a\u4f4e\u4e86\uff0c\u901a\u5e38\u5c06\u5176\u8bbe\u7f6e\u4e3a<strong>2G\uff082147483648\uff09<\/strong>\u3002\u9488\u5bf98G\u7684\u670d\u52a1\u5668\uff0c\u81f3\u5c11\u00a0<strong>4G<\/strong>\u00a0\u7684\u914d\u7f6e\uff0c\u5219\u662f<strong>4294967296<\/strong>\u3002<\/li>\n<li><strong>kernel.sem<\/strong>\uff1a\n<p>\u8868\u793a\u8bbe\u7f6e\u7684\u4fe1\u53f7\u91cf<\/li>\n<li><strong>net.ipv4.ip_local_port_range<\/strong>\uff1a\n<p>\u4e13\u7528\u670d\u52a1\u5668\u6a21\u5f0f\u4e0b\u4e0e\u7528\u6237\u8fdb\u7a0b\u901a\u4fe1\u65f6\u5206\u914d\u7ed9\u7528\u6237\u7684\u7aef\u53e3\u533a\u95f4<\/li>\n<li><strong>net.core.rmem_default<\/strong>\uff1a\n<p>\u9ed8\u8ba4\u63a5\u6536\u7f13\u51b2\u533a\u5927\u5c0f<\/li>\n<li><strong>net.core.rmem_max<\/strong>\uff1a\n<p>\u63a5\u6536\u7f13\u51b2\u533a\u6700\u5927\u503c<\/li>\n<li><strong>net.core.wmem_default<\/strong>\uff1a\n<p>\u9ed8\u8ba4\u7684\u53d1\u9001\u7f13\u51b2\u533a\u5927\u5c0f<\/li>\n<li><strong>net.core.wmem_max<\/strong>\uff1a\n<p>\u53d1\u9001\u7f13\u51b2\u533a\u6700\u5927\u503c<\/li>\n<\/ul>\n<p>\u6dfb\u52a0\u5e76\u4fdd\u5b58\u540e\uff0c\u6267\u884c\u547d\u4ee4\u4f7f\u53c2\u6570\u751f\u6548<\/p>\n<figure id=\"code-1634082096531943\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> sysctl -p<\/span><\/span>\r\n<span class=\"line\">fs.aio-max-nr = 1048576<\/span>\r\n<span class=\"line\">fs.file-max = 6815744<\/span>\r\n<span class=\"line\">kernel.shmall = 2097152<\/span>\r\n<span class=\"line\">kernel.shmmni = 4096<\/span>\r\n<span class=\"line\">kernel.shmmax = 4294967296<\/span>\r\n<span class=\"line\">kernel.sem = 250 32000 100 128<\/span>\r\n<span class=\"line\">net.ipv4.ip_local_port_range = 9000 65500<\/span>\r\n<span class=\"line\">net.core.rmem_default = 262144<\/span>\r\n<span class=\"line\">net.core.rmem_max = 4194304<\/span>\r\n<span class=\"line\">net.core.wmem_default = 262144<\/span>\r\n<span class=\"line\">net.core.wmem_max = 1048586<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<ul>\n<li>\u4f7f\u7528\u00a0<code>ipcs -l<\/code>\u00a0\u67e5\u770b\u7ed3\u679c<br \/>\n<figure id=\"code-1634082096531888\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> ipcs -l<\/span><\/span>\r\n\r\n<span class=\"line\">------ Messages Limits --------<\/span>\r\n<span class=\"line\">max queues system wide = 15637<\/span>\r\n<span class=\"line\">max size of message (bytes) = 8192<\/span>\r\n<span class=\"line\">default max size of queue (bytes) = 16384<\/span>\r\n\r\n<span class=\"line\">------ Shared Memory Limits --------<\/span>\r\n<span class=\"line\">max number of segments = 4096<\/span>\r\n<span class=\"line\">max seg size (kbytes) = 4194304<\/span>\r\n<span class=\"line\">max total shared memory (kbytes) = 8388608<\/span>\r\n<span class=\"line\">min seg size (bytes) = 1<\/span>\r\n\r\n<span class=\"line\">------ Semaphore Limits --------<\/span>\r\n<span class=\"line\">max number of arrays = 128<\/span>\r\n<span class=\"line\">max semaphores per array = 250<\/span>\r\n<span class=\"line\">max semaphores system wide = 32000<\/span>\r\n<span class=\"line\">max ops per semop call = 100<\/span>\r\n<span class=\"line\">semaphore max value = 32767<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u4f7f\u7528\u00a0<code>ipcs -u<\/code>\u00a0\u67e5\u770b\u5b9e\u9645\u4f7f\u7528\u60c5\u51b5<br \/>\n<figure id=\"code-1634082096531481\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> ipcs -u<\/span><\/span>\r\n\r\n<span class=\"line\">------ Messages Status --------<\/span>\r\n<span class=\"line\">allocated queues = 0<\/span>\r\n<span class=\"line\">used headers = 0<\/span>\r\n<span class=\"line\">used space = 0 bytes<\/span>\r\n\r\n<span class=\"line\">------ Shared Memory Status --------<\/span>\r\n<span class=\"line\">segments allocated 0<\/span>\r\n<span class=\"line\">pages allocated 0<\/span>\r\n<span class=\"line\">pages resident  0<\/span>\r\n<span class=\"line\">pages swapped   0<\/span>\r\n<span class=\"line\">Swap performance: 0 attempts\t 0 successes<\/span>\r\n\r\n<span class=\"line\">------ Semaphore Status --------<\/span>\r\n<span class=\"line\">used arrays = 0<\/span>\r\n<span class=\"line\">allocated semaphores = 0<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<\/ul>\n<h2 id=\"\u9650\u5236-oracle-\u7528\u6237\u6743\u9650\">\u9650\u5236 oracle \u7528\u6237\u6743\u9650<\/h2>\n<p>\u9650\u5236 oracle \u7528\u6237 shell \u6743\u9650<\/p>\n<figure id=\"code-1634082096531381\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> vim \/etc\/security\/limits.conf<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5728\u672b\u5c3e\u6dfb\u52a0<\/p>\n<figure id=\"code-1634082096531454\" class=\"highlight properties hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>\/etc\/security\/limits.conf<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-attr\">oracle<\/span>    <span class=\"hljs-string\">soft    nproc    2047<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-attr\">oracle<\/span>    <span class=\"hljs-string\">hard    nproc    16384<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-attr\">oracle<\/span>    <span class=\"hljs-string\">soft    nofile    1024<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-attr\">oracle<\/span>    <span class=\"hljs-string\">hard    nofile    65536<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p><strong>limits.conf \u914d\u7f6e\u8bf4\u660e<\/strong>\uff1a<\/p>\n<p>\u683c\u5f0f\uff1a<\/p>\n<figure id=\"code-1634082096533327\" class=\"highlight properties hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">&lt;domain&gt;<\/span>    <span class=\"hljs-string\">&lt;type&gt;    &lt;resource&gt;    &lt;value&gt;<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<ul>\n<li><strong>domain<\/strong>\uff1a\n<p><code>username|@groupname<\/code>\uff1a\u8bbe\u7f6e\u9700\u8981\u88ab\u9650\u5236\u7684\u7528\u6237\u540d\uff0c\u7ec4\u540d\u524d\u9762\u52a0\u00a0<code>@<\/code>\u00a0\u4e0e\u00a0<code>\u7528\u6237\u540d<\/code>\u00a0\u533a\u522b\u3002\u00a0<code>*<\/code>\u00a0\u8868\u793a\u6240\u6709\u7528\u6237\uff08\u6ce8\u610f\u6709\u7684\u7cfb\u7edf\u4e0d\u652f\u6301\uff09\u3002<\/li>\n<li><strong>type<\/strong>\uff1a\n<ul>\n<li><code>soft<\/code>\u00a0\u6307\u7684\u662f\u5f53\u524d\u7cfb\u7edf\u751f\u6548\u7684\u8bbe\u7f6e\u503c<\/li>\n<li><code>hard<\/code>\u00a0\u8868\u660e\u7cfb\u7edf\u4e2d\u6240\u80fd\u8bbe\u5b9a\u7684\u6700\u5927\u503c\uff08soft \u7684\u9650\u5236\u4e0d\u80fd\u6bd4 hard \u9650\u5236\u9ad8 \uff09<\/li>\n<li><code>-<\/code>\u00a0\u5c31\u8868\u660e\u540c\u65f6\u8bbe\u7f6e\u4e86 soft \u548c hard \u7684\u503c<\/li>\n<\/ul>\n<\/li>\n<li><strong>resource<\/strong>\uff1a\n<p><strong>\u9488\u5bf9Oracle\u7684\u6211\u4eec\u4e3b\u8981\u914d\u7f6enproc nofile<\/strong><\/p>\n<ul>\n<li><code>as<\/code>\uff1a\u5730\u5740\u7a7a\u95f4\u9650\u5236<\/li>\n<li><code>rss<\/code>\uff1a\u6700\u5927\u6301\u4e45\u8bbe\u7f6e\u5927\u5c0f<\/li>\n<li><code>cpu<\/code>\uff1a\u4ee5\u5206\u949f\u4e3a\u5355\u4f4d\u7684\u6700\u591a CPU \u65f6\u95f4<\/li>\n<li><code>core<\/code>\uff1a\u9650\u5236\u5185\u6838\u6587\u4ef6\u7684\u5927\u5c0f<\/li>\n<li><code>date<\/code>\uff1a\u6700\u5927\u6570\u636e\u5927\u5c0f<\/li>\n<li><code>stack<\/code>\uff1a\u6700\u5927\u6808\u5927\u5c0f<\/li>\n<li><code>fsize<\/code>\uff1a\u6700\u5927\u6587\u4ef6\u5927\u5c0f<\/li>\n<li><code>noproc<\/code>\uff1a<strong>\u8fdb\u7a0b\u7684\u6700\u5927\u6570\u76ee<\/strong><\/li>\n<li><code>nofile<\/code>\uff1a<strong>\u6253\u5f00\u6587\u4ef6\u7684\u6700\u5927\u6570\u76ee<\/strong><\/li>\n<li><code>memlock<\/code>\uff1a\u6700\u5927\u9501\u5b9a\u5185\u5b58\u5730\u5740\u7a7a\u95f4<\/li>\n<li><code>maxlogins<\/code>\uff1a\u6b64\u7528\u6237\u5141\u8bb8\u767b\u5f55\u7684\u6700\u5927\u6570\u76ee<\/li>\n<\/ul>\n<\/li>\n<li><strong>value<\/strong>\uff1a\n<p>\u9650\u5236\u7684\u503c<\/li>\n<\/ul>\n<p>\u4fee\u6539\u767b\u9646\u9a8c\u8bc1\u914d\u7f6e\u6587\u4ef6<\/p>\n<figure id=\"code-1634082096533140\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> vim \/etc\/pam.d\/login<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u672b\u5c3e\u589e\u52a0<\/p>\n<figure id=\"code-1634082096535708\" class=\"highlight properties hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>\/etc\/pam.d\/login<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-attr\">session<\/span>    <span class=\"hljs-string\">required     \/lib64\/security\/pam_limits.so<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-attr\">session<\/span>    <span class=\"hljs-string\">required     pam_limits.so<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u6dfb\u52a0 oracle profile \u914d\u7f6e\u6587\u4ef6<\/p>\n<figure id=\"code-163408209653654\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> vim \/etc\/profile.d\/oracle.sh<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<figure id=\"code-1634082096536506\" class=\"highlight bash hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>\/etc\/profile.d\/oracle.sh<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-keyword\">if<\/span> [ <span class=\"hljs-variable\">$USER<\/span> = <span class=\"hljs-string\">\"oracle\"<\/span> ]; <span class=\"hljs-keyword\">then<\/span><\/span>\r\n<span class=\"line\">    <span class=\"hljs-keyword\">if<\/span> [ <span class=\"hljs-variable\">$SHELL<\/span> = <span class=\"hljs-string\">\"\/bin\/ksh\"<\/span> ]; <span class=\"hljs-keyword\">then<\/span><\/span>\r\n<span class=\"line\">        <span class=\"hljs-built_in\">ulimit<\/span> -p 16384<\/span>\r\n<span class=\"line\">        <span class=\"hljs-built_in\">ulimit<\/span> -n 65536<\/span>\r\n<span class=\"line\">    <span class=\"hljs-keyword\">else<\/span><\/span>\r\n<span class=\"line\">        <span class=\"hljs-built_in\">ulimit<\/span> -u 16384 -n 65536<\/span>\r\n<span class=\"line\">    <span class=\"hljs-keyword\">fi<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-keyword\">fi<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fdd\u5b58\u540e\u4f7f\u4e4b\u751f\u6548<\/p>\n<figure id=\"code-1634082096537337\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">source<\/span> \/etc\/profile<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h2 id=\"\u521b\u5efa-oracle-\u5b89\u88c5\u76ee\u5f55\">\u521b\u5efa oracle \u5b89\u88c5\u76ee\u5f55<\/h2>\n<figure id=\"code-1634082096537784\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> mkdir -p \/u01\/app\/oracle\/product\/11.2.0   <span class=\"hljs-comment\"># oracle home \u76ee\u5f55<\/span><\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> mkdir \/u01\/app\/oracle\/oradata             <span class=\"hljs-comment\"># \u6570\u636e\u6587\u4ef6\u5b58\u653e\u76ee\u5f55<\/span><\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> mkdir \/u01\/app\/oracle\/inventory           <span class=\"hljs-comment\"># \u5b89\u88c5\u65e5\u5fd7\u5b58\u653e\u76ee\u5f55<\/span><\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> mkdir \/u01\/app\/oracle\/fast_recovery_area  <span class=\"hljs-comment\"># \u5feb\u901f\u6062\u590d\u5206\u533a<\/span><\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> chown -R oracle:oinstall \/u01\/app\/oracle<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> chmod -R 775 \/u01\/app\/oracle<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h2 id=\"\u914d\u7f6e-oracle-\u7528\u6237\u73af\u5883\u53d8\u91cf\">\u914d\u7f6e oracle \u7528\u6237\u73af\u5883\u53d8\u91cf<\/h2>\n<p>\u5207\u6362\u81f3 oracle \u7528\u6237<\/p>\n<figure id=\"code-1634082096537324\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> su - oracle<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fee\u6539 oracle \u7528\u6237 home \u8def\u5f84\u4e0b\u00a0<code>.bash_profile<\/code>\u00a0\u914d\u7f6e\u6587\u4ef6<\/p>\n<figure id=\"code-1634082096538313\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> vim ~\/.bash_profile<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5728\u672b\u5c3e\u6dfb\u52a0<\/p>\n<figure id=\"code-163408209653871\" class=\"highlight bash hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>~\/.bash_profile<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-comment\"># Oracle<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">umask<\/span> 022<\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> ORACLE_HOSTNAME=centos-oracle<\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> ORACLE_BASE=\/u01\/app\/oracle<\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> ORACLE_HOME=<span class=\"hljs-variable\">$ORACLE_BASE<\/span>\/product\/11.2.0\/<\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> ORACLE_SID=ORCL<\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> PATH=.:<span class=\"hljs-variable\">$ORACLE_HOME<\/span>\/bin:<span class=\"hljs-variable\">$ORACLE_HOME<\/span>\/OPatch:<span class=\"hljs-variable\">$ORACLE_HOME<\/span>\/jdk\/bin:<span class=\"hljs-variable\">$PATH<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> LC_ALL=<span class=\"hljs-string\">\"en_US\"<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> LANG=<span class=\"hljs-string\">\"en_US\"<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> NLS_LANG=<span class=\"hljs-string\">\"AMERICAN_AMERICA.ZHS16GBK\"<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-built_in\">export<\/span> NLS_DATE_FORMAT=<span class=\"hljs-string\">\"YYYY-MM-DD HH24:MI:SS\"<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4f7f\u914d\u7f6e\u751f\u6548<\/p>\n<figure id=\"code-1634082096538907\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">source<\/span> \/home\/oracle\/.bash_profile<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4f7f\u7528\u00a0<code>env<\/code>\u00a0\u547d\u4ee4\u67e5\u770b\u73af\u5883\u53d8\u91cf<\/p>\n<h2 id=\"\u89e3\u538b-oracle-\u538b\u7f29\u6587\u4ef6\">\u89e3\u538b oracle \u538b\u7f29\u6587\u4ef6<\/h2>\n<p>\u5207\u6362\u56de\u00a0<code>root<\/code>\u00a0\u7528\u6237\uff0c\u89e3\u538b oracle \u538b\u7f29\u6587\u4ef6\u81f3\u00a0<code>\/u01\/<\/code>\u00a0\u8def\u5f84\u4e0b<\/p>\n<figure id=\"code-1634082096539647\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> unzip linux.x64_11gR2_database_1of2.zip -d \/u01\/<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> unzip linux.x64_11gR2_database_2of2.zip -d \/u01\/<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> chown -R oracle:oinstall \/u01\/database\/<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u89e3\u538b\u5b8c\u6210\u540e<\/p>\n<figure id=\"code-1634082096539457\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> mkdir \/u01\/etc\/<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> cp \/u01\/database\/response\/* \/u01\/etc\/<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> chown -R oracle:oinstall \/u01\/etc\/<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fee\u6539\u00a0<code>db_install.rsp<\/code><\/p>\n<figure id=\"code-163408209653922\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> vim \/u01\/etc\/db_install.rsp<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fee\u6539\u5185\u5bb9\u5982\u4e0b\uff1a<\/p>\n<figure id=\"code-1634082096539117\" class=\"highlight properties hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>\/u01\/etc\/db_install.rsp<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span>\r\n<span class=\"line\">20<\/span>\r\n<span class=\"line\">21<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">oracle.install.option<\/span>=<span class=\"hljs-string\">INSTALL_DB_SWONLY<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">DECLINE_SECURITY_UPDATES<\/span>=<span class=\"hljs-string\">true<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">UNIX_GROUP_NAME<\/span>=<span class=\"hljs-string\">oinstall<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">INVENTORY_LOCATION<\/span>=<span class=\"hljs-string\">\/u01\/app\/oracle\/inventory<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">SELECTED_LANGUAGES<\/span>=<span class=\"hljs-string\">en,zh_CN<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">ORACLE_HOSTNAME<\/span>=<span class=\"hljs-string\">centos-oracle<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">ORACLE_HOME<\/span>=<span class=\"hljs-string\">\/u01\/app\/oracle\/product\/11.2.0<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">ORACLE_BASE<\/span>=<span class=\"hljs-string\">\/u01\/app\/oracle<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-meta\">oracle.install.db.InstallEdition<\/span>=<span class=\"hljs-string\">EE<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-meta\">oracle.install.db.DBA_GROUP<\/span>=<span class=\"hljs-string\">dba<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-meta\">oracle.install.db.OPER_GROUP<\/span>=<span class=\"hljs-string\">dba<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fdd\u5b58\u9000\u51fa\u540e\uff0c\u5f00\u59cb\u5b89\u88c5 oracle<\/p>\n<h2 id=\"\u5b89\u88c5-oracle\">\u5b89\u88c5 oracle<\/h2>\n<p>\u5207\u6362\u81f3 oracle \u7528\u6237<\/p>\n<figure id=\"code-1634082096539689\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> su - oracle<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u8fdb\u5165\u89e3\u538b\u540e\u7684 oracle \u5b89\u88c5\u76ee\u5f55<\/p>\n<figure id=\"code-1634082096540175\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">cd<\/span> \/u01\/database\/<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5f00\u59cb\u6267\u884c\u9759\u9ed8\u5b89\u88c5<\/p>\n<figure id=\"code-1634082096540632\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span>\r\n<span class=\"line\">20<\/span>\r\n<span class=\"line\">21<\/span>\r\n<span class=\"line\">22<\/span>\r\n<span class=\"line\">23<\/span>\r\n<span class=\"line\">24<\/span>\r\n<span class=\"line\">25<\/span>\r\n<span class=\"line\">26<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> .\/runInstaller -silent -ignorePrereq -responseFile \/u01\/etc\/db_install.rsp<\/span><\/span>\r\n<span class=\"line\">Starting Oracle Universal Installer...<\/span>\r\n\r\n<span class=\"line\">Checking Temp space: must be greater than 120 MB.   Actual 11280 MB    Passed<\/span>\r\n<span class=\"line\">Checking swap space: must be greater than 150 MB.   Actual 2047 MB    Passed<\/span>\r\n<span class=\"line\">Preparing to launch Oracle Universal Installer from \/tmp\/OraInstall2020-03-18_10-01-22AM. Please wait ...[oracle@centos-oracle database]$ [WARNING] [INS-32055] The Central Inventory is located in the Oracle base.<\/span>\r\n<span class=\"line\">   CAUSE: The Central Inventory is located in the Oracle base.<\/span>\r\n<span class=\"line\">   ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory.<\/span>\r\n<span class=\"line\">[WARNING] [INS-32055] The Central Inventory is located in the Oracle base.<\/span>\r\n<span class=\"line\">   CAUSE: The Central Inventory is located in the Oracle base.<\/span>\r\n<span class=\"line\">   ACTION: Oracle recommends placing this Central Inventory in a location outside the Oracle base directory.<\/span>\r\n<span class=\"line\">You can find the log of this install session at:<\/span>\r\n<span class=\"line\"> \/u01\/app\/oracle\/inventory\/logs\/installActions2020-03-18_10-01-22AM.log<\/span>\r\n<span class=\"line\">The following configuration scripts need to be executed as the \"root\" user.<\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\"> #<\/span><span class=\"hljs-bash\">!\/bin\/sh<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\"> #<\/span><span class=\"hljs-bash\">Root scripts to run<\/span><\/span>\r\n\r\n<span class=\"line\">\/u01\/app\/oracle\/inventory\/orainstRoot.sh<\/span>\r\n<span class=\"line\">\/u01\/app\/oracle\/product\/11.2.0\/root.sh<\/span>\r\n<span class=\"line\">To execute the configuration scripts:<\/span>\r\n<span class=\"line\">\t 1. Open a terminal window<\/span>\r\n<span class=\"line\">\t 2. Log in as \"root\"<\/span>\r\n<span class=\"line\">\t 3. Run the scripts<\/span>\r\n<span class=\"line\">\t 4. Return to this window and hit \"Enter\" key to continue<\/span>\r\n\r\n<span class=\"line\">Successfully Setup Software.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u6839\u636e\u63d0\u793a\u7684\u65e5\u5fd7\u8def\u5f84\uff0c\u5b89\u88c5\u671f\u95f4\u53ef\u4ee5\u65b0\u5f00\u4e2a\u7ec8\u7aef\u5e76\u4f7f\u7528\u00a0<code>tail<\/code>\u00a0\u547d\u4ee4\u67e5\u770b oracle \u7684\u5b89\u88c5\u65e5\u5fd7<\/p>\n<figure id=\"code-1634082096540561\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> tail -f \/u01\/app\/oracle\/inventory\/logs\/installActions2020-03-18_10-01-22AM.log<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u6839\u636e\u00a0<code>.\/runInstaller<\/code>\u00a0\u8f93\u51fa\u63d0\u793a<\/p>\n<p>\u65b0\u5f00\u4e00\u4e2a\u7ec8\u7aef\u5e76\u4ee5\u00a0<code>root<\/code>\u00a0\u8d26\u53f7\u6267\u884c\u811a\u672c<\/p>\n<ul>\n<li>\u6267\u884c<code>orainstRoot.sh<\/code><br \/>\n<figure id=\"code-1634082096540855\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> \/u01\/app\/oracle\/inventory\/orainstRoot.sh<\/span><\/span>\r\n<span class=\"line\">Changing permissions of \/u01\/app\/oracle\/inventory.<\/span>\r\n<span class=\"line\">Adding read,write permissions for group.<\/span>\r\n<span class=\"line\">Removing read,write,execute permissions for world.<\/span>\r\n\r\n<span class=\"line\">Changing groupname of \/u01\/app\/oracle\/inventory to oinstall.<\/span>\r\n<span class=\"line\">The execution of the script is complete.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u6267\u884c\u00a0<code>root.sh<\/code><br \/>\n<figure id=\"code-1634082096540865\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> \/u01\/app\/oracle\/product\/11.2.0\/root.sh<\/span><\/span>\r\n<span class=\"line\">Check \/u01\/app\/oracle\/product\/11.2.0\/install\/root_centos-oracle_2020-03-18_10-09-45.log for the output of root script<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<\/ul>\n<p>\u6839\u636e\u63d0\u793a\u518d\u6b21\u68c0\u67e5\u65e5\u5fd7<\/p>\n<figure id=\"code-1634082096540454\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> tail -f \/u01\/app\/oracle\/product\/11.2.0\/install\/root_centos-oracle_2020-03-17_17-18-23.log<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h2 id=\"\u914d\u7f6e\u9759\u9ed8\u76d1\u542c\">\u914d\u7f6e\u9759\u9ed8\u76d1\u542c<\/h2>\n<p>\u5207\u6362\u5230 oracle \u7528\u6237<\/p>\n<figure id=\"code-1634082096540424\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> su - oracle<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u914d\u7f6e\u76d1\u542c<\/p>\n<figure id=\"code-1634082096541823\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> netca \/silent \/responsefile \/u01\/etc\/netca.rsp<\/span><\/span>\r\n\r\n<span class=\"line\">Parsing command line arguments:<\/span>\r\n<span class=\"line\">    Parameter \"silent\" = true<\/span>\r\n<span class=\"line\">    Parameter \"responsefile\" = \/u01\/etc\/netca.rsp<\/span>\r\n<span class=\"line\">Done parsing command line arguments.<\/span>\r\n<span class=\"line\">Oracle Net Services Configuration:<\/span>\r\n<span class=\"line\">Profile configuration complete.<\/span>\r\n<span class=\"line\">Oracle Net Listener Startup:<\/span>\r\n<span class=\"line\">    Running Listener Control:<\/span>\r\n<span class=\"line\">      \/u01\/app\/oracle\/product\/11.2.0\/bin\/lsnrctl start LISTENER<\/span>\r\n<span class=\"line\">    Listener Control complete.<\/span>\r\n<span class=\"line\">    Listener started successfully.<\/span>\r\n<span class=\"line\">Listener configuration complete.<\/span>\r\n<span class=\"line\">Oracle Net Services configuration successful. The exit code is 0<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u67e5\u770b\u76d1\u542c\u7aef\u53e3<\/p>\n<figure id=\"code-1634082096541189\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> netstat -tnulp | grep 1521<\/span><\/span>\r\n<span class=\"line\">(Not all processes could be identified, non-owned process info<\/span>\r\n<span class=\"line\"> will not be shown, you would have to be root to see it all.)<\/span>\r\n<span class=\"line\">tcp6       0      0 :::1521                 :::*                    LISTEN      13686\/tnslsnr<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u76d1\u542c\u542f\u52a8\u4e0e\u5173\u95ed\u547d\u4ee4<\/p>\n<ul>\n<li>\u542f\u52a8\uff1a<code>lsnrctl start<\/code><\/li>\n<li>\u72b6\u6001\uff1a<code>lsnrctl status<\/code><\/li>\n<li>\u5173\u95ed\uff1a<code>lsnrctl stop<\/code><\/li>\n<\/ul>\n<h2 id=\"\u9759\u9ed8\u521b\u5efa\u6570\u636e\u5e93\">\u9759\u9ed8\u521b\u5efa\u6570\u636e\u5e93<\/h2>\n<figure id=\"code-1634082096541251\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> vim \/u01\/etc\/dbca.rsp<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u4fee\u6539\u5185\u5bb9\u5982\u4e0b<\/p>\n<figure id=\"code-1634082096541963\" class=\"highlight properties hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>\/u01\/etc\/dbca.rsp<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-attr\">GDBNAME<\/span> = <span class=\"hljs-string\">\"orcl\"<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">SID<\/span> = <span class=\"hljs-string\">\"orcl\"<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">SYSPASSWORD<\/span> = <span class=\"hljs-string\">\"oracle\"<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">SYSTEMPASSWORD<\/span> = <span class=\"hljs-string\">\"oracle\"<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">SYSMANPASSWORD<\/span> = <span class=\"hljs-string\">\"oracle\"<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">DBSNMPPASSWORD<\/span> = <span class=\"hljs-string\">\"oracle\"<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">DATAFILEDESTINATION<\/span> = <span class=\"hljs-string\">\/u01\/app\/oracle\/oradata<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">RECOVERYAREADESTINATION<\/span>=<span class=\"hljs-string\">\/u01\/app\/oracle\/fast_recovery_area<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">CHARACTERSET<\/span> = <span class=\"hljs-string\">\"AL32UTF8\"<\/span><\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-attr\">TOTALMEMORY<\/span> = <span class=\"hljs-string\">\"6553\"<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5176\u4e2d\u00a0<code>TOTALMEMORY<\/code>\u00a0\u8bbe\u7f6e\u4e3a\u603b\u5185\u5b58\u7684 80%\uff0c\u53738G\u5185\u5b58\u768480%<\/p>\n<p><span id=\"MathJax-Element-4-Frame\" class=\"mjx-chtml MathJax_CHTML\" style=\"box-sizing: inherit; font-style: normal; font-weight: normal; display: inline-block; line-height: 0; text-indent: 0px; text-align: left; text-transform: none; font-size: 15.4px; letter-spacing: normal; overflow-wrap: normal; word-spacing: normal; white-space: nowrap; float: none; direction: ltr; max-width: none; max-height: none; min-width: 0px; min-height: 0px; border: 0px; margin: 0px; padding: 1px 0px; position: relative;\" tabindex=\"0\" role=\"presentation\" data-mathml=\"&lt;math xmlns=&quot;http:\/\/www.w3.org\/1998\/Math\/MathML&quot;&gt;&lt;mn&gt;8&lt;\/mn&gt;&lt;mi&gt;G&lt;\/mi&gt;&lt;mo&gt;&amp;#x00D7;&lt;\/mo&gt;&lt;mn&gt;1024&lt;\/mn&gt;&lt;mo&gt;&amp;#x00D7;&lt;\/mo&gt;&lt;mn&gt;0.8&lt;\/mn&gt;&lt;mo&gt;&amp;#x2248;&lt;\/mo&gt;&lt;mn&gt;6553&lt;\/mn&gt;&lt;mi&gt;M&lt;\/mi&gt;&lt;mi&gt;B&lt;\/mi&gt;&lt;\/math&gt;\"><span id=\"MJXc-Node-40\" class=\"mjx-math\" aria-hidden=\"true\"><span id=\"MJXc-Node-41\" class=\"mjx-mrow\"><span id=\"MJXc-Node-42\" class=\"mjx-mn\"><span class=\"mjx-char MJXc-TeX-main-R\">8<\/span><\/span><span id=\"MJXc-Node-43\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">G<\/span><\/span><span id=\"MJXc-Node-44\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00d7<\/span><\/span><span id=\"MJXc-Node-45\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">1024<\/span><\/span><span id=\"MJXc-Node-46\" class=\"mjx-mo MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">\u00d7<\/span><\/span><span id=\"MJXc-Node-47\" class=\"mjx-mn MJXc-space2\"><span class=\"mjx-char MJXc-TeX-main-R\">0.8<\/span><\/span><span id=\"MJXc-Node-48\" class=\"mjx-mo MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">\u2248<\/span><\/span><span id=\"MJXc-Node-49\" class=\"mjx-mn MJXc-space3\"><span class=\"mjx-char MJXc-TeX-main-R\">6553<\/span><\/span><span id=\"MJXc-Node-50\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">M<\/span><\/span><span id=\"MJXc-Node-51\" class=\"mjx-mi\"><span class=\"mjx-char MJXc-TeX-math-I\">B<\/span><\/span><\/span><\/span><span class=\"MJX_Assistive_MathML\" role=\"presentation\">8G\u00d71024\u00d70.8\u22486553MB<\/span><\/span><\/p>\n<p>\u4fdd\u5b58\u9000\u51fa\u540e\uff0c\u6267\u884c\u9759\u9ed8\u521b\u5efa\u6570\u636e\u5e93<\/p>\n<figure id=\"code-1634082096541170\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span>\r\n<span class=\"line\">20<\/span>\r\n<span class=\"line\">21<\/span>\r\n<span class=\"line\">22<\/span>\r\n<span class=\"line\">23<\/span>\r\n<span class=\"line\">24<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> dbca -silent -responseFile \/u01\/etc\/dbca.rsp<\/span><\/span>\r\n<span class=\"line\">Copying database files<\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">1%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">3%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">11%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">18%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">26%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">37%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\">Creating and starting Oracle instance<\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">40%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">45%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">50%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">55%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">56%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">60%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">62%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\">Completing Database Creation<\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">66%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">70%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">73%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">85%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">96%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">100%<\/span><span class=\"hljs-bash\"> complete<\/span><\/span>\r\n<span class=\"line\">Look at the log file \"\/u01\/app\/oracle\/cfgtoollogs\/dbca\/orcl\/orcl.log\" for further details.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u67e5\u770b oracle \u5b9e\u4f8b\u8fdb\u7a0b<\/p>\n<figure id=\"code-1634082096541109\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span>\r\n<span class=\"line\">20<\/span>\r\n<span class=\"line\">21<\/span>\r\n<span class=\"line\">22<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> ps -ef | grep ora_ | grep -v grep<\/span><\/span>\r\n<span class=\"line\">oracle   14038     1  0 10:25 ?        00:00:00 ora_pmon_orcl<\/span>\r\n<span class=\"line\">oracle   14040     1  0 10:25 ?        00:00:00 ora_vktm_orcl<\/span>\r\n<span class=\"line\">oracle   14044     1  0 10:25 ?        00:00:00 ora_gen0_orcl<\/span>\r\n<span class=\"line\">oracle   14046     1  0 10:25 ?        00:00:00 ora_diag_orcl<\/span>\r\n<span class=\"line\">oracle   14048     1  0 10:25 ?        00:00:00 ora_dbrm_orcl<\/span>\r\n<span class=\"line\">oracle   14050     1  0 10:25 ?        00:00:00 ora_psp0_orcl<\/span>\r\n<span class=\"line\">oracle   14052     1  0 10:25 ?        00:00:00 ora_dia0_orcl<\/span>\r\n<span class=\"line\">oracle   14054     1  0 10:25 ?        00:00:00 ora_mman_orcl<\/span>\r\n<span class=\"line\">oracle   14056     1  0 10:25 ?        00:00:00 ora_dbw0_orcl<\/span>\r\n<span class=\"line\">oracle   14058     1  0 10:25 ?        00:00:00 ora_lgwr_orcl<\/span>\r\n<span class=\"line\">oracle   14060     1  0 10:25 ?        00:00:00 ora_ckpt_orcl<\/span>\r\n<span class=\"line\">oracle   14062     1  0 10:25 ?        00:00:00 ora_smon_orcl<\/span>\r\n<span class=\"line\">oracle   14064     1  0 10:25 ?        00:00:00 ora_reco_orcl<\/span>\r\n<span class=\"line\">oracle   14066     1  0 10:25 ?        00:00:00 ora_mmon_orcl<\/span>\r\n<span class=\"line\">oracle   14068     1  0 10:25 ?        00:00:00 ora_mmnl_orcl<\/span>\r\n<span class=\"line\">oracle   14070     1  0 10:25 ?        00:00:00 ora_d000_orcl<\/span>\r\n<span class=\"line\">oracle   14072     1  0 10:25 ?        00:00:00 ora_s000_orcl<\/span>\r\n<span class=\"line\">oracle   14082     1  0 10:25 ?        00:00:00 ora_qmnc_orcl<\/span>\r\n<span class=\"line\">oracle   14097     1  0 10:25 ?        00:00:00 ora_cjq0_orcl<\/span>\r\n<span class=\"line\">oracle   14099     1  0 10:25 ?        00:00:00 ora_q000_orcl<\/span>\r\n<span class=\"line\">oracle   14101     1  0 10:25 ?        00:00:00 ora_q001_orcl<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u67e5\u770b\u76d1\u542c\u72b6\u6001<\/p>\n<figure id=\"code-1634082096541947\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span>\r\n<span class=\"line\">17<\/span>\r\n<span class=\"line\">18<\/span>\r\n<span class=\"line\">19<\/span>\r\n<span class=\"line\">20<\/span>\r\n<span class=\"line\">21<\/span>\r\n<span class=\"line\">22<\/span>\r\n<span class=\"line\">23<\/span>\r\n<span class=\"line\">24<\/span>\r\n<span class=\"line\">25<\/span>\r\n<span class=\"line\">26<\/span>\r\n<span class=\"line\">27<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> lsnrctl status<\/span><\/span>\r\n\r\n<span class=\"line\">LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 18-MAR-2020 10:27:07<\/span>\r\n\r\n<span class=\"line\">Copyright (c) 1991, 2009, Oracle.  All rights reserved.<\/span>\r\n\r\n<span class=\"line\">Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))<\/span>\r\n<span class=\"line\">STATUS of the LISTENER<\/span>\r\n<span class=\"line\">------------------------<\/span>\r\n<span class=\"line\">Alias                     LISTENER<\/span>\r\n<span class=\"line\">Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production<\/span>\r\n<span class=\"line\">Start Date                18-MAR-2020 10:10:42<\/span>\r\n<span class=\"line\">Uptime                    0 days 0 hr. 16 min. 26 sec<\/span>\r\n<span class=\"line\">Trace Level               off<\/span>\r\n<span class=\"line\">Security                  ON: Local OS Authentication<\/span>\r\n<span class=\"line\">SNMP                      OFF<\/span>\r\n<span class=\"line\">Listener Parameter File   \/u01\/app\/oracle\/product\/11.2.0\/network\/admin\/listener.ora<\/span>\r\n<span class=\"line\">Listener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/centos-oracle\/listener\/alert\/log.xml<\/span>\r\n<span class=\"line\">Listening Endpoints Summary...<\/span>\r\n<span class=\"line\">  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))<\/span>\r\n<span class=\"line\">  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=centos-oracle)(PORT=1521)))<\/span>\r\n<span class=\"line\">Services Summary...<\/span>\r\n<span class=\"line\">Service \"orcl\" has 1 instance(s).<\/span>\r\n<span class=\"line\">  Instance \"orcl\", status READY, has 1 handler(s) for this service...<\/span>\r\n<span class=\"line\">Service \"orclXDB\" has 1 instance(s).<\/span>\r\n<span class=\"line\">  Instance \"orcl\", status READY, has 1 handler(s) for this service...<\/span>\r\n<span class=\"line\">The command completed successfully<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u767b\u5f55\u00a0<code>sqlplus<\/code>\uff0c\u67e5\u770b\u5b9e\u4f8b\u72b6\u6001<\/p>\n<p><strong>\u6ce8\u610f<\/strong>\uff1a\u5982\u679c\u6570\u636e\u5e93\u00a0<code>service_name<\/code>\u00a0\u6216\u8005\u00a0<code>SID<\/code>\u00a0\u540d\u4e0d\u4e3a\u9ed8\u8ba4\u7684\u00a0<code>ORCL<\/code>\uff0c\u60f3\u8981\u901a\u8fc7 sqlplus \u65e0\u5bc6\u7801\u767b\u9646\u9700\u8981\u5728\u547d\u4ee4\u884c\u4e2d\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf\u00a0<code>export ORACLE_SID=ORCL1<\/code>\uff0c\u628a\u5176\u4e2d\u00a0<code>ORCL1<\/code>\u66ff\u6362\u4e3a\u4f60\u7684SID\u3002<\/p>\n<p>\u5982\u679c\u67e5\u8be2\u62a5\u9519\uff0c\u53c2\u8003\uff1a<a href=\"https:\/\/little-star.love\/posts\/2b719439\/#ORA-01034\" data-pjax-state=\"\">ORA-01034<\/a><\/p>\n<figure id=\"code-1634082096542283\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> select status from v<span class=\"hljs-variable\">$instance<\/span>;<\/span><\/span>\r\n\r\n<span class=\"line\">STATUS<\/span>\r\n<span class=\"line\">------------------------<\/span>\r\n<span class=\"line\">OPEN<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u67e5\u770b\u6570\u636e\u5e93\u7f16\u7801<\/p>\n<figure id=\"code-1634082096542781\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> select userenv(<span class=\"hljs-string\">'language'<\/span>) from dual;<\/span><\/span>\r\n\r\n<span class=\"line\">USERENV('LANGUAGE')<\/span>\r\n<span class=\"line\">--------------------------------------------------------------------------------<\/span>\r\n<span class=\"line\">AMERICAN_AMERICA.AL32UTF8<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u4fe1\u606f<\/p>\n<figure id=\"code-1634082096542463\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> select * from v<span class=\"hljs-variable\">$version<\/span>;<\/span><\/span>\r\n\r\n<span class=\"line\">BANNER<\/span>\r\n<span class=\"line\">--------------------------------------------------------------------------------<\/span>\r\n<span class=\"line\">Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production<\/span>\r\n<span class=\"line\">PL\/SQL Release 11.2.0.1.0 - Production<\/span>\r\n<span class=\"line\">CORE\t11.2.0.1.0\tProduction<\/span>\r\n<span class=\"line\">TNS for Linux: Version 11.2.0.1.0 - Production<\/span>\r\n<span class=\"line\">NLSRTL Version 11.2.0.1.0 - Production<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u6fc0\u6d3b scott \u7528\u6237<\/p>\n<figure id=\"code-1634082096542777\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> alter user scott account unlock;<\/span><\/span>\r\n\r\n<span class=\"line\">User altered.<\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> alter user scott identified by tiger;<\/span><\/span>\r\n\r\n<span class=\"line\">User altered.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h2 id=\"\u8fdc\u7a0b\u8fde\u63a5-Oracle\">\u8fdc\u7a0b\u8fde\u63a5 Oracle<\/h2>\n<p>\u4ee5 Navicat \u4e3a\u4f8b\uff0c\u63a8\u8350\u4f7f\u7528PL\/SQL<\/p>\n<p>\u4f7f\u7528\u521a\u6fc0\u6d3b\u7684\u8d26\u53f7\uff1ascott \u5bc6\u7801\uff1atiger<\/p>\n<p>\u4ee5 OS X \u4e0a Navicat \u8fde\u63a5\u4e3a\u4f8b\u3002Windows \u4e0b Navicat \u8fde\u63a5 Oracle \u9700\u8981\u624b\u52a8\u914d\u7f6e\u00a0<code>oci.dll<\/code><\/p>\n<p><a class=\"gallery-item\" href=\"https:\/\/cdn.jsdelivr.net\/gh\/Erw1nK\/PicGo-imgs@master\/blog\/20200318144810.png\"><div class='fancybox-wrapper lazyload-container-unload' data-fancybox='post-images' href='https:\/\/cdn.jsdelivr.net\/gh\/Erw1nK\/PicGo-imgs@master\/blog\/20200318144810.png'><img class=\"lazyload lazyload-style-1\" src=\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\"  decoding=\"async\" data-original=\"https:\/\/cdn.jsdelivr.net\/gh\/Erw1nK\/PicGo-imgs@master\/blog\/20200318144810.png\" src=\"data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAEAAAABCAYAAAAfFcSJAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsQAAA7EAZUrDhsAAAANSURBVBhXYzh8+PB\/AAffA0nNPuCLAAAAAElFTkSuQmCC\" alt=\"\" \/><\/div><\/a><\/p>\n<h3 id=\"\u8fdc\u7a0b\u4f7f\u7528-sysdba-\u8d26\u53f7\">\u8fdc\u7a0b\u4f7f\u7528 sysdba \u8d26\u53f7<\/h3>\n<p>\u5982\u9700\u8fdc\u7a0b\u4f7f\u7528\u00a0<code>sysdba<\/code>\u00a0\u6743\u9650\u7ec4\u8d26\u53f7\u767b\u5f55\u3002\u9700\u8fdb\u884c\u5982\u4e0b\u64cd\u4f5c\uff1a<\/p>\n<ol>\n<li>\u67e5\u770b\u5f53\u524d\u73af\u5883\u53d8\u91cf\u4e2d\u00a0<code>ORACLE_SID<\/code><br \/>\n<figure id=\"code-1634082096542257\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">echo<\/span> <span class=\"hljs-variable\">$ORACLE_SID<\/span><\/span><\/span>\r\n<span class=\"line\">ORCL<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u66ff\u6362 SID \u4e3a\u5f53\u524d\u9700\u8981\u4fee\u6539\u6570\u636e\u5e93<br \/>\n<figure id=\"code-1634082096542174\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">export<\/span> ORACLE_SID=akiya<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u8fde\u63a5\u6570\u636e\u5e93<br \/>\n<figure id=\"code-163408209654321\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\uff0c\u786e\u8ba4\u662f\u5426\u6b63\u786e<br \/>\n<figure id=\"code-1634082096543857\" class=\"highlight sql hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">SQL&gt; select name from v$database;<\/span>\r\n\r\n<span class=\"line\">NAME<\/span>\r\n<span class=\"line\"><span class=\"hljs-comment\">------------------<\/span><\/span>\r\n<span class=\"line\">AKIYA<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u68c0\u67e5\u8fdc\u7a0b\u767b\u5f55\u8bbe\u7f6e<br \/>\n<figure id=\"code-1634082096543275\" class=\"highlight sql hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">SQL&gt; show parameter pass;<\/span>\r\n\r\n<span class=\"line\">NAME                                 TYPE<\/span>\r\n<span class=\"line\"><span class=\"hljs-comment\">------------------------------------ ----------------------<\/span><\/span>\r\n<span class=\"line\">VALUE<\/span>\r\n<span class=\"line\"><span class=\"hljs-comment\">------------------------------<\/span><\/span>\r\n<span class=\"line\">remote_login_passwordfile            string<\/span>\r\n<span class=\"line\">NONE<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u4fee\u6539\u914d\u7f6e\uff0c\u4f7f sysdba \u7528\u6237\uff08\u53ca\u62e5\u6709\u5176\u89d2\u8272\u7684\u666e\u901a\u7528\u6237\uff09\u53ef\u4ee5\u8fdc\u7a0b\u767b\u5f55\u3002<br \/>\n<figure id=\"code-1634082096543217\" class=\"highlight sql hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">SQL&gt; alter system set remote_login_passwordfile=exclusive scope=spfile;<\/span>\r\n\r\n<span class=\"line\">System altered.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u91cd\u542f\u6570\u636e\u5e93<br \/>\n<figure id=\"code-1634082096543942\" class=\"highlight sql hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">SQL&gt; startup force;<\/span>\r\n<span class=\"line\">ORACLE instance started.<\/span>\r\n\r\n<span class=\"line\">Total System Global Area 1603411968 bytes<\/span>\r\n<span class=\"line\">Fixed Size                  2213776 bytes<\/span>\r\n<span class=\"line\">Variable Size             402655344 bytes<\/span>\r\n<span class=\"line\">Database Buffers         1191182336 bytes<\/span>\r\n<span class=\"line\">Redo Buffers                7360512 bytes<\/span>\r\n<span class=\"line\">Database mounted.<\/span>\r\n<span class=\"line\">Database opened.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u91cd\u7f6e\u7528\u6237\u5bc6\u7801<br \/>\n<figure id=\"code-1634082096544151\" class=\"highlight hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">SQL&gt; alter user &lt;username&gt; identified by &lt;new_password&gt;;<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u73b0\u5728\u53ef\u4ee5\u4f7f\u7528\u00a0<code>sysdba<\/code>\u00a0\u6743\u9650\u8d26\u53f7\u4f8b\u5982\u00a0<code>system<\/code>\u00a0\u8d26\u53f7\uff0c\u5bc6\u7801\u00a0<code>&lt;new_password&gt;<\/code>\u00a0\u8fdc\u7a0b\u767b\u5f55\u4e86<\/li>\n<\/ol>\n<h2 id=\"\u9519\u8bef\u5904\u7406\">\u9519\u8bef\u5904\u7406<\/h2>\n<h3 id=\"ORA-01034\">ORA-01034<\/h3>\n<p>\u95ee\u9898\u63cf\u8ff0\uff1a<\/p>\n<p>\u4f7f\u7528\u00a0<code>sqlplus<\/code>\u00a0\u767b\u9646\u540e\u6267\u884c SQL \u62a5\u9519\u3002<\/p>\n<figure id=\"code-163408209654441\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> select status from v<span class=\"hljs-variable\">$instance<\/span>;<\/span><\/span>\r\n<span class=\"line\">select status from v$instance<\/span>\r\n<span class=\"line\">*<\/span>\r\n<span class=\"line\">ERROR at line 1:<\/span>\r\n<span class=\"line\">ORA-01034: ORACLE not available<\/span>\r\n<span class=\"line\">Process ID: 0<\/span>\r\n<span class=\"line\">Session ID: 0 Serial number: 0<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n<p>\u5173\u95ed\u6570\u636e\u5e93\u5b9e\u4f8b\u5e76\u91cd\u542f<\/p>\n<figure id=\"code-1634082096545463\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> shutdown immedate<\/span><\/span>\r\n<span class=\"line\">SP2-0717: illegal SHUTDOWN option<\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> startup<\/span><\/span>\r\n<span class=\"line\">ORACLE instance started.<\/span>\r\n\r\n<span class=\"line\">Total System Global Area 1603411968 bytes<\/span>\r\n<span class=\"line\">Fixed Size\t\t    2213776 bytes<\/span>\r\n<span class=\"line\">Variable Size\t\t  402655344 bytes<\/span>\r\n<span class=\"line\">Database Buffers\t 1191182336 bytes<\/span>\r\n<span class=\"line\">Redo Buffers\t\t    7360512 bytes<\/span>\r\n<span class=\"line\">Database mounted.<\/span>\r\n<span class=\"line\">Database opened.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5982\u679c\u62a5\u9519\u53c2\u8003\uff1a<a href=\"https:\/\/little-star.love\/posts\/2b719439\/#ORA-01078\" data-pjax-state=\"\">ORA-01078<\/a><\/p>\n<h3 id=\"ORA-01078\">ORA-01078<\/h3>\n<p>\u95ee\u9898\u63cf\u8ff0\uff1a<\/p>\n<p>\u542f\u52a8\u6570\u636e\u5e93\u5b9e\u4f8b\u62a5\u9519\u3002<\/p>\n<figure id=\"code-1634082096545122\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> startup;<\/span><\/span>\r\n<span class=\"line\">ORA-01078: failure in processing system parameters<\/span>\r\n<span class=\"line\">LRM-00109: could not open parameter file '\/u01\/app\/oracle\/product\/11.2.0\/dbs\/initORCL.ora'<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u9519\u8bef\u539f\u56e0\uff1a<\/p>\n<p>\u5728\u00a0<code>oracle9i<\/code>\u3001<code>10g<\/code>\u3001<code>11g<\/code>\u00a0\u7b49\u51e0\u4e2a\u7248\u672c\u4e2d\uff0c\u6570\u636e\u5e93\u9ed8\u8ba4\u4f7f\u7528\u00a0<code>spfile<\/code>\u00a0\u542f\u52a8\u6570\u636e\u5e93\uff0c\u5982\u679c\u00a0<code>spfile<\/code>\u00a0\u4e0d\u5b58\u5728\uff0c\u5219\u5c31\u4f1a\u51fa\u73b0\u4e0a\u8ff0\u9519\u8bef\u3002<\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n<p>\u7528\u00a0<code>find \/u01\/ -name pfile<\/code>\u00a0\u547d\u4ee4\u67e5\u627e pfile \u6587\u4ef6\u7684\u4f4d\u7f6e<\/p>\n<figure id=\"code-1634082096545146\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> find \/u01\/ -name pfile<\/span><\/span>\r\n<span class=\"line\">\/u01\/app\/oracle\/admin\/orcl\/pfile<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u8fdb\u5165\u67e5\u627e\u5230\u7684\u6587\u4ef6\u5939<\/p>\n<figure id=\"code-163408209654526\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">cd<\/span> \/u01\/app\/oracle\/admin\/orcl\/pfile<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> ll<\/span><\/span>\r\n<span class=\"line\">total 4<\/span>\r\n<span class=\"line\">-rw-r-----. 1 oracle oinstall 2041 Mar 18 10:21 init.ora.2182020102439<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5c06\u00a0<code>$ORACLE_BASE\/admin\/orcl11g\/pfile<\/code>\u00a0\u76ee\u5f55\u4e0b\u7684\u00a0<code>init.ora.2182020102439<\/code>\u00a0\u62f7\u8d1d\u5230\u00a0<code>$ORACLE_HOME\/dbs<\/code>\u00a0\u76ee\u5f55\u4e0b\uff0c\u5e76\u547d\u540d\u4e3a\u00a0<code>initORCL.ora<\/code>\u00a0\u5373\u53ef\u3002<\/p>\n<p><strong>\u6ce8\u610f<\/strong>\uff1a<code>initORCL.ora<\/code>\u00a0\u4e2d\u7684\u00a0<code>initORCL<\/code>\u00a0\u4e3a\u4f60\u521b\u5efa\u7684\u5b9e\u4f8b\u540d\u00a0<code>ORACLE_SID<\/code>\uff0c\u540c\u00a0<a href=\"https:\/\/little-star.love\/posts\/2b719439\/#%E9%9D%99%E9%BB%98%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AE%E5%BA%93\" data-pjax-state=\"\">\u9759\u9ed8\u521b\u5efa\u6570\u636e\u5e93<\/a>\u00a0\u4e2d\u914d\u7f6e\u4e00\u81f4<\/p>\n<figure id=\"code-1634082096545244\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> cp \/u01\/app\/oracle\/admin\/orcl\/pfile\/init.ora.2182020102439 <span class=\"hljs-variable\">$ORACLE_HOME<\/span>\/dbs\/initORCL.ora<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u518d\u6b21\u767b\u9646 sqlplus<\/p>\n<figure id=\"code-1634082096545109\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span>\r\n<span class=\"line\">12<\/span>\r\n<span class=\"line\">13<\/span>\r\n<span class=\"line\">14<\/span>\r\n<span class=\"line\">15<\/span>\r\n<span class=\"line\">16<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> startup;<\/span><\/span>\r\n<span class=\"line\">ORACLE instance started.<\/span>\r\n\r\n<span class=\"line\">Total System Global Area 1603411968 bytes<\/span>\r\n<span class=\"line\">Fixed Size\t\t    2213776 bytes<\/span>\r\n<span class=\"line\">Variable Size\t\t  402655344 bytes<\/span>\r\n<span class=\"line\">Database Buffers\t 1191182336 bytes<\/span>\r\n<span class=\"line\">Redo Buffers\t\t    7360512 bytes<\/span>\r\n<span class=\"line\">ORA-01102: cannot mount database in EXCLUSIVE mode<\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> select status from v<span class=\"hljs-variable\">$instance<\/span>;<\/span><\/span>\r\n\r\n<span class=\"line\">STATUS<\/span>\r\n<span class=\"line\">------------------------<\/span>\r\n<span class=\"line\">STARTED<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h3 id=\"ORA-01102\">ORA-01102<\/h3>\n<p>\u95ee\u9898\u63cf\u8ff0\uff1a<\/p>\n<p>\u7531\u4e8e\u6587\u4ef6\u88ab\u5360\u7528\uff0c\u65e0\u6cd5\u9501\u5b9a\u5bfc\u81f4\u6570\u636e\u5e93\u65e0\u6cd5\u6302\u8f7d\u3002<\/p>\n<figure id=\"code-16340820965467\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> startup;<\/span><\/span>\r\n<span class=\"line\">ORACLE instance started.<\/span>\r\n\r\n<span class=\"line\">Total System Global Area 1603411968 bytes<\/span>\r\n<span class=\"line\">Fixed Size\t\t    2213776 bytes<\/span>\r\n<span class=\"line\">Variable Size\t\t  402655344 bytes<\/span>\r\n<span class=\"line\">Database Buffers\t 1191182336 bytes<\/span>\r\n<span class=\"line\">Redo Buffers\t\t    7360512 bytes<\/span>\r\n<span class=\"line\">ORA-01102: cannot mount database in EXCLUSIVE mode<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n<p>\u8fdb\u5165\u6570\u636e\u5e93\u5173\u95ed\u5b9e\u4f8b<\/p>\n<figure id=\"code-16340820965467\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> shutdown immediate<\/span><\/span>\r\n<span class=\"line\">ORA-01507: database not mounted<\/span>\r\n\r\n\r\n<span class=\"line\">ORACLE instance shut down.<\/span>\r\n\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">exit<\/span><\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u8fdb\u5165\u00a0<code>$ORACLE_HOME\/dbs<\/code>\uff0c\u627e\u5230\u540d\u4e3a\u00a0<code>lk*<\/code>\u00a0\u7684\u6587\u4ef6\uff0c\u6b63\u5e38\u60c5\u51b5\u4e0b\u662f\u6ca1\u6709\u8fd9\u4e2a\u6587\u4ef6\u7684<\/p>\n<figure id=\"code-1634082096546760\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> <span class=\"hljs-built_in\">cd<\/span> <span class=\"hljs-variable\">$ORACLE_HOME<\/span>\/dbs<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> ls<\/span><\/span>\r\n<span class=\"line\">hc_DBUA0.dat  hc_orcl.dat  hc_ORCL.dat  init.ora  initORCL.ora  lkORCL  orapworcl  spfileorcl.ora<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5207\u6362\u5230 root \u7528\u6237<\/p>\n<figure id=\"code-1634082096546664\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> fuser -u \/u01\/app\/oracle\/product\/11.2.0\/dbs\/lkORCL<\/span><\/span>\r\n<span class=\"line\">-bash: fuser: command not found<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5982\u679c\u51fa\u73b0\u00a0<code>fuser: command not found<\/code>\uff0c\u5219\u6267\u884c\u547d\u4ee4\u5b89\u88c5\u00a0<code>yum -y install psmisc<\/code><\/p>\n<figure id=\"code-1634082096546360\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> fuser -u \/u01\/app\/oracle\/product\/11.2.0\/dbs\/lkORCL<\/span><\/span>\r\n<span class=\"line\">\/u01\/app\/oracle\/product\/11.2.0\/dbs\/lkORCL: 14038(oracle) 14044(oracle) 14048(oracle) 14050(oracle) 14054(oracle) 14056(oracle) 14058(oracle) 14060(oracle) 14062(oracle) 14064(oracle) 14066(oracle) 14068(oracle) 14082(oracle) 14097(oracle) 14099(oracle) 14101(oracle) 14141(oracle) 14143(oracle)<\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> fuser -k \/u01\/app\/oracle\/product\/11.2.0\/dbs\/lkORCL<\/span><\/span>\r\n<span class=\"line\">\/u01\/app\/oracle\/product\/11.2.0\/dbs\/lkORCL: 14038 14044 14048 14050 14054 14056 14058 14060 14062 14064 14066 14068 14082 14097 14099 14101 14141 14143<\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> fuser -u \/u01\/app\/oracle\/product\/11.2.0\/dbs\/lkORCL<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u91cd\u65b0\u542f\u52a8\u6570\u636e\u5e93\u770b\u770b\uff0c\u8fd9\u4e2a\u65f6\u5019\u6570\u636e\u5e93\u6ca1\u6709\u62a5\u9519\u4e86\uff0c\u80fd\u6b63\u5e38\u8d77\u6765\u3002<\/p>\n<figure id=\"code-1634082096547185\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span>\r\n<span class=\"line\">3<\/span>\r\n<span class=\"line\">4<\/span>\r\n<span class=\"line\">5<\/span>\r\n<span class=\"line\">6<\/span>\r\n<span class=\"line\">7<\/span>\r\n<span class=\"line\">8<\/span>\r\n<span class=\"line\">9<\/span>\r\n<span class=\"line\">10<\/span>\r\n<span class=\"line\">11<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> startup<\/span><\/span>\r\n<span class=\"line\">ORACLE instance started.<\/span>\r\n\r\n<span class=\"line\">Total System Global Area 1603411968 bytes<\/span>\r\n<span class=\"line\">Fixed Size\t\t    2213776 bytes<\/span>\r\n<span class=\"line\">Variable Size\t\t  402655344 bytes<\/span>\r\n<span class=\"line\">Database Buffers\t 1191182336 bytes<\/span>\r\n<span class=\"line\">Redo Buffers\t\t    7360512 bytes<\/span>\r\n<span class=\"line\">Database mounted.<\/span>\r\n<span class=\"line\">Database opened.<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<h3 id=\"ORA-12514\">ORA-12514<\/h3>\n<figure id=\"code-1634082096547940\" class=\"highlight plain hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\">ORA-12514: TNS:listener does not currently know of service requested in connect descriptor<\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u91cd\u542f\u6570\u636e\u5e93\u5373\u53ef<\/p>\n<ol>\n<li>\u5173\u95ed\u6570\u636e\u5e93<br \/>\n<figure id=\"code-1634082096572662\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> shutdown immediate<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u91cd\u542f\u76d1\u542c\u7a0b\u5e8f<br \/>\n\u91cd\u542f\u524d\u540e\u53ef\u4ee5\u5bf9\u6bd4\u4e0b pid \u662f\u5426\u4e00\u81f4<\/p>\n<figure id=\"code-1634082096572705\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> ps -ef | grep ora_ | grep -v grep<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u91cd\u542f<\/p>\n<figure id=\"code-1634082096573665\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> lsnrctl stop<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> lsnrctl start<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u67e5\u770b\u76d1\u542c\u72b6\u6001<\/p>\n<figure id=\"code-1634082096577387\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">#<\/span><span class=\"hljs-bash\"> lsnrctl status<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<\/li>\n<li>\u542f\u52a8\u6570\u636e\u5e93<br \/>\n<figure id=\"code-1634082096577343\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> startup<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n<p>\u5982\u679c\u8fd8\u662f\u8fde\u63a5\u62a5\u9519\uff0c\u8bf7\u67e5\u770b\u00a0<code>lsnrctl status<\/code>\u00a0\u4e2d\u65e5\u5fd7\u6587\u4ef6\u6392\u67e5\u9519\u8bef\u3002<\/li>\n<\/ol>\n<h3 id=\"ORA-28000\">ORA-28000<\/h3>\n<p>ORA-28000: the account is locked<\/p>\n<p>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n<p>\u5728\u670d\u52a1\u4e0a\u901a\u8fc7\u00a0<code>sqlplus \/ as sysdba<\/code>\u00a0\u767b\u9646 Oracle\uff0c\u7136\u540e\u662f\u89e3\u9501\u8be5\u8d26\u6237<\/p>\n<figure id=\"code-163408209657842\" class=\"highlight shell hljs\"><figcaption class=\"level is-mobile\">\n<div class=\"level-left\"><i class=\"fas fa-angle-down\"><\/i>shell<\/div>\n<div class=\"level-right\"><\/div>\n<\/figcaption><div class=\"highlight-body\">\n<table>\n<tbody>\n<tr>\n<td class=\"gutter\">\n<pre><span class=\"line\">1<\/span>\r\n<span class=\"line\">2<\/span><\/pre>\n<\/td>\n<td class=\"code\">\n<pre><span class=\"line\"><span class=\"hljs-meta\">$<\/span><span class=\"hljs-bash\"> sqlplus \/ as sysdba<\/span><\/span>\r\n<span class=\"line\"><span class=\"hljs-meta\">SQL&gt;<\/span><span class=\"hljs-bash\"> alter user &lt;username&gt; account unlock;<\/span><\/span><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u5728 Linux \u4e0a\u901a\u8fc7\u547d\u4ee4\u884c\u9759\u9ed8\u5b89\u88c5 Oracle 11g \u6570\u636e\u5e93 \u73af\u5883 \u547d\u4ee4\u884c\u524d\u7f00\u8bf4\u660e\uff1a #\u00a0\u8868\u793a\u4f7f\u7528 ro [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-1658","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts\/1658","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1658"}],"version-history":[{"count":1,"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts\/1658\/revisions"}],"predecessor-version":[{"id":1659,"href":"https:\/\/www.xh86.me\/index.php?rest_route=\/wp\/v2\/posts\/1658\/revisions\/1659"}],"wp:attachment":[{"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1658"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1658"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xh86.me\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1658"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}