SQL*Net Issues

Submitted by admin on Sat, 2004-08-07 07:17.

Assign a TCP/IP port to each database. You can't use one port to listen to all your databases like on Unix systems.
If you make use of database links or any distributed functionality like snapshots, Oracle will dedicate worker tasks unless you go through the TCP/IP drivers.
Some of the more popular protocols are: TCP/IP (T: driver); VTAM (B: driver); LU6.2 (L: driver); cross memory (Z: and M: drivers); etc.
The M: cross memory driver is supported for compatibility only. Convert to Z:
SQL*NET V2 is faster (but more difficult to configure) than V1 and uses a separate TNS address space.
TNS should have higher priority than CICS and MPM.