D:\product\11.1.0\db_1\admin\book\ (arch, bdump, cdump, create, udump)
D:\product\11.1.0\db_1\oradata\book\
bdump 存放背景進程追蹤 (含 alert_book.log),udump 存放用戶追蹤。
複製現有 init.ora 修改關鍵參數:
db_name=book
control_files=('D:\...\book\control01.ctl','D:\...\book\control02.ctl')
memory_target=500M
processes=150
audit_file_dest='D:\...\book\adump'
diagnostic_dest='D:\...\book'
SET ORACLE_SID=book
oradim -NEW -SID book -STARTMODE AUTO
orapwd file=D:\...\book\PWDbook.ora password=oracle entries=10
SQL> STARTUP NOMOUNT PFILE='D:\...\initbook.ora'
CREATE DATABASE book
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('D:\...\redo01.log') SIZE 50M,
GROUP 2 ('D:\...\redo02.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 100
MAXDATAFILES 100
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE 'D:\...\system01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILE 'D:\...\sysaux01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
DEFAULT TABLESPACE users DATAFILE 'D:\...\users01.dbf' SIZE 100M REUSE AUTOEXTEND ON
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE 'D:\...\temp01.dbf' SIZE 50M REUSE
UNDO TABLESPACE undotbs DATAFILE 'D:\...\undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON;
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/sqlplus/admin/pupbld.sql
-- 建立 SPFILE
CREATE SPFILE FROM PFILE='D:\...\initbook.ora';
-- 建立 SCOTT
@?/rdbms/admin/utlsampl.sql
SQL> SELECT name, open_mode FROM v$database;
SQL> SELECT tablespace_name FROM dba_tablespaces;