Oracle databases cannot be accessed using localhost and 127.0.0.1. oraclelocalhost

Oracle databases cannot be accessed using localhost and 127.0.0.1. oraclelocalhost

I recently learned about Oracle databases and installed Oracle 10g (Version: oracle_10g_10.2.0.20.win32) in Windows XP SP3 on a virtual machine ).

After the installation is complete, use PL/SQL Developer to access the Oracle database and find that the database can only be accessed using IP addresses (192.168.135.90), rather than localhost and 127.0.0.1.

After research, it is found that this is caused by LISTENER Configuration problems.

Solution: When configuring LISTENER, use the host name instead of the IP address or localhost.

The LISTENER Configuration after resolution is shown in:

Open the Oracle Net Manager tool and configure LISTENER:

Host entry in LISTENER ConfigurationHost Name of the Local Machine: Here I am zht-ylmf

The host name can be passed in the cmd command line>HostnameCommand:

After configuring LISTENERHost NameEnter localhost, 127.0.0.1, or 192.168.135.90. Then PL/SQL Developer can access the database.