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;

My Safari Bookshelf ~ Jan/Feb 2008

My Safari Bookshelf ~ Jan/Feb 2008 1. AutoIt v3: Your Quick Guide By Andy Flesner :actually quite helpful - made me aware of includes/features I didn't know know where there (in what I'd found an already very useful tool) 2. Critical Thinking: Tools for Taking Charge of Your Professional and Personal :helpful review / primer on logical thinking 3. Crystal Reports® XI: Official Guide :ok 4. HTML, XHTML, & CSS, Sixth Edition: Visual QuickStart Guide :good nut's & bolts 5. Inside Microsoft® SQL Server™ 2005: T-SQL Programming :just starting 6. Introduction to SQL: Mastering the Relational Database Language, Fourth :js 7. Learning SQL on SQL Server 2005 :ok 8. Learning UML 2.0 :js 9. MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005 :js 10. Mind Performance Hacks :very useful/cool book 11. Oracle PL/SQL Language Pocket Reference, 4th Edition :gn&b 12. Practical SQL Handbook, The: Using SQL Variants, Fourth Edition :excellent and getting better 13. SQL Hacks :js 14. SQL Tuning :js 15. VB & VBA in a Nutshell: The Language :Must have 16. VBScript in a Nutshell, 2nd Edition :MH 17. Windows Vista: The Definitive Guide :js

LibriVox's New Releases

Blog Archive