{"id":1365,"date":"2018-01-13T12:00:40","date_gmt":"2018-01-13T04:00:40","guid":{"rendered":"http:\/\/www.821121.com\/?p=1365"},"modified":"2021-03-02T10:50:42","modified_gmt":"2021-03-02T02:50:42","slug":"%e4%bf%ae%e6%94%b9oracle%e7%9a%84db_domain%e3%80%81global_name%e5%92%8cservice_name%e3%80%81unique_name","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1365","title":{"rendered":"\u4fee\u6539Oracle\u7684db_domain\u3001global_name\u548cservice_name\u3001unique_name"},"content":{"rendered":"
\u5b89\u88c5 oracle \u7684\u65f6\u5019\u4f1a\u5236\u5b9a db_domain\uff0c\u5236\u5b9a db_domain \u540e service_name \u548c global_name \u90fd\u4f1a\u52a0\u4e0a\u8fd9\u4e2adomain,\u6b64\u65f6\u5728\u914d\u7f6e tns file \u4ee5\u53ca easy connect \u7684\u65f6\u5019\u90fd\u8981 service_name \u5f88\u590d\u6742\u3002\u5c1d\u8bd5\u4fee\u6539 global_name\uff0c\u56e0\u4e3a service_name \u9ed8\u8ba4\u662f global_name,\u800cglobal_name=db_name.db_domain\u3002\ndb_domain\u5e38\u7528\u4e8e\u5206\u5e03\u5f0f\u6570\u636e\u5e93\u7cfb\u7edf\u6807\u8bc6\nglobal_name\u548cservice_name\u5e38\u7528\u4e8e\u76d1\u542c\u548ctnsnames\nunique_name\u662f\u6570\u636e\u5e93\u7684\u552f\u4e00\u540d\uff0c\u5e38\u7528\u4e8e\u6570\u636e\u5e93DG\u642d\u5efa\u3002<\/code><\/pre>\n
1.\u67e5\u770b\u72b6\u6001<\/h1>\n
show parameter name\nshow parameter db_domain\nshow parameter service_name;\nshow parameter db_unique_name;\nshow parameter global_name;<\/code><\/pre>\n
2.\u4fee\u6539db_domain<\/h1>\n
alter system set db_domain='coco' scope=spfile;\nstartup force    \/\/\u91cd\u542f\u6570\u636e\u5e93(\u751f\u4ea7\u73af\u9700\u8981\u6b63\u5e38\u5173\u5e93)\nshow parameter db_domain; \/\/\u68c0\u9a8c\u7ed3\u679c\n\u4fee\u6539db_domain\u4f1a\u987a\u5e26\u6539\u53d8service_name<\/code><\/pre>\n
3.\u5f00\u542f\u5e76\u4fee\u6539global_name<\/h1>\n
alter system set global_names=true scope=both;\nupdate global_name set global_name = 'coco'\ncommit;\n\u4fee\u6539 global_name \u5e76\u4e0d\u4f1a\u9ed8\u8ba4\u6539\u6389 service_name\uff0c\u4e5f\u4e0d\u4f1a\u9ed8\u8ba4\u4fee\u6539 db_domain<\/code><\/pre>\n
4.\u4fee\u6539service_names:\nalter system set service_names = 'coco' scope=spfile;\nstartup force    \/\/\u91cd\u542f\u6570\u636e\u5e93(\u751f\u4ea7\u73af\u9700\u8981\u6b63\u5e38\u5173\u5e93)\nshow parameter service_names;\n\u4fee\u6539global_name\u548cservice_name\u540e\u6570\u636e\u5e93\u7684\u76d1\u542c\u914d\u7f6e\u548ctnsnames\u4e5f\u9700\u8981\u4fee\u6539<\/code><\/pre>\n
5.\u4fee\u6539unique_name<\/h1>\n
alter system set db_unique_name = 'coco' scope=spfile;\nstartup force    \/\/\u91cd\u542f\u6570\u636e\u5e93(\u751f\u4ea7\u73af\u9700\u8981\u6b63\u5e38\u5173\u5e93) \nshow parameter db_unique_name;<\/code><\/pre>\n
\u8fc7\u7a0b\u5982\u4e0b\uff1a\nSQL> show parameter name\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ncell_offloadgroup_name               string\ndb_file_name_convert                 string\ndb_name                              string      orcl\ndb_unique_name                       string      orcl\nglobal_names                         boolean     FALSE\ninstance_name                        string      orcl\nlock_name_space                      string\nlog_file_name_convert                string\nprocessor_group_name                 string\nservice_names                        string      orcl\nSQL> show parameter db_domain\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_domain                            string\nSQL> show parameter service_name;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nservice_names                        string      orcl\nSQL> show parameter db_unique_name;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_unique_name                       string      orcl\nSQL> show parameter global_name;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nglobal_names                         boolean     FALSE\nSQL> select * from global_name;\n\nGLOBAL_NAME\n--------------------------------------------------------------------------------\nORCL\n\nSQL> alter system set db_domain='coco' scope=spfile;\n\nSystem altered.\n\nSQL> startup force\nORACLE instance started.\n\nTotal System Global Area  776646656 bytes\nFixed Size                  2257272 bytes\nVariable Size             507514504 bytes\nDatabase Buffers          264241152 bytes\nRedo Buffers                2633728 bytes\nDatabase mounted.\nDatabase opened.\nSQL> show parameter db_domain;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_domain                            string      coco\nSQL> show parameter global_name;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nglobal_names                         boolean     FALSE\nSQL> select * from global_name;\n\nGLOBAL_NAME\n--------------------------------------------------------------------------------\nORCL\n\n\u4fee\u6539db_domain\uff0cservice_name\u4f1a\u66f4\u7740\u4fee\u6539\u3002\n\nSQL> alter system set global_names=true scope=both;\n\nSystem altered.\n\nSQL> show parameter name;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ncell_offloadgroup_name               string\ndb_file_name_convert                 string\ndb_name                              string      orcl\ndb_unique_name                       string      orcl\nglobal_names                         boolean     TRUE\ninstance_name                        string      orcl\nlock_name_space                      string\nlog_file_name_convert                string\nprocessor_group_name                 string\nservice_names                        string      orcl.coco\nSQL> select * from global_name;\n\nGLOBAL_NAME\n--------------------------------------------------------------------------------\nORCL\n\nSQL> update global_name set global_name = 'coco';\n\n1 row updated.\n\nSQL> commit;\n\nCommit complete.\n\nSQL> select * from global_name;\n\nGLOBAL_NAME\n--------------------------------------------------------------------------------\ncoco\n\nSQL> startup force\nORACLE instance started.\n\nTotal System Global Area  776646656 bytes\nFixed Size                  2257272 bytes\nVariable Size             507514504 bytes\nDatabase Buffers          264241152 bytes\nRedo Buffers                2633728 bytes\nDatabase mounted.\nDatabase opened.\nSQL> select * from global_name;\n\nGLOBAL_NAME\n--------------------------------------------------------------------------------\ncoco\n\nSQL> alter system set db_unique_name = 'coco' scope=spfile;\n\nSystem altered.\n\nSQL> show parameter name;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ncell_offloadgroup_name               string\ndb_file_name_convert                 string\ndb_name                              string      orcl\ndb_unique_name                       string      orcl\nglobal_names                         boolean     TRUE\ninstance_name                        string      orcl\nlock_name_space                      string\nlog_file_name_convert                string\nprocessor_group_name                 string\nservice_names                        string      orcl.coco\nSQL> startup force \nORACLE instance started.\n\nTotal System Global Area  776646656 bytes\nFixed Size                  2257272 bytes\nVariable Size             507514504 bytes\nDatabase Buffers          264241152 bytes\nRedo Buffers                2633728 bytes\nDatabase mounted.\nDatabase opened.\nSQL> show parameter db_unique_name;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\ndb_unique_name                       string      coco\n\nSQL> alter system set service_names = 'coco' scope=spfile;\n\nSystem altered.\n\nSQL> startup force    \nORACLE instance started.\n\nTotal System Global Area  776646656 bytes\nFixed Size                  2257272 bytes\nVariable Size             507514504 bytes\nDatabase Buffers          264241152 bytes\nRedo Buffers                2633728 bytes\nDatabase mounted.\nDatabase opened.\n\nSQL> show parameter service_names;\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nservice_names                        string      coco<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u5b89\u88c5 oracle \u7684\u65f6\u5019\u4f1a\u5236\u5b9a db_domai<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,37],"tags":[],"class_list":["post-1365","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1365","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=1365"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1365\/revisions"}],"predecessor-version":[{"id":1366,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1365\/revisions\/1366"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1365"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}