Oracle 12c升级至19c后,客户端连接不上数据库,需要在sqlnet.ora文件中添加SQLNET.ALLOWED_LOGON_VERSION_SERVER=8参数
[oracle@ydhl rman]$ cd /u01/app/oracle/product/19.3.0/db_1/network/admin/
[oracle@ydhl admin]$ cat sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
添加完参数,客户端连接显示账号被锁定,或者账号密码错误
解决方法:
需要手工重置一下用户密码,获取用户的账号密码SQL语句为:
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');