XE and DB Links

  • From: Rodd Holman <rodd.holman@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 27 Jan 2010 14:57:08 -0600

Is XE prohibited from using db links?
Created XE database on first machine
Have on second machine as instance second
TNSNAMES on first machine has entry for second.
The tnsping to second works fine.

Login to XE database on first machine as system

    connect user/password@second
    select * from global_name

No problem

Now create a database link using same user and password to same database.

create database link second connect to user identified by password using 'second';
    Database link created.
    select * from global_name@second
    ERROR at line 1:
    ORA-01017: invalid username/password; logon denied
    ORA-02063: preceding line from SECOND

Why does one connect and not the other? Is there something I'm missing here or is Oracle not letting us use db links in XE?

Other related posts: