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.
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.
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.
A service that can be run along with Net8 to control multiple connections going to a Multi-Threaded Server.
A feature of Multi-Threaded Server in which idle user connections are re-used temporarily, allowing more concurrent users to reach the database.
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.
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.
A partitioned table that has an index that is also partitioned in exactly the same way as the table.
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.
A table that is stored in the database in physical order by its primary key.
A feature of DBMS_JOB package that limits a job in OPS to one database instance.
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.
Advanced replication features allowing updates on tables in remote sites as if every site were the master site.
Combining several individual transmissions and sending them across a single connection to and from a database.
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).
Creating snapshot templates using export and import utilities. No connection is required between the master and the remote site during the process.
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.
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.
A table containing data in multiple physical tables. This divides large amounts of data into smaller segments.
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.
Acronym for Remote Authentication Dial-In User Service, a client-server security protocol that is used primarily with the Internet.
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.
A copy of a table. Changed rows are refreshed by retrieving the row using its ROWID.
A replica of a table or part of a table that resides on another database instance. Snapshots can be read-only or updateable.
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.
A security model in which an administrator has access privileges to local and remote sites.
A security model in which an administrator has access privileges only to the local site.
A snapshot that supports insert, update, and delete on the remote site.