Add a Local Name Service

Set Environment Variables

Configuration

Testing the Connection

 

Add a Local Name Service

Run the Oracle Net Configuration Assistant. The name of the executable is netca, and it is in the bin directory. The assistant prompts you to define a service name, a network protocol, a host name, and a port. With this information, it creates an entry for the service name in the tnsnames.ora file

1. Click the radio button labeled Local Net Service Name Configuration. Click Next.
2. The add operation is selected by default. Click Next.
3. In the text box labeled Service Name type the Global Database Name of the target Oracle instance. For this exercise the service name is r10102.ads.autodesk.com. Click Next.
4. The TCP protocol is selected by default. Click Next.
5. In the text box labeled Hostname type the fully qualified name of the host where the Oracle instance is located. The port value is 1521 by default. Click Next.
6. The option to test the connection is selected by default. Click Next.
7. By default the text box labeled Net Service Name contains the root of the service name, that is, the characters preceding the dot (.) signaling the start of the domain name part. For this exercise this value is r10102. Click Next.
8. The option not to configure another name is selected by default. Click Next.