Oracle Database Connection Analysis

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.