PB2021 Support to Oracle 19c Exadata DB

Resolved PB2021 Support to Oracle 19c Exadata DB

Issue

Votes

Undo

Alagu Raja
PowerBuilder
Thursday, 28 October 2021 08:56 AM UTC

Hi,

We are migrating our Oracle Database from "Oracle Database 11g Enterprise Edition Release 11.2.0.4.0" to "Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0".

To make sure our PB supports cloud DB we are planning to migrate PB from PB2017R2 to PB2021.

When setting up DB profile we are getting below error in PB2021,

Same error comes up when we try login to this new DB through new Exe as well as old Exe.

All old DBs are connecting fine in PB as well as Exes.

We need help in setting up PB to connect to new DB to proceed with Development of Exe using PB2021 for new DB.

More Infos:

I have Oracle Client 11.2 installed in my system.

SQL Developer is able to connect to new DB in same system.

Responses (2)

Miguel Leeuwe Accepted Answer Pending Moderation

Thursday, 28 October 2021 18:01 PM UTC
PowerBuilder
# 1

Did your install the correct oracle client (32 bit) for the pb IDE?

You can set an environment variable in windows name TNS_ADMIN to indicate the path to where the tnsnames.ora file is located.

regards.

Comment

There are no comments made yet.

Olan Knight Accepted Answer Pending Moderation

Thursday, 28 October 2021 14:09 PM UTC
PowerBuilder
# 2

1) I assume you added the TNS entry into the TNSNAMES.ORA file for the new databases.

2) As per Chris Pollack O19C compliance was added to PB 2017 R3 in build 1915 (Dec 2019) and PB 2019 build 2170 (Dec 2019). Both of those releases were MR's.

Ensure you are using the correct version of PowerBuilder.

3) Ensure that you are using the correct driver.

Good Luck,

Olan

Comment

There are no comments made yet.

Page :
1

There are no replies made for this question yet.
However, you are not allowed to reply to this question.

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.