This Oracle Networking course introduces Oracle Network Services features and covers all areas of Oracle Network Administration including tnsnames.ora, Oracle database links. Identify networking log and trace files, Describe the Oracle*Net features, Develop a network topology, De-bug Oracle connections issues with ping and tnsping, Create a tnsnames.ora, protocol.ora and sqlnet.ora file, Configure and manage the listener using the listener.ora file, Set up multiple listeners using the Oracle Multi-threaded server (MTS), Install and manage Oracle*Net clients, Define remote connectivity between Oracle databases within SQL.
Advanced Queuing
A pre-defined package enabling you to store messages into queues for deferred retrieval and processing by the Oracle server.
Advanced Queuing (AQ)
A utility to store transactions in a queue, distribute the queue to other databases, and then retrieve and run the queued transactions.
Cache fusion
A diskless data transfer method for Oracle Parallel Server (OPS) that moves information from the cache of one database instance to the cache of another database instance.
Connection load balancing
A feature of Net8 that reviews the load on each of a group of database services or database dispatchers, and then selects the least busy available service or dispatcher and assigns a new connection to it.
Connection Manager
A service that can be run along with Net8 to control multiple connections going to a Multi-Threaded Server.
Connection pooling
A feature of Multi-Threaded Server in which idle user connections are re-used temporarily, allowing more concurrent users to reach the database.
Deployment template
A set of commands that create one or more snapshots at a remote site. The template can be used repeatedly to create identify sets of snapshots at multiple remote sites.
Disk affinity
A database instance of an Oracle Parallel System has disk affinity with a data file when the data file is located on a disk that is mounted on the same computer as the database instance.
Equipartitioned table
A partitioned table that has an index that is also partitioned in exactly the same way as the table.
getOracleArray
The getOracleArray method is an Oracle-specific extension that is not specified in the standard Array interface. The getOracleArray method retrieves the element values of the array into a Datum[] array. The elements are of the oracle.sql.* data type corresponding to the SQL type of the data in the original array. For an array of structured objects, this method will use oracle.sql.STRUCT instances for the elements.
Oracle also provides a getOracleArray(index,count) method to get a subset of the array elements.
Index-organized table
A table that is stored in the database in physical order by its primary key.
Instance affinity
A feature of DBMS_JOB package that limits a job in OPS to one database instance.
Instantiate
To create a specific version of an object (such as a snapshot) based on a template and some specific variables.
MAP MEMBER function
A function defined as part of an object type to sort or compare object rows with one another.
Multimaster replication
Advanced replication features allowing updates on tables in remote sites as if every site were the master site.
Multiplexing
Combining several individual transmissions and sending them across a single connection to and from a database.
Node affinity
A database instance of an Oracle Parallel System has node affinity with a data file when the data file and the database instance are located on the same computer (also called the node).
Offline instantiation
Creating snapshot templates using export and import utilities. No connection is required between the master and the remote site during the process.
Online instantiation
Creating snapshot templates in real time with a connection between the master and the remote sites.
Oracle Parallel Server
A database server consisting of multiple database instances that act as a single database. The OPS distributes activity by concurrently executing transactions on multiple database instances. Each database instance can be located on a different machine to maximize use of resources.
Parallel queries
Queries are divided into smaller sections, and each section of the query executes simultaneously (in parallel) in the database server. This is not the same as Oracle Parallel Server.
Partitioned table
A table containing data in multiple physical tables. This divides large amounts of data into smaller segments.
Partitioning
Dividing one table into several sections, or partitions, which are physically stored as if each partition were a separate table.
Primary key snapshot
A copy of a table or view. Changed rows are refreshed by retrieving the row using its primary key value.
RADIUS
Acronym for Remote Authentication Dial-In User Service, a client-server security protocol that is used primarily with the Internet.
Row movement
The automatic shifting of a row from one partition to another when the value of the partitioning column in the row changes so
that the row belongs in a different partition.
ROWID snapshot
A copy of a table. Changed rows are refreshed by retrieving the row using its ROWID.
Snapshot
A replica of a table or part of a table that resides on another database instance. Snapshots can be read-only or updateable.
Super administrator
In Oracle Enterprise Manager, a user with full privileges on the OEM console.
Transparent application failover (TAF)
A feature in Net8 to seamlessly move a user’s session from one instance to another when the original instance fails.
Trusted
A security model in which an administrator has access privileges to local and remote sites.
Untrusted
A security model in which an administrator has access privileges only to the local site.
Updateable snapshot
A snapshot that supports insert, update, and delete on the remote site.