{"id":75,"date":"2011-09-06T22:36:22","date_gmt":"2011-09-06T14:36:22","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=75"},"modified":"2011-09-19T22:05:26","modified_gmt":"2011-09-19T14:05:26","slug":"11-2%e6%95%b0%e6%8d%ae%e5%ba%93%e7%9b%91%e5%90%ac%e7%9a%84%e6%94%b9%e5%8f%98","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=75","title":{"rendered":"11.2\u6570\u636e\u5e93\u76d1\u542c\u7684\u6539\u53d8"},"content":{"rendered":"<p>11.2\u7531\u4e8eRAC\u4e2dGRID\u7684\u5206\u79bb\u4ee5\u53ca\u5b9e\u73b0\u4e86SCAN\u529f\u80fd\uff0c\u4f7f\u5f97\u76d1\u542c\u7684\u4f18\u5148\u7ea7\u53d1\u751f\u4e86\u6539\u53d8\u3002<br \/>\n\u4e00\u4e2a11.2\u73af\u5883\u7684\u5355\u5b9e\u4f8b\u6570\u636e\u5e93\uff0c\u914d\u7f6e\u4e86ASM\uff0c\u968f\u540e\u5728\u540c\u4e00\u4e2a\u670d\u52a1\u5668\u4e0a\u53c8\u65b0\u5efa\u4e86\u4e00\u4e2a\u6570\u636e\u5e93\uff0c\u540c\u6837\u4f7f\u7528\u8fd9\u4e2aASM\uff0c\u4f46\u662f\u53d1\u73b0\u8fde\u63a5\u8fd9\u4e2a\u65b0\u7684\u6570\u636e\u5e93\u65f6\u51fa\u73b0\u4e86\u9519\u8bef\u3002<\/p>\n<pre lang='SQL'>[oracle@dbserver1 ~]$ export ORACLE_SID=al32utf8\r\n[oracle@dbserver1 ~]$ sqlplus \/ as sysdba\r\nSQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 5 14:04:57 2011\r\nCopyright (c) 1982, 2010, Oracle.  All rights reserved.\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management, OLAP, Data Mining\r\nand Real Application Testing options\r\nSQL> set pages 100 lines 120\r\nSQL> show parameter service_names\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\nservice_names                        string      al32utf8\r\nSQL> conn thams\/thams@192.168.20.101\/al32utf8\r\nERROR:\r\nORA-12514: TNS:listener does not currently know of service requested in connect descriptor\r\nWarning: You are no longer connected to ORACLE.<\/pre>\n<p>\u7528\u8fd9\u79cd\u7b80\u6613\u8fde\u63a5\u7684\u65b9\u5f0f\u8fde\u63a5\u8fd9\u4e2a\u670d\u52a1\u5668\u4e0a\u7b2c\u4e00\u4e2a\u521b\u5efa\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\uff0c\u6ca1\u6709\u4efb\u4f55\u95ee\u9898\u3002\u68c0\u67e5\u76d1\u542c\u7684\u72b6\u6001\uff1a<\/p>\n<pre lang='SQL'>[oracle@dbserver1 ~]$ lsnrctl status \r\nLSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-SEP-2011 17:50:09\r\nCopyright (c) 1991, 2010, Oracle.  All rights reserved.\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver1)(PORT=1521)))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias                     LISTENER\r\nVersion                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production\r\nStart Date                31-AUG-2011 17:26:15\r\nUptime                    5 days 0 hr. 23 min. 53 sec\r\nTrace Level               off\r\nSecurity                  ON: Local OS Authentication\r\nSNMP                      OFF\r\nListener Parameter File   \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/network\/admin\/listener.ora\r\nListener Log File         \/u01\/app\/oracle\/diag\/tnslsnr\/dbserver1\/listener\/alert\/log.xml\r\nListening Endpoints Summary...\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver1)(PORT=1521)))\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\r\nServices Summary...\r\nService \"fhacdb1\" has 1 instance(s).\r\n  Instance \"fhacdb1\", status READY, has 1 handler(s) for this service...\r\nService \"fhacdbXDB\" has 1 instance(s).\r\n  Instance \"fhacdb1\", status READY, has 1 handler(s) for this service...\r\nThe command completed successfully<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\uff0c\u6570\u636e\u5e93\u7684\u76d1\u542c\u5e76\u6ca1\u6709\u5305\u542b\u65b0\u5efa\u7684al32utf8\u7684\u670d\u52a1\uff0c\u5c1d\u8bd5\u5728\u6570\u636e\u5e93\u4e2d\u8fdb\u884c\u624b\u5de5\u6ce8\u518c\u64cd\u4f5c\uff0c\u9519\u8bef\u4f9d\u65e7\u3002<br \/>\n\u8fd9\u65f6\u60f3\u8d77\u6570\u636e\u5e93\u914d\u7f6e\u4e86GRID\uff0c\u5207\u6362\u5230grid\u7528\u6237\uff0c\u679c\u7136\u53d1\u73b0\u4e86\u95ee\u9898\u6240\u5728\uff1a<\/p>\n<pre lang='SQL'>[oracle@dbserver1 ~]$ su - grid\r\nPassword: \r\n[grid@dbserver1 ~]$ lsnrctl status\r\nLSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-SEP-2011 17:50:59\r\nCopyright (c) 1991, 2010, Oracle.  All rights reserved.\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias                     LISTENER\r\nVersion                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production\r\nStart Date                04-AUG-2011 16:14:28\r\nUptime                    32 days 1 hr. 36 min. 33 sec\r\nTrace Level               off\r\nSecurity                  ON: Local OS Authentication\r\nSNMP                      OFF\r\nListener Parameter File   \/u01\/app\/grid\/product\/11.2.0\/gridhome_1\/network\/admin\/listener.ora\r\nListener Log File         \/u01\/app\/grid\/diag\/tnslsnr\/dbserver1\/listener\/alert\/log.xml\r\nListening Endpoints Summary...\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))\r\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver1)(PORT=1522)))\r\nServices Summary...\r\nService \"+ASM\" has 1 instance(s).\r\n  Instance \"+ASM\", status READY, has 1 handler(s) for this service...\r\nService \"al32utf8\" has 1 instance(s).\r\n  Instance \"al32utf8\", status READY, has 1 handler(s) for this service...\r\nService \"al32utf8XDB\" has 1 instance(s).\r\n  Instance \"al32utf8\", status READY, has 1 handler(s) for this service...\r\nThe command completed successfully\r\n[grid@dbserver1 ~]$ exit\r\nlogout\r\n[oracle@dbserver1 ~]$ sqlplus \/nolog\r\nSQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 5 17:51:20 2011\r\nCopyright (c) 1982, 2010, Oracle.  All rights reserved.\r\nSQL> conn thams\/thams@192.168.20.101:1522\/al32utf8\r\nConnected.\r\nSQL> select name from v$database;\r\nNAME\r\n---------\r\nAL32UTF8\r\nSQL> select instance_name from v$instance;\r\nINSTANCE_NAME\r\n----------------\r\nal32utf8<\/pre>\n<p>\u539f\u6765\u65b0\u5efa\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u6ce8\u518c\u5230grid\u7528\u6237\u4e0b\u7684\u76d1\u542c\u4e0a\u4e86\u3002\u4e4b\u6240\u4ee5\u548c\u53e6\u5916\u4e00\u4e2a\u6570\u636e\u5e93\u4e0d\u540c\uff0c\u662f\u56e0\u4e3a\u90a3\u4e2a\u6570\u636e\u5e93\u662f\u5728grid\u5b89\u88c5\u4e4b\u524d\uff0c\u56e0\u6b64\u6570\u636e\u5e93\u4f7f\u7528ORACLE_HOME\u672c\u8eab\u7684\u76d1\u542c\u3002\u800c\u4e00\u65e6\u914d\u7f6e\u4e86grid\uff0c\u5219grid\u7528\u6237\u4e0b\u7684\u76d1\u542c\u542f\u52a8\uff0c\u800cOracle\u7684\u4f18\u5148\u7ea7\u663e\u7136\u662f\u5148\u627egrid\u4e0b\u7684\u76d1\u542c\uff0c\u7136\u540e\u518d\u53bb\u8003\u8651ORACLE_HOME\u4e0b\u7684\u76d1\u542c\u3002<br \/>\n\u5f53\u7136\uff0c\u5bf9\u4e8e\u6ca1\u6709\u4f7f\u7528grid\u7684\u60c5\u51b5\u4e0b\uff0c11.2\u7684\u76d1\u542c\u548c\u4e4b\u524d\u7684\u7248\u672c\u6ca1\u6709\u4ec0\u4e48\u533a\u522b\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>11.2\u7531\u4e8eRAC\u4e2dGRID\u7684\u5206\u79bb\u4ee5\u53ca\u5b9e\u73b0\u4e86SCAN\u529f\u80fd\uff0c\u4f7f\u5f97\u76d1\u542c\u7684\u4f18\u5148\u7ea7\u53d1\u751f\u4e86\u6539\u53d8\u3002 \u4e00\u4e2a11.2\u73af\u5883\u7684\u5355\u5b9e\u4f8b\u6570\u636e\u5e93\uff0c\u914d\u7f6e\u4e86ASM\uff0c\u968f\u540e\u5728\u540c\u4e00\u4e2a\u670d\u52a1\u5668\u4e0a\u53c8\u65b0\u5efa\u4e86\u4e00\u4e2a\u6570\u636e\u5e93\uff0c\u540c\u6837\u4f7f\u7528\u8fd9\u4e2aASM\uff0c\u4f46\u662f\u53d1\u73b0\u8fde\u63a5\u8fd9\u4e2a\u65b0\u7684\u6570\u636e\u5e93\u65f6\u51fa\u73b0\u4e86\u9519\u8bef\u3002 [oracle@dbserver1 ~]$ export ORACLE_SID=al32utf8 [oracle@dbserver1 ~]$ sqlplus \/ as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Mon Sep 5 14:04:57 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 &#8211; &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=75\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[20,18,17,19],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-1d","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/75"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=75"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/75\/revisions"}],"predecessor-version":[{"id":114,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/75\/revisions\/114"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=75"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=75"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=75"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}