|
Standard |
Posted: 09/06/07
|
R State Standard |
£ Institutionally Developed |
College: n/a |
CIS 2132
– Oracle Network Administration
Course
Description:
Oracle Network Administration covers the tools
and techniques used when configuring an Oracle Database Management System in a
network environment. Upon completion of this course, the students will have the
skills necessary to configure and troubleshoot network connections to the
Oracle database. Topics include: be able to identify
networking issues and trends, understand Oracle networking solutions, use of Oracle
client/server software to establish database server connections, usage and
configuration of Oracle names, using Intelligent Agents, usage and
configuration of multi-threads servers, usage of the Connection manager,
troubleshooting networked Oracle environments, securing Oracle networked
databases, and establish competencies for Oracle Network Administration exam.
|
Competency
Areas: |
Hours:
|
|
|
Be able
to identify networking issues and trends |
Class |
4 |
|
Understand
Oracle networking solutions |
D. Lab |
4 |
|
Use of Oracle
client/server software to establish database server connections |
P.
Lab/O.B.I. |
0 |
|
Usage and
configuration of Oracle names |
Credit |
6 |
|
Using
Intelligent Agents |
|
|
|
Usage and
configuration of multi-threads servers |
|
|
|
Usage of
the Connection manager |
|
|
|
Troubleshooting
networked Oracle environments |
|
|
|
Securing Oracle
networked databases |
|
|
|
Establish
competencies for Oracle Network Administration exam |
|
|
|
Prerequisite: CIS 2128 and CIS 2129 |
|
Corequisite: |
|
Course Guide |
|
Competency |
After completing this section,
the student will: |
Hours |
||
|
Class |
D. Lab
|
P. Lab/ O.B.I. |
||
|
BE
ABLE TO IDENTIFY NETWORKING ISSUES AND TRENDS |
4 |
4
|
0 |
|
|
|
Be
familiar with Oracle client/server software capability and benefits. |
|
|
|
|
|
Learn how
to assess networking needs |
|
|
|
|
4 |
4
|
0 |
||
|
|
Understand
Client/Server connections (Net Service Names and Connect Descriptors) and Oracle
client/server software Architecture including the layers of the Oracle
communication stack |
|
|
|
|
4 |
4
|
0 |
||
|
|
|
|
|
|
|
|
|
|
|
|
|
USAGE
AND CONFIGURATION OF ORACLE NAMES |
4 |
4
|
0 |
|
|
|
Learn how
to setup centralized naming. Understand Oracle naming concepts and
architecture. |
|
|
|
|
|
Be able
to administer Oracle Names server using the Namesctl
utility. |
|
|
|
|
USING
INTELLIGENT AGENTS |
4 |
4
|
0 |
|
|
|
Learn how
to utilize intelligent agents for networking. |
|
|
|
|
USAGE
AND CONFIGURATION OF MULTI-THREADS SERVERS |
4 |
4
|
0 |
|
|
|
Understand
Multi-threaded server architecture and the connection process. |
|
|
|
|
|
Be able
to configure, and monitor a multi-threaded server, and to manage connection
pooling. |
|
|
|
|
USAGE
OF THE CONNECTION MANAGER |
4 |
4
|
0 |
|
|
|
Manage
connections using the connection manager. |
|
|
|
|
|
Learn
about connection manager capabilities and how to configure and monitor using
CMCTL. |
|
|
|
|
TROUBLESHOOTING
NETWORKED ORACLE ENVIRONMENTS |
4 |
4
|
0 |
|
|
|
Troubleshoot
network problems using TNSPING. |
|
|
|
|
|
Learn how
to troubleshoot basic problems and to enable logging and tracing with Oracle
client/server software. The use of Intelligent agents. |
|
|
|
|
SECURING
ORACLE NETWORKED DATABASES |
4 |
4
|
0 |
|
|
|
Understand
network security options and risks. |
|
|
|
|
|
Be able
to identify potential network security problems and utilize advanced network
option to assist with security resolution. |
|
|
|
|
ESTABLISH
COMPETENCIES FOR ORACLE NETWORK ADMINISTRATION EXAM |
4 |
4
|
0 |
|
|
Upon
completion of this course, the student should be prepared to take the Oracle Network
Administration exam. |
|
|
|
|
|
Suggested Resources |
Books:
Enterprise DBA Part 1B Networking; ORACLE; Oracle Academic Initiative
(OAI) program, http://www.Oracle.com/
Oracle 8i: Network Administration; ElementK
Press (www.elementk.com); ISBN: 0-791-541E
Reference Books:
Oracle Press http://www.Oracle.com/