Oracle Database Connection is analyzed in various environments, allowing you to quickly solve some database connection problems.
Oracle Database Connection is analyzed in various environments, allowing you to quickly solve some database connection problems.
1. Connect to the local database
A. if the local machine has A static IP address, after oracle is installed, it can connect to the local oracle database.
B. When oracle is installed, the local machine does not have a static IP address (that is, when the network cable is not plugged in ).
Modify the HOST in the tnsnames. ora and listener. ora files in the NETWORK \ admin files to the name of the local computer.
If the computer name is not set, modify the WINDOWS \ system32 \ drivers \ etc \ hosts file.
2. Connect to the server
A. Enable the instance service and listener.
B. Enter netManager to create a connection.
3. Connection notes
A. sqlplus nxg/nxg @ orcl format connection. You must enable the listener.
B. You must enable the listener when using pl-SQL.
C. Connect to MySQL. The connection string jdbc: oracle: thin: @ localhost: 1521: orcl must be a service.
Instance name, rather than the alias on the local machine.