oracle+转换成omf,Oracle 11g r2基于OMF方式手工创建数据库

1)、使用OMF特性可以帮助我们最快的完成手工创建数据库

2)、借助联机文档路径：Database Administration -> Administrator's Guide -> 2 Creating and Configuring an Oracle Database

Step 1: Specify an Instance Identifier (SID)

[oralce@localhost]$ export $ORACLE_SID=ORCL

Step 2: Ensure That the Required Environment Variables Are Set[oralce@localhost]$ vim .bash_profile

export $ORACLE_SID=ORCLexport $ORACLE_BASE=/u01/app/oracle

export $ORACLE_HOME=$ORACLE_BASE/produce/11.2.0/dbhome_1

export PATH=.:$PATH:/usr/sbin:$ORACLE_HOME/bin:$HOME/bin[oralce@localhost]$ source ./bash_profile

Step 3: Choose a Database Administrator Authentication Method

[oralce@localhost]$ cd $ORACLE_HOME/bin

[oralce@localhost]$ orapwd file=?/dbs/orapwORCL password=oracle entries=30 force=y

[oralce@localhost]$ mkdir -p /u01/app/oracle/oradata/ORCL/

Step 4: Create the Initialization Parameter File

[oralce@localhost]$ cd $ORACLE_HOME/dbs

[oralce@localhost]$ vim initORCL.ora

DB_NAME=ORCL

instance_name=ORCL

control_files='/u01/app/oracle/oradata/ORCL/control01.ctl','/u01/app/oracle/oradata/ORCL/control02.ctl'

sga_target=600M

Step 5: (Windows Only) Create an Instance  //Windows系统必须创建，Linux系统不需创建

Step 6: Connect to the Instance

[oralce@localhost]$ cd $ORACLE_HOE/bin

[oralce@localhost]$ ./sqlplus / as sysdba;

SQL>

Step 7: Create a Server Parameter File

[oralce@localhost]$ ./sqlplus sys/oracle as sysdba;

SQL> startup;

SQL> create spfile from pfile;

Step 8: Start the Instance

SQL> startup force;

SQL> show parameters db_unique_name;

SQL> show parameters instance_name;

9、Issue the CREATE DATABASE Statement

创建数据库0分点：

1)、Instance_name大小写敏感

2)、创建时默认Oracle_Home位于GC下面

3)、忘记创建control file

4)、忘记添加UNDO与TEMP表空间或者没有打开文件大小自动扩展功能

5)、采用了MEMORY_TARGET参数而没有足够的内存

6)、所给的init文件可能并非是在要求安装的机器上

7)、忘记create spfile from pfile

8)、从联机文档样本文件拷贝的文本、命令可能含有转义字符

9)、忘记创建临时表空间

创建数据库采用OMF方式是最快的方式

db_create_file_dest

db_create_online_log_dest_1

db_recovery_file_dest

创建数据库使用哪一个最方便？

SQL> show parameter db_c

SQL> alter system set db_create_file_dest='/u01/app/oracle/oradata/ORCL';

SQL> CREATE DATABASE CHARACTER SET ZHS16GBK EXTENT MANAGEMENT LOCAL;

CREATE DATABASE会自动创建system、sysaux、undo、temp表空间

SQL> select * from dba_data_files; //查询报错证明数据字典没有创建

Step 10: Create Additional Tablespaces

SQL> CREATE TABLESPACE users LOGGING DATAFILE '/u01/app/oracle/oradata/ORCL/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

-- create a tablespace for indexes, separate from user tablespace (optional)

SQL> CREATE TABLESPACE indx_users LOGGING DATAFILE '/u01/app/oracle/oradata/ORCL/indx01.dbf' SIZE 100M REUSE AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;

Step 11: Run Scripts to Build Data Dictionary Views

SQL> @?/rdbms/admin/catalog.sql

SQL> select * from dba_tables;

SQL> @?/rdbms/admin/catproc.sql

In SQL*Plus, connect to your Oracle Database instance as SYSTEM user:

SQL> alter user system identified by oralce;

SQL> conn system/oracle;

SQL> @?/sqlplus/admin/pupbld.sql

Step 12: (Optional) Run Scripts to Install Additional Options

Step 13: Back Up the Database.

Step 14: (Optional) Enable Automatic Instance Startup