通过命令创建Oracle 11g数据库

本文简单介绍通过Oracle数据库的create database命令创建一个符合OFA规范的Oracle数据库。1 设置环境变量（vi .bash_profile或者是保存为一个可执行文件执行创建）ORACLE_BASE=/u01/appORACLE_HOME=$ORACLE_HOME/oracleORACLE_SID=hsjPATH=$ORACLE_HOME/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATHDISPLAY==192.168.138.1:0.0export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH DISPLAY2 创建某些目录（存放日志目录，存放数据文件目录，存放控制文件目录，归档目录）mkdir -p /u01/app/flash_recovery_area/hsjmkdir -p /u01/app/diag/rdbms/hsj #用来存放alert trace 跟踪日志mkdir -p /u01/app/oradata/hsj/archive # 用来存放归档日志，上一级目录用来存放控制文件和数据文件、联机日志文件mkdir -p /u01/app/admin/hsj/adumpmkdir -p /u01/app/admin/hsj/dpdumpmkdir -p /u01/app/admin/hsj/pfilemkdir -p /u01/app/admin/hsj/scripts3 创建参数文件 inithsj.ora,并且通过inithsj.ora 创建spfile，spfile文件必须存放$ORACLE_HOME/dbs/目录下面mkdirinithsj.ora 文件类容（某些参数需要根据实际环境进行修改）v inithsj.orahsj.__db_cache_size=327155712hsj.__java_pool_size=4194304hsj.__large_pool_size=4194304hsj.__oracle_base="/u01/app"#ORACLE_BASE set from environmenthsj.__pga_aggregate_target=331350016hsj.__sga_target=490733568hsj.__shared_io_pool_size=0hsj.__shared_pool_size=146800640hsj.__streams_pool_size=0audit_file_dest="/u01/app/admin/hsj/adump"audit_trail="db"compatible="11.2.0.0.0"control_files="/u01/app/oradata/hsj/control01.ctl","/u01/app/flash_recovery_area/hsj/control02.ctl"db_block_size=8192db_domain=""db_name="hsj"db_recovery_file_dest="/u01/app/flash_recovery_area"db_recovery_file_dest_size=4039114752diagnostic_dest="/u01/app"dispatchers="（PROTOCOL=TCP）（SERVICE=hsjXDB）"log_archive_format="%t_%s_%r.dbf"memory_target=818937856nls_language="AMERICAN"open_cursors=300remote_login_passwordfile="EXCLUSIVE"undo_tablespace="UNDOTBS1"sqlplus / as sysdbacreate spfile from pfile #需要确保是在dbs目录下，否则需要指定具体的pfile文件路径和名称4 启动数据库到nomount状态Startup nomount;5 创建数据库脚本 createdb.sqlspool createdb.logcreate database hsjuser sys identified by rootuser system identified by rootlogfile group 1（"/u01/app/oradata/hsj/redo01.log"） size 50M blocksize 512,group 2（"/u01/app/oradata/hsj/redo02.log"） size 50M blocksize 512,group 3（"/u01/app/oradata/hsj/redo03.log"） size 50M blocksize 512maxlogfiles 30maxlogmembers 5maxloghistory 1maxdatafiles 100character set al32utf8national character set al16utf16extent management localdatafile "/u01/app/oradata/hsj/system01.dbf" size 300M reusesysaux datafile "/u01/app/oradata/hsj/sysaux01.dbf" size 300M reusedefault tablespace usersdatafile "/u01/app/oradata/hsj/users01.dbf" size 300M reuseautoextend on maxsize unlimiteddefault temporary tablespace tempts1tempfile "/u01/app/oradata/hsj/temp01.dbf" size 20M reuseundo tablespace UNDOTBS1datafile "/u01/app/oradata/hsj/undotbs01.dbf"size 200M reuse autoextend on maxsize unlimited;spool off6 进入到sqlplus执行创建数据库的脚本@createdb.sql7 如果有报错，请查看createdb.log alert日志和trace日志8 进入到 $ORACLE_HOME/rdbms/admin目录，执行创建数据字典的sql和创建系统包的sql@catalog.sql@catproc.sql --------------------------------------分割线 --------------------------------------Oracle 11g 在RedHat Linux 5.8_x64平台的安装手册 http://www.linuxidc.com/Linux/2014-07/104745.htmLinux-6-64下安装Oracle 12C笔记 http://www.linuxidc.com/Linux/2013-07/86805.htm在CentOS 6.4下安装Oracle 11gR2（x64） http://www.linuxidc.com/Linux/2014-02/97374.htmOracle 11gR2 在VMWare虚拟机中安装步骤 http://www.linuxidc.com/Linux/2013-09/89579p2.htmDebian 下安装 Oracle 11g XE R2 http://www.linuxidc.com/Linux/2014-03/98881.htm更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址