XE and DB Links

From: Rodd Holman <rodd.holman_at_gmail.com>
Date: Wed, 27 Jan 2010 14:57:08 -0600
Message-ID: <4B60A8A4.8000006_at_gmail.com>

Is XE prohibited from using db links?
Created XE database on first machine
Have 11.1.0.7 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_at_second
     Connected.
     select * from global_name
     GLOBAL_NAME
     ---------------------------
     SECOND.DOMAIN

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_at_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?

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 27 2010 - 14:57:08 CST