关于Oracle rac新加节点时可能遇到的问题

最新推荐文章于 2021-04-04 22:11:29 发布

oracle0421

最新推荐文章于 2021-04-04 22:11:29 发布

阅读量751

点赞数

分类专栏： Oracle DB 文章标签： database oracle rac 扩展

本文链接：https://blog.csdn.net/lanjingbinglong/article/details/38546075

版权

Oracle DB 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

1、Could not connect to ASM due to following error:ORA-12547：TNS：lost contact

处理办法：

修改两个节点grid用户bin目录下Oracle文件权限：

grid@DB-B bin]$ ls -l oracle

-rwxrwxr-x. 1 grid oinstall 203972203 Jun 25 2013 oracle

[grid@DB-B bin]$ chmod +s oracle

[grid@DB-B bin]$ ls -l oracle

-rwsrwsr-x. 1 grid oinstall 203972203 Jun 25 2013 oracle

2、扩展grid时遇到Exception java.lang.OutOfMemoryError: Java heap space occurred..

错误如下：

[grid@server1 bin]$ cat /u01/app/oraInventory/logs/oraInstall2013-04-24_12-30-39PM.err
Exception java.lang.OutOfMemoryError: Java heap space occurred..
Exception in thread "Thread-45" java.lang.OutOfMemoryError: Java heap space
        at sun.nio.cs.UTF_8.newDecoder(UTF_8.java:104)
        at java.lang.StringCoding$CharsetSD.<init>(StringCoding.java:170)
        at java.lang.StringCoding$CharsetSD.<init>(StringCoding.java:161)
        at java.lang.StringCoding.decode(StringCoding.java:217)
        at java.lang.StringCoding.decode(StringCoding.java:234)
        at java.lang.String.<init>(String.java:458)
        at oracle.sysman.oii.oiix.OiixTeePrintStream.write(OiixTeePrintStream.java:369)
        at sun.nio.cs.StreamEncoder$CharsetSE.writeBytes(StreamEncoder.java:336)
        at sun.nio.cs.StreamEncoder$CharsetSE.implFlushBuffer(StreamEncoder.java:404)
        at sun.nio.cs.StreamEncoder.flushBuffer(StreamEncoder.java:115)
        at java.io.OutputStreamWriter.flushBuffer(OutputStreamWriter.java:169)
        at java.io.PrintStream.write(PrintStream.java:459)
        at java.io.PrintStream.print(PrintStream.java:602)
        at oracle.sysman.oii.oiic.OiicSilentInstallPhaseProgressListener.displayProgress(OiicSilentInstallPhaseProgressListener.java:372)
        at oracle.sysman.oii.oiic.OiicSilentInstallPhaseProgressListener.addBytes(OiicSilentInstallPhaseProgressListener.java:341)
        at oracle.sysman.oii.oiic.OiicSilentInstallPhaseProgressListener.addPercentage(OiicSilentInstallPhaseProgressListener.java:555)
        at oracle.sysman.oii.oiix.OiixProgressUpdator$OiixProgressUpdatingWorker.run(OiixProgressUpdator.java:199)
        at java.lang.Thread.run(Thread.java:595)
java.lang.OutOfMemoryError: Java heap space
        at java.io.UnixFileSystem.resolve(UnixFileSystem.java:93)
        at java.io.File.<init>(File.java:179)
        at java.io.File.listFiles(File.java:1020)
        at oracle.cluster.deployment.ractrans.DirectoryMap.processDir(DirectoryMap.java:225)
        at oracle.cluster.deployment.ractrans.DirectoryMap.processDir(DirectoryMap.java:281)
        at oracle.cluster.deployment.ractrans.DirectoryMap.processDir(DirectoryMap.java:281)
        at oracle.cluster.deployment.ractrans.DirectoryMap.<init>(DirectoryMap.java:166)
        at oracle.cluster.deployment.ractrans.DirListing.<init>(DirListing.java:283)
        at oracle.cluster.deployment.ractrans.DirListing.<init>(DirListing.java:159)
        at oracle.cluster.deployment.ractrans.RACTransferCore.createDirListing(RACTransferCore.java:209)
        at oracle.cluster.deployment.ractrans.RACTransfer.createDirListing(RACTransfer.java:1838)
        at oracle.cluster.deployment.ractrans.RACTransfer.transferDirStructureToNodes(RACTransfer.java:608)
        at oracle.cluster.deployment.ractrans.RACTransfer.transferDirToNodes(RACTransfer.java:252)
        at oracle.ops.mgmt.cluster.ClusterCmd.transferDirToNodes(ClusterCmd.java:3103)
        at oracle.ops.mgmt.cluster.ClusterCmd.transferDirToNodes(ClusterCmd.java:3022)
        at oracle.sysman.oii.oiip.oiipg.OiipgClusterOps.transferDirToNodes(OiipgClusterOps.java:947)
        at oracle.sysman.oii.oiif.oiifw.OiifwClusterCopyWCCE.doOperation(OiifwClusterCopyWCCE.java:544)
        at oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:171)
        at oracle.sysman.oii.oiif.oiifw.OiifwAddNodePhaseWCDE.doOperation(OiifwAddNodePhaseWCDE.java:313)
        at oracle.sysman.oii.oiif.oiifb.OiifbCondIterator.iterate(OiifbCondIterator.java:171)
        at oracle.sysman.oii.oiic.OiicPullSession.doOperation(OiicPullSession.java:1371)
        at oracle.sysman.oii.oiic.OiicSessionWrapper.doOperation(OiicSessionWrapper.java:294)
        at oracle.sysman.oii.oiic.OiicInstaller.run(OiicInstaller.java:579)
        at oracle.sysman.oii.oiic.OiicInstaller.runInstaller(OiicInstaller.java:969)
        at oracle.sysman.oii.oiic.OiicInstaller.main(OiicInstaller.java:906)

解决办法

修改/u01/app/11.2.0/grid/oui/oraparam.ini文件，

JRE_MEMORY_OPTIONS=" -mx1024m" （默认值为96M）修改为1024即可