Navicat remote connection to Oracle: error, ora-28547: connection to server failed, probable Oracle net admin error
Cool breeze AAA 2022-02-13 07:41:43 阅读数:503
Problem analysis
Use navicat Remote connection to the company's oracle The database reported the following error , Stuck for a long time .
reason
oci.dll Version inconsistency .
because Navicat It's through Oracle Client connection Oracle Server's ,Oracle There are two types of clients , One is the standard version , One is the simple version , namely Oracle Install Client.
And we use Navicat when It usually contains multiple versions of... In its own installation path OCI, If you use Navicat Connect Oracle The server appears ORA-28547 When it's wrong , Mostly because Navicat The local OCI Version and Oracle Caused by server mismatch . So all we have to do is download OCI Make it similar to what we installed Oracle Server match .
solve
OCI stay Oracl Download address on the official website ：
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
step
1. Select the corresponding version
Version Description : When you find the reason on the Internet , Many people say that no matter what their computer is 32 Bit , still 64 Bit , Can only download 32 Bit . Test and solve it yourself : Find out 32 Bit is still not connected , Another mistake :oracle library is not loaded. Later it was replaced by 64 Bits can be connected correctly .
This should be connected to oracle The version of has something to do with , Here I'll tell you the version of my successful connection for your reference : Computer :win10 64 position ,navicat:v12.0 Green decompression version ,OCI: The latest version downloaded from the official website ,windows64 19.10.0.0.0, Connected company oracle:64 11 edition
2. With windows64 Position as an example
Before downloading, you need to log in to your oracle account number , Without following the prompts, just register step by step .
3. Put the downloaded file locally
Don't have : chinese , Space , Special characters, etc
4. open navicat Replace the file
Tools — Options — Environmental Science
Select the path of the file just below .dll file
Be careful : Then click the OK button , Remember to restart navicat, Connecting oracle test , Generally, the connection can be successful at this time .
copyright：author[Cool breeze AAA]，Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130741407131.html
- Java compilation error: compilation failed
- Spring cloud startup error
- Java AWT stack overflow
- Zipfile invalid LOC header error in spring boot project
- Unexpected EOF read on the socket
- Spring security filterinvocation failed to get access path
- Springboot error
- Java program and vsftpd failed to upload files on the same machine. The file size is 0
- How to solve the error of PM2 installed offline under Linux
- There are too many zombie processes under the Linux top command. How do you know which process caused it
- Spring @ Autowired implementation details you don't know
- Mybatis plug-in extension and integration principle with spring
- Go deep into mybatis source code - execution process
- This time, understand the core principles of springboot (automatic configuration, event driven, condition)
- Understand the principle of spring MVC this time
- This time, understand the bean instantiation principle of spring
- This time, understand the XML parsing principle of spring
- In depth mybatis source code - configuration analysis
- On the source code of mybatis -- elegant and excellent skeleton
- Mysql database 5 --- database lock
- Mysql database 4 --- database index
- Mysql database 3 --- database storage engine
- Mysql database 2 - complex SQL commands
- Mysql database 1 - basic database commands
- HashMap and hashtable of the set
- Springboot interview questions
- Redis interview questions
- Design mode
- Mybatis interview questions
- Spring interview questions
- Redis tool class
- Mybatis plus (use of crud)
- Springboot integrates springsecurity II
- Dynamic SQL statements in mybatis framework
- Mybatis one to many query
- Mybatis executes many to one queries
- Three methods for spring MVC to obtain parameters -- Idea
- Addition, deletion and modification of mybatis - idea
- Introduction to mybatis - idea
- Spring MVC framework construction - idea
- Use Tomcat server, database, JSP and HTML to realize user registration
- Mysql database operation using JDBC
- Java school last semester's question, who can give a reference answer
- The data structure course is designed with queues to achieve the following
- MySQL Chinese garbled code has been changed to utf8. Is that still the case
- Help me see if the Hadoop cluster is successfully built and running, right
- What's the difference between flightboot and springboot
- How to learn Java? Recommended books? Please let me know!
- An error is reported when a website requests HTTPS using the requests module in Python
- What if Vue fails to access static resources after being deployed to a Linux server?
- If dynamic continuous results are needed, top Linux processes have five states. What are the corresponding status codes?
- How to deal with the unexpected result of logging in to Oracle
- When deploying the Vue project on the nginx server on Linux, you can only access the home page and other pages 404
- RM - RF / what if you really delete all Linux hard disk files!
- Library management system website (Application Technology: bootstrap, jQuery, JavaScript)
- Using jQuery to make simple addition and deletion of employee information
- Using JavaScript to do a simple page Jump
- MySQL basics -- 004 other database objects: views, stored procedures and functions, variables, process control and cursors, triggers
- MySQL basics -- 003 SQL DDL, DML and DCL usage: creating and managing tables, adding, deleting and modifying data processing, MySQL data types, constraints
- MySQL basics -- select usage of 002 SQL: basic select statements, operators, sorting and paging, multi table query, single line function, aggregate function, sub query