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

今天客户要用oracle 9.2.0.5，aix 6.1已经不支持了，只好从别的数据库把软件拷贝过来重编译。但是建库只能用手工建库了。很久没有

今天客户要用Oracle 9.2.0.5，，aix 6.1已经不支持了，只好从别的数据库把软件拷贝过来重编译。但是建库只能用手工建库了。很久没有使用手工建库了，简单记录下建库过程

1.设置oracle用户环境

su - oracle

export 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 vi

2.创建启动的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

本文原创发布php中文网，转载请注明出处，感谢您的尊重！