手工建立資料庫具體步驟

一建立存放資料庫檔案的目錄和日誌相關的檔案目錄

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

使用命令檢視目錄結構

[oracle@wang NEWDB]$ pwd

/u01/app/admin/NEWDB

[oracle@wang NEWDB]$ pwd

/u01/app/oradata/NEWDB

二確定ORACLE例項名

[oracle@wang NEWDB]$ export ORACLE_SID=NEWDB

三建立初始化引數檔案

1 建立引數檔案

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

2 建立spfile引數檔案

[oracle@wang dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Feb 23 14:37:08 2014

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

四建立資料庫

1 startup nomount;

2 編寫建立資料庫指令碼

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;

3執行指令碼

SQL> 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;

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

Database created.

五建立資料字典

SQL>@?/rdbms/admin/catalog.sql

…

View created.

Synonym created.

Grant succeeded.

View created.

Comment created.

Synonym created.

Grant succeeded.

View created.

Comment created.

Synonym created.

Grant succeeded.

View created.

Synonym created.

Grant succeeded.

Commit complete.

View created.

Synonym created.

Grant succeeded.

View created.

Synonym created.

Grant succeeded.

View created.

Comment created.

Synonym created.

Grant succeeded.

PL/SQL procedure successfully completed.

SQL> @?/rdbms/admin/catproc.sql

…

Synonym created.

Grant succeeded.

Library created.

Package created.

Package body created.

Package created.

Package body created.

Library created.

Function created.

PL/SQL procedure successfully completed.

Package body created.

No errors.

Package body created.

PL/SQL procedure successfully completed.

SQL> @?/rdbms/admin/catblock.sql

……

View created.

Synonym created.

Grant succeeded.

SQL> connect system/oracle

Connected.

SQL> @?/sqlplus/admin/pupbld.sql

……

Synonym created.

DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE

*

ERROR at line 1:

ORA-01432: public synonym to be dropped does not exist

Synonym created.

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

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

……

View created.

58 rows created.

Commit complete.

手動建庫的時候執行到最後，需要使用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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/750077/viewspace-1130248/，如需轉載，請註明出處，否則將追究法律責任。

手工建立資料庫的完整步驟

一建立存放資料庫檔案的目錄和日誌相關的檔案目錄

二確定ORACLE例項名

三建立初始化引數檔案

1 建立引數檔案

2 建立spfile引數檔案

四建立資料庫

1 startup nomount;

2 編寫建立資料庫指令碼

3執行指令碼

五建立資料字典

相關文章

手工建立資料庫的完整步驟

一建立存放資料庫檔案的目錄和日誌相關的檔案目錄

二 確定ORACLE例項名

三 建立初始化引數檔案

1 建立引數檔案

2 建立spfile引數檔案

四 建立資料庫

1 startup nomount;

2 編寫建立資料庫指令碼

3執行指令碼

五 建立資料字典

相關文章

二確定ORACLE例項名

三建立初始化引數檔案

四建立資料庫

五建立資料字典