关于应用程序连接Oracle 12C ORA-01017问题汇总
1.修改数据库服务端认证级别，修改文件
oracle用户下
cd $ORACLE_HOME/network/admin/sqlnet.ora
添加以下内容
SQLNET.ALLOWED_LOGON_VERSION=8
注意rac集群环境下要修改的oracle用户下sqlnet.ora而非grid用户下
2.修改用户名密码如果pdb需要切换到pdb下
在服务器端操作
cd cd $ORACLE_HOME/network/admin/
[oracle@rac2 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
SENDINFO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sendinfo)
)
)
su - oracle
sqlplus sys/oracle@sendinfopdb as sysdba
alter user bdltq identified by "sendinfo";
查询用户密码版本
SQL> select password_versions from dba_users where username=upper('bdltq');
PASSWORD_VERSIONS
----------------------------------
11G 12C
相关认证降级官方文档介绍
http://docs.oracle.com/database/122/NETRF/parameters-for-the-sqlnet-ora-file.htm#NETRF198
http://docs.oracle.com/database/122/DBSEG/configuring-authentication.htm#DBSEG99815
oracle用户下
cd $ORACLE_HOME/network/admin/sqlnet.ora
添加以下内容
SQLNET.ALLOWED_LOGON_VERSION=8
注意rac集群环境下要修改的oracle用户下sqlnet.ora而非grid用户下
2.修改用户名密码如果pdb需要切换到pdb下
在服务器端操作
cd cd $ORACLE_HOME/network/admin/
[oracle@rac2 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
SENDINFO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sendinfo)
)
)
su - oracle
sqlplus sys/oracle@sendinfopdb as sysdba
alter user bdltq identified by "sendinfo";
查询用户密码版本
SQL> select password_versions from dba_users where username=upper('bdltq');
PASSWORD_VERSIONS
----------------------------------
11G 12C
相关认证降级官方文档介绍
http://docs.oracle.com/database/122/NETRF/parameters-for-the-sqlnet-ora-file.htm#NETRF198
http://docs.oracle.com/database/122/DBSEG/configuring-authentication.htm#DBSEG99815
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24486203/viewspace-2146353/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
