Client receives ORA-12514 when 64-bit listener is used for 32-bit database on 64-bit Windows

(Doc ID 732083.1)

Last updated on APRIL 16, 2018

Applies to:

Oracle Net Services - Version: 9.2 to 11.1.0.6
This problem can occur on any platform.

Symptoms

In a mixed mode environment , For Ex : 11G 64 bit database and 9i 32-bit database installed on Microsoft Windows Server 2003 R2 64-bit . Both 64-bit and 32-bit databases have been created successfully. 11g listener is used to service both the 11G/64 and 9i/32 database.

Also, the 11G/32 client binaries have been installed to connect the 9i 32-bit database.

When connecting to 9i 32-bit database through the 11G 64-bit listener , the following error occurs :

H:\>SET TNS_ADMIN=C:\oracle\product\11.1.0.6\db_2\NETWORK\ADMIN

H:\>SQLPLUS FNDMO32/FNDMO32@FNDMO32

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jul 28 17:57:51 2008

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

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms