You can find TNSNAMES.ORA file in oracle installed folder.
Add and entry in the file as follows
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.1)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
If you are facing any problems, just check the following tnsping in command prompt.
- Ping your ip address as in the following example.
C:\Documents and Settings\test>tnsping 192.168.101.1
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 26-AUG-2
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.1)(PORT=1521)))
OK (30 msec)
- Open PL/SQL Developer and login with your username, password and give database as HOST_XE which you specified in the TNSNAMES.ORA file.
If any problem, please let me know.