Re: intermittent ora-12545

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 06 Feb 2004 10:34:54 +0100
Message-ID: <bvvmga$pcd$1@news4.tilbu1.nb.home.nl>

andrea wrote:

> "Gerry Sinkiewicz" <sinkiege_at_snet.net> wrote in message news:<K%WTb.31852$yT3.4028_at_newssvr33.news.prodigy.com>...
>

>>"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
>>news:u9bu109bpqnd10naqsn1jsst6n1df30njc_at_4ax.com...
>>
>>>On 2 Feb 2004 14:57:39 -0800, sparling_at_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
>>
>>And perhaps TWO_TASK (for a unix machine).

>
>
> My "dba" answers me this -
> no connections are local, all are tcp, no bequeath
> dont need two_task
>
> So within his constraints, why would I get the intermittent error 12545?
>
> Perhaps I could rewrite the Pro*C with a different method?
> ( I am connecting as "user_at_prod" )
> We have ORACLE_SID set to prod
> we do not have two_task

Your DBA should talk to a sysadmin with some knowledge of networking. Why would you have all overhead of TCP/IP, where you can use bequeath?!? Have seen IPC and Bequeath outperform TCP/IP by a factor of 100.

Apart from that - your approach is twofold - you either set ORACLE_SID and connect user/password (which would end up in a bequeath connection), or do no such thing, and connect user/password_at_connect (which would be a "remote" connect, using IPX, TCP, Named Pipes - TCP in your case).

And your DBA should have lookup up the error (or you should): [oracle_at_csdb01 oracle]$ oerr tns 12545
12545, 00000, "Connect failed because target host or object does not exist"

// *Cause: The address specified is not valid, or the program being
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name.  Ensure that the
// executable for the server exists (perhaps "oracle" is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.

I'd go for the bequeath solution, if possible, or else IPC. Never configure tnsnames for TCP on the server.

-- 

Regards,
Frank van Bortel

Received on Fri Feb 06 2004 - 03:34:54 CST