手动创建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