Oracle 12

far · Post by **far** » 22 Mar 2014, 16:23

My customer plans to update from Oracle 11to Oracle 12c.

I made a test to see if everything works with this new Oracle Version. My Program witch was build with TeamDeveloper 5.1 cannot connect to this database.
Everything, except this program, works as before (Java programs and Oracle sqlDeveloper). With Oracle 11 no problems.
I get SQL Error 'cannot connect'.

I know, it Oracle 12c is not supported. Oracle 11 also was not supported, but is running very good.
Is there a known issue wit teamdeveloper 5.1 and oracle 12c? Any chance to get it running editing sql.ini?

far

TDWiki YouTube Channel · Post by **Dave Rabelink** » 23 Mar 2014, 14:47

I just ask...

Did you use the 32bit Oracle client?

far · Post by **far** » 24 Mar 2014, 13:09

Dave Rabelink wrote:I just ask...

Did you use the 32bit Oracle client?

Yes the client runs on windows 2003 32 bit. The server is linux fedora 20 64 bit. The client has no problem with orace 9, 10 and 11.

I found I have to add the remotedbname in sql.ini. But I still cannot open. Now the message is
"Cannot open database".

Harald

Charlie · Post by **Charlie** » 26 Mar 2014, 13:00

From my experience working with Oracle databases (from version 7 to 11) and Team Developer (production applications built/maintained with SQLWindows 5.1, TD 2.0, TD2.1, TD5.2; and testing of TD versions 3.1 and 4.2), any Oracle client compatible with the particular version of TD has been able to get our apps connected and working without issue with any version of Oracle.

A "cannot connect to database" error sure sniffs of something missing (or not correct) in either (or both) SQL.INI and/or TNSNAMES.ORA

Unless Oracle 12 really is a different beast that will not work with previous generation Oracle clients ...

far · Post by **far** » 28 Mar 2014, 07:22

>> From my experience working with Oracle databases (from version 7 to 11) and Team Develope ... any Oracle client ... working without issue

That is also my experience. And also every other client which I tried work without problem. First I had a wrong SQL.ini. Now sql.ini and tnsnames.ora are good. Now I don't get 'cannot connect to database", I get 'cannot open database'.

Harald

Charlie · Post by **Charlie** » 03 Apr 2014, 11:42

What version of the Oracle client are you using ?

far · Post by **far** » 04 Apr 2014, 07:09

On the developer computer Oracle 9 is installed. It was not installed by me. I also find an installer which have the version 10.1.0.5.0.
I am not shure how to check the client version. Probably it is 9. The installer shows the installed products. Here a snapshot:

oracle_inst.png

Maybe this is a good point to check. On the other side all other programs (e.g. SqlDeveloper and java programs have no problem to connect to oracle 12).

What would I have to install to get the new client?

Thank you
Harald

Charlie · Post by **Charlie** » 04 Apr 2014, 12:24

You have two Oracle Clients installed?

Are they using the same TNSNAMES.ORA file ?

My guess is that each Oracle client is using its own TNSNAMES.ORA file. Try putting the entry/entries you need in both TNSNAMES.ORA files.

far · Post by **far** » 07 Apr 2014, 09:02

I am not shure. But I think I have only Oracle 9.2 installed. From Oracle 10.1 I see only an installer.

Harald

Team Developer SQLWindows Community Forum

Oracle 12

Oracle 12

Re: Oracle 12

Re: Oracle 12

Re: Oracle 12

Re: Oracle 12

Re: Oracle 12

Re: Oracle 12

Re: Oracle 12

Re: Oracle 12

Who is online