XE and DB Links
Date: Wed, 27 Jan 2010 14:57:08 -0600
Is XE prohibited from using db links?
Created XE database on first machine
Have 126.96.36.199 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
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?Received on Wed Jan 27 2010 - 14:57:08 CST