Is XE prohibited from using db links? Created XE database on first machine Have 220.127.116.11 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 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@second ERROR at line 1: ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from SECONDWhy 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?