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

《Oracle的安装,配置,运行环境》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、实习一、Oracle的安装,配置,运行环境实验目的：了解Oracle安装环境的要求，学习其安装及服务器端和客户端的配置，掌握使用SQLPLUS工具连接服务器的方法。一、网络环境服务器：··操作系统：RedHatLinux9.0,核心为2.4.20-8··IP地址：202.201.235.121··数据库：Oracle9i(9.2.0.4)forLinux(Intel)··WWW服务器：Apache1.3.22客户机：··操作系统：Windows2000Professional··IP地址：202.201.235.X··Oracle9i客户端二、在RedHatA

2、dvancedServer3_0Linux上安装Oracle9i的步骤，请将此文档译成中文。三、查看Oracle服务器的配置（黑体部分为必须输入的命令，回车执行）1.1.使用Putty工具通过SSH协议登陆到202.201.235.1212.2.Login:oracle3.3.password:oracle4.4.env（此命令用来显示当前用户的环境变量，执行结果如下：）HOSTNAME=oracleTERM=xtermSHELL=/bin/bashHISTSIZE=1000SSH_CLIENT=202.201.235.87114522QTDIR=/usr/l

3、ib/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/

4、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/pro

5、duct/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=202.201.235.871145202.201.235.12122LESSOPEN=

6、/usr/bin/lesspipe.sh%sDISPLAY=202.201.235.121:0.0ORA_NLS33=/opt/oracle9i/product/9.2.0/ocommon/n

7、ls/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.catlistener.ora（查看listener.ora文件内容，结果如下：）#LISTENER.ORANetworkConfigurationFile:/opt/oracle9i/product/9.2.0/network/

8、admin/listener.ora#GeneratedbyOracleconfigurationtools.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

9、=/opt/oracle9i/prod