手工建立資料庫的完整步驟 一建立存放資料庫檔案的目錄和日志相關的檔案目錄 二 确定ORACLE執行個體名 三 建立初始化參數檔案 四 建立資料庫 五 建立資料字典

<b>手工建立資料庫具體步驟</b>

分别在$ORACLE_BASE\oradata 和 $ORACLE_BASE\admin目錄下建立NEWDB目錄

使用指令檢視目錄結構

[oracle@wang NEWDB]$ pwd

/u01/app/admin/NEWDB

/u01/app/oradata/NEWDB

[oracle@wang NEWDB]$ export

ORACLE_SID=NEWDB

vi $ORACLE_BASE/dbs/initNEWDB.ora

control_files              =

(/u01/app/oradata/NEWDB/control01.dbf,

                              /u01/app/oradata/NEWDB/control02.dbf,

                              /u01/app/oradata/NEWDB/control03.dbf)

db_name                    = NEWDB

db_domain                  = NEWDB.oracle.com

log_archive_dest_1         =

"LOCATION=/u01/app/admin/NEWDB/arch"

log_archive_dest_state_1   = enable

db_block_size              = 8192

pga_aggregate_target       = 90M

processes                  = 100

sessions                   = 120

open_cursors               = 200

undo_management            = AUTO

undo_tablespace            = undotbs

compatible                 = 10.2.0

sga_target                 = 270M

nls_language               = AMERICAN

nls_territory              = AMERICA

db_recovery_file_dest      = /u01/app/admin/NEWDB/flashback

db_recovery_file_dest_size = 1G

audit_dump_dest            = /u01/app/admin/NEWDB/adump

core_dump_dest             = /u01/app/admin/NEWDB/cdump

background_dump_dest       = /u01/app/admin/NEWDB/bdump

[oracle@wang dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production

on Sun Feb 23 14:37:08 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL&gt; create spfile from pfile;

File created.

vi temp

CREATE DATABASE NEWDB

   USER SYS IDENTIFIED BY oracle

   USER SYSTEM IDENTIFIED BY oracle

   LOGFILE GROUP 1 ('/u01/app/oradata/NEWDB/redo01.log') SIZE 50M,

           GROUP 2 ('/u01/app/oradata/NEWDB//redo02.log') SIZE 50M,

           GROUP 3 ('/u01/app/oradata/NEWDB/redo03.log') SIZE 50M

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 100

   MAXINSTANCES 1

   CHARACTER SET US7ASCII

   NATIONAL CHARACTER SET AL16UTF16

   DATAFILE '/u01/app/oradata/NEWDB/system01.dbf' SIZE 325M REUSE

   EXTENT MANAGEMENT LOCAL

   SYSAUX DATAFILE '/u01/app/oradata/NEWDB//sysaux01.dbf' SIZE 325M REUSE

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '/u01/app/oradata/NEWDB/temp01.dbf'

      SIZE 20M REUSE

   UNDO TABLESPACE undotbs

      DATAFILE '/u01/app/oradata/NEWDB/undotbs01.dbf'

      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

SQL&gt; CREATE DATABASE NEWDB

   NATIONAL

CHARACTER SET AL16UTF16

  2    3    4    5    6    7    8    9   10   11   12   13   14   15   16   17   18   19   20   21   22 

Database created.

SQL&gt;@?/rdbms/admin/catalog.sql

…

View created.

Synonym created.

Grant succeeded.

Comment created.

Commit complete.

PL/SQL procedure successfully completed.

SQL&gt; @?/rdbms/admin/catproc.sql

Library created.

Package created.

Package body created.

Function created.

No errors.

SQL&gt; @?/rdbms/admin/catblock.sql

……

SQL&gt; connect system/oracle

Connected.

SQL&gt; @?/sqlplus/admin/pupbld.sql

DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE

                    *

ERROR at line 1:

ORA-01432: public synonym to be dropped

does not exist

建立help表并插入help的資料,非常值得參考

SQL&gt; @?/sqlplus/admin/help/hlpbld.sql

helpus.sql

58 rows created.

手動建庫的時候執行到最後，需要使用system使用者執行SQL腳本  ，但在執行hlpbld.sql的時候要求輸入參數，

  @?/sqlplus/admin/help/hlpbld.sql

?代表oracle home

實際就是建立了一張名為help的表，用于支援help指令，而hlpbld.sql本身是沒有插入資料的語句的，是以需要傳遞一個參數，而這個參數實際上就是插入help資料的腳本。将helpus.sql作為輸入參數的指令 就是

 @?/sqlplus/admin/help/hlpbld.sql helpus.sql