手工创建数据库（Create database manually）.docVIP

手工创建数据库（Create database manually） Scripts and instructions for manually creating databases System environment: 1, operating system: Windows 2000 Server, machine memory 128M 2, database: Oracle, 8i, R2 (8.1.6), for, NT Enterprise Edition 3, installation path: D:\ORACLE Steps of building database: 1, manually create the relevant directory D:\Oracle\admin\test D:\Oracle\admin\test\adhoc D:\Oracle\admin\test\bdump D:\Oracle\admin\test\cdump D:\Oracle\admin\test\create D:\Oracle\admin\test\exp D:\Oracle\admin\test\pfile D:\Oracle\admin\test\udump D:\Oracle\oradata\test D:\Oracle\oradata\test\archive 2, manual creation, initialization, start parameter file: D:\Oracle\admin\test\pfile\inittest.ora, content: Db_name = test Instance_name = Test Service_names = Test Db_files = 1024 Control_files = (D:\Oracle\oradata\test\control01.ctl, D:\Oracle\oradata\test\control02.ctl, D:\Oracle\oradata\test\control03.ctl) Open_cursors = 200 Max_enabled_roles = 30 Db_file_multiblock_read_count = 8 Db_block_buffers = 4096 Shared_pool_size =Large_pool_size =Java_pool_size =Log_checkpoint_interval = 10000 Log_checkpoint_timeout = 1800 Processes = 115 Parallel_max_servers = 5 Log_buffer = 32768 Max_dump_file_size = 10240 Global_names = true Oracle_trace_collection_name = Background_dump_dest = D:\Oracle\admin\test\bdump User_dump_dest = D:\Oracle\admin\test\udump Db_block_size = 16384 Remote_login_passwordfile = exclusive Os_authent_prefix = Job_queue_processes = 4 Job_queue_interval = 60 Open_links = 4 Distributed_transactions = 10 Mts_dispatchers = (PROTOCOL=TCP) (PRE=oracle.aurora.server.SGiopServer) Mts_dispatchers = (protocol=TCP) Compatible = 8.1.0 Sort_area_size = 65536 Sort_area_retained_size = 65536 # log_archive_start = true # log_archive_dest_1 = location=D:\Oracle\oradata\oradb\archive # log_archive_format =%%ORACLE_SID%%T%TS%S.ARC 3, manually create D:\Oracle\Ora81\DATABASE\inittest.ora files, Content: IFILE= D:\Oracle\admin\test\pfile\inittest.ora