Oracle命令行建库

１、创建必要的相关目录

跟踪文件目录bdump、cdump、udump：mkdiradumpbdumpcdumpudumppfile

数据文件目录mkdirhunter02

2、创建初始化参数文件

3.设置环境变量Oracle_sid

exportORACLE_SID=hunter02

4.创建口令文件orapwdfile=orapwhunter02password=oracleentries=5

5.将数据库启动nomount

6.运行createdatabase建库脚本

CREATEDATABASEhunter02

USERSYSIDENTIFIEDBYoracle

USERSYSTEMIDENTIFIEDBYoracle

LOGFILEGROUP1('/u01/oracle/oradata/hunter02/redo01.log')SIZE100M,

GROUP2('/u01/oracle/oradata/hunter02/redo02.log')SIZE100Mmysql命令行,

GROUP3('/u01/oracle/oradata/hunter02/redo03.log')SIZE100M

MAXLOGFILES5

MAXLOGMEMBERS5

MAXLOGHISTORY1

MAXDATAFILES100

MAXINSTANCES1

CHARACTERSETUS7ASCII

NATIONALCHARACTERSETAL16UTF16

DATAFILE'/u01/oracle/oradata/hunter02/system01.dbf'SIZE325MREUSE

EXTENTMANAGEMENTLOCAL

SYSAUXDATAFILE'/u01/oracle/oradata/hunter02/sysaux01.dbf'SIZE325MREUSE

DEFAULTTEMPORARYTABLESPACEtempts1

TEMPFILE'/u01/oracle/oradata/hunter02/temp01.dbf'

SIZE20MREUSE

UNDOTABLESPACEUNDOTBS1--这里的undotbs1要和初始换参数中的一样

DATAFILE'/u01/oracle/oradata/hunter02/undotbs01.dbf'

SIZE200MREUSEAUTOEXTENDONMAXSIZEUNLIMITED;

7.创建数据字典

SQL>@?/rdbms/admin/catalog

SQL>@?/rdbms/admin/catproc

SQL>connsystem/oracle

SQL>@?/sqlplus/admin/pupbld

（编辑：威海站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!