Oracle的安装,配置,运行环境.docx

实习一、Oracle的安装,配置,运行环境实验目的：了解Oracle安装环境的要求，学习其安装及服务器端和客户端的配置，掌握使用SQL PLUS工具连接服务器的方法。一、网络环境服务器： 操作系统：RedHat Linux 9.0 ,核心为2.4.20-8 IP地址：21 数据库：Oracle 9i () for Linux(Intel) WWW服务器：Apache 1.3.22 客户机： 操作系统：Windows 2000 Professional IP地址：202.201.235.X Oracle9i客户端 二、在RedHat Advanced Server 3_0 Linux上安装Oracle9i的步骤，请将此文档译成中文。三、查看Oracle服务器的配置（黑体部分为必须输入的命令，回车执行）1. 1. 使用Putty工具通过SSH协议登陆到212. 2. Login:oracle 3. 3. password:oracle 4. 4. env （此命令用来显示当前用户的环境变量，执行结果如下：） HOSTNAME=oracleTERM=xtermSHELL=/bin/bashHISTSIZE=1000SSH_CLIENT=7 1145 22QTDIR=/usr/lib/qt-3.1SSH_TTY=/dev/pts/0USER=oracleLD_LIBRARY_PATH=/opt/oracle9i/product/9.2.0/lib:/lib:/usr/lib:/usr/local/libORACLE_SID=ORACLE_BASE=/opt/oracle9iTNS_ADMIN=/opt/oracle9i/product/9.2.0/network/adminMAIL=/var/spool/mail/oraclePATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/opt/oracle9i/product/9.2.0/binINPUTRC=/etc/inputrcPWD=/home/oracleLANG=en_USORACLE_TERM=xtermSSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpassSHLVL=1HOME=/home/oracleLANGUAGE=zh_CN.GB18030:zh_CN.GB2312:zh_CNLD_ASSUME_KERNEL=2.4.1LOGNAME=oracleCLASSPATH=/opt/oracle9i/product/9.2.0/JRE:/opt/oracle9i/product/9.2.0/jlib:/opt/oracle9i/product/9.2.0/rdbms/jlib:/opt/oracle9i/product/9.2.0/network/jlibSSH_CONNECTION=7 1145 21 22LESSOPEN=|/usr/bin/lesspipe.sh %sDISPLAY=21:0.0ORA_NLS33=/opt/oracle9i/product/9.2.0/ocommon/nls/admin/dataORACLE_HOME=/opt/oracle9i/product/9.2.06. 6. cd $ORACLE_HOME/network/admin（转向/opt/oracle9i/product/9.2.0/network/admin）7. 7. pwd （显示当前工作目录） 8. 8. ls (列出当前目录下的文件) 9. 9. cat listener.ora （查看listener.ora文件内容，结果如下：） # LISTENER.ORA Network Configuration File: /opt/oracle9i/product/9.2.0/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(PORT = 1521)SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = /opt/oracle9i/product/9.2.0)(PROGRAM = extproc)(SID_DESC =(GLOBAL_DBNAME = ORA)(ORACLE_HOME = /opt/oracle9i/product/9.2.0)(SID_NAME = ORCL)10. 10. exit （退出telnet） 四、查看Oracle客户端的配置1. 1. 打开“命令提示符”窗口（开始-程序-附件-命令提示符,或开始-运行-输入cmd-回车） 2. 2. path （可以看到Oracle客户端的安装目录，如PATH=C:oracleora90bin;） 3. 3. 用“记事本”打开c:oracleora90networkadmintnsnames.ora # TNSNAMES.ORA Network Configuration File: c:oracleora90networkadmintnsnames.ora# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 21)(PORT = 1521)(CONNECT_DATA =(SERVICE_NAME = ORA)4. 4. 用“记事本”打开c:oracleora90networkadminsqlnet.ora # SQLNET.ORA Network Configuration File: c:oracleora90networkadminsqlnet.ora# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)五、用SQL*Plus连接到Oracle数据库1. 1. 运行“SQL*Plus” 方法1：开始-程序-Oracle - OraHome90-Application Development-SQL Plus用户：scott口令：tiger主机字符串：ORCL出现以下信息表明连接成功SQL*Plus: Release .1 - Production on 星期五 9月 2 20:42:21 2005(c) Copyright 2001 Oracle Corporation. All rights reserved.连接到: Oracle9i Enterprise Edition Release .0 - ProductionWith the Partitioning ,OLAP and Oracle Data Mining optionJServer Release .0 - ProductionSQL方法2：开始-运行-输入sqlplus-回车）请输入用户名：scott/tigerorcl出现以下信息表明连接成功连接到: Oracle8i Enterprise Edition Release .0 - ProductionWith the Partitioning ,OLAP and Oracle Data Mining optionJServer Release .0 - ProductionSQL 2. 2. 退出“SQL*Plus” SQLexit 或 quit六、启动、停止Oracle数据库服务器及Oracle监听服务1. 1. 停止Oracle数据库服务器 telnet 21Login:oraclepassword:oraclesvrmgrlSVRMGRconnect internalSVRMGRshutdownSVRMGRexit按“五、用SQL*Plus连接到Oracle数据库”的步骤测试能否连接到Oracle数据库2. 2. 启动Oracle数据库服务器 telnet 21Login:oraclepassword:oraclesvrmgrlSVRMGRconnect internalSVRMGRstartupSVRMGRexit按“五、用SQL*Plus连接到Oracle数据库”的步骤测试能否连接到Oracle数据库3. 3. 停止Oracle监听服务 telnet 21L