You must start the Oracle listener service so incoming client connection requests are received and sent to the database server.
Procedure
- Open a command prompt window and set the ORACLE_HOME variable.
For example, in the command prompt window, enter: set oracle_home=c:\oracle\product\11.2.0\dbhome_1
- In the same command prompt window, enter lsnrctl start.
This ensures that an
OracleOraDb<nn>g_home1TNSListener service exists in the Services Control Panel. Where
<nn> is the Oracle version number.
For example:
- OracleOraDb11g_home1TNSListener
- Access Windows Administrative Tools then click on Services and locate the OracleOraDb<nn>g_home1TNSListener service. Make sure it is set to Automatic.
- Restart the OracleOraDb<nn>g_home1TNSListener service.
If your database and application server are not able to communicate with each other, it is typically because the two-way communication is blocked by a firewall or security settings are not matching. Refer to the topic about security and firewall configuration for more information.