Omega Technical Support

Configuring 16 bit Tools for OmegaPS on Windows NT Client

Creating the NT Loop-Back to Enable 16 bit Tools

Create 'Alias'

To be used as the Host String when logging into SQL*Plus or OmegaPS.

Check that the TCP/IP protocol is installed on the client (and the adaptor). Make a note of the server's IP address.
At the Server End

Find the Easy-Config application off the Start Menu (normally in Oracle for Windows NT group).

At the script screens choose the following:

* Add DB alias
* What Alias "..." {alias name your choice}
* New Protocol "TCP/IP"
* TCP/IP host name "000.000.000.000"
* Server IP Address
* Summary - lists above choices
* Returns to the beginning - select Exit

Check that you can log into database through SQL*PLUS 3.3 using above host string.
At the Client End

If SQL*PLUS 3.3 is loaded on the machine, do the following:

* Copy TNSNAMES.ORA from
[ORAHOME_SRV]:\ORANT\NETWORK\ADMIN at the server
([ORAHOME_SRV] is the home drive of Oracle on server).
* Paste it to the
[ORAHOME_CLT]:\ORANT\NETWORK\ADMIN directory of the client
([ORAHOME_CLT] is the home drive of Oracle installation on the client).

Go to SQL*PLUS 3.3 (in Oracle for Windows NT group on Start Menu or PLUS33.EXE in ORANT\BIN). Try to login to the database using the string alias. Should be successful. Exit.

Copy the TNSNAMES file from the above location to the [ORAHOME_CLT]:\ORAWIN\NETWORK\ADMIN directory of the client (Note : ORAWIN = 16-bit tools directory).

Go to SQL*Plus 3.1 (in Oracle for Windows group on Start Menu or PLUS31.EXE in ORAWIN\BIN). Try to login to the database using the string alias Should now be successful.

If the above is successful, try to log into OmegaPS. It should succeed.

Back to Frequently Asked Questions