oracle11g手工建库.docVIP

oracle11g手工建库 oracle手工建库过程记录 环境：VM6.0 + centos4.7 + ORACLE11gR1 用手工建库，实践成功！ 虽然其中的参数设置，有很多不合理的地方，但至少前进了一大步， 终于把linux + oracle 环境搭建起来了 step1: 创建脚本lijl.env export ORACLE_BASE=/oracle/app export ORACLE_HOME=$ORACLE_BASE/product export ORACLE_SID=lijl export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/bin:/usr/lib export PATH=$ORACLE_HOME/bin:$PATH 在.profile 添加 . ./lijl.env 编译 . ./.profile step2: 创建口令文件 在/oracle/app/product/dbs 目录下 orapwd是一个unix命令：直接在命令行下执行， 不是在SQL orapwd file=orapwlijl password=oracle entries=10 step3: 建好数据库需要的目录 存放进程跟踪文件,执行lijlmkdir.sh #!/bin/sh OLD_UMASK=`umask` umask 0027 mkdir -p /oracle/app/admin/lijl/adump mkdir -p /oracle/app/admin/lijl/dpdump mkdir -p /oracle/app/admin/lijl/pfile mkdir -p /oracle/app/oradata/lijl mkdir -p /oracle/app/cfgtoollogs/dbca/lijl mkdir -p /oracle/app/flash_recovery_area/lijl/archivelog mkdir -p /oracle/app/oradata/lijl umask ${OLD_UMASK} 存放控制文件/数据文件 /oracle/app/oradata/lijl 存放参数/密码文件: /oracle/app/product/dbs initlijl.ora orapwlijl step4: 创建初始化参数文件initlijl.ora lijl.__db_cache_sizelijl.__java_pool_size=4194304 lijl.__large_pool_size=4194304 lijl.__oracle_base=/oracle/app#ORACLE_BASE set from environment lijl.__pga_aggregate_target=205520896 lijl.__sga_target=155189248 lijl.__shared_io_pool_size=0 lijl.__shared_pool_size=113246208 lijl.__streams_pool_size=0 *.audit_file_dest=/oracle/app/admin/lijl/adump *.audit_trail=db *.compatible=.0 *.control_files=/oracle/app/oradata/lijl/controlfile/ctl01.ctl,/oracle/app/oradata/lijl/controlfile/ctl02.ctl,/oracle/app/oradata/lijl/controlfile/ctl03.ctl *.db_block_size=8192 *.db_create_file_dest=/oracle/app/oradata *.db_domain= *.db_name=lijl *.db_recovery_file_dest=/oracle/app/flash_recovery_area *.db_recovery_file_dest_size=2147483648 *.diagnostic_dest=/oracle/app *.dispatchers=(PROTOCOL=TCP) (SERVICE=lijlXDB) *.log_archive_format=%t_%s_%r.dbf *.memory_target=358612992 *.open_curso