-
编辑 删除
10.2.0.3 exp BUG:5586842
exp 错误：Errors when doing an export.Export log:. exporting cluster definitionsEXP-00056: ORACLE error 4045 encounteredORA-04045: errors during recompilation/revalidation of SYS.KU$_XMLSCHEMA_VIEWORA-22973: size of object identifier exceeds maximum size allowedEXP-00000: Export terminated unsuccessfully[@more@]解决：SolutionWorkaround:1. SQL>show parameter lengthIf the parameter nls_length_semantics=char > complete the next steps2. SQL>connect as sysdbaSQL> alter session set nls_len
-
编辑 删除
oracle 9204 for linuxAS4安装
在安装过程中会遇见2个报错：1是，运行runInstall报错；2是，运行dbca报错；[@more@]安装报错处理1：1) 在运行CD-Rom 里面的 runInstall,却发现以下错误信息：Error occurred during initialization of VMUnable 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需要打一个补丁：download the p3006854_9204 patch p3006854_9204_LINUX.zip from http://metalink.oracle.com. See bug 3006854 for
-
编辑 删除
ORA-12537 TNS：数据库连接错误
数据库session连接报错：ORA-12537： TNS连接错误操作系统报错：cdksh: 0403-030 The fork function failed. Too many processes already exist.[@more@]错误原因：查看操作系统允许最大连接数：#lsattr -El sys0|grep maxuproc参数默认128。错误解决：把此参数允许最大连接数改大：#chdev -l sys0 -a maxuproc=1024数据库问题立马解决。附调整数据库参数：在sqlnet.ora中将tcp.validnode_checking的值设为no；重启数据库和listener服务。
-
编辑 删除
VMware 搭建 Oracle10g RAC 笔记
使用 VMware Server 在 Linux 上安装 Oracle RAC 10g 笔记：[@more@]1. ocfs和asm安装包# cat /etc/redhat-releaseEnterprise Linux Enterprise Linux AS release 4 (October Update 5)# uname -r2.6.9-67.0.4.0.2.ELsmp# uname -pi686ASM包的下载地址:http://www.oracle.com/technology/software/tech/linux/asmlib/rhel4.htmlOCFS2包的下载地址: :http://oss.oracle.com/projects/ocfs2/files/RedHat/RHEL4/i386/1.2.9-1/2.6.9-42.EL/OCFS2 Tools包的下载地址: :http://oss.oracle.com/projects/ocfs2-tools/files/RedHat/RHEL4/i386/1.
-
编辑 删除
10g rac升级crs,执行root102.sh报错
故障信息：exec(): 0509-036 Cannot load program crsctl.bin because of the following errors: 0509-130 Symbol resolution failed for crsctl.bin because: 0509-136 Symbol __ct__Q2_3std8_LocinfoFPCci (number 176) is not exported from dependent module /usr/lib/libC.a[ansi_64.o]. 0509-192 Examine .loader section symbols with the 'dump -Tv' command.[@more@]故障原因：xlC.rte 版本低解决方法:升级xlC.rte 版本到9.0.0.1
-
编辑 删除
10g rac安装crs,执行root.sh报错
错误信息：root.sh错误：Failure at final check of Oracle CRS stack.10/oracrs/crs/log/rcy01/client/css.log错误：[ CSSCLNT][1]clsssInitNative: connect failed, rc 9...[@more@]故障原因：网络通信问题；tcp_recvspace和tcp_sendspace故障解决：修改网卡的该参数值；ifconfig en0 down ifconfig en0 detachchdev –l en0 –a tcp_recvspace=65536chdev –l en0 –a tcp_sendspace=131072chdev –l en0 –a rfc1323=1ifconfig en0 up
