Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to solve the problem of connecting Oracle 12C ORA-01017 in applications. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

1. Modify the database server authentication level and modify the file

Under oracle users

Cd $ORACLE_HOME/network/admin/sqlnet.ora

Add the following

SQLNET.ALLOWED_LOGON_VERSION=8

Note that the oracle users to be modified in the rac cluster environment are under sqlnet.ora instead of grid users.

two。 Change user name and password if pdb needs to switch to pdb

Operate on the server side

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"

Query user password version

SQL > select password_versions from dba_users where username=upper ('bdltq')

PASSWORD_VERSIONS

-

About the application connection Oracle 12C ORA-01017 problem is how to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.