Home » RDBMS Server » Networking and Gateways » ORA-12545: *only* with 32 bit client on Windows Server 2016 (Oracle 11.0.3 / Windows Server 2016)
ORA-12545: *only* with 32 bit client on Windows Server 2016 [message #659888] Thu, 02 February 2017 04:40 Go to next message
ThomasG
Messages: 3211
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
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
add entry to local "hosts" file.
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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
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 Go to previous message
ThomasG
Messages: 3211
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.
Previous Topic: ORA-12560: TNS:protocol adapter error
Next Topic: Where are predicates applied when linking Oracle to SQL Server
Goto Forum:
  


Current Time: Thu Mar 28 04:40:48 CDT 2024