{"id":1672,"date":"2018-01-15T13:27:41","date_gmt":"2018-01-15T05:27:41","guid":{"rendered":"http:\/\/www.821121.com\/?p=1672"},"modified":"2022-04-27T21:42:44","modified_gmt":"2022-04-27T13:42:44","slug":"%e9%9d%99%e9%bb%98%e5%ae%89%e8%a3%85oracle%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1672","title":{"rendered":"\u9759\u9ed8\u5b89\u88c5Oracle\u6570\u636e\u5e93"},"content":{"rendered":"<h3>1.\u4e0a\u4f20\u538b\u7f29\u5305\u5230\/soft\u4e0b\u5e76\u89e3\u538b<\/h3>\n<p>\u89e3\u538b\u540e\u76ee\u5f55\u4e3a\/soft\/database<\/p>\n<h3>2.\u7f16\u8f91\u9759\u9ed8\u5b89\u88c5\u6587\u4ef6<\/h3>\n<pre><code class=\"language-shell\">cd \/soft\/database\/response\/\n# \u5c06\u6587\u4ef6\u5907\u4efd\uff1b\ncp db_install.rsp db_install01.rsp    \n# \u7f16\u8f91\u4fee\u6539\uff1b\nvim db_install.rsp                   <\/code><\/pre>\n<p>\u6839\u636e\u63d0\u793a\u914d\u7f6e\u6587\u4ef6\u4e2d\u7684\u53c2\u6570<\/p>\n<h3>3.\u5f00\u59cb\u5b89\u88c5<\/h3>\n<pre><code class=\"language-shell\">#oracle\u7528\u6237\u4e0b\u6267\u884c,\u8bb0\u5f97\u8d4b\u6743\u9650\n.\/runInstaller -silent -responseFile \/soft\/database\/response\/db_install.rsp<\/code><\/pre>\n<h3>4.\u6267\u884c\u9759\u9ed8\u5b89\u88c5\u547d\u4ee4<\/h3>\n<pre><code class=\"language-shell\">su - root\n\/u01\/app\/oraInventory\/orainstRoot.sh\n$ORACLE_HOME\/root.sh<\/code><\/pre>\n<h3>5.\u914d\u7f6e\u76d1\u542c<\/h3>\n<pre><code class=\"language-shell\">netca \/silent \/responsefile \/soft\/database\/response\/netca.rsp<\/code><\/pre>\n<h3>6.\u542f\u52a8\u76d1\u542c<\/h3>\n<pre><code class=\"language-shell\">lsnrctl start<\/code><\/pre>\n<h3>7.\u7f16\u8f91\u9759\u9ed8\u5efa\u5e93\u914d\u7f6e\u6587\u4ef6<\/h3>\n<pre><code class=\"language-shell\">vim \/soft\/database\/response\/dbca.rsp<\/code><\/pre>\n<h3>8.\u6267\u884c\u9759\u9ed8\u5efa\u5e93\u547d\u4ee4<\/h3>\n<pre><code class=\"language-shell\"> dbca -silent -createDatabase  -responseFile  \/soft\/database\/response\/dbca.rsp <\/code><\/pre>\n<h3>9.\u5efa\u5e93\u5b8c\u6210\uff0c\u542f\u52a8\u6570\u636e\u5e93<\/h3>\n<pre><code class=\"language-shell\">sqlplus \/ as sysdba\nSQL&gt; start up\nSQL&gt; select open_mode from v$database;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1.\u4e0a\u4f20\u538b\u7f29\u5305\u5230\/soft\u4e0b\u5e76\u89e3\u538b \u89e3\u538b\u540e\u76ee\u5f55\u4e3a\/<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1672","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1672"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1672\/revisions"}],"predecessor-version":[{"id":1735,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1672\/revisions\/1735"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1672"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}