RelationalDBDesign RelationalDBDesign


Managing Users  «Prev 

Oracle Net Configuration Assistant

  1. Start by clicking Start to open the Start menu.
  2. Next click Programs to open the Programs submenu.
  3. Click the entry for Oracle - OraHome81.
  4. You will find Oracle Net Configuration Assistant in the Network Administration submenu, so click Network Administration.
  5. The depth to which these menus are nested makes it difficult to find things, but you should see an icon labeled Oracle Net Configuration Assistant. Click it.
  6. This is the Oracle Net Configuration Assistant opening screen. Notice the action radio buttons to the left.
    Create is the default choice, and it has already been selected for you. All you need to do is enter a service name for the database to which you want to connect. The service name may be anything you like, but let's use "COIN" for this example.
    Type COIN into the service name field, and click the Next button.
  7. Now you need to choose the network protocol that you are using. TCP/IP is by far the most commonly used, so let's go with that. Click the Next button to continue.
  8. This screen asks you for the name of the host computer, and also for the TCP/IP port number. The port number should match that in your listener.ora file. Take the default of 1521 unless you chose some other value during the initial install. You do need to fill in the Host Name field with either a TCP/IP address or name. For this example, enter an address of 10.11.49.239. Then click the Next button.
  9. Now you need to choose whether you are accessing your database using a service name or a SID. In this instance, we are using a SID. Click the bottom radio button, enter COIN into the Database SID textbox, and click Next to continue.
  10. You are almost done. If you like, you can test the connection, or you can just click Next to finish without doing the test. For this simulation, click Test.
  11. Oracle Net Configuration Assistant performs the test by attempting to connect with the username and password of SCOTT/TIGER. Since our COIN database does not have this user, the test failed. Click the Change Login button to supply a different username and password.
  12. The Change Login window opens, and you may now enter a valid username and password for the database to which you are trying to connect. Enter system for the username, and manager for the password, then click OK.
  13. The popup window closes, and you are brought back to the Connection Test screen. Click the Test button to try the test again.
  14. This time, using a valid username and password, you can see that the test was successful. Click the Close button to close the Connection Test window.
  15. The Connection Test window has closed. Now, press Next to continue the configuration process.
  16. The configuration is complete. An entry for COIN has been added to your tnsnames.ora file. Click the Finish button to leave the Easy Config program.
  17. The Net8 Easy Config window closes. This is the end of the simulation. Click Exit to return to the lesson.