linux系統(tǒng)中怎么創(chuàng)建數(shù)據(jù)庫

這期內(nèi)容當(dāng)中小編將會給大家?guī)碛嘘P(guān)linux系統(tǒng)中怎么創(chuàng)建數(shù)據(jù)庫，文章內(nèi)容豐富且以專業(yè)的角度為大家分析和敘述，閱讀完這篇文章希望大家可以有所收獲。

一：系統(tǒng)環(huán)境：Red Hat Enterprise Linux Server release 5.4

ORACLE版本Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

二：

1/首先安裝數(shù)據(jù)庫軟件

2.設(shè)置環(huán)境變量

3.創(chuàng)建需要的目錄

4.創(chuàng)建參數(shù)文件pfile

5.創(chuàng)建密碼文件

6.數(shù)據(jù)庫啟動到numount，創(chuàng)建Oracle的建庫腳本

7.創(chuàng)建Oracle的數(shù)據(jù)字典

1.首先安裝數(shù)據(jù)庫軟件；安裝rlwrap軟件。

2.設(shè)置環(huán)境變量

export PATH

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export ORACLE_SID=willson

export PATH=$PATH:$ORACLE_HOME/bin

alias sqlplus='rlwrap sqlplus'

alias   rman='rlwrap rman'

3.創(chuàng)建需要的目錄

mkdir -p $ORACLE_BASE/oradata/willson

mkdir -p $ORACLE_BASE/admin/willson/adump

mkdir -p $ORACLE_BASE/admin/willson/bdump

mkdir -p $ORACLE_BASE/admin/willson/pfile

4.創(chuàng)建參數(shù)文件

 cd cd $ORACLE_HOME/dbs

 vim initwillson.ora

audit_file_dest='/u01/app/oracle/admin/willson/adump'

audit_trail='db'

compatible='11.2.0.0.0'

control_files='/u01/app/oracle/oradata/willson/control01.ctl','/u01/app/oracle/oradata/willson/control02.ctl'

db_block_size=8192

db_domain=''

db_name='willson'

diagnostic_dest='/u01/app/oracle'

memory_target=442006528

open_cursors=300

processes=150

remote_login_passwordfile='EXCLUSIVE'

sessions=170

undo_tablespace='UNDOTBS1'

登陸到sqlplus / as sysdba

創(chuàng)建spfile

 create spfile from pfile

5.創(chuàng)建密碼文件

 orapwd file=orapwwillson password=willson entries=10 創(chuàng)建密碼文件

6.數(shù)據(jù)庫啟動到nomount，創(chuàng)建ORACLE的建庫腳本

spool willson_dbcreate.log;

create database "willson"

character set "AL32UTF8"

national character set AL16UTF16

datafile '/u01/app/oracle/oradata/willson/system01.dbf' size 500M

SYSAUX DATAFILE '/u01/app/oracle/oradata/willson/sysaux01.dbf' SIZE 100M

UNDO TABLESPACE "UNDOTBS1"

DATAFILE '/u01/app/oracle/oradata/willson/undotbs01.dbf' SIZE 200M

DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/app/oracle/oradata/willson/temp01.dbf' SIZE 300M

DEFAULT TABLESPACE uses DATAFILE '/u01/app/oracle/oradata/willson/user01.dbf' SIZE 20m

logfile GROUP 1 (

'/u01/app/oracle/oradata/willson/redo01a.rdo',

'/u01/app/oracle/oradata/willson/redo01b.rdo'

) SIZE 100M,

GROUP 2 (

'/u01/app/oracle/oradata/willson/redo02a.rdo',

'/u01/app/oracle//oradata/willson/redo02b.rdo'

) SIZE 100M,

GROUP 3 (

'/u01/app/oracle/oradata/willson/redo03a.rdo',

'/u01/app/oracle/oradata/willson/redo03b.rdo'

) SIZE 100M;

spool off

7.創(chuàng)建ORACLE數(shù)據(jù)字典

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

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

catalog.sql----創(chuàng)建數(shù)據(jù)字典基表和數(shù)據(jù)字典視圖

catproc.sql----安裝oracle系統(tǒng)包

上述就是小編為大家分享的linux系統(tǒng)中怎么創(chuàng)建數(shù)據(jù)庫了，如果剛好有類似的疑惑，不妨參照上述分析進行理解。如果想知道更多相關(guān)知識，歡迎關(guān)注億速云行業(yè)資訊頻道。