database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
ㆍOracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Oracle Tutorials 9051 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 9051
Repository 생성 절차
작성자
정재익(advance)
작성일
2001-12-25 13:38
조회수
3,655

[ 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을 개발할 수 있는 환경

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

[Top]
No.
제목
작성자
작성일
조회
9054ora-01034 처리방법
정재익
2001-12-25
7128
9053Data와 Index가 같은 tablespace에 있는 경우 를 분리하는 방법
정재익
2001-12-25
4404
9052Oracle 8i의 Migration workbench
정재익
2001-12-25
4791
9051Repository 생성 절차
정재익
2001-12-25
3655
9049Oracle을 외부 네트워크로 열어주고자 할때(MTS인 경우)
정재익
2001-12-25
3784
9047SQL Loader 예제
정재익
2001-12-25
4346
9045Oracle8의 national Character Set(nchar)에 대하여
정재익
2001-12-25
3700
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2022 DSN, All rights reserved.
작업시간: 0.028초, 이곳 서비스는
	PostgreSQL v13.3으로 자료를 관리합니다