04_create_database

Chapter 4

04_create_database

OLTP

OLAP

create database

OMF

OFA:Optimal Flexible Arch

=====================================

oracle_home:纯软件

oradata：数据文件

admin/*.dump  追踪文件和告警文件

======================================

Creating a Database:

OUI

DBCA

Create database command

ORACLE_BASE

ORACLE_HOME

ORACLE_SID

ORACLE_ORA_NLS33

PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

 EXPORT $LD_LIBRARY_PATH

Creating a DB Manually:

db,instance name

character set

os variables

pfile

nomount stage

create database command

run scripts to generate the data dictionary and accomplish post-creation steps 

create additonal tablespace as needed

1,SID

2,EV

3,Authentication method

4,

手动删除一个数据库：

/oradata

/admin

/dbs

*********************

. ./bbk.env

 *********************

 

 initbbk.ora

 

 spfilebbk.ora

 

 

 09步：

 create database bbk;

strings spfilewilson.ora > initbbk.ora

vi initbbk.ora

:%s/wilson/bbk/g    全局替换

:%s/*\.//g    把*.去掉

创建数据字典，视图

catalog.sql

catproc.sql

pubbld.sql

v$transaction

dba_users

v$session