su - oracle

export ORACLE_SID=PROD                              //输出环境变量

--.bash_profile

alias ss="sqlplus '/as sysdba'"                     //设置SQLPLUS的别名

--mkdir                                             //建对应的目录

mkdir -p /u01/app/oracle/admin/PROD/adump

mkdir -p /u01/app/oracle/admin/PROD/bdump

mkdir -p /u01/app/oracle/admin/PROD/cdump

mkdir -p /u01/app/oracle/admin/PROD/udump

mkdir -p /u01/app/oracle/oradata/PROD/disk1

mkdir -p /u01/app/oracle/oradata/PROD/disk2

mkdir -p /u01/app/oracle/oradata/PROD/disk3

mkdir -p /u01/app/oracle/oradata/PROD/disk4

mkdir -p /u01/app/oracle/oradata/PROD/disk5

--initPROD.ora                                       //整理参数文件

cat init.ora | grep -v ^# | grep -v ^$ > initPROD.ora

add as flow

db_name=PROD

sga_max_size=280m

sga_target=280m

control_files = ("/u01/app/oracle/oradata/PROD/disk1/controlfile01.dbf",

                 "/u01/app/oracle/oradata/PROD/disk2/controlfile02.dbf",

                 "/u01/app/oracle/oradata/PROD/disk3/controlfile03.dbf")

*.compatible='10.2.0.1.0'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.log_archive_dest_1='location=/u01/app/oracle/oradata/arch'

*.log_archive_format='%t_%s_%r.dbf'

*.open_cursors=300

*.pga_aggregate_target=83886080

*.processes=500

*.remote_login_passwordfile='EXCLUSIVE'

--startup nomount                                //启动到nomount状态

startup nomount pfile='$ORACLE_HOME/dbs/initPROD.ora

--create spfile

create spfile from pfile;

startup nomount force;

--modify                                         //修改参数

alter system set background_dump_dest='/u01/app/oracle/admin/PROD/bdump' scope=spfile;

alter system set core_dump_dest='/u01/app/oracle/admin/PROD/cdump' scope=spfile;

alter system set user_dump_dest='/u01/app/oracle/admin/PROD/udump' scope=spfile;

alter system set audit_file_dest='/u01/app/oracle/admin/PROD/adump' scope=spfile;

alter system set db_create_file_dest='/u01/app/oracle/oradata/PROD/disk3' scope=spfile;

alter system set db_create_online_log_dest_1='/u01/app/oracle/oradata/PROD/disk1' scope=spfile;

alter system set undo_management=auto scope=spfile;

alter system set undo_tablespace=undotbs scope=spfile;

alter system set job_queue_processes=5 scope=spfile;

startup nomount force;

--password file                                      //建密码文件

orapwd file=orapwPROD password=oracle entries=5 force=y

--create database                                      //手工建库

create database prod

   user sys identified by oracle

   user system identified by oracle

   logfile group 1 ('/u01/app/oracle/oradata/PROD/disk1/redo01.log') size 100m,

           group 2 ('/u01/app/oracle/oradata/PROD/disk1/redo02.log') size 100m,

           group 3 ('/u01/app/oracle/oradata/PROD/disk1/redo03.log') size 100m

   maxlogfiles 30

   maxlogmembers 5

   maxloghistory 1

   maxdatafiles 500

   maxinstances 2

   character set utf8

   national character set utf8

   datafile '/u01/app/oracle/oradata/PROD/disk2/system01.dbf' size 325m reuse extent management local

   sysaux datafile '/u01/app/oracle/oradata/PROD/disk3/sysaux01.dbf' size 325m reuse

   default temporary tablespace tempts1

      tempfile '/u01/app/oracle/oradata/PROD/disk4/temp01.dbf' size 20m reuse

   undo tablespace undotbs

      datafile '/u01/app/oracle/oradata/PROD/disk5/undotbs01.dbf'

      size 200m reuse autoextend on maxsize unlimited;

@?/rdbms/admin/catalog.sql                              //创建数据字典