When configuring Oralce client or server side problems, consider the following steps:
1 Check the following files:
Client side:
D:\app\Administrator\product\11.2.0\client_3\network\admin
Listener.ora
Tnsnames.ora
Server side:
D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
Listener.ora
Tnsnames.ora
2 Checking the firewall
The firewall may block client access;
3 Oracle Client Configuration
When the client configures service naming, the service name corresponds to the database server's global database name, for example: ORCL
Host address, IP address of the bit database server
Client Configuration "Listener", Listener configured "host" address is the IP of the database
4 Database Server firewall issues
Client access to database server Yes, server side need to add port exception, or shut down firewall
Some ideas on how to configure Oracle database when installing