Advanced Plsql Programming V1.0 Setup Instructions Readme

Advanced PL/SQL Programming - Setup Instructions

Course Setup Requirements Course Version: V1.0 Last Updated: January 4, 2003 These instructions are for Windows environments only. UNIX instructions can be found in the Oracle documentation here. Hardware Required (refer to the Oracle Installation Guide for complete details) ♦ Minimal Processor: Pentium 166 or Pentium 200 ♦ Recommended Processor: Pentium 266 ♦ RAM: 128 MB (256 MB recommended) ♦ For Windows environments, Oracle Corporation also recommends increasing virtual memory to : ♦ Minimum 200 MB, Maximum 400 MB ♦ Modify it in the Performance tab of System Properties in the Control Panel. ♦ Available Disk Space ♦ FAT 4.75 GB for HOME Directory, 140MB for System Drive ♦ NTFS 2.85 GB for HOME Directory, 140MB for System Drive ♦ Temp Space – 400 MB ♦ Video: 256 color ♦ A connection to the Internet is desirable (but not absolutely necessary) to show students various Oracle-related sites. Software Requirements (refer to the Oracle Installation Guide for complete details) ♦ Windows NT 4.0 (SP5 or Higher), Windows 2000 (SP 1 or higher) Windows XP Professional ♦ Oracle9i Enterprise Edition Release 2 (9.2.0.1.0) or higher ♦ A new install is required. © 2003 SkillBuilders, Inc.

Page 1 of 2

♦ Microsoft Internet Explorer 5 or Netscape Navigator 4.76 (or later) ♦ Adobe Acrobat Reader or Acrobat 4.0 or later (for the course presentation)

Installing Oracle9i A new install of Oracle9i is required on the instructor machine and each student machine. Oracle provides a utility called the “Universal Installer” (so-called because it looks the same on all platforms) that will walk you through the installation process. The Installer may start automatically upon inserting the Oracle CD; if not, start “setup.exe” on the CD. All defaults offered by the Installer can be taken, including installation of the STARTER database. You should be presented a message indicating the install was successful and the names and passwords of the initial userids. The name of the database and database instance will also be displayed. This information needs to be noted and provided to the instructor. After installation, login to SQL*Plus with the SYSTEM userid and execute the following query: SELECT * FROM v$database; A successful response from this query is another good indication that the installation was successful. If you have any questions, please call SkillBuilders at 401.783.6172 and request installation support.

Student Files The student files consist of finished versions of the various labs, files needed to complete certain labs, and various demo applications. They are provided on the course CD in the form of a selfextracting zip file called SETUP.EXE that will create a student directory (c:/oraclass) and subdirectories. Important note: If the student files from a previous session of this course are still on the machine, they will have to be refreshed. Erase the student directory and all subdirectories and reinstall the student files as described below.

Instructor Setup The instructor will be presenting the course in the form of Adobe Acrobat (PDF) files, as well as demonstrations of the labs and other applications and displays of documentation screens. This requires: ¾ An instructor workstation with the same setup as for the students. ¾ Adobe Acrobat Reader installed on the instructor workstation. It is available in the Software\ Adobe Acrobat Reader folder on the course CD. ¾ A projector connected to the instructor workstation.

© 2003 SkillBuilders, Inc.

Page 2 of 2