DB 수동생성 작업
1. mkdir -p /oracle/ora920/dbs 생성
2. vi /oracle/ora920/dbs/initORA9.ora 생성
*.background_dump_dest='/oracle/admin/ORA9/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/oradata/ORA9/control01.ctl','/oradata/ORA9/control02.ctl','/oradata/ORA9/control03.ctl'
*.core_dump_dest='/oracle/admin/ORA/cdump'
*.db_block_size=8192
*.db_cache_size=629145600
*.db_file_multiblock_read_count=16
*.db_name='ORA9'
*.instance_name='ORA9'
*.large_pool_size=314572800
*.processes=150
*.sga_max_size=1572864000
*.shared_pool_size=209715200
*.sort_area_size=524288
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS01'
*.user_dump_dest='/oracle/admin/ORA9/udump'
(11g 의 경우)
ORCL.__db_cache_size=213909504
ORCL.__java_pool_size=4194304
ORCL.__large_pool_size=4194304
ORCL.__oracle_base='/oracle/app/oracle '#ORACLE_BASE set from environment
ORCL.__pga_aggregate_target=251658240
ORCL.__sga_target=369098752
ORCL.__shared_io_pool_size=0
ORCL.__shared_pool_size=138412032
ORCL.__streams_pool_size=0
*.audit_file_dest='/oracle/app/oracle/admin/ORCL/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/data/ORCL/control01.ctl','/data/ORCL/control02.ctl','/data/ORCL/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='ORCL'
*.diagnostic_dest='/oracle/app/oracle'
*.memory_target=620756992
*.open_cursors=300
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
3. cd /oracle/ora920/dbs
orapwd file=orapwORA9 password=manager entries=5
4.
mkdir -p /oracle/admin/ORA9/bdump
mkdir -p /oracle/admin/ORA9/cdump
mkdir -p /oracle/admin/ORA9/udump
5. cr_db.sql 화일 작성
SQL> startup nomount
@cr_db.sql
- 9i의 경우
CREATE DATABASE ORA9
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 10
MAXLOGMEMBERS 10
MAXDATAFILES 100
DATAFILE '/oradata/ORA9/system01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/ORA9/temp01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS01" DATAFILE '/oradata/ORA9/undotbs01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET KO16KSC5601
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oradata/ORA9/redo01.log') SIZE 102400K,
GROUP 2 ('/oradata/ORA9/redo02.log') SIZE 102400K,
GROUP 3 ('/oradata/ORA(/redo03.log') SIZE 102400K ;
- 10g의 경우
CREATE DATABASE ORCL
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 32
MAXLOGMEMBERS 5
MAXDATAFILES 2000
DATAFILE '/userc/oraprod/proddata/system01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/oradata/temp01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS01" DATAFILE '/oradata/undotbs01.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
SYSAUX DATAFILE '/oradata/sysauxo1.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET KO16KSC5601
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oradata/redo01.log') SIZE 102400K,
GROUP 2 ('/oradata/redo02.log') SIZE 102400K,
GROUP 3 ('/oradata/redo03.log') SIZE 102400K ;
- 11g 의 경우
CREATE DATABASE ORCL
USER SYS IDENTIFIED BY manager
USER SYSTEM IDENTIFIED BY manager
LOGFILE GROUP 1 ('/data/ORCL/redo01.log') SIZE 100M,
GROUP 2 ('/data/ORCL/redo02.log') SIZE 100M,
GROUP 3 ('/data/ORCL/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 1000
MAXINSTANCES 1
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/data/ORCL/system01.dbf' SIZE 1000M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/data/ORCL/sysaux01.dbf' SIZE 1000M REUSE
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/data/ORCL/temp01.dbf'
SIZE 1000M REUSE
UNDO TABLESPACE UNDOTBS1
DATAFILE '/data/ORCL/undotbs01.dbf'
SIZE 1000M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
6.
sysdba 로 실행
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
system유저로 실행
@?/sqlplus/admin/pupbld.sql
