2 Replies Latest reply: Jul 1, 2011 4:07 AM by Alain RSS

    database link from 10.2.0.3 enterprise to 11.2.0.2.0 xe doesn't work

    Alain
      from 10.2.0.3.0:

      sqlplus user/xxxx@192.168.7.14:1521/XE
      =>
      Connected to:
      Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Beta
      sql>desc cec.matable@ABTEST;
      Name Null? Type
      ----------------------------------------- -------- ----------------------------
      IDRIGHT NOT NULL VARCHAR2(60)
      USERSALLOWED NOT NULL VARCHAR2(4000)
      SIGNIFICATION VARCHAR2(2047)


      but:
      SQL>create database link ABTEST CONNECT TO user IDENTIFIED BY xxxx USING '192.168.7.14:1521/XE';
      Database link created.
      SQL>desc cec.matable@ABTEST;
      ERROR:
      ORA-01017: invalid username/password; logon denied
      ORA-02063: preceding line from ABTEST


      Any hint?