{"id":1193,"date":"2014-05-06T10:33:29","date_gmt":"2014-05-06T02:33:29","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=1193"},"modified":"2014-05-06T16:43:53","modified_gmt":"2014-05-06T08:43:53","slug":"%e6%89%8b%e5%b7%a5%e5%bb%ba%e5%ba%93","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=1193","title":{"rendered":"\u624b\u5de5\u5efa\u5e93"},"content":{"rendered":"<p>\u8fd9\u4e00\u7bc7\u4ecb\u7ecd\u5982\u4f55\u624b\u5de5\u5efa\u5e93\u7684\u6587\u6863\uff0c\u4e4b\u524d\u5728\u5927\u5b66\u90a3\u4f1a\u81ea\u5df1\u64cd\u4f5c\u8fc7\uff0c\u8bb0\u5f97\u5f53\u65f6\u597d\u50cf\u8fd8\u5728\u5bbf\u820d\u5f55\u4e86\u4e00\u4e2a\u624b\u5de5\u5efa\u5e93\u7684\u4f18\u9177\u89c6\u9891\u6765\u7740\uff0c\u73b0\u5728\u91cd\u65b0\u590d\u4e60\u4e00\u4e0b\uff01<\/p>\n<p><strong>\u521b\u5efa\u76f8\u5173\u76ee\u5f55<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ocm1 oracle]$ pwd\r\n\/u01\/app\/oracle\r\n[oracle@ocm1 oracle]$ mkdir -p test\/bdump\r\n[oracle@ocm1 oracle]$ mkdir -p test\/cdump\r\n[oracle@ocm1 oracle]$ mkdir -p test\/udump\r\n<\/pre>\n<p><strong>\u521b\u5efa\u53c2\u6570\u6587\u4ef6<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ocm1 ~]$ export ORACLE_SID=test\r\n[oracle@ocm1 ~]$ cd $ORACLE_HOME\/dbs\r\n[oracle@ocm1 dbs]$ cat init.ora |grep -v ^#| grep -v ^$ &gt; inittest.ora\r\n[oracle@ocm1 dbs]$ cat inittest.ora \r\ndb_name=test\r\ndb_files = 180                                                         # SMALL  \r\ndb_file_multiblock_read_count = 8                                     # SMALL  \r\n#db_block_buffers = 100                                                 # SMALL  \r\n#shared_pool_size = 3500000                                            # SMALL\r\nlog_checkpoint_interval = 10000\r\nprocesses = 150                                                        # SMALL  \r\nparallel_max_servers = 5                                              # SMALL\r\n#log_buffer = 32768                                                    # SMALL\r\nmax_dump_file_size = 10240      # limit trace file size to 5 Meg each\r\nglobal_names = TRUE\r\n#begin add parameters\r\nsga_max_size = 300M\r\nsga_target = 300M\r\nundo_management = auto\r\nundo_tablespace= undotbs\r\nbackground_dump_dest=\/u01\/app\/oracle\/test\/bdump\r\ncore_dump_dest=\/u01\/app\/oracle\/test\/cdump\r\nuser_dump_dest=\/u01\/app\/oracle\/test\/udump\r\ncontrol_files = (\/u01\/app\/oracle\/test\/control1,\/u01\/app\/oracle\/test\/control2)\r\n<\/pre>\n<p>\u6ce8\u610f\uff1a\u8be5\u5904\u9700\u8981\u4eba\u4e3a\u5c06\u6240\u6709\u5185\u5b58\u53c2\u6570\u6ce8\u9500\u6389\uff0c\u540c\u4e00\u7531sga_max_size\u548csga_target2\u4e2a\u53c2\u6570\u66ff\u4ee3\u7ba1\u7406\uff1b\u9700\u8981\u4fee\u6539\u6570\u636e\u5e93\u540ddb_name\uff1b\u9700\u8981\u8c03\u5927\u53c2\u6570\u503cdb_files,processes;\u589e\u52a0\u53c2\u6570undo_tablespace,undo_management;\u4fee\u6539\u63a7\u5236\u6587\u4ef6\u8def\u5f84control_files;\u6dfb\u52a0\u65e5\u5fd7\u76ee\u5f55\u7684\u8def\u5f84background_dump_dest,core_dump_dest,user_dump_dest.<\/p>\n<p><strong>\u4fee\u6539OS\u53c2\u6570\/etc\/oratab<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ocm1 ~]$ tail -1 \/etc\/oratab \r\ntest:\/u01\/app\/oracle\/product\/10.2.0\/db_1:N\r\n<\/pre>\n<p><strong>\u751f\u6210spfile<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ocm1 dbs]$ env| grep ORACLE_SID\r\nORACLE_SID=test\r\n[oracle@ocm1 dbs]$ sqlplus &quot;\/as sysdba&quot;\r\n\r\nSQL*Plus: Release 10.2.0.1.0 - Production on Mon May 5 08:54:55 2014\r\n\r\nCopyright (c) 1982, 2005, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL&gt; startup nomount pfile=&#039;\/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/inittest.ora&#039;;\r\nORACLE instance started.\r\n\r\nTotal System Global Area  314572800 bytes\r\nFixed Size                  1219184 bytes\r\nVariable Size              96470416 bytes\r\nDatabase Buffers          213909504 bytes\r\nRedo Buffers                2973696 bytes\r\nSQL&gt; create spfile from pfile=&#039;\/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/inittest.ora&#039;;\r\n\r\nFile created.\r\n\r\nSQL&gt; shutdown immediate;\r\nORA-01507: database not mounted\r\n\r\n\r\nORACLE instance shut down.\r\nSQL&gt; startup nomount;\r\nORACLE instance started.\r\n\r\nTotal System Global Area  314572800 bytes\r\nFixed Size                  1219184 bytes\r\nVariable Size              96470416 bytes\r\nDatabase Buffers          213909504 bytes\r\nRedo Buffers                2973696 bytes\r\nSQL&gt; \r\n<\/pre>\n<p><strong>\u521b\u5efa\u6570\u636e\u5e93<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; CREATE DATABASE test\r\n  2     USER SYS IDENTIFIED BY oracle\r\n  3     USER SYSTEM IDENTIFIED BY oracle\r\n  4     LOGFILE GROUP 1 (&#039;\/u01\/app\/oracle\/test\/redo01.log&#039;) SIZE 100M,\r\n  5             GROUP 2 (&#039;\/u01\/app\/oracle\/test\/redo02.log&#039;) SIZE 100M,\r\n  6             GROUP 3 (&#039;\/u01\/app\/oracle\/test\/redo03.log&#039;) SIZE 100M\r\n  7     MAXLOGFILES 5\r\n  8     MAXLOGMEMBERS 5\r\n  9     MAXLOGHISTORY 1\r\n 10     MAXDATAFILES 100\r\n 11     MAXINSTANCES 1\r\n 12     CHARACTER SET US7ASCII\r\n 13     NATIONAL CHARACTER SET AL16UTF16\r\n 14     DATAFILE &#039;\/u01\/app\/oracle\/test\/system01.dbf&#039; SIZE 325M REUSE\r\n 15     EXTENT MANAGEMENT LOCAL\r\n 16     SYSAUX DATAFILE &#039;\/u01\/app\/oracle\/test\/sysaux01.dbf&#039; SIZE 325M REUSE\r\n 17     DEFAULT TEMPORARY TABLESPACE tempts1\r\n 18        TEMPFILE &#039;\/u01\/app\/oracle\/test\/temp01.dbf&#039; \r\n 19        SIZE 20M REUSE\r\n 20     UNDO TABLESPACE undotbs \r\n 21        DATAFILE &#039;\/u01\/app\/oracle\/test\/undotbs01.dbf&#039;\r\n 22        SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;\r\n\r\nDatabase created.\r\n<\/pre>\n<p>\u6ce8\u610f\uff1a\u6570\u636e\u5e93\u540d\u548coracle_sid\u4e00\u81f4\uff1bsys,system\u5bc6\u7801\uff1bredo\u8def\u5f84\uff1b\u6570\u636e\u6587\u4ef6\u8def\u5f84\uff1b\u5b57\u7b26\u96c6\u8bbe\u5b9a\uff1b\u9ed8\u8ba4\u8868\u7a7a\u95f4\u8bbe\u7f6e\u3002\t  <\/p>\n<p><strong>\u8dd1\u6570\u636e\u5b57\u5178\u811a\u672c\u548cPL\/SQL\u7684\u811a\u672c<\/strong>\t  <\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; @\/u01\/app\/oracle\/product\/10.2.0\/db_1\/rdbms\/admin\/catalog.sql\r\nSQL&gt; @\/u01\/app\/oracle\/product\/10.2.0\/db_1\/rdbms\/admin\/catproc.sql\r\n<\/pre>\n<p><strong>\u521b\u5efa\u5bc6\u7801\u6587\u4ef6<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\n[oracle@ocm1 ~]$ cd $ORACLE_HOME\/dbs\/\r\n[oracle@ocm1 dbs]$ orapwd \r\nUsage: orapwd file=&lt;fname&gt; password=&lt;password&gt; entries=&lt;users&gt; force=&lt;y\/n&gt; \r\n\r\n  where\r\n    file - name of password file (mand),\r\n    password - password for SYS (mand),\r\n    entries - maximum number of distinct DBA and     force - whether to overwrite existing file (opt),\r\nOPERs (opt), \r\n  There are no spaces around the equal-to (=) character.\r\n[oracle@ocm1 dbs]$ orapwd file=orapwtest password=oracle entries=10\r\n<\/pre>\n<p><strong>\u68c0\u67e5\u6570\u636e\u5e93<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; desc dba_registry\r\n Name                                      Null?    Type\r\n ----------------------------------------- -------- ----------------------------\r\n COMP_ID                                   NOT NULL VARCHAR2(30)\r\n COMP_NAME                                          VARCHAR2(255)\r\n VERSION                                            VARCHAR2(30)\r\n STATUS                                             VARCHAR2(11)\r\n MODIFIED                                           VARCHAR2(20)\r\n NAMESPACE                                 NOT NULL VARCHAR2(30)\r\n CONTROL                                   NOT NULL VARCHAR2(30)\r\n SCHEMA                                    NOT NULL VARCHAR2(30)\r\n PROCEDURE                                          VARCHAR2(61)\r\n STARTUP                                            VARCHAR2(8)\r\n PARENT_ID                                          VARCHAR2(30)\r\n OTHER_SCHEMAS                                      VARCHAR2(4000)\r\n\r\nSQL&gt; set line 400\r\nSQL&gt; col COMP_NAME for a40\r\nSQL&gt; select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;\r\n\r\nCOMP_ID                        COMP_NAME                                VERSION                        STATUS\r\n------------------------------ ---------------------------------------- ------------------------------ -----------\r\nCATALOG                        Oracle Database Catalog Views            10.2.0.1.0                     VALID\r\nCATPROC                        Oracle Database Packages and Types       10.2.0.1.0                     VALID\r\n\r\n2 rows selected.\r\n<\/pre>\n<p><strong>\u8fdb\u884c\u51b7\u5907\u4efd<\/strong><\/p>\n<pre class=\"wp-code-highlight prettyprint\">\r\nSQL&gt; shutdown immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production\r\nWith the Partitioning, OLAP and Data Mining options\r\n[oracle@ocm1 dbs]$ cp -r \/u01\/app\/oracle\/test \/tmp\/\r\n[oracle@ocm1 dbs]$ cp $ORACLE_HOME\/dbs\/*test* \/tmp\r\n<\/pre>\n<p>\u81f3\u6b64\u5168\u90e8OK\uff01\u6b63\u6240\u8c13\u662f\u6e29\u6545\u800c\u77e5\u65b0...<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8fd9\u4e00\u7bc7\u4ecb\u7ecd\u5982\u4f55\u624b\u5de5\u5efa\u5e93\u7684\u6587\u6863\uff0c\u4e4b\u524d\u5728\u5927\u5b66\u90a3\u4f1a\u81ea\u5df1\u64cd\u4f5c\u8fc7\uff0c\u8bb0\u5f97\u5f53\u65f6\u597d\u50cf\u8fd8\u5728\u5bbf\u820d\u5f55\u4e86\u4e00\u4e2a\u624b\u5de5\u5efa\u5e93\u7684\u4f18\u9177\u89c6\u9891\u6765\u7740\uff0c\u73b0 [&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":[254],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1193"}],"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=1193"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1193\/revisions"}],"predecessor-version":[{"id":1200,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/1193\/revisions\/1200"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1193"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}