Oracle Database Administration/Network

This lesson introduces the Oracle database network environment.

Objectives and Skills
Objectives and skills for the network environment portion of Oracle Database Administration I certification include:
 * Configuring the Oracle Network Environment
 * Configure and Manage the Oracle Network
 * Using the Oracle Shared Server architecture

Readings

 * 1) Oracle: Database 2-Day DBA Configuring the Network Environment

Multimedia

 * 1) YouTube: Understanding the tnsnames.ora and listener.ora files

Network

 * 1) Configure the network environment.
 * 2) Complete the tutorial Oracle: Configuring the Network Environment.

Listener

 * 1) Stop and start the listener.
 * 2) Review Oracle: Configuring and Administering Oracle Net Listener.
 * 3) Use Enterprise Manager to stop and start the listener.
 * 4) Use the following commands to view status, stop, and start the Enterprise Manager console service:
 * 5) Use the Windows Services management console to view status, stop, and start the OracleOraDb11g_ TNSListener service.
 * 6) Test local and remote connections.
 * 7) Review Oracle: Net Services.
 * 8) Use SQL*PLUS or SQL Developer to connect to the database from the server and from a network client to verify functionality. Close the client application.
 * 9) Use Enterprise Manager, , Services, or the   command to stop the listener service.
 * 10) Use SQL*PLUS or SQL Developer to connect to the database from the server and from a network client to verify functionality. The local server connection should still work, while the network client connection will fail.
 * 11) Use Enterprise Manager, , Services, or the   command to start the listener service.
 * 12) Use SQL*PLUS or SQL Developer to connect to the database from a network client to verify functionality. Do not close the client application.
 * 13) Use Enterprise Manager, , Services, or the   command to stop the listener service.
 * 14) Use the following query to select instance information:  Stopping the listener prevents new network connections but does not interrupt existing connections.
 * 15) Use Enterprise Manager, , Services, or the   command to start the listener service.
 * 16) View listener settings.
 * 17) Review Oracle: Managing Oracle Net Services.
 * 18) Use Enterprise Manager to view listener settings.
 * 19) Use a text editor to open the %ORACLE_HOME%\network\admin\listener.ora file and view listener settings.
 * 20) Use Net Manager to view listener settings.
 * 21) Use Network Configuration Assistant to view / reconfigure listener settings. Cancel the assistant without saving changes.

TNSNAMES

 * 1) View and edit tnsnames.ora settings.
 * 2) Review Oracle: Local Naming Parameters (tnsnames.ora).
 * 3) Use a text editor to open the %ORACLE_HOME%\network\admin\tnsnames.ora file.
 * 4) Use the following command to connect to the local server using this tnsnames.ora file:  The connection should work, using the orcl connection information found in tnsnames.ora.
 * 5) Use the following command to connect to the local server using this tnsnames.ora file:  The connection should fail, because there is no test service entry in the tnsnames.ora file.
 * 6) In tnsnames.ora, copy the existing orcl service entry and paste it after the existing entry. Rename the copied service entry as TEST. Leave all other information as is. Save the updated tnsnames.ora file.
 * 7) Use the following command to connect to the local server using this tnsnames.ora file:  The connection should now work, because there is a test service entry in the tnsnames.ora file.

SQLNET

 * 1) View sqlnet.ora settings.
 * 2) Review  Sqlnet.ora and Oracle: Profile Parameters (sqlnet.ora).
 * 3) Use a text editor to open the %ORACLE_HOME%\network\admin\sqlnet.ora file.
 * 4) Examine each entry in the file to determine the result of that setting.

Shared Server

 * 1) Review Oracle: Configuring Oracle Database for Shared Server.
 * 2) View the current server environment.
 * 3) Open two command prompts, one for viewing listener status and one for SQL*PLUS queries. Connect to Oracle using:
 * 4) Use the following query to display current processes:
 * 5) Use the following command to view listener status:
 * 6) Configure the shared server environment.
 * 7) Use SQL*PLUS to enable shared server processes with the following query:
 * 8) Configure dispatcher processes with the following query:
 * 9) Register the configuration with the following query:
 * 10) Use the following query to display current processes:  Note the addition of the D0?? and S0?? processes.
 * 11) Use the following query to display shared server information:
 * 12) Use the following query to display dispatcher information:
 * 13) Use the following command to view the new listener status:  Note the additional dispatcher listener configuration.
 * 14) Reset the shared server environment.
 * 15) Use the following query sequence to reset the shared server environment:
 * 16) Query V$PROCESS, V$SHARED_SERVER, and V$DISPATCHER and view listener status to confirm the configuration.