The premise is that the firewall on the server has been disabled or port 1521 has been replaced.
To connect to the oracle server on a machine without an oracle Server, first install the oracle client.
I am now installing an oracle lite client. After installation, open PLSQL Developer. You will be prompted to enter the user name and password:
Click "cancel". On the displayed page, click "Tools"> "Preferences"
The preceding figure shows how PLSQL Developer connects to the database without installing the oracle server. Next I will explain how Navicat. for. Oracle connects to the database.
Because there are a lot of Navicat. for. Oracle green version downloads on the Internet, but after you download it, you will find that it is not a green version at all. My version is really green and free, and there is a registration machine in it, you can choose according to the actual situation.
After installing the oracle client and Navicat. for. Oracle, open Navicat: Select "Tools"> "options"
PS: Since I have just learned some oracle and I am not very familiar with these things, I can only post it easily. Hope you guys don't laugh ......
Navicat_for_Oracle Database Server Management http://u.115.com/file/clo382to
Oracle_10.2 _ perfect lite client _ 30 m http://u.115.com/file/clo3ptzr only
This article is from the "lanni654321" blog