OMF

$ : cd $ORACLE_HOME/dbs $: export ORACLE_SID=omfdb $： vi initomfdb.ora [oracle@linux dbs]$ cat initomfdb.ora DB_NAME='omfdb' MEMORY_TARGET=900M db_create_file_dest = '/u01/app/oracle/oradata/omfdb' $: mkdir -p /u01/app/oracle/oradata/omfdb 登入数据库 > create spfile from pfile; > startup nomount; > create database; > @?/rdbms/admin/catalog.sql ； > @?/rdbms/admin/catproc.sql ； > @?/rdbms/admin/utlrp.sql 切换为system用户 ，运行最后一个脚本 [oracle@linux02 ~]$ sqlplus system/oracle ； > @?/sqlplus/admin/pupbld.sql ； 查看自动创建的文件大小、命名 select file_name,tablespace_name,bytes/1024/1024||'M' M from dba_data_files; 以下为文档： [oracle@linux02 ~]$ vi .bash_profile export ORACLE_SID=hldb export ORACLE_UNQNAME=hldb [oracle@linux02 ~]$ source .bash_profile [oracle@linux02 oradata]$ cd /u01/app/oracle/oradata [oracle@linux02 oradata]$ pwd /u01/app/oracle/oradata [oracle@linux02 oradata]$ mkdir hldb [oracle@linux02 ~]$ cd $ORACLE_HOME/dbs [oracle@linux02 dbs]$ orapwd file=orapwhldb password=oracle [oracle@linux02 dbs]$ vi inithldb.ora DB_NAME='hldb' CONTROL_FILES='/u01/app/oracle/oradata/hldb/control01.ctl' MEMORY_TARGET=900M [oracle@linux02 dbs]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 23 10:03:27 2018 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to an idle instance. SQL> create spfile from pfile; File created. SQL> startup nomount; ORACLE instance started. Total System Global Area  939495424 bytes Fixed Size                  2233960 bytes Variable Size             545261976 bytes Database Buffers          385875968 bytes Redo Buffers                6123520 bytes CREATE DATABASE hldb USER SYS IDENTIFIED BY oracle USER SYSTEM IDENTIFIED BY oracle LOGFILE GROUP 1 ('/u01/app/oracle/oradata/hldb/redo01.log') SIZE 100M BLOCKSIZE 512, GROUP 2 ('/u01/app/oracle/oradata/hldb/redo02.log') SIZE 100M BLOCKSIZE 512, GROUP 3 ('/u01/app/oracle/oradata/hldb/redo03.log') SIZE 100M BLOCKSIZE 512 MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 1 MAXDATAFILES 100 CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL DATAFILE '/u01/app/oracle/oradata/hldb/system01.dbf' SIZE 325M REUSE SYSAUX DATAFILE '/u01/app/oracle/oradata/hldb/sysaux01.dbf' SIZE 325M REUSE DEFAULT TABLESPACE users DATAFILE '/u01/app/oracle/oradata/hldb/users01.dbf' SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/hldb/temp01.dbf' SIZE 20M REUSE UNDO TABLESPACE undotbs DATAFILE '/u01/app/oracle/oradata/hldb/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; ------------------------------------------------------------------------------------------------- SQL> CREATE DATABASE hldb 2     USER SYS IDENTIFIED BY oracle 3     USER SYSTEM IDENTIFIED BY oracle 4     LOGFILE GROUP 1 ('/u01/app/oracle/oradata/hldb/redo01.log') SIZE 100M BLOCKSIZE 512, 5             GROUP 2 ('/u01/app/oracle/oradata/hldb/redo02.log') SIZE 100M BLOCKSIZE 512, 6             GROUP 3 ('/u01/app/oracle/oradata/hldb/redo03.log') SIZE 100M BLOCKSIZE 512 7     MAXLOGFILES 5 8     MAXLOGMEMBERS 5 9     MAXLOGHISTORY 1 10     MAXDATAFILES 100 11     CHARACTER SET AL32UTF8 12     NATIONAL CHARACTER SET AL16UTF16 13     EXTENT MANAGEMENT LOCAL 14     DATAFILE '/u01/app/oracle/oradata/hldb/system01.dbf' SIZE 325M REUSE 15     SYSAUX DATAFILE '/u01/app/oracle/oradata/hldb/sysaux01.dbf' SIZE 325M REUSE 16     DEFAULT TABLESPACE users 17        DATAFILE '/u01/app/oracle/oradata/hldb/users01.dbf' 18        SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED 19     DEFAULT TEMPORARY TABLESPACE tempts1 20        TEMPFILE '/u01/app/oracle/oradata/hldb/temp01.dbf' 21        SIZE 20M REUSE 22     UNDO TABLESPACE undotbs 23        DATAFILE '/u01/app/oracle/oradata/hldb/undotbs01.dbf' 24        SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; Database created. ------------------------------------------------------------------------------------------------- In SQL*Plus, connect to your Oracle Database instance with the SYSDBA administrative privilege: [oracle@linux02 ~]$ sqlplus / as sysdba > @?/rdbms/admin/catalog.sql > @?/rdbms/admin/catproc.sql > @?/rdbms/admin/utlrp.sql In SQL*Plus, connect to your Oracle Database instance as SYSTEM user: [oracle@linux02 ~]$ sqlplus system/oracle > @?/sqlplus/admin/pupbld.sql