📄 480.html
字号:
<STYLE type=text/css>
<!--
body,td { font-size:9pt;}
hr { color: #000000; height: 1px}
-->
</STYLE>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD><TITLE>论坛精华 >> Oracle 专栏 >> 接触 solaris : 安装 oracle</title>
</head>
<body >
<p><IMG SRC="../image/jsp001_middle_logo.gif" WIDTH="180" HEIGHT="60" BORDER=0 ALT=""></p>
<table width=100% bgcolor="#cccccc" align=center cellpadding="2" cellspacing="0" border=1 bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#EFF8FF"><td>
<a href=http://www.jsp001.com/list_thread.php?int_attribute=4>论坛精华</a>
>> <a href=http://www.jsp001.com/list_thread.php?forumid=20&int_attribute=4>Oracle 专栏</a>
>> 接触 solaris : 安装 oracle [<a href=http://www.jsp001.com/forum/showthread.php?goto=newpost&threadid=480>查看别人的评论</a>]<br>
<hr><p>由 webmaster 发布于: 2001-02-19 16:27</p><p><img src="images/icons/icon6.gif" alt="Cool" border=0> </p><p>作者：余 枫 Macro Zeng <br>主页：http://www.greatchinatelecom.com/card/oracle/ <a href="http://www.ctohome.com" target=_blank>http://www.ctohome.com</a> <br><br><br>Install oracle815 in Solaris 7 <br><br>1.建立 ORACLE 用户和 DBA 组，初始化安装目录 <br>================================================= <br>groupadd dba <br>useradd -g dba oracle <br>passwd oracle <br>mkdir /oracle <br>chown -R oracle.dba /oracle <br><br>2.为安装 ORACLE 设置系统变量 <br>================================================= <br>vi /etc/system <br>(add in the end)=> <br>set shmsys:shminfo_shmmax=4294967295 <br>set shmsys:shminfo_shmmin=1 <br>set shmsys:shminfo_shmmni=100 <br>set shmsys:shminfo_shmseg=10 <br>set semsys:seminfo_semmni=100 <br>set semsys:seminfo_semmsl=100 <br>set semsys:seminfo_semmns=2000 <br>set semsys:seminfo_semopm=100 <br>set semsys:seminfo_semvmx=32767 <br>（请根据实际情况做调整） <br><br>vi /etc/services <br>(add in the end)=> <br>orasrv 1525/tcp oracle <br>listener 1521/tcp <br>（请根据实际情况做调整） <br><br>vi /etc/oracle/.profile(.cshrc) <br>(add or modify)=> <br>set path=( /oracle/bin /usr/sbin /usr/bin /usr/openwin/bin /oracle /etc /usr/ccs/bin . ) <br>setenv ORACLE_HOME /oracle <br>setenv ORACLE_SID oracle8 <br>#setenv DISPLAY 10.1.1.110:0.0 <br>setenv NLS_LANG AMERICAN_AMERICA.ZHS16CGB231280 <br>#setenv NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK <br>（请根据实际情况做调整） <br><br><br>说明：加#为可选的参数， 10.1.1.110是用PC机运行EXTRAX登录服务器所配置的。 <br><br>#sync;sync;reboot Sun OS重启，使系统参数生效 <br><br>3.Install <br>================================================= <br>1 、插入ORACLE 安装光盘 <br>#/etc/init.d/volmgt stop <br>#/etc/init.d/volmgt start <br>%volcheck <br>%df -k 检查有无cdrom的设备 <br><br>2、 %cd /cdrom/cdrom0 %./runInstaller 出现 ORACLE Universal Installer的安装窗口,按Next键继续 <br><br>(远程安装则在 KEA!X Server 等远程模拟桌面环境下在命令窗口中运行 ./runInstaller 出现 ORACLE Universal Installer的安装窗口,按Next键继续) <br><br>3、Destination框输入将要安装oracle的目录这里我输入/oracle，接着出现弹出窗口要求用root运行/tmp/orainstRoot.sh (它创建oraInventory的安装目录) 接着选择要安装的产品ORACLE8I 8.1.5 <br><br>4、选typical或custom安装，注意屏幕上端Language按钮，选Chinese语言。 <br><br>5、接着出现将要安装ORACLE产品的全部信息，如果有不对的地方可以按Perious按钮返回修改。如果确认无误，按Next，ORACLE开始安装。 <br><br>(如果选择了要建数据库，会要求你输入数据库的存放地址，这里我输入/oracle/data,那么数据库的真正存放地址是 /oracle/data/oradata/dbdir) <br><br>6、安装成功100%后又回到开始的选项菜单。/oracle/orainst/install.log 安装日志文件最后提示OK <br><br>7、弹出Setup Privileges窗口,要求用root运行 #/oracle/root.sh <br>Are these setting correct (y/n):敲 y Enter the full pathname of the local bin directory (y/n): 敲/bin (此shell 程序在/var/oracle路径下生成一个文件oratab ,并做系统检测) <br><br><br>4.创建数据库时应该注意的问题 <br>================================================= <br>小心库建好后不能修改的参数： <br><br>Character sets : ZHS16GDK <br>db_block_size : 2048 <br><br>建库失败错误 01034 : <br><br>先取消建库过程。 <br>检查oracle安装目录下的 .profile(.cshrc) 设置及其他系统设置。 <br>（必要的时候 reboot 服务器）用/oracle/dbs/dbassist 重新建库 <br><br>建库失败后重建时说库已经存在： <br><br>rm -r /oracle/admin/ <br>rm -r /oracle// <br><br><br>5.建库后的微调 <br>================================================= <br>#vi /var/opt/oracle/oratab 最后一行改 app1:/oracle:Y <br>#vi /var/opt/oracle/listener.ora 改 host= (host_name) oraclehome= (/oracle) <br>例子: listener=(address_list= <br>(address=(protocol=tcp) <br>(port=1521) <br>(host=joe))) <br>sid_list_listener=(sid_list= <br>(sid_desc=(sid_name=oracle8) <br>(oracle_home=/oracle))) <br>trace_level+listener=admin <br>startup_wait_time_listener=0 <br>connect_timeout_listener=5 <br><br>#vi /var/opt/oracle/tnsnames.ora 一些连接字符串，分布式通讯时有用 <br><br><br>6.安装测试 <br>================================================= <br>#su - oracle %env 看环境变量改变了没有 <br><br>%svrmgrl 唤醒SVRMGR状态 <br>SVRMGR>connect internal <br>连接打开数据库 SVRMGR>shutdown immediate 先关闭 instances, 数据库 <br>SVRMGR>startup 再打开数据库，当看到 instances startup, database mount, database open的时候，oracle安装成功 <br>SVRMGR>exit <br><br>%lsnrctl start 启动listener 如果出错检查环境变量是否设好，及lsnrctl文件的内容和执行属性。 <br><br><br>7。配置自启动/关闭 <br>================================================= <br>编写 SH 文件 <br>vi /etc/oracle <br><br>#!/bin/sh <br>OPT_=$1 <br><br>case "$OPT_" in <br>start) <br>/bin/echo "$0 : (start)" <br># <br># Your service startup command goes here. <br># <br>su - oracle -c "/oracle/bin/dbstart" <br>su - oracle -c "/oracle/bin/lsnrctl start" <br># su - root -c "/www/tomcat/bin/startup.sh" <br># su - root -c "/www/apache/bin/apachectl start" <br><br># NOTE: Must exit with zero unless error is severe. <br>exit 0 <br>;; <br>stop) <br>/bin/echo "$0 : (stop)" <br># <br># Your service shutdown command goes here. <br># <br>su - oracle -c "/oracle/bin/lsnrctl stop" <br>su - oracle -c "/oracle/bin/dbshut" <br># su - root -c "/www/tomcat/bin/shutdown.sh" <br># su - root -c "/www/apache/bin/apachectl stop" <br><br># NOTE: Must exit with zero unless error is severe. <br>exit 0 <br>;; <br>*) /bin/echo '' <br>/bin/echo "Usage: $0 [start|stop]" <br>/bin/echo " Invalid argument ==> \"${OPT_}\"" <br>/bin/echo '' <br>exit 0 <br>;; <br>esac <br><br>设置执行次序 <br>ln -s /etc/init.d/oracle /etc/rc2.d/S99oracle <br>ln -s /etc/init.d/oracle /etc/rc0.d/K01oracle <br><br><br>8.自启动/关闭 测试 <br>================================================= <br>reboot 后 ps -ef | grep oracle <br><br><br>作者：余 枫 Macro Zeng <br>主页：http://www.greatchinatelecom.com/card/oracle/ <a href="http://www.ctohome.com" target=_blank>http://www.ctohome.com</a> </p></td>
</tr>
</table>
<p>
<CENTER><a href="http://www.jsp001.com/forum/newreply.php?action=newreply&threadid=480">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>0</font> 分，你认为它对你有帮助吗？
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=480&intVote=4","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>非常多</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=480&intVote=2","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>有一些</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=480&intVote=1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>无帮助</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=480&intVote=-1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>是灌水</a>](<font color=red>0</font>) </p>
<script language="javascript" src="http://www.jsp001.com/include/read_thread_script.php?threadid=480"></script>
<p><CENTER>
Copyright © 2001 - 2009 JSP001.com . All Rights Reserved <P>
<IMG SRC="../image/jsp001_small_logo.gif" WIDTH="85" HEIGHT="30" BORDER=0 ALT="">
</CENTER></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -