Computer

PHP/Oracle Development


Syllabus
Schedule
Reading
Discussion
Project
Test
Resource
Tip

Review Questions: Week 6
(Access to Oracle Database)

  1. How do you know if the Oracle database on your computer is available?
  2. How can you tell if Oracle TNS Listener is up and ready to communicate?
  3. If the Oracle TNS Listener has not been started yet, how do you start the listener?
  4. What does "lsnrctl" utility do? What are the functions of the program?
  5. How do you use "lsnrctl" program?
  6. What information can "tnsping" provide us?
  7. How do you use "tnsping" command/program?
  8. What is OCI8?
  9. What are the major functions of OCI8? Provide at least one specific example of the OCI8 library?
  10. After you define Oracle connection parameters in oracle_parameter.php, you will need to include the parameter file in your main PHP program such as OracleStandardConnection.php. What is the difference between "include" and "include-once" functions?