[ Repository 생성 절차 ]

1. Character Set 변경

- DB character set을 'KO16KSC5601' 로 설정

DBA 권한이 있는 user로 connect 한후 다음 sql문으로 확인

SQL> select name c1, value$ c1 from sys.props$;

* 변경시 bulletin 10016 참조

- client의 nls_lang을 'KO16KSC5601' 로 설정

(Win3.1용 : c:\windows\oracle.ini

Win96 용 : registry 정보 확인 및 수정)

2. parameter 설정

Personal Oracle7인 경우

: ?/database/initORCL.ora

Server인 경우

: ?/dbs/initSID.ora

- shared_pool_size=18000000 (최소 12M 이상)

- db_block_buffers=1000

- processes=50

- open_cursors=200

- global_names=false

3. sys user로 login, run the SQL followed

create tablespace case

datafile 'c:\orawin95\database\caseorcl.ora'

size 40M;

create tablespace case_i

datafile 'c:\orawin95\database\ca_iorcl.ora'

size 20M;

alter tablespace system

add datafile 'c:\orawin95\database\sys2orcl.ora'

size 60M;

alter tablespace temporary_data

add datafile 'c:\orawin95\database\tmp1orcl.ora'

size 20M;

alter rollback segment rb1 offline;

alter rollback segment rb2 offline;

alter rollback segment rb3 offline;

alter rollback segment rb4 offline;

alter rollback segment rb5 offline;

alter rollback segment rb6 offline;

alter rollback segment rb7 offline;

alter rollback segment rb8 offline;

alter rollback segment rb9 offline;

alter rollback segment rb10 offline;

alter rollback segment rb11 offline;

alter rollback segment rb12 offline;

alter rollback segment rb13 offline;

alter rollback segment rb14 offline;

alter rollback segment rb15 offline;

alter rollback segment rb16 offline;

drop rollback segment rb1;

drop rollback segment rb2;

drop rollback segment rb3;

drop rollback segment rb4;

drop rollback segment rb5;

drop rollback segment rb6;

drop rollback segment rb7;

drop rollback segment rb8;

drop rollback segment rb9;

drop rollback segment rb10;

drop rollback segment rb11;

drop rollback segment rb12;

drop rollback segment rb13;

drop rollback segment rb14;

drop rollback segment rb15;

drop rollback segment rb16;

drop tablespace rollback_data including contents;

4. DOS Prompt에서, "c:\orawin95\database\rbs1ORCL.ora"삭제

5. SQL script 실행

create rollback segment r0 tablespace system

storage (initial 16k next 16k minextents 2 maxextents 20);

alter rollback segment r0 online;

rem tablespace RBS creating...

create tablespace rbs

datafile 'c:\orawin95\database\rbsORCL.ora' size 40M

default storage (initial 2M next 2M pctincrease 0 minextents 2)

/

rem rollback segment creating...

create PUBLIC rollback segment r01 tablespace rbs;

create PUBLIC rollback segment r02 tablespace rbs;

create PUBLIC rollback segment r03 tablespace rbs;

create PUBLIC rollback segment r04 tablespace rbs;

alter rollback segment r01 online;

alter rollback segment r02 online;

alter rollback segment r03 online;

alter rollback segment r04 online;

alter rollback segment r0 offline;

drop rollback segment r0

/

create tablespace BIGR

datafile'c:\orawin95\database\BIGORCL.ora' size 30M

default storage(initial 2M next 2M pctincrease 0 minextents 2)

/

create PUBLIC rollback segment BIGRBS tablespace BIGR;

alter rollback segment BIGRBS online;

create user syscase identified by syscase

default tablespace case

temporary tablespace temporary_data;

alter user syscase

quota unlimited on case

quota unlimited on case_i;

grant connect, resource to syscase;

create role case_role;

grant create any synonym,

create procedure,

create role,

create sequence,

create session,

create table,

create trigger,

create view

to case_role;

grant case_role to syscase;

grant unlimited tablespace to syscase;

grant dba to syscase;

< sys로 connect 한 후 >

grant execute on sys.dbms_pipe to syscase;

grant execute on sys.dbms_lock to syscase;

grant execute on sys.dbms_sql to syscase;

grant execute on sys.dbms_alert to syscase;

grant select on sys.v_$session to syscase;

6. Database shutdown & Restart the Database

7. "Repository Admin Utility(RAU)"에 "syscase/syscase"로 Login

- Change Tablespace name

. INDEX TABLESPACE = CASE_I

. TABEL TABLESPACE = CASE

- Click the button "INSTALL"

9. Click the button "start"

두번에 걸쳐 수행되는데, 약 3 -4 시간 소요

10. Repository 설치의 확인

sqlplus를 syscase로 connect 한 후 다음 sql문 수행

    SQL > select ci_type, count(ci_type)  
          from ck_installed_objects  
          group by ci_type; 

CI_TYPE            COUNT(CI_TYPE) 
--------------------------------------------------- 
CONSTRAINT       27 
INDEX                   150      146 
PACKAGE              335      320 
PACKAGE BODY     329      314 
RESETAPI               1        1 
SEQUENCE             6        6 
SYNONYM              6        6 
TABLE                   91        88 
TRIGGER               16       16 
VIEW                     219      211 
--------------------------------------------------- 
                         V1.3        V1.2 

* repository를 생성한 후 필요한 user를 만들고 (RAU),

application을 생성하면 application을 개발할 수 있는 환경

조성 작업이 끝나게 됩니다.