手工创建数据库

手工创建数据库

一、建立环境变量

ORACLE_BASE=/oracle;export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/9.2.0;export ORACLE_HOME ORACLE_SID=demodb;export ORACLE_SID NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data #JAVA_HOME=/weblogic/bea/jdk141_05 #export JAVA_HOME #PATH=${JAVA_HOME}/bin:$PATH:. #export PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/lib:/usr/lib:/usr/td/lib:/usr/ucblib:/usr/local/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/bin/X11:/usr/local/bin:/usr/sbin:/sbin:$PATH:.;export PATH #LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH set -o vi

二、创建口令文件

cd $ORACLE_HOME/dbs

orapwd file=orapwdemodb password=oracle entries=3;

三、创建初始化参数文件

*.background_dump_dest='/oracle/admin/demodb/bdump' *.COMPATIBLE='9.2.0.0.0' *.control_files='/dev/vgodemodb/rlvcontrol1','/dev/vgodemodb/rlvcontrol2', '/dev/vgodemodb/rlvcontrol3' *.db_block_size=8192 *.db_cache_size=2000000000 *.db_file_multiblock_read_count=16 *.db_files=400# MEDIUM *.db_name='demodb' *.fast_start_mttr_target=300 *.global_names=TRUE *.log_buffer=5000000# SMALL *.log_checkpoint_interval=10000 *.max_dump_file_size='10240' *.parallel_max_servers=4 *.pga_aggregate_target=50m *.processes=200 *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_size=1000000000# SMALL *.undo_management='auto' *.undo_tablespace='UNDOTBS1' *.workarea_size_policy='auto'

四、创建数据库

CREATE DATABASE demodb MAXINSTANCES 1 MAXLOGHISTORY 1 MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 1024 DATAFILE '/dev/vgdemodb/rlvsystem' SIZE 600M REUSE EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/dev/vgdemodb/rlvtemp' SIZE 1996M REUSE UNDO TABLESPACE "UNDOTBS1" DATAFILE '/dev/vgdemodb/rlvundotbs1' SIZE 1996M REUSE CHARACTER SET ZHS16GBK NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ('/dev/vgdemodb/rlvredo1') SIZE 100M, GROUP 2 ('/dev/vgdemodb/rlvredo2') SIZE 100M, GROUP 3 ('/dev/vgdemodb/rlvredo3') SIZE 100M; spool off exit;

五、建立数据库基表

Sqlplus “/ as sysdba”

@ ？/rdbms/admin/catalog.sql

@ ? /rdbms/admin/catproc.sql

Conn system;

@ ?/sqlplus/admin/pupbld.sql

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/19446/viewspace-164213/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/19446/viewspace-164213/