Cd $ORACLE_HOME/dbs
Cat init.ora | grep -v ^# | grep -v ^$ > initHEXJ.ora
CREATE DATABASE hfxj
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 (/u01/app/oracle/redo01a.log,/u01/app/oracle/redo01b.log) SIZE 100M BLOCKSIZE 512,
GROUP 2 (/u01/app/oracle/redo02a.log,/u01/app/oracle/redo02b.log) SIZE 100M BLOCKSIZE 512,
GROUP 3 (/u01/app/oracle/redo03a.log,/u01/app/oracle/redo03b.log) SIZE 100M BLOCKSIZE 512
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE /u01/app/oracle/oradata/system01.dbf
SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
SYSAUX DATAFILE /u01/app/oracle/oradata/sysaux01.dbf
SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
DEFAULT TABLESPACE users
DATAFILE /u01/app/oracle/oradata/users01.dbf
SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE /u01/app/oracle/oradata/temp01.dbf
SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE undotbs1
DATAFILE /u01/app/oracle/oradata/undotbs01.dbf
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
文章版權(quán)歸作者所有,未經(jīng)允許請(qǐng)勿轉(zhuǎn)載,若此文章存在違規(guī)行為,您可以聯(lián)系管理員刪除。
轉(zhuǎn)載請(qǐng)注明本文地址:http://systransis.cn/yun/129372.html
閱讀 1358·2023-01-11 13:20
閱讀 1707·2023-01-11 13:20
閱讀 1215·2023-01-11 13:20
閱讀 1907·2023-01-11 13:20
閱讀 4165·2023-01-11 13:20
閱讀 2759·2023-01-11 13:20
閱讀 1402·2023-01-11 13:20
閱讀 3673·2023-01-11 13:20