oralce实验五.docx

如何用命令建立一个数据库？详细说明命令中各个子句的意义。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.0 export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH DISPLAY 2 创建某些目录（存放日志目录，存放数据文件目录，存放控制文件目录，归档目录）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.ora hsj.__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/adumpaudit_trail=dbcompatible=11.2.0.0.0control_files=/u01/app/oradata/hsj/control01.ctl,/u01/app/flash_recovery_area/hsj/control02.ctldb_block_size=8192db_domain=db_name=hsjdb_recovery_file_dest=/u01/app/flash_recovery_areadb_recovery_file_dest_size=4039114752diagnostic_dest=/u01/appdispatchers=(PROTOCOL=TCP) (SERVICE=hsjXDB)log_archive_format=%t_%s_%r.dbfmemory_target=818937856nls_language=AMERICANopen_cursors=300remote_login_passwordfile=EXCLUSIVEundo_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) si