Oracle cannot connect over an IP address

After the Oracle installation is complete and sometimes cannot connect using the IP address or cannot connect at all, we can solve this problem by configuring the monitoring of Oracle;

Locate the net Manager for the Oracle folder in the Start menu, as shown in changing the location shown to the IP address of the local computer

Then select database service, modify the default database service information for the database instance information that is installed by default when you install it

After the configuration is complete, click on the file, save the network configuration, and then restart the service monitoring services;

However, this mode can no longer be used with localhost or 127.0.0.1来 to access, we may add a listening address in the above listener, as follows

Click Save Network Service and restart Listener, which can be accessed either via IP address or localhost

Oracle cannot connect over an IP address