su - oracle
export ORACLE_SID=PRD
vi init.ora:
*.compatible='9.2.0.0.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/PRD/origlogA/cntrlPRD.dbf'
*.core_dump_dest='/orasys/oracle/admin/PRD/cdump'
*.db_block_size=8192
*.db_cache_size=17179869
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='PRD'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.java_pool_size=0
*.job_queue_processes=2
*.large_pool_size=524288000
*.LOG_ARCHIVE_FORMAT='log_%t_%s.arc'
*.nls_date_format='YYYY-MM-DD'
*.open_cursors=10000
*.optimizer_mode='FIRST_ROWS_10'
*.pga_aggregate_target=838860800
*.processes=900
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='exclusive'
*.shared_pool_size=2147483648
*.sort_area_size=52428800
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.user_dump_dest='/orasys/oracle/admin/PRD/udump'
*.LOG_ARCHIVE_DEST_1='LOCATION=/oracle/PRD/oraarch'
orapwd file='/orasys/oracle/product/9.2.5/dbs/orapwPRD' password=sys entries=5
SQL>startup mount pfile='init.ora'
SQL>alter database open;
Database altered.
