Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news.linkpendium.com!news-out.visi.com!petbe.visi.com!news.octanews.net!news.maxwell.syr.edu!sn-xit-03!sn-xit-04!sn-xit-06!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: intermittent ora-12545 Date: Tue, 03 Feb 2004 06:11:44 +0100 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <751c2487.0402021457.119541b8@posting.google.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 12 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:253523 On 2 Feb 2004 14:57:39 -0800, sparling@speakeasy.net (andrea) wrote: >tnsnames.ora - no sqlnet - the program is on the same machine as the >sid If the program is on the server, why do you use the TCP/IP protocol to connect? You should set ORACLE_SID prior to connecting and leave out the @prod or use the IPC protocol. -- Sybrand Bakker, Senior Oracle DBA