RHAS3 and oracle9204

超、凢脫俗 2024-02-17 20:17 8阅读 0赞

[http://support.geisnic.com/file\_detail/2006-3-9/2006391120393210.htm][http_support.geisnic.com_file_detail_2006-3-9_2006391120393210.htm]

1、从网上下载redhat Enterprise Linux Advanced Server3的四个安装文件，安装时swap分区设置为内存的二倍。不要采用DHCP设置主机名和IP地址，而是“手工设置”。否则会在安装oracle的时候出现如下错误：  
引用：*Thrown when the IP address of a host cannot be determined*  
  
出现这个错误将使Oracle不能安装成功。安装RHAS３，可以刻录到光盘安装，也可以从硬盘安装，从硬盘安装RHAS3，请参考：http://bbs.chinaunix.net/forum/viewtopic.php?p=2416942\#2416942  
2、系统要求：内存最低256（我的就是这么大），建议512M，硬盘空间4G，如果Oracle安装文件存在硬盘，建议5G（在安装操作系统后的剩余空间）。  
可以查看内存的大小，用到的命令是：grep MemTotal /proc/meminfo  
swap分区在安装操作系统的时候就设定好了，为内存的２倍，当内存达到１G以上时，和内存大小相同就可以了啊。相看交换分区命令是：/sbin/swapon -s  
3、检查是否安装以下包：  
引用：*\#su - root  
\#rpm -qa|grep compat  
compat-db-4.0.14-5.i386  
compat-gcc-7.3-2.96.122.i386  
compat-gcc-c++-7.3-2.96.122.i386  
compat-libstdc++-7.3-2.96.122.i386  
compat-libstdc++-devel-7.3-2.96.122.i386  
\#rpm -qa|grep openmotif21  
openmotif21-2.1.30-8.i386  
\#rpm -qa|grep setarch  
setarch-1.3-1.i386  
\#rpm -qa|grep tcl  
tcl-8.3.5-92.i386*  
  
  
上面显示的内容是在笔者已经安装了具体的RPM包之后的结果。它们对应的软件包是：引用：  
*compat-db-4.0.14-5.i386.rpm  
compat-gcc-7.3-2.96.122.i386.rpm  
compat-gcc-c++-7.3-2.96.122.i386.rpm  
compat-libstdc++-7.3-2.96.122.i386.rpm  
compat-libstdc++-devel-7.3-2.96.122.i386.rpm  
openmotif21-2.1.30-8.i386.rpm  
setarch-1.3-1.i386.rpm  
tcl-8.3.5-92.i386.rpm*  
  
  
一般情况下，你的系统上的输出结果和这个不同。如果个别包没有安装，把系统安装光盘mount上,找到具体的软件包(大多数在第三张光盘上)，然后利用如下的命令来安装相应的包：  
\# rpm -ivh compat.....rpm  
因为我没有把RHAS3刻录到光盘，所以我用下面的命令来挂载iso文件  
引用：*mount -o loop /mnt/e/rhas3/rhel-3-i386-as-disc3.iso /mnt/cdrom*  
  
要额外注意的是，这些软件包之间是有依赖性的，先后的顺序要找好。否则会报告不能安装的错误。在安装软件包的时候，如果出现软件包的依赖性，就先安装有有依赖的包。我相信大家会看明白软件包之间的依赖性的。  
还需要将gcc、g++更换为2.96的版本.  
方法如下：  
引用：*\#su - root  
mv /usr/bin/gcc /usr/bin/gcc323  
ln -s /usr/bin/gcc296 /usr/bin/gcc  
mv /usr/bin/g++ /usr/bin/g++323 \# if g++ doesn't exist, then gcc-c++ was not installed（这里是注释哦）  
ln -s /usr/bin/g++296 /usr/bin/g++*  
  
  
3、设置内核参数：  
这个版本的默认的glibc 很合适，免去了不少麻烦。  
用grep MemTotal /proc/meminfo查看内存总量  
出现 MemTotal XXXXXKB，其中的XXXXX就是内存总量。  
修改两个文件，如下：  
引用：  
*\#vi /etc/sysctl.conf  
加入：  
kernel.shmmax = xxxxx\*1024\*2(为内存的2倍，切换到字节。要是超过这个值，在运行dbca时会出现Ora-27123:Unable to attach to shared memeroy segment)  
kernel.shmmni=4096  
kernel.shmall=2097152  
kernel.sem=250 32000 100 128  
fs.file-max=65536  
net.ipv4.ip\_local\_port\_range=1024 65000  
\#vi /etc/security/limits.conf  
加入：  
oracle hard nofile 65536  
oracle soft nofile 65536  
oracle hard nproc 16384  
oracle soft nproc 16384*  
  
  
4、建立用户、设置环境变量  
建立用户的命令是以root用户运行的。  
引用：*\#groupadd oinstall  
\#groupadd dba  
\#useradd -g oinstall -G dba oracle  
\#passwd oracle*  
  
  
设置环境变量：  
以oracle用户登录，  
引用：*vi $HOME/.bash\_profile  
插入下面的内容  
\# Set the LD\_ASSUME\_KERNEL environment variable only for Red Hat 9 and  
\# for Red Hat Enterprise Linux Advanced Server 3 (RHEL AS 3) !!  
\# Use the "Linuxthreads with floating stacks" implementation instead of NPTL:  
export LD\_ASSUME\_KERNEL=2.4.1  
  
\# Oracle Environment  
export ORACLE\_BASE=/home/oracle  
export ORACLE\_HOME=$ORACLE\_BASE/product/9.2.0  
export ORACLE\_SID=test  
export ORACLE\_TERM=xterm  
\# export TNS\_ADMIN= Set if sqlnet.ora, tnsnames.ora, etc. are not in $ORACLE\_HOME/network/admin  
export NLS\_LANG=AMERICAN;  
export ORA\_NLS33=$ORACLE\_HOME/ocommon/nls/admin/data  
LD\_LIBRARY\_PATH=$ORACLE\_HOME/lib:/lib:/usr/lib  
LD\_LIBRARY\_PATH=$LD\_LIBRARY\_PATH:/usr/local/lib  
export LD\_LIBRARY\_PATH  
  
\# Set shell search paths  
export PATH=$PATH:$ORACLE\_HOME/bin*  
  
  
然后注销重新登录，用set|more查看环境变量是否生效。因为我把Oracle安装在了oracle用户主目录下，所以我的ORACLE\_BASE值为/home/oracle，当然你也可以安装到指定的目录，如下：  
引用：*\#su - root  
\#mkdir /opt/oracle  
\#mkdir /opt/oracle/product  
\#mkdir /opt/oracle/product/9.2.0  
\#chown -R oracle.oinstall /opt/oracle  
  
\#mkdir /var/opt/oracle  
\#chown oracle.dba /var/opt/oracle  
\#chmod 755 /var/opt/oracle*  
  
  
这时ORACLE\_BASE的值就是/opt/oracle。  
5、开始安装  
从http://www.oracle.com下载三个安装文件，  
ship\_9204\_linux\_disk1.cpio.gz  
ship\_9204\_linux\_disk2.cpio.gz  
ship\_9204\_linux\_disk3.cpio.gz  
用zcat ship\_9204\_linux\_disk1.cpio.gz|cpio -idmv  
zcat ship\_9204\_linux\_disk2.cpio.gz|cpio -idmv  
zcat ship\_9204\_linux\_disk3.cpio.gz|cpio -idmv  
生成三个文件夹Disk1，Disk2，Disk3；  
你也可以用gunzip ship\_9204\_linux\_disk1.cpio.gz  
cpio -idmv <ship\_9204\_linux\_disk1.cpio  
这样的命令来生成三个目录，可以用下面的命令刻录到光盘，也可以保存在硬盘。引用：  
*mkisofs -r Disk1 | cdrecord -v --eject dev=0,0,0 speed=15 -  
mkisofs -r Disk2 | cdrecord -v --eject dev=0,0,0 speed=15 -  
mkisofs -r Disk3 | cdrecord -v --eject dev=0,0,0 speed=15 -*  
  
  
进入Disk1目录运行runInstaller之前，注意两点：  
a、export LANG=en\_us(否则安装界面出来就会出现“□”，因为Oracle9i不支持中文界面。)  
b、安装p3006854\_9204\_LINUX.zip补丁，否则会出现如下错误：  
引用：*Error occurred during initialization of VM  
Unable to load native library: /tmp/OraInstall2003-10-25\_03-14-57PM/jre/lib/i386/libjava.so:  
symbol \_\_libc\_wait, version GLIBC\_2.0 not defined in file libc.so.6 with link time reference*  
  
  
从http://metalink.oracle.com下载p3006854\_9204\_LINUX.zip补丁。安装此补丁的方法：引用：  
*su - root  
\# unzip p3006854\_9204\_LINUX.zip  
Archive: p3006854\_9204\_LINUX.zip  
creating: 3006854/  
inflating: 3006854/rhel3\_pre\_install.sh  
inflating: 3006854/README.txt  
  
\# cd 3006854  
\# sh rhel3\_pre\_install.sh  
Applying patch...  
Patch successfully applied  
\#  
注意：如果运行 rhel3\_pre\_install.sh出现下面的错误  
rhel3\_pre\_install.sh: line 36: gcc: command not found  
是因为你忘了安装gcc，同样要是出现下面的错误：  
\# ls  
ls: error while loading shared libraries: /etc/libcwait.so: cannot open shared object file: No such file or directory  
\# rm /etc/ld.so.preload  
rm: error while loading shared libraries: /etc/libcwait.so: cannot open shared object file: No such file or directory  
\#  
请不要退出bash，用下面的方法来修复（我开始遇到，后来没有遇到了，可能是因为我把gcc降级到了296吧）  
\# echo "" >; /etc/ld.so.preload  
rm /etc/ld.so.preload  
And start over again.*  
  
  
  
现在运行./runInstaller &（必须进入到Disk1目录，或者从光盘运行，从光盘安装不要进入/mnt/cdrom后运行runInstaller，而是这样运行./mnt/cdrom/runInstaller）  
　　呵呵，高兴了吧，期待以久的GUI界面终于出来了啊。这是欢迎界面。显示了Oracle安装的源文件所在目录，还有要安装到的产品目录。我们点“Next”；  
接着出现的下一个界面是Inventory路径，我们点“Next”；  
　　现在要求用户输入UNIX组名，我们用Oracle用户所在的组“oinstall”，然后点“Next”，如果你是第一次安装Oracle产品，则要你运行一个sh文件。文件是/tmp/orainstRoot.sh，我们打开一个shell窗口，切换到root用户，如下：  
引用：*su root  
sh /tmp/orainstRoot.sh*  
  
  
运行完毕我们返回Oracle安装界面，点“Continue”；  
　　选择文件存放的目录，我们选择默认值。然后“Next”；  
　　安装的产品是“Oracle９i Database 9.2.0.4.0”，点“Next”；  
　　选择安装类型是“通用”，默认选项。点“Next”；  
　　输入全局数据库名，然后“Next”；  
　　数据文件的存放位置，我采用的是默认位置，点“Next”；  
　　出现安装组件的选择结果，这时点“Install”，开始安装，复制文件，进度条在一点一点的增加，当安装并link完后，出现配置工具界面，agent服务不能配置成功，忽略不用管，在下面修复。DBCA，NETCA，HTTP都正确配置完毕哦。呵呵。下面开始修复错误。其实要是把各个界面抓取下来就更好了。  
6、安装p3238244\_9204\_LINUX.zip补丁  
此补丁也是从http://metalink.oracle.com下下载，同时要下载一个opatch软件包：p2617419\_220\_GENERIC.zip，它主要是用来悠agent服务不能启动的错误。  
过程如下：引用：*su - oracle  
$ cp p2617419\_210\_GENERIC.zip /tmp  
$ cd /tmp  
$ unzip p2617419\_210\_GENERIC.zip  
$ export PATH=$PATH:/tmp/OPatch  
$ export PATH=$PATH:/sbin \# the patch needs "fuser" which is located in /sbin  
$ unzip p3238244\_9204\_LINUX.zip  
$ cd 3238244  
$ opatch apply*  
  
补丁修复完成，需要relinked一个.mk文件。  
$ cd $ORACLE\_HOME/network/lib  
$ make -f ins\_oemagent.mk install  
现在在运行agentctl start，看是不是可以成功运行agent服务了啊，可以用stop、status来停止此服务或者检查服务的状态。  
在这个成功之后，居然不能启动Oracle，说是不能找到初始化文件，没办法，我用dbca先删除了原来安装时建立的库，再重新建立了数据库。  
7、运行dbca来创建数据库。呵呵，一路畅通，完成数据库的安装。  
希望你也能成功安装。  
  
**后记：我想在各个版本的LINUX上安装Oracle的各版本，思路和步骤都大体相同，但是更要注意那些微小的差别，也许可能就是这些微小的差别将使你无法成功的安装。建议各位多到Oracle的网部去看看，多上网找些资料来对比着学习学习。我想你肯定会成功的。祝愿热爱Oracle和Linux的朋友都能成功。**

--------------------

**[renxiao2003][] 回复于：2004-07-09 01:11:00**  
  
不知不觉就是凌晨1：00多了，第一次写了好多，却因为标题过长，居然没有发布上去，气死我了，借着这点余力，再次贴了上来，却只用了半个小时多点，可能质量就不如第一次写得那么好吧。不过没什么，太悃了，等明天有时间再修改吧。  
在这里借鉴了好些资料，就不列出了，感谢那些前辈和朋友们；  
同时要特别感谢一个曾经的朋友，是他给我提供了metalink的帐号，要是没有他，我就不能上metalink上下载相应的补丁，也不能成功安装了啊。再次感谢所有的朋友们！热爱Oracle和Linux的朋友们，感谢Chinaunix.net这里的朋友们

--------------------

**[joson][] 回复于：2004-07-09 06:53:45**  
  
renxiao203,辛苦了！

--------------------

**[renxiao2003][] 回复于：2004-07-09 12:14:11**  
  
尽我的努力，为你提供服务，如果需要，请发EMAIL:wangccsy@126.com  
MSN:wangcc\_neusoft@hotmail.com  
  
**p3095277\_9204\_LINUX这个补丁有３００多M，不能传给朋友们，不过可以刻盘（收取光盘成本费用），其它的几个都很小，才几百K，这些可以通过Email给朋友们，需要的Email和我联系。**  
  
要是朋友们直接下载Oracle9204，就不用上面那个３００多M的补丁包了啊。

--------------------

**[xxj119][] 回复于：2004-07-09 12:31:53**  
  
顶！！！！！！  
辛苦了！

--------------------

**[unixbeginer][] 回复于：2004-07-09 12:33:23**  
  
正在redhat8上安装oracle9.2.0.4,非常感谢老大这篇呕心沥血之作

--------------------

**[renxiao2003][] 回复于：2004-07-09 18:38:28**  
  
在沈阳的朋友们，如果想相互学习，我可以提供帮助，我有RedHat EnterPrise Linux Advanced Server３的安装文件，也有Oracle9204的安装文件，如果需要请联系我啊！

--------------------

**[renxiao2003][] 回复于：2004-07-09 18:54:05**  
  
Startup and Shutdown of the Oracle 9i Database  
安装完成后，就可以启动和停止Oracle数据库了。  
Oracle9i不再支持svrmgrl，你可以用sqlplus来启动与停止数据库。  
启动数据库的命令如下：  
引用：   
*oracle$ sqlplus /nolog  
SQL>; connect / as sysdba  
SQL>; startup*  
  
  
上面的连接是以sys的身份进入数据库的，并且以sysdba的角色来连接。sysdba具有下面的权限：  
\- sysoper privileges WITH ADMIN OPTION  
\- create database  
\- recover database until  
  
$ORACLE\_HOME/bin/dbstart and $ORACLE\_HOME/bin/dbshut  
  
你也可以用$ORACLE\_HOME/bin/dbstart来启动database，和用$ORACLE\_HOME/bin/dbshut 来停止 database。你可以把 $ORACLE\_HOME/bin/dbstart加入到/etc/rc.d/rc.local启动脚本中， 在系统启动时自动启动Oracle，为了让 $ORACLE\_HOME/bin/dbstart 和$ORACLE\_HOME/bin/dbshut 工作，你需要改变三个地方： /etc/oratab 改"N"为 "Y"。  
  
如，我的 Oracle SID 是"orcl" 我把文件 /etc/oratab中的下面的行从  
  
orcl:/home/oracle/product/9.2.0:N  
to read:  
orcl:/home/oracle/product/9.2.0:Y  
  
In some cases for 9.2.0 I also had to copy the init file for my SID "test" from /opt/oracle/admin/orcl/pfile to $ORACLE\_HOME/dbs to get dbstart and dbshut working:  
cp /opt/oracle/admin/test/pfile/inittest.ora.642002224936 $ORACLE\_HOME/dbs/initorcl.ora  
But first make sure if your init file already exists in $ORACLE\_HOME/dbs!

--------------------

**[renxiao2003][] 回复于：2004-07-09 18:55:28**  
  
Oracle Installation Problems, Tips and Hints  
  
Some of these problems apply only to 9.0.1!  
Do not cd to /mnt/cdrom to run ./runInstaller!  
If you do so, the installation will fail because you won't be able to change the CDs.  
  
  
If you forgot to set the DISPLAY environment variable (e.g. export DISPLAY=oracleserver:0.0), or if you forgot to give the remote console - your Oracle Server - authority to display X information on your desktop PC (e.g. xhost +oracleserver), then you will get the following error:  
Xlib: connection to ":0.0" refused by server  
Xlib: Client is not authorized to connect to Server  
In this case, I always had to kill runInstaller in Oracle9iR1 (9.0.1) which was still running in the background. If I didn't do this in 9.0.1, runInstaller didn't completely come up any more without displaying any error messages. You might also want to clean up /tmp/OraInstall.  
  
When runInstaller starts to configure the tools ("Configuration Tools"), the "Oracle Net Configuration Assistant" will sometimes hang. Simply stop the Assistant and restart it, or continue the installation. When the rest of the installation is finished, do a "Retry" for "Oracle Net Configuration Assistant". This always worked for me.  
When the system stops responding during the Oracle installation in particular during the database creation, then that's probably because you don't have enough RAM or enough swap space. I saw the whole system not responding or to "hang" for several minutes when I did not have enough swap space. If this happens, simply wait until the system starts to respond again.  
The Oracle installation also runs make etc. In a production environment you might not have compilers and other development packages installed. Therefore make sure you have temporarily the following packages installed: gcc, cpp, glibc-devel, compat-libstdc++, kernel-headers (for RH 7.1, 7.2, 2.1AS), glibc-kernheaders (for RH 7.3, 8.0, 9.0), binutils. See also Development Packages for more information.  
  
If for any reason the Oracle9i installation didn't finish successfully, you might want to clean up the following files and directories before you start over again: /etc/oraInst.loc /etc/oratab /tmp/<OtherOracleOwnedFiles>; $ORACLE\_BASE/\*  
Other Problems:  
You might want to check out the Oracle on Linux Discussion Forum.

--------------------

**[renxiao2003][] 回复于：2004-07-09 18:56:23**  
  
Oracle Installation Errors  
  
Here is a list of Oracle 9i (9.0.1 & 9.2.0) installation problems and issues. Some issues, errors, problems, and solutions apply only to 9.0.1 and some only to 9.2.0. Since I did not experience all of the problems here, I am not able to verify the correctness of all the solutions. However, I experienced almost all of the problems listed here. If you have other problems and you were able to resolve them, then please drop me an email at webmaster\_at\_puschitz.com so that I can add it to the list here.  
  
Here is a list of issues issues, errors, problems and solutions:  
Log Files  
First check always the error logs for 9.2.0 in /tmp/OraInstall (e.g /tmp/OraInstall2002-07-04\_09-50-19PM), and for 9.0.1 in /tmp/OraInstall. When you get make problems, check also the file $ORACLE\_HOME/install/make.log.  
  
  
"Various make Problems"  
Make sure that gcc is installed on your system:  
$ which gcc  
/usr/bin/gcc  
  
Here is the command to find the RPM package name for /usr/bin/gcc:  
$ rpm -qf /usr/bin/gcc  
gcc-2.96-98  
  
Check also the other error messages below. See also Development Packages for more information.  
  
  
"Error in invoking target install of makefile /opt/oracle/product/9.2.0/ctx/lib/ins\_ctx.mk"  
I saw this error only when I installed Oracle9iR2 (9.2.0). This was also the only problem I experienced with Oracle 9i R2 on Red Hat 8.0. However, this does not necessarily mean that you won't experience other problems described here.  
  
When I had this problem, the following errors showed up in $ORACLE\_HOME/install/make.log:  
/lib/libdl.so.2: undefined reference to \`\_dl\_addr@GLIBC\_PRIVATE'  
/lib/libdl.so.2: undefined reference to \`\_dl\_open@GLIBC\_PRIVATE'  
/lib/libdl.so.2: undefined reference to \`\_dl\_close@GLIBC\_PRIVATE'  
/lib/libdl.so.2: undefined reference to \`\_dl\_sym@GLIBC\_PRIVATE'  
/lib/libdl.so.2: undefined reference to \`\_dl\_vsym@GLIBC\_PRIVATE'  
  
This error comes up when the following step is executed:  
/usr/bin/make -f ins\_ctx.mk install ORACLE\_HOME=/opt/oracle/product/9.2.0  
  
Edit the file $ORACLE\_HOME/ctx/lib/env\_ctx.mk, go to "INSO\_LINK =", and add a "$(LDLIBFLAG)dl" to the line and save it.  
  
Here is the full line with the added "$(LDLIBFLAG)dl" flag:  
  
INSO\_LINK = -L$(CTXLIB) $(LDLIBFLAG)m $(LDLIBFLAG)dl $(LDLIBFLAG)sc\_ca $(LDLIBFLAG)sc\_fa $(LDLIBFLAG)sc\_ex $(LDLIBFLAG)sc\_da $(LDLIBFLAG)sc\_ut $(LDLIBFLAG)sc\_ch $(LDLIBFLAG)sc\_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)  
  
After that hit retry in the error popup.  
  
  
If this didn't work, then try the following:  
  
Edit the file $ORACLE\_HOME/ctx/lib/env\_ctx.mk again, go to "INSO\_LINK =", remove the above entry you made and add a "\`cat $(LIBHOME)/sysliblist\`" to the line and save it.  
  
Here is the full line with the added "\`cat $(LIBHOME)/sysliblist\`" string:  
  
INSO\_LINK = -L$(CTXLIB) $(LDLIBFLAG)m \`cat $(LIBHOME)/sysliblist\` $(LDLIBFLAG)sc\_ca $(LDLIBFLAG)sc\_fa $(LDLIBFLAG)sc\_ex $(LDLIBFLAG)sc\_da $(LDLIBFLAG)sc\_ut $(LDLIBFLAG)sc\_ch $(LDLIBFLAG)sc\_fi $(LLIBCTXHX) $(LDLIBFLAG)c -Wl,-rpath,$(CTXHOME)lib $(CORELIBS) $(COMPEOBJS)  
  
After that hit retry in the error popup.  
  
  
ORA-27123: unable to attach to shared memory segment.  
  
I saw this error only when I installed Oracle 9i R2 (9.2.0).  
  
This error message came up when the Oracle Database Configuration Assistant was running. I executed the following command to temporarily increase the maximum shared memory size:  
su - root  
\# cat /proc/sys/kernel/shmmax  
33554432  
\# echo \`expr 1024 /\* 1024 /\* 1024\` >; /proc/sys/kernel/shmmax  
\# cat /proc/sys/kernel/shmmax  
1073741824  
\#  
Then click "Retry" for the Oracle Database Configuration Assistant.  
  
It is recommended to increase the shmmax setting permanently for Oracle9i. So if you want to increase the maximum shared memory size permanently, add the following line to the /etc/sysctl.conf file:  
  
kernel.shmmax=1073741824  
For more information on setting shared memory parameters for Oracle, see Setting Shared Memory.  
  
  
ORA-03113: end-of-file on communication channel  
I saw this error when I've run the "Database Configuration Assistant" and "sqlplus". When the "Database Configuration Assistant" gave me this error during Oracle9iR2 (9.2.0) installation on Red Hat 2.1 AS, I simply removed the shared memory segments owned by the Oracle user and I restarted the "Database Configuration Assistant". I'm not sure if this is the right way but it always worked for me. Here is what I did to get the "Database Configuration Assistant" running again:  
  
Database Configuration Assistant:  
  
I executed the ipcs command to get the address of the shared memory segments that have been allocated by Oracle:  
$ su - root  
\# ipcs  
  
\------ Shared Memory Segments --------  
key shmid owner perms bytes nattch status  
0x00000000 0 root 600 196608 2  
0x00000001 32769 root 600 655360 2  
0x00000000 458755 oracle 660 4194304 0  
0x00000000 491524 oracle 660 33554432 0  
0x00000000 524293 oracle 660 33554432 0  
0x00000000 557062 oracle 660 33554432 0  
0x00000000 589831 oracle 660 33554432 0  
0x00000000 622600 oracle 660 33554432 0  
0x00000000 655369 oracle 660 33554432 0  
0x00000000 688138 oracle 660 33554432 0  
0x3ecee0b0 720907 oracle 660 4194304 0  
  
\------ Semaphore Arrays --------  
key semid owner perms nsems status  
  
\------ Message Queues --------  
key msqid owner perms used-bytes messages  
  
\#  
Then I removed all shared memory segments that were owned by the Oracle user during the installation with the following command:  
\# ipcrm shm 458755 491524 524293 557062 589831 622600 655369 688138 720907  
After that I restarted the "Database Configuration Assistant". Once the installation was done I immediately restarted the DB as well.  
Caveat: I'm not sure if this procedure can cause any further problems if this is done during the installation. But so far I haven't seen any issues with this approach.  
  
sqlplus:  
  
If you get this problem in connection with sqlplus, then simply make sure that the database is down and exit sqlplus. After that, follow the procedure above by removing all shared memory segments that belong to the Oracle user. To my knowledge, this should not cause any problems.  
  
For more information on shared memory segments, see Determining Which Semaphore Sets and Shared Memory Segments Belong to Each Oracle Database or Instance.  
  
NOTE:  
To solve this problem permanently, increase the kernel shmmax size. For more information, see Setting Shared Memory and Setting Shared Memory.  
  
  
"Error invoking target install of makefile /opt/oracle/product/9.0.1/plsql/lib/ins\_plsql.mk"  
"Error invoking target install of makefile /opt/oracle/product/9.0.1/precomp/lib/ins-precomp.mk"  
"Error invoking target install of makefile /opt/oracle/product/9.0.1/precomp/lib/ins-net-client"  
  
I saw this error only when I installed Oracle 9i (9.0.1). People have sent me emails pointing out that the following solution also works for Mandrake 8.1, Mandrake 8.2, and for SuSE 8.0.  
  
Edit the file $ORACLE\_HOME/bin/genclntsh and change the following line:  
LD\_SELF\_CONTAINED="-z defs"  
to read:  
LD\_SELF\_CONTAINED=""  
After that run the script $ORACLE\_HOME/bin/genclntsh as the user "oracle" and not as the user "root". Also make sure you have all the Oracle environments set correctly!  
$ su - oracle  
$ $ORACLE\_HOME/bin/genclntsh  
Created /opt/oracle/product/9.0.1/lib/libclntst9.a  
$  
After that hit Retry in the error dialog window. This always worked for me.  
  
Here is Oracle's official solution for Oracle 9iR1 and 9iR1 iAS on RedHat 2.1 Advanced Server:  
http://otn.oracle.com/software/products/oracle9i/files/binutils\_readme.html  
  
  
"Error in invoking target install of make file /opt/oracle/product/9.2.0/network/lib/ins\_oemagent.mk"  
  
If you see this error on Red Hat Enterprise Linux 3, follow the guideline at Running Oracle Installation on Red Hat Enterprise Linux Advanced Server 3.  
  
On Red Hat 9 I performed the following steps here when the ORACLE\_HOME/install/make.log file contained the error messages:  
...  
/opt/oracle/product/9.2.0/network/lib/libnmi.a(snmitcln.o)(.text+0x159d): In function \`Nls\_ScanCmd':  
: undefined reference to \`\_\_ctype\_b'  
/opt/oracle/product/9.2.0/network/lib/libnmi.a(snmitcln.o)(.text+0x1603): more undefined references to \`\_\_ctype\_b' follow  
  
  
The issue here is that \_\_ctype\_b() is actually gone for \_\_ctype\_b\_loc() because Red Hat uses a new locale model. However, in libc.so, \_\_ctype\_b is still exported as compatibility symbol; at least that's the case with RH 9 glibc-2.3.2-5. And here is the reason why some people have this problem with Red Hat 9 and why some don't:  
  
When you bought the Red Hat 9 CDs in a store, then you will probably find glibc-2.3.2-5.i686.rpm on the first CD. This glibc version exports \_\_ctype\_b():  
$ rpm -ql glibc-2.3.2-5 | grep libc.so  
/lib/i686/libc.so.6  
/lib/libc.so.6  
/lib/tls/libc.so.6  
$ nm -a /lib/i686/libc.so.6 | grep \_\_ctype\_b  
001315f8 D \_\_ctype\_b  
00022340 T \_\_ctype\_b\_loc  
$ nm -a /lib/libc.so.6 | grep \_\_ctype\_b  
00133c58 D \_\_ctype\_b  
000223a0 T \_\_ctype\_b\_loc  
$  
But when you downloaded Red Hat 9 from redhat.com or from one of the mirror sites, then you will find glibc-2.3.2-11.9.i686.rpm on the image. This glibc version does not export \_\_ctype\_b(). This is also the case with glibc-devel-2.3.2-27.9.i386.rpm.  
$ rpm -ql glibc-2.3.2-11.9 | grep libc.so  
/lib/i686/libc.so.6  
/lib/libc.so.6  
/lib/tls/libc.so.6  
$ nm -a /lib/i686/libc.so.6 | grep \_\_ctype\_b  
00131718 D \_\_ctype\_b@GLIBC\_2.0  
000223a0 T \_\_ctype\_b\_loc  
$ nm -a /lib/libc.so.6 | grep \_\_ctype\_b  
00133d58 D \_\_ctype\_b@GLIBC\_2.0  
000223f0 T \_\_ctype\_b\_loc  
$  
  
Check the glibc version on your system:  
  
First check if the glibc packages on your RH 9 system work with the Oracle installer:  
$ rpm -q glibc-2.3.2-5 glibc-common-2.3.2-5 glibc-devel-2.3.2-5  
  
If you got the following error mesages:  
package glibc-2.3.2-5 is not installed  
package glibc-common-2.3.2-5 is not installed  
package glibc-devel-2.3.2-5 is not installed  
  
then you have glibc packages on your system that don't work with the Oracle installer and you need to follow the "Work Around" procedure here.  
But if your system has the 2.3.2-5 glibc versions installed, then you are fine and you don't need to follow the described "Work Around" procedure!  
  
  
Work Around Procedure:  
  
Since I was not able to find the glibc-2.3.2-5 RPMs available for download, I'm making the RPMs available on my website. These RPMs are copies of the glibc RPMs that came with the RH 9 CDs I bought in the store. I do not recommend to use any of the "compat" RPMs from older Red Hat distributions since RH 9 contains major changes.  
  
Here is the procedure for installing glibc-2.3.2-5 temporarely on your RH 9 server:  
  
Download the 2.3.2-5 glibc RPMs from here on my web site.  
  
First make sure if these downloaded RPM's are not corrupt and if they were really built and signed by Red Hat. You never know if someone fiddled with these RPMs or replaced them. To ensure the integrity and origin of these Red Hat's RPMs, run the following commands:  
$ su - root  
\# rpm --import /usr/share/rhn/RPM-GPG-KEY \# add Red Hat's PGP public key to the RPM database  
\# rpm --checksig glibc-2.3.2-5.i686.rpm glibc-common-2.3.2-5.i386.rpm glibc-devel-2.3.2-5.i386.rpm  
glibc-2.3.2-5.i686.rpm: (sha1) dsa sha1 md5 gpg OK  
glibc-common-2.3.2-5.i386.rpm: (sha1) dsa sha1 md5 gpg OK  
glibc-devel-2.3.2-5.i386.rpm: (sha1) dsa sha1 md5 gpg OK  
\#  
Downgrade glibc, glibc-common, and glibc-devel:  
\# rpm -Uvh --oldpackage glibc-2.3.2-5.i686.rpm glibc-common-2.3.2-5.i386.rpm glibc-devel-2.3.2-5.i386.rpm  
If you get the following error:  
error: Failed dependencies:  
glibc = 2.3.2-11.9 is needed by (installed) glibc-debug-2.3.2-11.9  
glibc = 2.3.2-11.9 is needed by (installed) glibc-utils-2.3.2-11.9  
glibc-devel = 2.3.2-11.9 is needed by (installed) glibc-debug-2.3.2-11.9  
glibc-devel = 2.3.2-11.9 is needed by (installed) nptl-devel-2.3.2-11.9  
  
then you can temporarily remove these RPMs (glibc-debug, glibc-utils, nptl-devel) from your system until you upgrade the glibc RPMs after your Oracle installation:  
\# rpm -e glibc-debug glibc-utils nptl-devel  
  
Now try to run runInstaller again.  
  
After Oracle has been installed, you can upgrade glibc, glibc-common, and glibc-devel again. For example:  
\# rpm -Uvh glibc-2.3.2-11.9.i686.rpm glibc-common-2.3.2-11.9.i386.rpm glibc-devel-2.3.2-11.9.i386.rpm  
  
According to Red Hat, binary compatibility in Red Hat Linux is always guaranteed for binaries and shared libraries accross releases, but not for .o files nor .a files. However, compatibility is guaranteed for .o files and .a files. \_within\_ a realease. Since glibc-2.3.2-5 and glibc-2.3.2-11.9 are from the same release, compatibility should be guaranteed for .o files (Oracle's .o files which have been created during the Oracle installation) and .a files.  
This means that Oracle should be fine when you upgrade glibc after the Oracle installation.  
  
If you have any problems or issues with this solution, or if you have any comments, please let me know. You can find my email address at the bottom of this web site.  
  
  
$ agentctl start  
  
DBSNMP for Linux: Version 9.2.0.4.0 - Production on 07-JAN-2004 19:11:14  
  
Copyright (c) 2003 Oracle Corporation. All rights reserved.  
  
Starting Oracle Intelligent Agent.../opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1855 Segmentation fault nohup $ORACLE\_HOME/bin/dbsnmp $\*  
>;>;$DBSNMP\_WDLOGFILE 2>;&1  
/opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1868 Segmentation fault nohup $ORACLE\_HOME/bin/dbsnmp $\* >;>;$DBSNMP\_WDLOGFILE 2>;&1  
/opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1880 Segmentation fault nohup $ORACLE\_HOME/bin/dbsnmp $\* >;>;$DBSNMP\_WDLOGFILE 2>;&1  
/opt/oracle/product/9.2.0/bin/dbsnmpwd: line 156: 1892 Segmentation fault nohup $ORACLE\_HOME/bin/dbsnmp $\* >;>;$DBSNMP\_WDLOGFILE 2>;&1  
  
You are probably trying to start the agent on RH AS 3. See Patching Oracle Intelligent Agent on RH AS 3 how to resolve it.  
  
  
$ dbca  
SIGSEGV 11\* segmentation violation  
stackbase=0x453da000, stackpointer=0x453d9d5c  
Full thread dump:  
"AWT-EventQueue-0" (TID:0x411d1e20, sys\_thread\_t:0x453d9e0c,  
state:R) prio=5 \*current thread\*  
java.lang.Object.wait(Object.java)  
java.awt.EventQueue.getNextEvent(EventQueue.java:126)  
...  
I got reports about dbca crashing on Red Hat 8.0 and on Red Hat 9. If this happens, try the following suggestion:  
  
$ su - root  
touch /etc/rac\_on  
Now try to restart dbca.  
  
Another option is to edit $ORACLE\_HOME/bin/dbca and to put the following lines under comment except the line marked in blue:  
\# if \[ -f /etc/rac\_on \]; then  
\# Run DBCA  
$JRE\_DIR/bin/jre -native -DORACLE\_HOME=$OH ...  
\# else  
\# Run DBCA  
\# $JRE\_DIR/bin/jre -DORACLE\_HOME=$OH ...  
\# fi  
  
Now try to restart dbca.  
  
  
./runInstaller: line 58: ./runInstaller: cannot execute binary file.  
You are probably trying to run a 64-bit Oracle version on a 32-bit Linux system. Make sure you downloaded the right Oracle version for your Linux system.  
  
To check if runInstaller is a 32-bit binary or a 64-bit binary, run the following command:  
$ cd /mnt/cdrom  
$ file install/linux/runInstaller  
install/linux/runInstaller: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.0.0, dynamically linked (uses shared libs), not stripped  
  
To check if your Linux system is 32-bit system or a 64-bit system, run e.g. the following command:  
$ file /sbin/init  
/sbin/init: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped  
  
  
  
The Oracle installer runInstaller hangs at: Installing Java Runtime Environment... Link pending... Copying README...  
This problems comes up only on RH 9. You probably forgot to set the environment variable LD\_ASSUME\_KERNEL to 2.4.1.  
  
To rectify this problem, run the following command and restart runInstaller:  
oracle$ export LD\_ASSUME\_KERNEL=2.4.1  
For more information on this issue, see Red Hat 9.  
  
  
Recovery Manager rman hangs  
You are probably running the wrong rman binary which belongs to the XFree86-devel RPM:  
$ which rman  
/usr/X11R6/bin/rman  
  
  
Can't find init file for Database "SID".  
I saw this error only with Oracle 9i R2 (9.2.0) when It tried to start the database with dbstart.  
  
I copied the init file for my SID "test" from /opt/oracle/admin/test/pfile to $ORACLE\_HOME/dbs to get dbstart and dbshut working:  
cp /opt/oracle/admin/test/pfile/inittest.ora.642002224936 $ORACLE\_HOME/dbs/inittest.ora  
  
  
"Error in setting permissions of file/directory /opt/oracle/jre/1.1.8/bin/i686/native\_threads/.extract\_args"  
This happens if you didn't burn your CD correctly.  
Either you burn your CD again to include dot files or you copy the .extract\_args file from your downloaded image to where runInstaller complains it is missing.  
  
  
"jre was not found in /tmp/OraInstall/jre/bin/i586/green\_threads/jre"  
You are probably running runInstaller on a 586 machine, or your AMD CPU gets recognized as 586 (e.g. AMD K6-III-400). You can check your machine (hardware) type by executing "uname -m". If you are not running on a 586 or on a AMD machine, try to link jre to java and see if this solves your problem.  
  
To rectify the problem with the 586 machine or with the AMD CPU, create a link for lib and bin from i586 to i686 and make the i686 directories read only. For example:  
  
ln -s /tmp/OraInstall/jre/bin/i686 /tmp/OraInstall/jre/bin/i586  
ln -s /tmp/OraInstall/jre/lib/i686 /tmp/OraInstall/jre/lib/i586  
chmod u-w /tmp/OraInstall/jre/bin/i686/tmp/OraInstall/jre/lib/i686  
Now restart runInstaller.  
  
  
../jre/bin/i386/native\_threads/java: error while loading shared libraries: libstdc++-libc6.1-1.so.2: cannot open shared object file: No such file or directory  
You probably forgot to install the compat-libstdc++ RPM which is a package for "Standard C++ libraries for Red Hat Linux 6.2 backwards compatibility". To rectify this problem, install the compat-libstdc++ RPM. For example on Red Hat 9:  
rpm -ivh compat-libstdc++-7.3-2.96.118.i386.rpm  
See also Development Packages for more information.  
  
  
/opt/oracle/jre/1.1.8/bin/../lib/i686/green\_threads/libzip.so: symbol errno, version GLIBC\_2.0 not defined in file libc.so.6 with link time reference (libzip.so)  
Unable to initialize threads: cannot find class java/lang/Thread  
Could not create Java VM  
I experienced this problem when I was running the Database Configuration Assistant dbca on Red Hat 9 without setting the LD\_ASSUME\_KERNEL environment variable.  
  
To rectify this problem, run the following command on Red Hat 9 and restart dbca:  
oracle$ export LD\_ASSUME\_KERNEL=2.4.1  
For more information on this issue, see Red Hat 9.  
  
  
Other Errors  
You might want to check out the Oracle on Linux Discussion Forum.

[http_support.geisnic.com_file_detail_2006-3-9_2006391120393210.htm]: http://support.geisnic.com/file_detail/2006-3-9/2006391120393210.htm
[renxiao2003]: http://bbs.chinaunix.net/viewpro.php?uid=88887
[joson]: http://bbs.chinaunix.net/viewpro.php?uid=33476
[xxj119]: http://bbs.chinaunix.net/viewpro.php?uid=54358
[unixbeginer]: http://bbs.chinaunix.net/viewpro.php?uid=34578