1 Reply Latest reply on Jun 12, 2018 6:51 PM by sdkdev

    Install Repository Designer 10g

    sdkdev

      I try to install a Repository with oracle designer 10g and oracle database xe 11g an error appear:

      RME-02105: Oracle error occurred...

      ORA-06550: line 123, column 7:

      PL/SQL: ORA-00980: synonym translation is no longer valid

      ORA-06550: line 108, column 5:

      PL/SQL: SQL Statement ignored

      ORA-06550: line 149, column 7:

      PL/SQL: ORA-00980: synonym translation is no longer valid

      ORA-06550: line 134, column 5:

      PL/SQL: SQL Statement ignored

        • 1. Re: Install Repository Designer 10g
          sdkdev

          step 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

          1 person found this helpful