current position:Home>Ora-28000 error after upgrading Oracle 12C to 19C

Ora-28000 error after upgrading Oracle 12C to 19C

2022-06-24 09:39:12Huizhou wuyanzu

Oracle 12c To upgrade to 19c after , The client cannot connect to the database , Need to be in sqlnet.ora Add... To the file SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 Parameters

[[email protected] rman]$ cd /u01/app/oracle/product/19.3.0/db_1/network/admin/
[[email protected] admin]$ cat sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Finished adding parameters , The client connection shows that the account is locked , Or the account and password are wrong
 Insert picture description here
resolvent :
You need to reset the user password manually , Get the user's account password SQL Statement for :

SQL> select 'alter user '||name||' identified by values'''||password||''' default tablespace users temporary tablespace temp;' from user$ where name in (select username from dba_users where account_status='OPEN');

copyright notice
author[Huizhou wuyanzu],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/175/202206240817364286.html

Random recommended