Connecting multiple Oracle SQL Databases with TNSNames

Oracle database is a database which is commonly referred to as Oracle RDBMS or simply as Oracle and the Oracle Corporation produced and marketed this.  Oracle database management can track its computer data storage by the help of information which is stored in the SYSTEM tablespace. The SYSTEM tablespace contains the data dictionary—and by default […]

Creating a local Oracle Database Service with TNSNames

Oracle database, produced by the Oracle Corporation, is written in C,C++. This is a ORDBMS typed database.  The Oracle RDBMS, which is defined previously, stores data logically in the form of tablespaces and in physically it stores data in the form of data files ("datafiles"). Tablespaces contains memory segments of various types like Data Segments, […]

Local naming parameters, a tnsnames.ora file

Local Naming parameters is a tnsnames.ora file which is a configuration file that contains net service names mapped to connect descriptors for the local naming method or mapped to listener protocol addresses. By default, the vary file tnsnames.ora can be stored in the  $ORACLE_HOME/network/admin directory on UNIX operating systems and on Windows operating systems in […]