0

My company has switched the Oracle authentication from a password to RADIUS authentication. The only change I needed to make in Oracle SQL Developer was oracle.net.authentication_services = RADIUS. I am able to login and work fine. But when I use another application, like Intellij IDEA, I am having issues. I set the authentication service to RADIUS and am able to connect. However each time I want to run a query, I need to enter my passcode. Is there some way to keep the connection alive?

asked Feb 21, 2023 at 23:41

1 Answer 1

1

I'm afraid it is nature if application you use. It opens a new connection for each query. Try execute this multiple time

 select distinct sid from v$mystat;

To check whether session/connection ID changes each time.

answered Feb 22, 2023 at 9:48

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.