ORACLE的安装.doc

安装Oracle以二进制方式上传oracle安装文件以及补丁到临时文件夹/home/setup，需要的文件如下：p3006854_9204_LINUX.zipship_9204_linux_disk1.cpioship_9204_linux_disk2.cpioship_9204_linux_disk3.cpio1安装oracle for Linux的补丁root# cd /home/setup#unzip p3006854_9204_LINUX.zip生成rhel3_pre_install.sh # sh rhel3_pre_install.sh 2修改oracle用户的环境变量文件#su oracle（切换用户，按提示输入oracle用户的密码）$vi .bash_profile修改.bash_profile文件，在文件的最后增加如下内容：export LANG=Cexport LC_ALL=C保存退出3解压Oracle安装包oracle$cd /home/setup$cpio -idmv ship_9204_linux_disk1.cpio$cpio -idmv ship_9204_linux_disk2.cpio$cpio -idmv connect / as sysdba已连接到空闲例程。sqlstartupORACLE 例程已经启动。Total System Global Area 252776884 bytesFixed Size 450996 bytesVariable Size 234881024 bytesDatabase Buffers 16777216 bytesRedo Buffers 667648 bytes数据库装载完毕。数据库已经打开。（如果已启动，系统会提示不能启动已启动的服务。提示如下：ORA-01081: cannot start already-running ORACLE - shut it down first。）sqlexit从Oracle9i Enterprise Edition Release 9.2.0.8.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.8.0 - Production中断开4）启动监听进程：oracle$lsnrctl start（lsnrctl stat查看状态）LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 25-2月 -2008 15:49:41Copyright (c) 1991, 2006, Oracle Corporation. All rights reserved.启动/home/oracle/ora9i/bin/tnslsnr：请稍候.TNSLSNR for Linux: Version 9.2.0.8.0 - Production系统参数文件为/home/oracle/ora9i/network/admin/listener.ora写入/home/oracle/ora9i/network/log/listener.log的日志信息监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.40.110.91)(PORT=1521)监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.40.110.91)(PORT=1522)正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)LISTENER 的 STATUS-别名 LISTENER版本 TNSLSNR for Linux: Version 9.2.0.8.0 - Production启动日期 25-2月 -2008 15:49:41正常运行时间 0 天 0 小时 0 分 0 秒跟踪级别 off安全性 OFFSNMP OFF监听器参数文件 /home/oracle/ora9i/network/admin/listener.ora监听器日志文件 /home/oracle/ora9i/network/log/listener.log监听端点概要. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.40.110.91)(PORT=1521) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.40.110.91)(PORT=1522)服务摘要.服务 PLSExtProc 包含