水煮oracle28----oracle手工建库步骤

（1）设置环境变量
（2）创建pfile文件
   最少推荐参数：db_name/control_files/memory_target
（3）创建spfile
CREATE SPFILE FROM PFILE;
（4）启动instance
startup nomount

（5）数据库创建脚本
CREATE DATABASE "oracle"
   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/oracle/redo01.log') SIZE 100M BLOCKSIZE 512,
           GROUP 2 ('/u01/app/oracle/oradata/oracle/redo02.log') SIZE 100M BLOCKSIZE 512,
           GROUP 3 ('/u01/app/oracle/oradata/oracle/redo03.log') SIZE 100M BLOCKSIZE 512
   MAXLOGFILES 5
   MAXLOGMEMBERS 5
   MAXLOGHISTORY 1
   MAXDATAFILES 100
   CHARACTER SET ZHS16GBK
   NATIONAL CHARACTER SET UTF8
   EXTENT MANAGEMENT LOCAL
   DATAFILE '/u01/app/oracle/oradata/oracle/system01.dbf' SIZE 325M REUSE
   SYSAUX
   DATAFILE '/u01/app/oracle/oradata/oracle/sysaux01.dbf' SIZE 325M REUSE
   DEFAULT TABLESPACE users
   DATAFILE '/u01/app/oracle/oradata/oracle/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
   DEFAULT TEMPORARY TABLESPACE tempts1
   TEMPFILE '/u01/app/oracle/oradata/oracle/temp01.dbf' SIZE 20M REUSE
   UNDO TABLESPACE undotbs1
   DATAFILE '/u01/app/oracle/oradata/oracle/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
（6）执行数据字典和pl/sql package脚本
 sys： @?/rdbms/admin/catalog.sql
            @?/rdbms/admin/catproc.sql
system:
            @?/rdbms/admin/pupbld.sql

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23890223/viewspace-772480/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23890223/viewspace-772480/