To manually create an Oracle database instance

1, first set oracle_sid=manual

2. Create a password file

Enter/u01/app/oracle/product/10.2.0/db_1/dbs directory, execute command to create database password file

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

3, create the desired directory structure

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

[Oracle@myorcl admin]$ mkdir Manual

Then go into the manual directory and create the file.

[ORACLE@MYORCL manual]$ ls

Adumpbdumpcdumppfileudump

4, create the required parameter files

[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