oracle 11g ocm 考试--创建数据库
联机文档的目录地址
Database Administration>>Administrator's Guide>>
2 Creating and Configuring an Oracle Database>>Creating a Database with the CREATE DATABASE Statement>>Step 9: Issue the CREATE DATABASE Statement
考试的时候要求创建PROD3数据库
1.创建参数文件
export ORACLE_SID=PROD3
cd $ORACLE_HOME/dbs
[oracle@gridcontrol dbs]$ vi initPROD3.ora
memory_target=500m
db_name=PROD3
control_files='/home/oracle/app/oradata/PROD3/control01.ctl','/home/oracle/app/oradata/PROD3/control02.ctl'
memory_target=500m
db_name=PROD3
control_files='/home/oracle/app/oradata/PROD3/control01.ctl','/home/oracle/app/oradata/PROD3/control02.ctl'
2.启动数据库到nomount
[oracle@gridcontrol dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 21 16:19:52 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
select instance_name from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SYS@PROD3 > create spfile from pfile;
File created.
SYS@PROD3 > startup nomount;
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2229944 bytes
Variable Size 343935304 bytes
Database Buffers 167772160 bytes
Redo Buffers 7999488 bytes
SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 21 16:19:52 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
select instance_name from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SYS@PROD3 > create spfile from pfile;
File created.
SYS@PROD3 > startup nomount;
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2229944 bytes
Variable Size 343935304 bytes
Database Buffers 167772160 bytes
Redo Buffers 7999488 bytes
3.执行创建数据库脚本
[oracle@gridcontrol files]$ vi cr_db.sql
CREATE DATABASE PROD3
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/home/oracle/app/oradata/PROD3/redo01a.log','/home/oracle/app/oradata/PROD3/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/home/oracle/app/oradata/PROD3/redo02a.log','/home/oracle/app/oradata/PROD3/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/home/oracle/app/oradata/PROD3/redo03a.log','/home/oracle/app/oradata/PROD3/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/home/oracle/app/oradata/PROD3/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/home/oracle/app/oradata/PROD3/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/home/oracle/app/oradata/PROD3/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/home/oracle/app/oradata/PROD3/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/home/oracle/app/oradata/PROD3/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
CREATE DATABASE PROD3
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/home/oracle/app/oradata/PROD3/redo01a.log','/home/oracle/app/oradata/PROD3/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/home/oracle/app/oradata/PROD3/redo02a.log','/home/oracle/app/oradata/PROD3/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/home/oracle/app/oradata/PROD3/redo03a.log','/home/oracle/app/oradata/PROD3/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/home/oracle/app/oradata/PROD3/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/home/oracle/app/oradata/PROD3/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/home/oracle/app/oradata/PROD3/users01.dbf'
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/home/oracle/app/oradata/PROD3/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/home/oracle/app/oradata/PROD3/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
SYS@PROD3 > @/home/oracle/files/cr_db.sql
Database created.
SYS@PROD3 > select status from v$instance;
Database created.
SYS@PROD3 > select status from v$instance;
STATUS
------------
OPEN
------------
OPEN
4.执行必要的脚本
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
conn system/oracle
@?/sqlplus/admin/pupbld.sql
执行脚本的过程需要花费一些时间,这个时候可以做一些其他的题目,最后记得配置tns。
--原创文章,切勿转载