{"id":1288,"date":"2014-07-29T21:01:46","date_gmt":"2014-07-29T13:01:46","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1288"},"modified":"2014-07-29T21:01:46","modified_gmt":"2014-07-29T13:01:46","slug":"tnsname%e4%b8%adura%e9%85%8d%e7%bd%ae%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1288","title":{"rendered":"tnsname\u4e2dUR=A\u914d\u7f6e\u4f7f\u7528"},"content":{"rendered":"<p><strong>\u5f53\u6570\u636e\u5e93nomount,mount\u6216\u8005restricted\u65f6\uff0c\u52a8\u6001\u76d1\u542c\u663e\u793a\u72b6\u6001\u4e3aBLOCKED\u65f6\uff0c\u5ba2\u6237\u7aef\u53ef\u901a\u8fc7\u914d\u7f6eUR=A\u8fdb\u884c\u8fde\u63a5\u3002<\/strong><br \/>\n\u5982\u4e0b\uff1a<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; startup nomount;\r\nORACLE instance started.\r\n\r\nTotal System Global Area  939495424 bytes\r\nFixed Size                  2233960 bytes\r\nVariable Size             562039192 bytes\r\nDatabase Buffers          369098752 bytes\r\nRedo Buffers                6123520 bytes\r\nSQL&gt; ALTER SYSTEM REGISTER;\r\n\r\nSystem altered.\r\n\r\n[oracle@rhl6 ~]$ lsnrctl status\r\n\r\nLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-JUL-2014 08:41:00\r\n\r\nCopyright (c) 1991, 2011, Oracle.  All rights reserved.\r\n\r\nConnecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias                     LISTENER\r\nVersion                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production\r\nStart Date                15-JUL-2014 08:40:23\r\nUptime                    0 days 0 hr. 0 min. 37 sec\r\nTrace Level               off\r\nSecurity                  ON: Local OS Authentication\r\nSNMP                      OFF\r\nListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/rhl6\/listener\/alert\/log.xml\r\nListening Endpoints Summary...\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rhl6.0x64)(PORT=1521)))\r\nServices Summary...\r\nService &quot;ora11gr2&quot; has 1 instance(s).\r\n  Instance &quot;ora11gr2&quot;, status BLOCKED, has 1 handler(s) for this service...\r\nThe command completed successfully\r\n<\/pre>\n<p>\u5ba2\u6237\u7aef\u914d\u7f6e<\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nbbed_ur =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.154)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = ora11gr2)\r\n\t  (UR=A)\r\n    )\r\n  )\r\n\r\n\r\nbbed =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.154)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = ora11gr2)\r\n    )\r\n  )\r\n\r\n\r\n<\/pre>\n<pre class=\"wp-code-highlight prettyprint\">\r\nC:\\Users\\YallonKing&gt;sqlplus sys\/oracle@bbed as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on \u661f\u671f\u4e8c 7\u6708 29 14:15:24 2014\r\n\r\nCopyright (c) 1982, 2010, Oracle.  All rights reserved.\r\n\r\nERROR:\r\nORA-12528: TNS: \u76d1\u542c\u7a0b\u5e8f: \u6240\u6709\u9002\u7528\u4f8b\u7a0b\u90fd\u65e0\u6cd5\u5efa\u7acb\u65b0\u8fde\u63a5\r\n\r\n\r\n\u8bf7\u8f93\u5165\u7528\u6237\u540d:\r\nC:\\Users\\YallonKing&gt;sqlplus sys\/oracle@bbed_ur as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on \u661f\u671f\u4e8c 7\u6708 29 14:15:28 2014\r\n\r\nCopyright (c) 1982, 2010, Oracle.  All rights reserved.\r\n\r\n\r\n\u8fde\u63a5\u5230:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n\r\nSQL&gt; select status from v$instance;\r\n\r\nSTATUS\r\n------------------------\r\nSTARTED\r\n\r\nSQL&gt; alter database mount;\r\n\r\n\u6570\u636e\u5e93\u5df2\u66f4\u6539\u3002\r\n\r\nSQL&gt; alter database open;\r\n\r\n\u6570\u636e\u5e93\u5df2\u66f4\u6539\u3002\r\n\r\nSQL&gt; select open_mode from v$database;\r\n\r\nOPEN_MODE\r\n--------------------\r\nREAD WRITE\r\n\r\nSQL&gt; select status from v$instance;\r\n\r\nSTATUS\r\n------------\r\nOPEN\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5f53\u6570\u636e\u5e93nomount,mount\u6216\u8005restricted\u65f6\uff0c\u52a8\u6001\u76d1\u542c\u663e\u793a\u72b6\u6001\u4e3aBLOCKED\u65f6\uff0c\u5ba2\u6237\u7aef\u53ef\u901a\u8fc7 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[87],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1288"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1288"}],"version-history":[{"count":1,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1288\/revisions"}],"predecessor-version":[{"id":1289,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1288\/revisions\/1289"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1288"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}