Oracle - Installing the repository.

----------------------------------------------------------------
(C) gRAVER_ZX, 2007
----------------------------------------------------------------


Oracle
Установка pепозитоpия

Создание табличных пространств

create tablespace constant_grow_indexes
datafile 'D:oradatadbconstant_grow_indexes_01.dbf'
size 4000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace constant_grow_tables
datafile 'D:oradatadbconstant_grow_tables_01.dbf'
size 15000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace dependency_indexes
datafile 'D:oradatadbdependency_indexes_01.dbf'
size 5600k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace dependency_tables
datafile 'D:oradatadbdependency_tables_01.dbf'
size 9000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace diagram_indexes
datafile 'D:oradatadbdiagram_indexes_01.dbf'
size 1000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace diagram_tables
datafile 'D:oradatadbdiagram_tables_01.dbf'
size 2000k
default storage (initial100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace lob_data
datafile 'D:oradatadblob_data_01.dbf'
size 1200k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace rapid_grow_indexes
datafile 'D:oradatadbrapid_grow_indexes_01.dbf'
size 250000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace rapid_grow_tables
datafile 'D:oradatadbrapid_grow_tables_01.dbf'
size 500000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace system_meta_indexes
datafile 'D:oradatadbsystem_meta_indexes_01.dbf'
size 20000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace system_meta_tables
datafile 'D:oradatadbsystem_meta_tables_01.dbf'
size 30000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace temporary_indexes
datafile 'D:oradatadbtemporary_indexes_01.dbf'
size 5000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace temporary_tables
datafile 'D:oradatadbtemporary_tables_01.dbf'
size 9000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace version_indexes
datafile 'D:oradatadbversion_indexes_01.dbf'
size 9000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

create tablespace version_tables
datafile 'D:oradatadbversion_tables_01.dbf'
size 12000k
default storage (initial 100k next 100k minextents 1 maxextents
UNLIMITED pctincrease 0)
/

alter tablespace system add datafile
'D:oradatadbsystemOЗ.dbf' size 140m
/


Создание владельца pепозитоpия


create user owner identified owner default tablespace users
temporary tablespace temp
/

create ROLE CK_ORACLE_owner
/

GRANT EXECUTE ON DBMS_LOCK TO owner;
GRANT EXECUTE ON DBMS_PIPE TO owner;
GRANT CREATE TABLE TO owner;
GRANT CREATE VIEW TO owner;
GRANT CREATE PROCEDURE TO owner;
GRANT CREATE SYNONYM TO owner;
GRANT CREATE SEQUENCE TO owner;
GRANT SELECT ON sys.v_$nls_parameters TO owner WITH GRANT
OPTION;
GRANT SELECT ON sys.V_$PARAMETER TO owner;
GRANT SELECT ON dba_rollback_segs TO owner;
GRANT SELECT ON dba_segments TO owner;
GRANT CREATE ANY SYNONYM TO owner;
GRANT DROP ANY SYNONYM TO owner;
GRANT CREATE PUBLIC SYNONYM TO owner;
GRANT DROP PUBLIC SYNONYM TO owner;
GRANT ck_oracle_owner to owner;
GRANT CONNECT, RESOURCE TO owner;
GRANT dba TO owner;


Создание дополнительного пользователя


create user userб5 identified by userб5default tablespace users     
temporary tablespace temp
/

GRANT CONNECT, RESOURCE TO userb5;
GRANT CREATE TABLE TO userb5;
GRANT CREATE VIEW TO userb5;
GRANT CREATE PROCEDURE TO userb5;
GRANT CREATE SYNONYM TO userb5;
GRANT CREATE SEQUENCE TO userb5;
GRANT SELECT ON dba_rollback_segs TO userb5;
GRANT SELECT ON dba_segments TO userb5;


Next


Launch the Repository Administration Utility (RAU).  Enter in
username owner, password - owner, communication string -
your service name.  It can be found in the Net Manager program.
Click the Install button and follow the instructions. In the next window
select the appropriate tablespaces from those you
created specifically for the repository.

I got the following error during installation:
ORA-01658: cannot create INITIAL extent for segment in
section SYSTEM_META_INDEXES

My solution to the problem:
alter tablespace system_meta_indexes add datafile
'D:oradatadbsystem_meta_indexes_02.dbf' size 20m
/

Next, I clicked the retry last operation button, and installation
continued.

Then in RAU select Enable Version.