Oracle数据库的创建可以通过几种不同的方法实现,下面我将介绍最常用的几种方式:
DBCA是Oracle提供的图形化工具,适合初学者使用:
dbca
(在Windows上) 或 dbca &
(在Linux/Unix上)适合有经验的DBA进行更精细的控制:
sqlplus / as sysdba
STARTUP NOMOUNT
执行CREATE DATABASE命令:
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY sys_password
USER SYSTEM IDENTIFIED BY system_password
LOGFILE GROUP 1 ('/u01/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/u01/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/u01/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/u01/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/u01/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/oradata/mynewdb/users01.dbf' SIZE 500M REUSE
AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u01/oradata/mynewdb/temp01.dbf' SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/oradata/mynewdb/undotbs01.dbf' SIZE 200M REUSE
AUTOEXTEND ON MAXSIZE UNLIMITED;
运行必要的后创建脚本:
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
在RAC环境中,可以使用Oracle Restart或Grid Infrastructure来创建数据库:
srvctl add database -db db_unique_name -o oracle_home
创建完成后,可以通过以下命令验证:
SELECT name, open_mode FROM v$database;
SELECT * FROM v$version;
您需要哪种具体环境的创建方法?或者对上述步骤中的哪一部分需要更详细的说明?