DB 수동 생성

DB 엔진

수동으로 DB생성 순서

 

1. Diagnostic file 경로 생성

2. Data file 경로 생성

3. SID 지정

4. password file 생성

5. pfile 생성

6. Create database 구문 작성

7. Startup nomount;

8. Database 생성

9. Sys, system password 설정하기

10. Data dictionary 정보와 built-in package 설치 위해서 script 실행하기

 

 

 

설정확인하기

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u01/oradata/TESTDB/system01.dbf
/u01/oradata/TESTDB/sysaux01.dbf
/u01/oradata/TESTDB/undotbs01.dbf

3 rows selected.

 

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
/u01/oradata/TESTDB/control01.ctl
/u01/oradata/TESTDB/control02.ctl

2 rows selected.

 

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/oradata/TESTDB/redo01.log
/u01/oradata/TESTDB/redo02.log
/u01/oradata/TESTDB/redo03.log

3 rows selected.

 

 

SQL> col tablespace_name for a15
SQL> col file_name for a40
SQL> select tablespace_name, file_name from dba_data_files;

TABLESPACE_NAME     FILE_NAME
---------------         ----------------------------------------
SYSTEM                  /u01/oradata/TESTDB/system01.dbf
SYSAUX                  /u01/oradata/TESTDB/sysaux01.dbf
UNDOTBS1              /u01/oradata/TESTDB/undotbs01.dbf

3 rows selected.