The following steps walk you through the process of making a connection from a Windows client machine to an Oracle database.
- The first step is to launch the Oracle Net Services Assistant. (We have already done that for you.)
Double-click "Service Names" in the directory tree to launch the wizard you will use to add a TNS service name.
- The next step is to provide the TNS service name. This is normally the same name as the remote database unless you have multiple databases with the same name in your network. In this case, we will call our service name "edi1."
edi1 in the Service Name field. Then click the Next button.
- Next you choose the protocol, in this case TCP/IP. Click the Next button to accept this protocol.
- Next you are prompted for the host name and the port number. You can enter an IP address into the Host Name field, but it is not recommended. Instead, type
dilbert in the Host Name field. There is no reason to change the port number--1521 is the port number for most Oracle databases. So leave it as it is and click the Next button.
- Next, you need to specify the remote database system ID (SID). As you will note from the guidelines included in the wizard, ORCL is the default, but let us assume you want to rename it. Normally, you would select ORCL and simply overtype to enter your desired SID.
However, for the purposes of this simulation, simply click within the Database SID field and we will erase ORCL for you.
- Now type
fred, the new database SID, in the Database SID field. Then click the Next button to advance to the next screen.
- At this point, you have the opportunity to verify that a connection to the database can be made using the information you have provided. Click the Test Service button to run the test.
- To run the test, you need to enter a valid database user name and password. Type
system in the Username field. We have provided a secret password for you, so simply click in the Password field to make your password appear.
- Then click the Test button to initiate the test.
- For the purposes of this simulation, let us assume the test was successful. (And of course, you are just as likely to be successful in a real situation!) Click the Done button to complete the connection process.
- Now click the Finish button to create the new service name. This concludes the simulation.