default temporary tablespace temp
tempfile '/u01/oradata/webdb/temp01.dbf'
size 50M autoextend on next 640K maxsize UNLIMITED;
startup force;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER SYSTEM SWITCH LOGFILE;
（6）@dic.sql
//运行数据字典dic.sql内容如下：
SET VERIFY OFF
connect "SYS"/"password" as SYSDBA
spool dic
@ /rdbms/admin/catalog.sql
@ /rdbms/admin/catproc.sql
@ /rdbms/admin/catblock.sql
@ /rdbms/admin/catoctk.sql
@ /rdbms/admin/owminst.plb
spool off
connect "SYSTEM"/"password"
spool pub
@ /sqlplus/admin/pupbld.sql
@ /sqlplus/admin/help/hlpbld.sql helpus.sql
spool off
（7）@ctab.sql
//ctab.sql 是创建表空间，语法格式如下。
connect "SYS"/"password" as SYSDBA
spool ctab
DROP TABLESPACE BACKUPINCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE BACKUP DATAFILE
'/u01/tabdata/webdb/BACKUP.dbf' SIZE 1320M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
（8）@cuser.sql
//cuser.sql是用来创建用户。
sqlplus / as sysdba
CREATE USER MAINT
IDENTIFIED BY password
DEFAULT TABLESPACE BACKUP
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for MAINT
GRANT CONNECT TO MAINT;
GRANT RESOURCE TO MAINT;
ALTER USER MAINT DEFAULT ROLE ALL;
-- 1 System Privilege for WBXMAINT
GRANT UNLIMITED TABLESPACE TO MAINT;
==============================================================================
Done
基于以上步骤，就可以so easy且有所得滴创建一个instance。
还需要在listener 以及tns 文件上天剑才能进行网络连接。后面会给大家分享OracleDB连接方式时，再详细介绍。
希望对您有帮助，有什么可以帮您？请留言。