{"id":1229,"date":"2024-06-05T20:29:59","date_gmt":"2024-06-05T12:29:59","guid":{"rendered":"https:\/\/cn.raksmart.com\/blog\/host\/4063.html"},"modified":"2024-06-05T20:29:59","modified_gmt":"2024-06-05T12:29:59","slug":"oracle%e4%b9%8b%e5%8f%82%e6%95%b0%e6%96%87%e4%bb%b6%e4%bb%8b%e7%bb%8d","status":"publish","type":"post","link":"https:\/\/cn.raksmart.com\/blog\/knowledge\/1229.html","title":{"rendered":"oracle\u4e4b\u53c2\u6570\u6587\u4ef6\u4ecb\u7ecd"},"content":{"rendered":"
\n

raksmart<\/a>\u7f8e\u56fd\u670d\u52a1\u5668<\/a><\/strong>\u4e3a\u60a8\u4ecb\u7ecdoracle\u4e4b\u53c2\u6570\u6587\u4ef6\uff1a
\n\u53c2\u6570\u6587\u4ef6\u7684\u542b\u4e49
\n\u53c2\u6570\u6587\u4ef6\u7684\u4f5c\u7528\uff1a
\n\u8bbe\u5b9a\u6570\u636e\u5e93\u7684\u9650\u5236\u3001\u8bbe\u5b9a\u7528\u6237\u6216\u8005\u8fdb\u7a0b\u7684\u9650\u5236\u3001\u8bbe\u5b9a\u6570\u636e\u5e93\u8d44\u6e90\u7684\u9650\u5236\u3001\u8c03\u6574\u7cfb\u7edf\u7684\u6027\u80fd
\n\u6570\u636e\u5e93\u901a\u8fc7\u8bfb\u53d6\u53c2\u6570\u6587\u4ef6\uff0c\u5206\u914d\u5185\u5b58\u7a7a\u95f4\uff0c\u542f\u52a8\u540e\u53f0\u8fdb\u7a0b\uff0c\u542f\u52a8\u5230nomount\u72b6\u6001\u3002\u63a8\u8350\u6587\u7ae0\uff1a\u300aogg\u7684\u5b89\u88c5\u4e0e\u914d\u7f6e\u300b<\/a>
\n\u4e00.\u4e24\u79cd\u53c2\u6570\u6587\u4ef6\u7684\u533a\u522b<\/span>
\n1.pfile \u2014->init.ora
\n\u6587\u672c
\n\u80fd\u88ab\u7f16\u8f91\u5668\u4fee\u6539
\n\u80fd\u653e\u5728oracle\u5ba2\u6237\u7aef\u4e5f\u80fd\u653e\u5728oracle\u670d\u52a1\u5668\u7aef
\n\u4e0d\u80fd\u88abrman\u5907\u4efd
\n2.spfile
\n\u4e8c\u8fdb\u5236\u6587\u4ef6
\n\u4fee\u6539\u65b9\u5f0f\uff1aalter system\/session set parameter_name=values<>;
\n\u53ea\u80fd\u653e\u5728oracle\u670d\u52a1\u5668\u7aef
\n\u80fd\u88abrman\u5907\u4efd
\n\u4e8c.oracle\u542f\u52a8\u65f6\u8981\u6253\u5f00\u53c2\u6570\u6587\u4ef6\uff0c\u4f18\u5148\u7ea7\u5982\u4e0b\uff1a<\/span>
\nspfile.ora>spfile.ora>init.ora
\n\u4e09.\u53c2\u6570\u6587\u4ef6\u7684\u4f4d\u7f6e\uff1a<\/span>
\nspfile:$ORACLE_HOME\/dbs\/spfile$ORACLE_SID.ora
\npfile::$ORACLE_HOME\/dbs\/init$ORACLE_SID.ora
\n\u56db.\u6307\u5b9a\u53c2\u6570\u6587\u4ef6\u542f\u52a8<\/span>
\nstartup pfile=\u2019\/u01\/oracle \/10g\/dbs\/initorcl.ora\u2019
\n\u53ef\u4ee5\u901a\u8fc7 show parameter spfile \u67e5\u770b\u5f53\u524d\u6570\u636e\u7528\u4e86\u90a3\u79cdspfile\u6587\u4ef6\u63a8\u8350\u6587\u7ae0\uff1a\u300aoracle 11g \u8868\u7a7a\u95f4\u52a0\u5bc6\u300b<\/a>
\n\u4e94.\u4e24\u79cd\u53c2\u6570\u6587\u4ef6\u7684\u590d\u5236\uff1a<\/span>
\ncreate pfile\/spfile=\u201d\u2026\u201d from spflie\/pfile=\u201d\u2026\u201d
\n(\u8def\u5f84\u53ef\u5199\u53ef\u4e0d\u5199\uff0c\u4e0d\u5199\u4e3a\u9ed8\u8ba4\u8def\u5f84)
\n11g|\uff1acreate spfile=\u201d\u2026\u201d from memory
\n\u516d.spfile\u53c2\u6570\u6587\u4ef6\u7684\u4fee\u6539<\/span>
\nalter system\/session set parameter_name=values scope=memory|spfile|both;
\nscope\u4e2d\u7684memory\u8868\u793a\u4fee\u6539\u7684\u53c2\u6570\u53ea\u5728\u5f53\u524d\u90fd\u751f\u6548\uff0c\u4e0b\u6b21\u542f\u52a8\u5b9e\u4f8b\u65e0\u6548
\nspfile\u8868\u793a\u5f53\u524d\u4e0d\u751f\u6548\uff0c\u53c2\u6570\u6587\u4ef6\u751f\u6548\uff0c\u6240\u4ee5\u4e0b\u6b21\u542f\u52a8\u624d\u751f\u6548
\nboth\u8868\u793a\u5f53\u524d\u548cspfile\u53c2\u6570\u6587\u4ef6\u90fd\u751f\u6548(\u9ed8\u8ba4)
\n\u7cfb\u7edf\u4e2d\u603b\u5171\u5b58\u5728\u4e09\u79cd\u72b6\u6001\u7684\u53c2\u6570\uff1a
\nimmediate \u52a8\u6001\u53c2\u6570 alter system set parameter_name=values scope=memory|spfile|both;
\nfalse \u9759\u6001\u53c2\u6570 alter system set parameter_name=values scope=spfile;
\ndeferred \u4f1a\u8bdd\u53c2\u6570 alter session set parameter_name=values scope=memory|spfile|both;
\n\u4e03.\u663e\u793a\u53c2\u6570<\/span>
\nshow parameter \u53c2\u6570\u540d;
\nselect name,value from v$parameter;(\u6240\u6709\u53c2\u6570)
\nselect sid,name,value from v$spparameter where value is not null;(spfile\u4e2d\u5b9a\u4e49\u7684\u53c2\u6570)
\n\u516b.\u9690\u85cf\u53c2\u6570\u6587\u4ef6(\u4e0d\u5efa\u8bae\u4f7f\u7528)<\/span>
\n\u9690\u85cf\u53c2\u6570 (hidden parameters) \uff0c\u7531oracle\u5185\u90e8\u4f7f\u7528\uff0c\u4ee5 \u2018_\u2019 \u5f00\u5934\u3002
\n\u9690\u85cf\u53c2\u6570\u662foracle\u5b98\u65b9\u4e0d\u63a8\u8350\u7528\u6237\u4f7f\u7528\u7684\u53c2\u6570\uff0c\u5b98\u65b9\u6587\u6863\u5bf9\u8fd9\u4e9b\u53c2\u6570\u4ecb\u7ecd\u4e5f\u4e0d\u591a\uff0c\u82e5\u662f\u9690\u85cf\u53c2\u6570\u6ca1\u6709\u6b63\u786e\u4f7f\u7528\u4f1a\u5bfc\u81f4\u4e25\u91cd\u7684\u540e\u679c\u3002
\n\u4f46\u662f\u6709\u65f6\u5019\u6211\u4eec\u9047\u5230\u4e86\u4e00\u4e9b\u95ee\u9898\uff0c\u8fd9\u4e9b\u9690\u85cf\u53c2\u6570\u5374\u53c8\u80fd\u8fbe\u5230\u610f\u60f3\u4e0d\u5230\u7684\u6548\u679c\u3002\u63a8\u8350\u6587\u7ae0\uff1a\u300aOracle\u4f20\u8f93\u8868\u7a7a\u95f4\u300b<\/a>
\n\u6bd4\u5982\uff1a\u5f53\u6211\u4eec\u5728\u505a\u6062\u590d\u65f6\uff0c\u5907\u4efd\u6709\u95ee\u9898\uff0c\u53ea\u80fd\u5c06\u6570\u636e\u5e93\u6062\u590d\u5230\u4e0d\u4e00\u81f4\u72b6\u6001\uff0c\u8fd9\u65f6\u53ef\u4ee5\u501f\u52a9\u67d0\u4e2a\u9690\u85cf\u53c2\u6570\uff0c\u8ba9oracle\u8df3\u8fc7\u4e00\u81f4\u6027\u68c0\u67e5\u6253\u5f00\u4ece\u800c\u6570\u636e\u5e93\u3002
\n\u67e5\u770b\u65b9\u5f0f\uff1a
\nSELECT i.ksppinm name,
\ni.ksppdesc description,
\nCV.ksppstvl VALUE,
\nCV.ksppstdf isdefault,
\nDECODE(BITAND(CV.ksppstvf, 7),
\n1,
\n\u2018MODIFIED\u2019,
\n4,
\n\u2018SYSTEM_MOD\u2019,
\n\u2018FALSE\u2019) ismodified,
\nDECODE(BITAND(CV.ksppstvf, 2), 2, \u2018TRUE\u2019, \u2018FALSE\u2019) isadjusted
\nFROM sys.x$ksppi i, sys.x$ksppcv CV
\nWHERE i.inst_id = USERENV(\u2018Instance\u2019)
\nAND CV.inst_id = USERENV(\u2018Instance\u2019)
\nAND i.indx = CV.indx
\nAND i.ksppinm LIKE \u2018\/_%\u2019 ESCAPE \u2018\/\u2019
\nORDER BY REPLACE(i.ksppinm, \u2018_\u2019, \u201d);
\n\u6216\u8005
\nSELECT ksppinm, ksppstvl, ksppdesc
\nFROM x$ksppi x, x$ksppcv y
\nWHERE x.indx = y.indx
\nAND TRANSLATE(ksppinm, \u2018_\u2019, \u2018#\u2019) LIKE \u2018#%\u2019;<\/p>\n","protected":false},"excerpt":{"rendered":"

raksmart\u7f8e\u56fd\u670d\u52a1\u5668\u4e3a\u60a8\u4ecb\u7ecdoracle\u4e4b\u53c2\u6570\u6587\u4ef6\uff1a \u53c2\u6570\u6587\u4ef6\u7684\u542b\u4e49 \u53c2\u6570\u6587\u4ef6\u7684\u4f5c\u7528\uff1a \u8bbe\u5b9a\u6570\u2026 <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[971],"class_list":["post-1229","post","type-post","status-publish","format-standard","hentry","category-knowledge","tag-oracle"],"_links":{"self":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/posts\/1229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/comments?post=1229"}],"version-history":[{"count":0,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/posts\/1229\/revisions"}],"wp:attachment":[{"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/media?parent=1229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/categories?post=1229"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.raksmart.com\/blog\/wp-json\/wp\/v2\/tags?post=1229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}