This discussion is archived
2 Replies Latest reply: Jul 1, 2011 2:07 AM by Alain RSS

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

Alain Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points