Oracle Database cannot be accessed using localhost and 127.0.0.1

Oracle Database cannot be accessed using localhost and 127.0.0.1

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:

In the LISTENER Configuration, enter the host name of the Local Machine: zht-ylmf

The host name can be obtained through the> hostname command in the cmd command line:

After configuring LISTENER, enter localhost, 127.0.0.1, or 192.168.135.90 as the host name in the naming service, and then use PL/SQL Developer to access the database.

Migration from 32-bit to 64-bit for a single Oracle instance

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian