手動建立ORACLE資料庫執行個體

1、首先設定ORACLE_SID=manual

2、建立密碼檔案

進入/u01/app/oracle/product/10.2.0/db_1/dbs目錄下，執行命令建立資料庫密碼檔案

[oracle@myorcl dbs]$ orapwd file=orapmanual password=oracle

3、建立所需的目錄結構

[oracle@myorcl dbs]$ cd /u01/app/oracle/admin/

[oracle@myorcl admin]$ mkdir manual

然後進入manual目錄建立一下檔案

[oracle@myorcl manual]$ ls

adumpbdumpcdumppfileudump

4、建立所需的參數檔案

[oracle@myorcl ~]$ cd /u01/app/oracle/admin/manual/pfile/

[oracle@myorcl pfile]$ vi init.ora

db_name=manual

db_domain=""

sga_target=285212672

pga_aggregate_target=94371840

db_block_size=8192

db_file_multiblock_read_count=16

open_cursors=300

processes=150

background_dump_dest=/u01/app/oracle/admin/manual/bdump

core_dump_dest=/u01/app/oracle/admin/manual/cdump

user_dump_dest=/u01/app/oracle/admin/manual/udump

audit_file_dest=/u01/app/oracle/admin/manual/adump

control_files=("/u01/app/oracle/oradata/manual/control01.ctl",/u01/app/oracle/oradata/manual/control02.ctl)

db_recovery_file_dest=/u01/app/oracle/flash_recovery_area/manual/

db_recovery_file_dest_size=2147483648

log_archive_format=%t_%s_%r.dbf

compatible=10.2.0.1.0

remote_login_passwordfile=EXCLUSIVE

undo_management=AUTO

undo_tablespace=UNDOTBS1