使用脚本创建数据库
切换环境变量export ORACLE_SID=PROD
[oracle@node1 ~]$ export ORACLE_SID=PROD
[oracle@node1 ~]$ env
HOSTNAME=node1
SHELL=/bin/bash
TERM=vt100
HISTSIZE=1000
NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252
USER=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
ORACLE_SID=PROD
ORACLE_BASE=/u01/app/oracle
MAIL=/var/spool/mail/oracle
PATH=/u01/app/oracle/product/11.2.0/dbhome_1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
INPUTRC=/etc/inputrc
PWD=/home/oracle
LANG=en_US.UTF-8
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SHLVL=1
HOME=/home/oracle
LOGNAME=oracle
CVS_RSH=ssh
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
G_BROKEN_FILENAMES=1
_=/bin/env
查看口令文件并创建相应的口令文件
口令文件目录
[oracle@node1 ~]$ cd $ORACLE_HOME/dbs
[oracle@node1 dbs]$ ls
hc_DBUA0.dat init.ora orapworcl peshm_orcl_0
hc_orcl.dat lkORCL peshm_DBUA0_0 spfileorcl.ora
创建口令文件
[oracle@node1 dbs]$ orapwd file=orapwPROD password=ORACLE
[oracle@node1 dbs]$ ls
hc_DBUA0.dat init.ora orapworcl peshm_DBUA0_0 spfileorcl.ora
hc_orcl.dat lkORCL orapwPROD peshm_orcl_0
COPY PFILE文件
[oracle@node1 dbs]$ cp init.ora initPROD.ora
[oracle@node1 dbs]$ ll
total 40
-rw-rw---- 1 oracle oinstall 1544 Mar 24 2015 hc_DBUA0.dat
-rw-rw---- 1 oracle oinstall 1544 Mar 24 2015 hc_orcl.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 2851 Mar 25 17:03 initPROD.ora
-rw-r----- 1 oracle oinstall 24 Mar 24 2015 lkORCL
-rw-r----- 1 oracle oinstall 1536 Mar 24 2015 orapworcl
-rw-r----- 1 oracle oinstall 1536 Mar 25 17:01 orapwPROD
drwx------ 2 oracle oinstall 4096 Mar 24 2015 peshm_DBUA0_0
drwx------ 2 oracle oinstall 4096 Mar 24 2015 peshm_orcl_0
-rw-r----- 1 oracle oinstall 2560 Mar 25 11:52 spfileorcl.ora
修改pfile文件
[oracle@node1 dbs]$ vi initPROD.ora
db_name='PROD'
memory_target=800m
processes = 150
audit_file_dest='/u01/app/oracle/admin/PROD/adump'(查看目录是否存在,防止报错)
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' (查看目录是否存在,防止报错)
db_recovery_file_dest_size=2G
diagnostic_dest='/u01/app/oracle'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = ('/u01/app/oracle/oradata/PROD/disk1/control01.ctl','/u01/app/oracle/oradata/PROD/disk2/control02.ctl')(查看目录是否存在,防止报错)
compatible ='11.2.0'
查看目录是否存在,不存在创建
[oracle@node1 ~]$ ll /u01/app/oracle/admin/PROD/adump
创建5个disk
[oracle@node1 ~]$ mkdir -p /u01/app/oracle/oradata/PROD
[oracle@node1 PROD]$ mkdir disk1
[oracle@node1 PROD]$ mkdir disk2
[oracle@node1 PROD]$ mkdir disk2
[oracle@node1 PROD]$ mkdir disk3
[oracle@node1 PROD]$ mkdir disk4
[oracle@node1 PROD]$ mkdir disk5
[oracle@node1 PROD]$ ls
disk1 disk2 disk3 disk4 disk5
SQL> CREATE SPFILE FROM PFILE;
SQL> startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates
修改kernel.sem为
kernel.sem =5010 641280 5010 128
echo "5010 641280 5010 128" > /proc/sys/kernel/sem
SQL> select status from v$instance;
STATUS
------------
STARTED
1 row selected.
创建执行脚本(根据文档进行更改)
Step 9: Issue the CREATE DATABASE Statement
[oracle@node1 ~]$ vi db_create.sql
CREATE DATABASE PROD
USER SYS IDENTIFIED BY ORACLE
USER SYSTEM IDENTIFIED BY ORACLE
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/disk1/redo01a.log','/u01/app/oracle/oradata/PROD/disk2/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/app/oracle/oradata/PROD/disk2/redo02a.log','/u01/app/oracle/oradata/PROD/disk3/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/app/oracle/oradata/PROD/disk3/redo03a.log','/u01/app/oracle/oradata/PROD/disk1/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/app/oracle/oradata/PROD/disk4/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/disk5/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/PROD/disk1/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/u01/app/oracle/oradata/PROD/disk2/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/u01/app/oracle/oradata/PROD/disk3/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
SQL> select status from v$instance;
STATUS
------------
OPEN
1 row selected.
执行数据字典脚本(根据要求)
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql