创建数据库

                                                              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'

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

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;

SYS@PROD3 > @/home/oracle/files/cr_db.sql
Database created.

SYS@PROD3 > select status from v$instance;

STATUS
------------
OPEN

4.执行必要的脚本

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

conn system/oracle

@?/sqlplus/admin/pupbld.sql

执行脚本的过程需要花费一些时间，这个时候可以做一些其他的题目，最后记得配置tns。

--原创文章，切勿转载