這篇文章給大家分享的是有關(guān)如何手工創(chuàng)建數(shù)據(jù)庫的內(nèi)容。小編覺得挺實用的，因此分享給大家做個參考，一起跟隨小編過來看看吧。

創(chuàng)新互聯(lián)是專業(yè)的容縣網(wǎng)站建設公司，容縣接單;提供成都做網(wǎng)站、網(wǎng)站制作、成都外貿(mào)網(wǎng)站建設,網(wǎng)頁設計,網(wǎng)站設計,建網(wǎng)站,PHP網(wǎng)站建設等專業(yè)做網(wǎng)站服務;采用PHP框架,可快速的進行容縣網(wǎng)站開發(fā)網(wǎng)頁制作和功能擴展;專業(yè)做搜索引擎喜愛的網(wǎng)站,專業(yè)的做網(wǎng)站團隊,希望更多企業(yè)前來合作!

Refer Doc:Administrator’s Guide->2 Creating and Configuring an Oracle Database->Creating a Database with the CREATE DATABASE Statement

Step 1: Specify an Instance Identifier (SID)

[oracle@OCM ~]$ export ORACLE_SID=PROD3

Step 2: Ensure That the Required Environment Variables Are Set

[oracle@OCM ~]$ env |grep ORACLE

ORACLE_SID=PROD3

ORACLE_BASE=/u01/app/oracle/product

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

Step 3: Choose a Database Administrator Authentication Method

[oracle@OCM ~]$ cd $ORACLE_HOME/dbs

[oracle@OCM dbs]$ orapwd file=orapwPROD3 password=oracle entries=30

[oracle@OCM dbs]$ ll

total 12

-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora

-rw-r----- 1 oracle oinstall 5120 Dec  5 07:51 orapwPROD3

Step 4: Create the Initialization Parameter File

[oracle@OCM scripts]$ cat initPROD3.ora

db_name='PROD3'

db_recovery_file_dest=' /u01/app/oracle/product/flash_recovery_area'

db_recovery_file_dest_size=2G

[oracle@OCM product]$ mkdir –p  /u01/app/oracle/product/flash_recovery_area

Step 5: (Windows Only) Create an Instance

Step 6: Connect to the Instance

[oracle@OCM scripts]$ sqlplus / as sysdba

Step 7: Create a Server Parameter File

SQL> CREATE SPFILE FROM PFILE;

Step 8: Start the Instance

SQL>  startup nomount

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size                  2251816 bytes

Variable Size             159384536 bytes

Database Buffers           50331648 bytes

Redo Buffers                5189632 bytes

Step 9: Issue the CREATE DATABASE Statement

[root@OCM ~]# mkdir -p  /u01/app/oracle/oradata/PROD3/redo

[root@OCM ~]# mkdir -p /u01/logs/PROD3

[root@OCM ~]# mkdir -p /u02/logs/PROD3

[root@OCM u01]# cat createdb.sql

CREATE DATABASE PROD3

   USER SYS IDENTIFIED BY sys_password

   USER SYSTEM IDENTIFIED BY system_password

   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD3/redo/redo01a.log','/u01/app/oracle/oradata/PROD3/redo/redo01b.log') SIZE 100M BLOCKSIZE 512,

       GROUP 2 ('/u01/app/oracle/oradata/PROD3/redo/redo02a.log','/u01/app/oracle/oradata/PROD3/redo/redo02b.log') SIZE 100M BLOCKSIZE 512,

       GROUP 3 ('/u01/app/oracle/oradata/PROD3/redo/redo03a.log','/u01/app/oracle/oradata/PROD3/redo/redo03b.log') SIZE 100M BLOCKSIZE 512

   MAXLOGFILES 5

   MAXLOGMEMBERS 5

   MAXLOGHISTORY 1

   MAXDATAFILES 100

   CHARACTER SET AL32UTF8

   NATIONAL CHARACTER SET AL16UTF16

   EXTENT MANAGEMENT LOCAL

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

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

   DEFAULT TABLESPACE users

      DATAFILE '/u01/app/oracle/oradata/PROD3/users01.dbf'

      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

   DEFAULT TEMPORARY TABLESPACE tempts1

      TEMPFILE '/u01/app/oracle/oradata/PROD3/temp01.dbf'

      SIZE 20M REUSE

   UNDO TABLESPACE undotbs

      DATAFILE '/u01/app/oracle/oradata/PROD3/undotbs01.dbf'

      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

SQL>  @/u01/createdb.sql

Database created.

Step 10: Create Additional Tablespaces

Step 11: Run Scripts to Build Data Dictionary Views

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

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

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

Step 12: (Optional) Run Scripts to Install Additional Options

Step 13: Back Up the Database.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  217157632 bytes

Fixed Size                  2251816 bytes

Variable Size             159384536 bytes

Database Buffers           50331648 bytes

Redo Buffers                5189632 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

Step 14: (Optional) Enable Automatic Instance Startup

感謝各位的閱讀！關(guān)于“如何手工創(chuàng)建數(shù)據(jù)庫”這篇文章就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，讓大家可以學到更多知識，如果覺得文章不錯，可以把它分享出去讓更多的人看到吧！

分享名稱：如何手工創(chuàng)建數(shù)據(jù)庫
當前地址：http://vcdvsql.cn/article4/pejpoe.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供App開發(fā)、建站公司、虛擬主機、品牌網(wǎng)站建設、商城網(wǎng)站、網(wǎng)站維護

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)