Re: 10G passwords in Oracle 12C

From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Mon, 9 Jul 2018 12:06:07 -0700
Message-ID: <CAKsxbLr03FoLRyGqmm3Az5RYrpVN2haPs2BfWgzY-k9rZMbR+w_at_mail.gmail.com>



Yes you need to set SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10 in your sqlnet.ora file on the server.

On Mon, Jul 9, 2018 at 10:37 AM, Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> 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?
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> <https://maps.google.com/?q=1240+W.+6th+Street+Cleveland,+Ohio+44113&entry=gmail&source=g>
> Cleveland, Ohio 44113
> <https://maps.google.com/?q=1240+W.+6th+Street+Cleveland,+Ohio+44113&entry=gmail&source=g>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 09 2018 - 21:06:07 CEST

Original text of this message