2008-01-29

Oracle db link using 12154 error ~ try tnsnames full discriptor

--tns 12154 error? --Shouldn’t have to go through these gyrations – but, this appears to work: -- Drop existing database link drop database link MBEE; -- Create database link create database link MBEE connect to myuser identified by myuser using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = myremotehost)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = myremoteservice)))'; --try query SELECT * FROM mytable@MBEE;

No comments:

LibriVox's New Releases

Blog Archive