Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DORA-1017 errors connecting via OCI but not SQLPLUS

KSandbergNGCJun 22 2016 — edited Aug 22 2016

Database version: 11.2.0.4

OS: Solaris 10

We have a scenario where one of our newer DB accounts can connect to the database using sqlplus, but not using OCI.
We have Oracle Wallet enabled, and use the same account in both circumstances.

Using SQLPlus, the user connects using "sqlplus /@SID.username". SQLPlus connects to the database OK

Using our app written in C, using OCI, we use the same account and wallet settings. But Oracle returns ORA-1017

A clue to the root cause is -- user accounts that DO work under both scenarios, have a DBA_USER.PASSWORD_VERSION="10g 11g"

This one account, that doesn't work, has a DBA_USER.PASSWORD_VERSION="11g".

In other words, it appears that Oracle's authentication, under OCI, behaves differently if the PASSWORD_VERSION is "10g 11g" versus "11g"... while SQLPLUS apparently does not apply the same rules.

Does anyone have any experience with this, or a similar problem?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2016

Added on Jun 22 2016

#database-security, #database-security-general

2 comments

812 views