Oracle 9i数据库手工建库过程简记

今天客户要用Oracle 9.2.0.5，aix 6.1已经不支持了，只好从别的数据库把软件拷贝过来重编译。但是建库只能用手工建库了。很久没有使用手工建库了，简单记录下建库过程1.设置oracle用户环境su - oracleexport ORACLE_SID=radius
export ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH$ORACLE_BASE/product/9.2.0/lib
export TNS_ADMIN=$ORACLE_BASE/product/9.2.0/network/admin
export PATH=/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/oracle/bin:$ORACLE_BASE/product/9.2.0/bin
export ORACLE_TERM=xterm
export CLASSPATH=$ORACLE_BASE/product/9.2.0/JRE:$ORACLE_BASE/product/9.2.0/jlib:$ORACLE_BASE/product/9.2.0/rdbms/jlib:/oracle/product/9.2.0/network/jlib
export ORA_NLS33=$ORACLE_BASE/product/9.2.0/ocommon/nls/admin/data
umask 022
set -o vi2.创建启动的pfile文件
cat /home/oracle/yd.ora*.aq_tm_processes=1
*.background_dump_dest="/u01/app/oracle/admin/dcmsuat/bdump"
*.compatible="9.2.0.0.0"
*.control_files="/u01/app/oracle/oradata/dcmsuat/control01.ctl","/u01/app/oracle/oradata/dcmsuat/control02.ctl","/u01/app/oracle/or
adata/dcmsuat/control03.ctl"
*.core_dump_dest="/u01/app/oracle/admin/dcmsuat/cdump"
*.db_block_size=8192
*.db_cache_size=86777216
*.db_domain="dcmsuat"
*.db_file_multiblock_read_count=16
*.db_name="dcmsuat"
*.fast_start_mttr_target=300
*.hash_area_size=1048576
*.hash_join_enabled=TRUE
*.instance_name="dcmsuat"
*.java_pool_size=83886080
*.job_queue_processes=10
*.large_pool_size=16777216
*.log_archive_dest="/u01/app/oracle/arch/dcmsuat/"
*.log_archive_format="%S.dat"
*.log_archive_start=TRUE
*.open_cursors=3000
*.pga_aggregate_target=33554432
*.processes=1500
*.query_rewrite_enabled="TRUE"
*.remote_login_passwordfile="EXCLUSIVE"
*.resource_limit=TRUE
*.shared_pool_size=183886080
*.sort_area_size=5048576
*.star_transformation_enabled="TRUE"
*.timed_statistics=TRUE
*.undo_management="AUTO"
*.undo_retention=10800
*.undo_tablespace="undotbs"
*.user_dump_dest="/u01/app/oracle/admin/dcmsuat/udump"
mkdir -p /u01/app/oracle/admin/dcmsuat/bdump
mkdir -p /u01/app/oracle/admin/dcmsuat/cdump
mkdir -p /u01/app/oracle/admin/dcmsuat/udump
mkdir -p /u01/app/oracle/admin/dcmsuat/pfile
mkdir -p /u01/app/oracle/admin/dcmsuat/create
mkdir -p /u01/app/oracle/oradata/dcmsuat

Oracle 11g R2 RAC环境下修改主机名用SQL语言管理Oracle数据库相关资讯 Oracle 9i Oracle建库 Oracle手工建库

Red Hat Enterprise Linux AS4, C+ （03月06日）
静默方式安装Oracle 10g数据库软件（08/30/2014 06:38:18）
Oracle 9i配置Statspack工具（05/05/2014 20:06:15）

Oracle 10g 快速手工建库步骤（01/11/2015 07:48:57）
Oracle 10g AND Oracle 11g手工建（05/22/2014 11:01:52）
Oracle通过软连接裸设备建库（03/11/2014 14:09:35）

本文评论查看全部评论（0）