（一些重点需要修改的地方我做的笔记并截图，放在文章最后。）

安装数据库软件并设置环境变量就不说了

点击(此处)折叠或打开

创建参数文件

点击(此处)折叠或打开

$ cd $ORACLE_HOME/dbs
$ cat init.ora |grep -v ^# |grep -v ^$ >initPROD1.orp
$ vi initPROD1.orp
db_name='PROD1'
memory_target=1G
processes = 150
audit_file_dest='/u01/app/oracle/admin/PROD1/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
dispatchers='(PROTOCOL=TCP) (SERVICE=PROD1XDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files = (/u01/app/oracle/oradata/PROD1/control01.ctl,/u01/app/oracle/fast_recovery_area/PROD1/control02.ctl)
compatible ='11.2.0'

创建目录

点击(此处)折叠或打开

设置edit调用vi（以下设置为永久生效）（临时可用ed _define=vim）

点击(此处)折叠或打开

启动数据库到nomount状态

点击(此处)折叠或打开

清空然后添加一下内容并更改(创建建库脚本并执行）

点击(此处)折叠或打开

点击(此处)折叠或打开

CREATE DATABASE PROD1
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD1/redo01a.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/PROD1/redo02a.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/PROD1/redo03a.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/PROD1/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD1/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/PROD1/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/PROD1/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/PROD1/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
/

执行

点击(此处)折叠或打开

创建数据字典

点击(此处)折叠或打开

创建内部包

点击(此处)折叠或打开

执行pupbld脚本

点击(此处)折叠或打开

至此创建OK

创建建库脚本部分

ITPub博客

oracle 11g 手动建库