使用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=ORCL export $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