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 位用户发现它有用