-
1. Re: Install Repository Designer 10g
sdkdev Jun 12, 2018 6:51 PM (in response to sdkdev)1 person found this helpfulstep to install repository:
CREATE TABLESPACE ts_designer
DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\DES1.ORA'
SIZE 400M AUTOEXTEND ON NEXT 100M;
CREATE TABLESPACE des_index
DATAFILE 'C:\oraclexe\app\oracle\oradata\XE\TINDEX.ORA'
SIZE 800M AUTOEXTEND ON NEXT 100M;
create undo tablespace des_undo datafile 'C:\oraclexe\app\oracle\oradata\XE\UNDODES.ORA' size 10m;
create rollback segment rbs_designer tablespace ts_designer storage
(initial 1m next 1m minextents 3 optimal 4m);
alter rollback segment rbs_designer online;
select tablespace_name, sum(bytes)/1024/1024 from dba_free_space
group by tablespace_name;
ALTER TABLESPACE system
ADD DATAFILE
'C:\oraclexe\app\oracle\oradata\XE\system1.dbf'
size 400m;
select tablespace_name, status from dba_tablespaces;
create user designer identified by designer
default tablespace ts_designer temporary tablespace temp;
Créer et Cranter le rôle CK_ORACLE_REPOS_OWNER à ton user designer.
Repère le script oracle_home\repadm61\utl\ckrorole.sql sur ton poste client.grant dba to designer;
GRANT EXECUTE ON DBMS_RLS TO designer;
GRANT EXECUTE ON DBMS_LOCK TO designer;
GRANT EXECUTE ON DBMS_PIPE TO designer;
GRANT CREATE TABLE TO designer;
GRANT CREATE VIEW TO designer;
GRANT CREATE PROCEDURE TO designer;
GRANT CREATE SYNONYM TO designer;
GRANT CREATE SEQUENCE TO designer;
GRANT SELECT ON sys.v_$nls_parameters TO designer WITH GRANT OPTION;
GRANT SELECT on V_$PARAMETER TO designer;
GRANT SELECT ON dba_rollback_segs TO designer;
GRANT SELECT ON dba_segments TO designer;
GRANT CREATE ANY SYNONYM TO designer;
GRANT DROP ANY SYNONYM TO designer;
GRANT CREATE PUBLIC SYNONYM TO designer;
GRANT DROP PUBLIC SYNONYM TO designer;
grant CK_ORACLE_REPOS_OWNER to designer;
grant connect, resource to designer;
grant execute on utl_file to designer;
Lancer l'installation à partir de Repository Administration Utility