dbca
命令启动数据库配置助手-- 1. 创建必要的目录
-- 2. 创建初始化参数文件(init<SID>.ora)
-- 3. 创建服务(Windows)或环境变量(Unix/Linux)
-- 4. 启动SQL*Plus并以SYSDBA身份连接
SQL> CONNECT / AS SYSDBA
-- 5. 启动实例到NOMOUNT状态
SQL> STARTUP NOMOUNT;
-- 6. 执行CREATE DATABASE命令
SQL> 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 NEXT 1280K 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 NEXT 5120K MAXSIZE UNLIMITED;
-- 7. 创建数据字典视图
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/sqlplus/admin/pupbld.sql
-- 检查数据库状态
SELECT name, open_mode, database_role FROM v$database;
-- 检查表空间
SELECT tablespace_name, status, contents FROM dba_tablespaces;
-- 检查数据文件
SELECT file_name, tablespace_name, bytes/1024/1024 MB FROM dba_data_files;
以上是Oracle数据库创建的基本方法,具体参数应根据实际环境和需求进行调整。