Omega Technical Support

Tips on Getting Oracle 16-bit Tools to Work Correctly

Sometimes there are problems logging into the database through a client machine, even when all configuring seems complete. This could be due to the following problems at the client:

1. The TNSNAMES.ORA file needs another port added.
2. On installation the TCP/IP adaptor did not install correctly.

Try to fix the problem in 1) first.
Solutions

1. Manually edit the TNSNAMES.ORA file according to the following instructions:

The following segment of TNSNAMES is the connection through TCP/IP. In this example, the host string, or "alias name" is OMEGAPS. The IP address of the server is 193.117.113.61.

Copy the copy the first address block to create the second below it and change the Port Number to 1526. Ensure the brackets are included.

omegaps.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 193.117.113.61)
(Port = 1521)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 193.117.113.61)
(Port = 1526)
)
)
(CONNECT_DATA = (SID = omegaps)
)
)

2. If the installation of 16-bit SQL*Net tools did not correctly complete, try the following:
1. Remove all the 16-bit tools from the client using the installer.
2. Check that the paths in AUTOEXEC.BAT do NOT have any reference to the OmegaPS directories (they have some DLLs which the installer will try to replace). Just REM them if they exist (put them back after installation).
3. Reinstall the 16-Bit tools. And follow the config instructions.

Back to Frequently Asked Questions