DAVIS FMS DriveRight Database Selection Guide (8186) - Manual (Page 14)

14
15. When you are prompted to configure another Net Service Name, select No and
click Next. Then click Finish.
16. Click Exit. The Oracle 9i client installation is finished. See “Creating and
Configuring Oracle DSN” on page 15 for the next steps in the process.
Creating Listener and Net Service Name Manually
If you are in this section, you had problems creating a service name while creating
Oracle Client. If everything worked fine in the previous section move on to the
next section.
1. First close the present Oracle Client Installation dialog box. A message may
display that states that some things are not installed correctly. Use the
following steps to correct the process.
2. Go to Programs->Oracle-OraHome90->Configuration and Migration Tools-
>Net Manager.
3. Expand the directory to Local->Listeners. If LISTENER is displayed, a
listener was created during the 9i Client installation. If so, see step 5 below.
4. Click on Listeners, and then click the '+' icon on the left side if LISTENER is
not displayed. Leave the name as 'LISTENER'. Then click Add Address and
leave the defaults alone.
5. Click Add Address again, and select Protocol as IPC from the Protocol drop
down box. Enter the key as 'EXTPROC0' (The last character is a zero, and the
character before C is capital letter O).
6. Expand Service Naming. If you see a child node, with a name similar to
dright.davisnet.com, continue on to Step 9.
7. Click Service Naming and then click the ‘+’ icon. Add Net Service Name as
'DRight'. Click Next twice. In the Host Name, enter the Oracle server IP
address. Click Next to continue.
8. Select Oracle8i or later, and enter DRight in the text box. Click Next.
9. Click Test. If this step fails, please contact your database administrator. If this
step succeeds, click Change Login and change both the user name and
password to the user name and password provided by your database
administrator.
10. Click OK and click Test again. Then close the dialog box.
11. Click Finish.
12. Expand Service Naming, select the child node which looks similar to:
(DRight.your_company_name.com). Check for the parameters. Host Name
should be the IP address of your Oracle server.
13. Close Net Manager, and click Save when it prompts you. for the next steps in
the process.