Originally posted by: coolmix

Hi Team,

I'm trying to connect to the oracle 12c on exadata database from the database interface designer(from windows 7). Oracle is installed on linux. When i try to connect to the database to generate type trees, i'm getting "The connection to the database failed error".

I have installed the following on my desktop.

WTX 8.4.1.3 Design studio 32bit variation

Oracle 11g client.

Has anybody tried to coonect to oracle 12c from WTX? Any help is greatly appreciated.

Thanks

Originally posted by: Ejay

Hello,

Could you please check the trace file generated in the database interface designer . Menu -> view -> trace file  and paste it here ?

Do you confirm also that you are able to connect in the same session using sqlplus ?

You might need to check your tnsnames.ora file.

Emmanuel .

Originally posted by: coolmix

Hi Emmanuel,

Thanks for response.

The trace file(.dbl) doesn't have any data in it. it's a zero byte file. I'm able to connect to the database via sqlplus and toad.

following is the oracle database version info.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Thanks

Originally posted by: paul.brett

Well, the Database Interface Designer is connecting to the local oracle client software.

1.  Is it 32 bit?

2.  What version exactly (do a tnsping)

Mine shows:

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 27-OCT-2
015 15:26:37

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

TNS-03502: Insufficient arguments.  Usage:  tnsping <address> [<count>]

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: coolmix

Thanks Paul.

1. Oracle client is 64bit.

2 find below the tnsping result on my desktop where the Database Interface Designer is installed.

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 27-OCT-2
015 11:42:34

Thanks

Originally posted by: paul.brett

As you may know, Database Interface Designer is 32-bit software, and will require a 32-bit client to connect to the database.

Please obtain and install/configure a 32-bit client.

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: coolmix

Thank you Paul.

Just one clarification. To connect to the oracle 12c database from a WTX map executing on the linux server, the 64bit oracle client (11g or 12c) should work, right?

Server 1:

IIB 9.0.0.4 (64 bit)

WTX for IS 64 bit

Server 2:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Thanks

Originally posted by: paul.brett

Yes, a 64-bit WTX installation will be able to communicate with a 64-bit database client.

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: coolmix

Thank you Paul.