Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Converting to MFA (Radius Authentication) causes issues with connecting to PB 2021

  1. New
  2. Issue
0
Votes
Undo
  1. Steven Turner
    Steven Turner
  2. PowerBuilder
  3. Friday, 13 December 2024 13:03 PM UTC

Good morning,

We are using: Oracle SQL Developer Version 23.1.1.345 Build 345.2114, PowerBuilder 2021 Build 1509

Database: Oracle 19c (soon to be 21c)
Will be migrating to PowerBuilder 2022 soon as well

Our agency has decided to convert to Multi-Factor Authentication (Radius authentication).
To implement this on Oracle SQL Developer, we had to upgrade to the Oracle 21c client (64-bit)

The issue is when installing the 21c client, the ORACLE_HOME entry in the path is set to the 64-bit installation. This prevents us from connecting to the database because the IDE uses 32-bit client. Removing the ORACLE_HOME entry will allow PB to work, then we can't use Oracle SQL Developer (with MFA).

Is there a workaround for this, without converting PB to 64-bit? We have legacy add-ons that are 32-bit and the agency does not want to modify them.

Thanks in advance....

Steve

Assistance with Synchronizing New Objects in WizSo...
PB2025 Beta DataWindow Detail band color when the...
Responses (3)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 13 December 2024 22:19 PM UTC
  2. PowerBuilder
  3. # 1

You can also have a look at the use of TNS_ADMIN

https://docs.oracle.com/en/database/oracle/oracle-database/19/ntqrf/about-tns-admin-parameter.html

Also, SQL DEVELOPER should allow you to config a path to where the TNSNAMES.ORA file is that you want to use, depending on which client (driver) you want to use in sql developer.

 

 

 

 

 

Comment
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Sunday, 15 December 2024 13:37 PM UTC
oracle 21c still has a 32 bit client. Install it and then make sure that the path to the 32 bit client comes before the 64 bit client. (and modify the oracle_home if necessary).
  1. Helpful 1
There are no comments made yet.
Steven Turner
Steven Turner Accepted Answer Pending Moderation
  1. Friday, 13 December 2024 13:35 PM UTC
  2. PowerBuilder
  3. # 2

Had not thought of that. Will definitely try that.
Thanks!!

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 13 December 2024 13:32 PM UTC
  2. PowerBuilder
  3. # 3

Hi.

Have you tested if you could add that oracle_home environment variable when launching sql developer (example create a batch file that will set ORACLE_HOME and then run sql developer).

Andreas.

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.
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.