Manual database creation process for Oracle 9i Database

Today, the customer wants to use Oracle 9.2.0.5, which is no longer supported by aix 6.1, so he has to copy the software from other databases and recompile it. However, you can only create a database manually. I haven't used manual database creation for a long time. I simply recorded the database creation process.

1. Set the oracle user environment

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/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. Create a pfile for startup
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
*. Processses = 1500
*. Query_rewrite_enabled = 'true'
*. Remote_login_passwordfile = 'clusive'
*. 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

1 2 3 Next Page