Discover Navicat as a database-connected tool that really works well, the visual interface looks a lot more comfortable, here are some of the issues I have today when connecting to the Oracle database:
1, after the installation of Oracle directly with Navicat is not connected, will appear as the error; When you use Navicat to connect to Oracle, you must first download the Oracle instantclient client and download it on the official website.
2. Unpack the downloaded installation package; open Navicat, Tools = = "oci==" in the OCI library select just extracted oci.dll path, determined to restart.
3, then enter our connection name, connection address, here we use the system user name systems can be connected to the
4, after the connection, we create a new user, the permissions and the Scott (Oracle provided test user) user settings are the same, but the Admin user just created the connection with an error, such as:
5, determine the user name and password are not wrong, but is a hint of error. In fact, the reason is very simple, we create users when the user name must be capitalized. This will make the connection successful.
Some problems connecting Oracle data using NAVICAT, connection error: ORA-28547, connection error after new User: ORA-01017