Oracle9i培训材料

************************************************************** Setup Instructions Introduction to Oracle9i: SQL ************************************************************** Course: Introduction to Oracle9i: SQL Course Version: 1.1 Date: 02-Oct-2001 Modified: 24-Oct-2001 File Name: setupdoc.txt File Version: 1.1 Course Developers: Nancy Greenberg,Priya Nathan SPOC: Chris Lawless, Sarah Jones Test Date: 19-Oct-2001 Copyright (c) 2001 Oracle Corporation SETUP DOCUMENT CONTENTS: 1. HARDWARE 2. SOFTWARE 3. INSTALL ORACLE SOFTWARE - RECOMMENDATIONS 4. LOCATE AND DOWNLOAD THE COURSE FILES 5. CREATE STUDENT AND INSTRUCTOR ACCOUNTS 6. CREATE THE ORACLE DATABASE 7. iSQL*PLUS INFORMATION 8. STUDENT AND INSTRUCTOR FILES 9. SETUP DATABASE USERS AND SCHEMA OBJECTS FOR PRACTICES 10. SQL*NET CONFIGURATION 11. TEST THE SETUP 12. CLEANUP AFTER THE CLASS 1. HARDWARE The following server and client hardware was used to develop this course: a. Client * Dell Optiplex DGX 5166 Windows PC * Windows NT 4.0 with sp5 or better b. Database Server * Sun Ultra 60 * Solaris 2.7 or any higher certified version c. Middle Tier * Microsoft Windows 2000 or MS Windows NT 4.0 with sp5 or later 2 SOFTWARE The following server and client software was used to develop this course: a. Client * Windows NT 4.0 sp5 or later * FTP, Telnet, and other communication utilities * Netscape 4.7x or IE 5.5 * Oracle Net Services b. Database Server * Solaris 2.7 * TCP/IP * Oracle9i Enterprise Edition 9.0.1 * iSQL*Plus 9.0.1 (installed along with Oracle9i). c. Oracle HTTP Server Software * Oracle HTTP Server 1.3.12.0.1a * Net9 Products 3. INSTALL ORACLE SOFTWARE - RECOMMENDATIONS Install the Oracle software by following the instructions in the Oracle 9i installation guides. Ensure it is the Enterprise Edition when installing Oracle. 4. LOCATE AND DOWNLOAD THE COURSE FILES FROM EDUCATION PRODUCTS' SERVER Servername: sunourep.us.oracle.com/ IP Address: Path: /cw/COURSES/TOOLS/O9iINTRO_SQL/40049GC11/LABS a. Download the files from the path indicated above: * setup.exe b. Inflate setup.exe It creates 6 files: * student.exe (Step 8) * instruct.exe (Step 8 ) * student.tar (Step 8) * instruct.tar (Step 8) * files.exe (Step 6) * files.tar (Step 6) c. Starting in Step 6, you will inflate the .exe file(s) and .tar file that were created after inflating setup.exe 5. CREATE STUDENT AND INSTRUCTOR ACCOUNTS NOTE: In step 6, you run the credb.sql file which creates the db. In step 9, you run the creschem.sql file which sets up the class accounts. a. Client: i. Create client netware accounts: ora1-ora15 based on a class of 30 students, where: 2 students make up one lab team. Create an account "teach" for instructor ii. Assign each client account the same password: oracle b. Database Server: i. Create one instructor and as many student accounts as needed on the database server machine. Name the server student accounts: ora1-ora15 and instructor account: teach. ii. Assign each account the same password: oracle iii. If you use the Korn shell, edit the .profile and provide values for these variables: * ORACLE_HOME designates the full direcotry path location the Oracle software on your machine. * ORACLE_SID designates the name of the database instance. Suggested names are T01 - T16. * ORACLE_NLS=$ORACLE_HOME/ocommon/nls/admin/data iv. If you use the C shell, edit the .login and provide values for the same environment variables specified in the previous step (6b.iv). v. Each class account must have search and write privileges on the $ORACLE_HOME/ directory. 6. CREATE THE ORACLE DATABASE a. You can use the sample sql script to create the database for the class. This script is called "credb.sql". This file creates a database called "T3" with default tablespace "Data01" and temporary tablespace "Temp". The script also contains various GRANT statements to grant privileges to the users, which are necessary to successfully execute practices. The script "creschem.sql" that creates users and schema objects uses these default names created by the script credb.sql. Hence, if you are not using this script, you must edit the creschem.sql script by replacing the default values with your database and tablespace names. i. For NT Expand the "files.exe" file, referenced in Step 4. It creates these 14 files: * credb.sql * creschem.sql * creteach.sql * dropsche.sql * dropteac.sql * hr_code.sql * hr_comnt.sql * hr_cre.sql * hr_drop.sql * hr_idx.sql * hr_main.sql * hr_popul.sql * del_data.sql * init_x.ora For Solaris Expand the "files.tar" file, referenced in Step 4. It creates these 14 files: * credb.sql * creschem.sql * creteach.sql * dropsche.sql * dropteac.sql * hr_code.sql * hr_comnt.sql * hr_cre.sql * hr_drop.sql * hr_idx.sql * hr_main.sql * hr_popul.sql * del_data.sql * init_x.ora ii. One database is shared by the whole class. The credb.sql file needs only be executed once. iii. Please note that the specifics of creating a database vary from platform to platform. For complete information on creating an Oracle database, please read the Oracle Administrator and SQL manuals for your platform. iv. Edit the "credb.sql" script by following the guidelines found in the beginning of the script. * Provide a database name. * Fill in local directory paths where the Oracle data files, log files and control files will reside. * Do not change the tablespace or datafile names found in the credb.sql script, because class workbooks and labs refer to them. vi. Edit the "init_x.ora" file by following the