OraFAQ Forum: Networking and Gateways » ORA-12545: *only* with 32 bit client on Windows Server 2016

Home » RDBMS Server » Networking and Gateways » ORA-12545: *only* with 32 bit client on Windows Server 2016 (Oracle 11.0.3 / Windows Server 2016)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12545: *only* with 32 bit client on Windows Server 2016 [message #659888]

Thu, 02 February 2017 04:40

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Has andbody run into this problem on Windows? The "Windows People" are installing a new Windows Server 2016, and it seems some 32bit applications can't connect to the network in some cases. (with host not found errors) The same setup works on any "other" Windows clients like Windows 7 and 10 and Server 2008 we have around.

sqlplus (and 32bit programs that use the 32bit Oracle client) are also affected, so maybe someone here has seen it and has found the solution? (Perl CPAN and 32 bit wget have similar problems, so I'm pretty sure it's primarily a Windows bug of misconfiguration, but any ideas would be appreciated)

64 Bit client works....

C:\Program Files\Oracle\Client_11_64>sqlplus user/pass@db
SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 2 11:00:27 2017
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

32 Bit client does not...

C:\Program Files\Oracle>cd Client_11_32

C:\Program Files\Oracle\Client_11_32>sqlplus user/pass@db

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 2 11:00:47 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-12545: Connect failed because target host or object does not exist

Report message to a moderator

Re: ORA-12545: *only* with 32 bit client on Windows Server 2016 [message #659889 is a reply to message #659888]

Thu, 02 February 2017 04:56

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

OK, right after I posted a got another lead:

With IPs in the tnsnames.ora it works. With hostnames in tnsnames.ora it doesn't work. (same with wget. With IP it works, with hostname not)

So I will give THAT ticket to the "Windows People" Wink

Report message to a moderator

Re: ORA-12545: *only* with 32 bit client on Windows Server 2016 [message #659894 is a reply to message #659889]

Thu, 02 February 2017 08:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

add entry to local "hosts" file.

Report message to a moderator

Re: ORA-12545: *only* with 32 bit client on Windows Server 2016 [message #659899 is a reply to message #659894]

Thu, 02 February 2017 11:12

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

BlackSwan wrote on Thu, 02 February 2017 15:24

add entry to local "hosts" file.

It's on my list of possible workarounds. But since there are now eight other different applications in total that exhibit the problem, the ball seems to be firmly in the Windows admins court for now. Laughing

Report message to a moderator

Re: ORA-12545: *only* with 32 bit client on Windows Server 2016 [message #660310 is a reply to message #659899]

Tue, 14 February 2017 10:40

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Just FYI: The third tier of Microsoft finally found out that there was something botched with the install media of the OS that caused all kind of "weirdness". On a fresh install everything looks fine.

Report message to a moderator

Previous Topic:	ORA-12560: TNS:protocol adapter error
Next Topic:	Where are predicates applied when linking Oracle to SQL Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 21:23:10 CST 2024