Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to solve the problem of error reporting in Oracle12c connection. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

During this period of time, because of the project, I came into contact with Oracle12C. In fact, the problem is very simple, that is, pl/sql developer can access the database server, but it has encountered a strange problem. Now share it.

1. An Ora-12505 error, i.e. TNS:listener does not currently know of SID given in connect descripter, is reported on the java side.

Note: find the database administrator, the database management is told to the database service name, after the change, do not report the error for the time being.

2. Report an Ora-01017 error on the pl/sql developer client, that is, promote invalid username/password.logon denied.

Note: ask the database administrator to help check, there is no problem logging in his client, but there is still a problem in the client login here.

3. Check the reason on the Internet and find out why you can't log in. The reason is that there is a compatibility problem when Oracle accesses the Oracle12c server, but because the database server is not maintained locally and cannot be changed or restarted without authorization, you can only consider the client solution.

3.1Note: find the location of the installer in cmd before executing the command

Setup.exe-ignorePrereq-J "- Doracle.install.client.validate.clientSupportedOSCheck=false"

3.2 modify sqlnet.ora

1) in the server environment, modify sqlnet.ora and add the following two lines:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

The number represents the minimum version number that can be connected.

2) restart the listening service: lsnrctl restart

3.3 change the password for new users in Oracle to make the compatibility effective.

ALTER USER username IDENTIFIED BY password

Select username,account_status,default_tablespace,created,password_versions from dba_users

3.4.Create a clocked # user, create user c##test identified by test

Among them, 3.1was ineffective, 3.2was unable to check the database environment, 3.3changed password authentication was still useless, 3.4.The dba refused to do it.

4. A path in a dead end. Change the Oracle client version.

Through searching on the Internet, we found a compatibility table between the client and the server, to the effect that only 11.2.0.3 and above can support access to the relevant version of Oracle12c.

The client-server compatibility is shown in the following table

5. Install a new Oracle12c client and report an INS-30131 error, that is

Initial setup requierd for the execution of installation failed

Note, query Baidu again and find that the problem is caused by the previous java version of the Oracle client. Delete and reinstall it.

6 、 OK

This is the end of this article on "how to solve the problem of reporting errors in Oracle12c connections". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please 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.