Use the Net Configuration Assistant to add a service which listens on a TCP port for database connect requests.
Select Net Configuration Assistant from
the menu path StartPrograms
Oracle
- OraDb10g_home1
Configuration and Migration
Tools.
Use this assistant to add a Listener Configuration. Use the default string ‘LISTENER’ for the Listner name value. Select TCP as the protocol. Use the default port 1521. Use the symbolic host name for your machine for the HOST value.
Verify that the listener service is running
Click on theServices icon
in the Administrative Tools folder.
The access path is StartPrograms
Settings
Control
Panel
Administrative Tools.
In the Services window, you will
see a service whose name is something like OracleOraDb10g_home1TNSListener and
whose status is Started.
Edit the listener.ora file in C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN. You will an entry for LISTENER that will look like the following.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = otwshak.ads.autodesk.com)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)