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.
»
- Login to post comments

