How can a technician use the OSI 7-layer model as a troubleshooting tool for a database issue?

What will be an ideal response?


Try a top-to-bottom or bottom-to-top OSI model approach to the problem. Sometimes it pays to try both.
7 - Application:     Could there be a problem with the API that enables the database application to connect to the database server?
6 - Presentation:    Could there be a problem with encryption between the application and the database server?
5 - Session:           Could a database authentication failure be preventing access?
4 - Transport:        Perhaps extreme traffic on the network could block an acknowledgment segment? This seems a bit of a reach, but worth considering.
3 - Network:         Someone might have changed the IP address of the database server.
2 - Data Link:       The MAC address of the database server or the user's machine might be blacklisted.
1 - Physical:          A disconnected cable or dead NIC can make for a bad day.
 

Computer Science & Information Technology

You might also like to view...

A style manual outlines the required rules and conventions related to the preparation of a paper

Indicate whether the statement is true or false

Computer Science & Information Technology

After you add two related tables to the query design, a ____ shows the relationship between the tables.

A. relationship line B. help line C. join line D. match line

Computer Science & Information Technology

Which of the following represents the speed of the CPU?

a. TDP b. Cache c. Internal clock speed d. Bus speed

Computer Science & Information Technology

A structure chart shows the functional flow through a program.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology