資源描述:
《Oracle的安裝,配置,運行環(huán)境》由會員上傳分享,免費在線閱讀,更多相關內(nèi)容在行業(yè)資料-天天文庫。
1、實習一、Oracle的安裝,配置,運行環(huán)境實驗目的:了解Oracle安裝環(huán)境的要求,學習其安裝及服務器端和客戶端的配置,掌握使用SQLPLUS工具連接服務器的方法。一、網(wǎng)絡環(huán)境服務器:··操作系統(tǒng):RedHatLinux9.0,核心為2.4.20-8··IP地址:202.201.235.121··數(shù)據(jù)庫:Oracle9i(9.2.0.4)forLinux(Intel)··WWW服務器:Apache1.3.22客戶機:··操作系統(tǒng):Windows2000Professional··IP地址:202.201.235.X··Oracle9i客戶端二、在RedHatA
2、dvancedServer3_0Linux上安裝Oracle9i的步驟,請將此文檔譯成中文。三、查看Oracle服務器的配置(黑體部分為必須輸入的命令,回車執(zhí)行)1.1.使用Putty工具通過SSH協(xié)議登陸到202.201.235.1212.2.Login:oracle3.3.password:oracle4.4.env(此命令用來顯示當前用戶的環(huán)境變量,執(zhí)行結果如下:)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文件內(nèi)容,結果如下:)#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