Oracle Net Manager

Net Manager is an utility come together with Oracle DBMS. User can find it inside Network Administrator at start menu or execute it by using command netmgr. Net Manager serves for 2 main purposes:

Set TNS Name at client PC. TNS name is the connection setting at client PC so that it is able to access database.

1. Go to the tree navigator, select Service Naming and click add (green plus button at left panel).
2. Set Net Service Name, what ever name you want.
3. Set Network Type, which normally TCP/IP.
4. Set Host Name and Port Number. Host Name you can either use IP address or DNS Name (if you got a DNS server at your network). While the default port is 1521.
5. Set Service Name and Connection Type. Service Name is the name of the database, while Connection Type we can left it as default.
6. Done.

Set Listener at Server. Listener is a process to accept connection from client and pass the connection to the database.

1. Go to the tree navigator, select Listeners and click add (green plus button at left panel).
2. Set what ever name you want for the listener.
3. At the top of right panel, you can see a drop down box, which we need to set 2 things: Listening Location and Database Services.
4. Listening Locations: add new a address, fill in Protocol (TCP/IP), Host (normally localhost will do where listener is resided together with the database) and Port (default 1521).
5. Database Services: add new database, set Global Database Name and SID (both are the name of database) and Oracle Home Directory (where you install oracle DBMS).