Re: 10G passwords in Oracle 12C

Hello
This issue is related to 12.2 version
To keep old behavior of authentication
There are two parameter To set

SQLNET.ALLOWED_LOGON_VERSION_CLIENT
<https://docs.oracle.com/database/121/NETRF/sqlnet.htm#CIHDDDGI> = 10

· SQLNET.ALLOWED_LOGON_VERSION_SERVER <https://docs.oracle.com/database/121/NETRF/sqlnet.htm#CIHCCJAE> = 10

Check docs for more information

Thanks

Cherif BEN HENDA

Le lun. 9 juil. 2018 à 22:00, Rich J <rjoralist3_at_society.servebeer.com> a écrit :

> On 2018/07/09 12:37, Jeffrey Beckstrom wrote:
>
> After upgrading to Oracle 12C, we found that we have some old user
> accounts with only 10 specified for the password_version value in
> sys.dba_users. Short of requiring the users to changes these passwords, is
> there any way to continue to allow these passwords to function with 12C?
>
> Specifically, which version of Oracle 12? And are you getting an error
> message trying to login as those users? Here's what I get (username
> obviously changed):
>
> SQL> SELECT username
> FROM dba_users
> WHERE password_versions = '10G ' -- note the trailing space
> ORDER BY username;
>
> USERNAME
> -----------------------------
> *[snip]*
> MYOLDUSER
>
> 7 rows selected.
>
> SQL> connect myolduser
> Enter password:
> Connected.
> SQL> select user from dual;
>
> USER
> ------------------------------
> MYOLDUSER
>
> SQL> select * from v$version;
>
> BANNER
> CON_ID
> --------------------------------------------------------------------------------
> ----------
> Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit
> Production 0
> PL/SQL Release 12.1.0.2.0 -
> Production 0
> CORE 12.1.0.2.0
> Production 0
> TNS for IBM/AIX RISC System/6000: Version 12.1.0.2.0 -
> Production 0
> NLSRTL Version 12.1.0.2.0 -
> Production 0
>
> I've been using this in test for about 8 months now with no issue, which
> your question now has me curious...
>
> Rich
>
>

--
http://www.freelists.org/webpage/oracle-l