手动创建数据库

使用脚本创建数据库

切换环境变量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