Tuesday, June 5, 2007

TNS, TNSnames.ora

TNS

TNS or Transparent Network Substrate is Oracle's networking architecture. TNS provides a uniform application interface to enable network applications to access the underlying network protocols transparently.

TNSNAMES.ORA

TNSNAMES.ORA is an ASCII text file that provides SQL*Net with server location and necessary connection strings needed to connect to Oracle databases. This file normally resides in the ORACLE_HOME\NETWORK\ADMIN directory.

REFERENCE:

Oracle Glossary

BOYER MOORE ALGORITHM

Algorithm's explanation and more.

See here.