Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g

Overview/Description
To outline the concepts and processes to secure the Oracle listener and to work with remote and distributed transactions

Target Audience
Oracle database administrators and database operators

Prerequisites
Experience in Oracle database administration; mastery of Associate level content for Oracle 10g; proficiency in programming with SQL and PL/SQL

Expected Duration
135 Minutes

Objectives:

Controlling the Oracle Listener and Enabling Distributed Transactions in Oracle 10g

  • set the listener password and specify who can access a database.
  • improve the security for external procedures.
  • tighten security for the Oracle 10g listener.
  • use Net Services to connect to a database.
  • create database links and view information about them.
  • recognize situations when manual resolution of distributed transactions is required.
  • use database links and transactions.


    • Course Number: 212478_eng