Add a Listener

Create a Database

Installing and Configuring an Oracle Database on Windows

Add a Service Name

 

Add a Listener

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 StartProgramsOracle - OraDb10g_home1Configuration 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 StartProgramsSettingsControl PanelAdministrative 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))      

) 

) 

)