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

This article mainly introduces how to solve all kinds of problems when navicat links to oracle. It is very detailed and has certain reference value. Friends who are interested must finish it!

1. ORA-28040: there is no matching authentication protocol

Method: find the sqlnet.ora file under the installation path of Oracle. (my installation path E:\ app\ sa1\ product\ 12.2.0\ dbhome_1\ network\ admin\ sqlnet.ora) it is solved by adding SQLNET.ALLOWED_LOGON_VERSION=8 at the end of the file

2.ORA-12560TNS: protocol adapter error

1. The listening service is not up. The windows platform operates as follows: start-programs-management tools-services, open the services panel

Start the OracleOraDb11g_home1TNSlistener service.

2.database instance didn't get up. The windows platform operates as follows: start-programs-management tools-services, open services

Panel, launch OracleServiceBOOKSALES, BOOKSALES is your database SID

3.ORA-01017: invalid username/password; logon denied

Open sqlplus

User name: SYSTEM

Password:

Log in

Create a new user

Syntax: create user username identified by password

Unlock the syntax for the newly created user:

Syntax: alter user username account unlock; (unlock is unlock, lock is lock)

Grant creation rights to newly logged-in users

Syntax: grant create session to user name

Grant database administrator privileges to the newly created user:

Syntax: grant dba to user name

Grant additional permissions to the user:

Directive:

GRANT CREATE USER,DROP USER,ALTER USER, CREATE ANYVIEW, DROP ANYVIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA, CONNECT,RESOURCE,CREATE SESSION TO C##kou

Switch to the newly created user login syntax: connect username / password

Instruction: connect C##kou/kou

Delete user syntax: drop user user name

Instruction: drop user C##user

If the user has a datasheet, it cannot be deleted directly. Use the keyword cascade:

Instruction: drop user user01 cascade

The above is all the contents of this article entitled "how to solve all kinds of problems in navicat linking oracle". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.