Oracle dbca时报：ORA-12547: TNS:lost contact错误的解决
前言
最近在工作中遇到了一个问题，错误是Oracledbca时报错：ORA-12547:TNS:lostcontact，通过查找相关的资料终于找到了解决的方法，下面分享给大家，话不多说了，来一起看看详细的介绍吧。
环境：
- OS:RHEL6.5x86-64bit
- DB:11.2.0.4forLinux86-64bit
思路：
DBCA报错，首先看DBCA的日志，日志中也是报ORA-12547:TNS:lostcontact
于是再sqlplus/assysdba敲回车，也是报ORA-12547:TNS:lostcontact，
基于之前的工程经验，先到bdump下找trc文件，不过在bdump下是没有任何trc生成的。
再到/u01/app/oracle/product/11.2.0/db_1/rdbms/log下找trc文件，果然找到了：
[oracle@dg1log]$pwd /u01/app/oracle/product/11.2.0/db_1/rdbms/log [oracle@dg1log]$ls-lrt total9808 -rw-r-----.1oracleoinstall401207Feb116:16dbua1557284_ora_8053.trc -rw-r-----.1oracleoinstall401207Feb116:16dbua1557284_ora_8062.trc -rw-r-----.1oracleoinstall401207Feb116:16dbua1557284_ora_8065.trc -rw-r-----.1oracleoinstall401373Feb116:18dg1_ora_8227.trc -rw-r-----.1oracleoinstall401228Feb116:26dg1_ora_2701.trc -rw-r-----.1oracleoinstall401228Feb116:26dg1_ora_2706.trc -rw-r-----.1oracleoinstall401410Feb116:27dg1_ora_2715.trc -rw-r-----.1oracleoinstall401228Feb116:27dg1_ora_2722.trc -rw-r-----.1oracleoinstall401244Feb116:31dbua3144297_ora_2792.trc -rw-r-----.1oracleoinstall401244Feb116:31dbua3144297_ora_2801.trc -rw-r-----.1oracleoinstall401244Feb116:31dbua3144297_ora_2804.trc -rw-r-----.1oracleoinstall401410Feb116:34dg1_ora_2930.trc -rw-r-----.1oracleoinstall401341Feb117:27dg1_ora_3181.trc -rw-r-----.1oracleoinstall401090Feb117:27dg1_ora_3187.trc -rw-r-----.1oracleoinstall401341Feb117:27dg1_ora_3190.trc -rw-r-----.1oracleoinstall401090Feb117:28dg1_ora_3205.trc -rw-r-----.1oracleoinstall401341Feb117:28dg1_ora_3210.trc -rw-r-----.1oracleoinstall401090Feb117:28dg1_ora_3214.trc -rw-r-----.1oracleoinstall401090Feb117:36dg1_ora_3313.trc -rw-r-----.1oracleoinstall401341Feb117:37dg1_ora_3329.trc -rw-r-----.1oracleoinstall401090Feb117:37dg1_ora_3341.trc -rw-r-----.1oracleoinstall401090Feb117:37dg1_ora_3344.trc -rw-r-----.1oracleoinstall401341Feb117:40dg1_ora_3369.trc -rw-r-----.1oracleoinstall401341Feb117:40dg1_ora_3375.trc -rw-r-----.1oracleoinstall401090Feb117:40dg1_ora_3378.trc [oracle@dg1log]$ [oracle@dg1log]$vidg1_ora_3369.trc Dumpfile/u01/app/oracle/product/11.2.0/db_1/rdbms/log/dg1_ora_3369.trc ***2016-02-0117:40:23.652 OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-64bitProduction WiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptions ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 Systemname:Linux Nodename:dg1 Release:2.6.32-431.el6.x86_64 Version:#1SMPSunNov1022:19:54EST2013 Machine:x86_64 Instancename:dg1 Redothreadmountedbythisinstance:0Oracleprocessnumber:0 Unixprocesspid:3369,image:oracle@dg1 ***2016-02-0117:40:23.652 skgmerror27135:errno=0,info=0,0,0,0,1048576,2097152,0 skgmerror27135:errno=0,info=0,0,0,0,1048576,2097152,0 ***2016-02-0117:40:23.654 Exception[type:SIGSEGV,Addressnotmappedtoobject][ADDR:0x3D8][PC:0x95BE6EB,opiodr()+11347][flags:0x0,count:1] Registers: %rax:0x000000000c0ea630%rbx:0x000000000c0ea638%rcx:0x0000000000000000 %rdx:0x0000000000000000%rdi:0x000000000c0ccba0%rsi:0x00007fffa308e250 %rsp:0x00007fffa308d970%rbp:0x00007fffa308e440%r8:0x00007fffa308d970 %r9:0x00007fffa308e440%r10:0x00007fffa308c600%r11:0x00007fab40ec1538 %r12:0x000000000000003c%r13:0x0000000000000004%r14:0x00007fffa308e6f8 %r15:0x0000000000000002%rip:0x00000000095be6eb%efl:0x0000000000010246 opiodr()+11325(0x95be6d5)lea(%rax,%rbx),%rdx opiodr()+11329(0x95be6d9)mov%rdx,(%rcx,%rbx) opiodr()+11333(0x95be6dd)mov0x2b34a84(%rip),%rax opiodr()+11340(0x95be6e4)mov0x178(%rax),%rdx >opiodr()+11347(0x95be6eb)movzwl0x3d8(%rdx),%ecx opiodr()+11354(0x95be6f2)test$0x100,%ecx opiodr()+11360(0x95be6f8)jz0x95bc8c7 opiodr()+11366(0x95be6fe)mov-0x18(%rbp),%eax opiodr()+11369(0x95be701)cmp$60,%eax ***2016-02-0117:40:23.660 dbkedDefDump():Startinganon-incidentdiagnosticdump(flags=0x1,level=3,mask=0x0) -----ErrorStackDump----- ORA-07445:exceptionencountered:coredump[opiodr()+11347][SIGSEGV][ADDR:0x3D8][PC:0x95BE6EB][Addressnotmappedtoobject][] ORA-27135:OperatingSystemhardstacklimitissettoolow----------->>>>>>>注意此处 Additionalinformation:1048576 Additionalinformation:2097152 -----SQLStatement(None)----- CurrentSQLinformationunavailable-noSGA. 以下省略。。。
解决方法
最后确认，是/etc/security/limits.conf文件的问题：
oraclesoftnproc2047 oraclehardnproc16384 oraclesoftnofile1024 oraclehardnofile65536 oraclesoftstack1024--->此处应该是10240,依据:RequirementsforInstallingOracle11gR2RDBMSonRHEL6orOL664-bit(x86-64)(文档ID1441282.1)
修改完之后，关闭dbca界面，exit退出oracle用户，su-oracle用户，再重新发起dbca即可。
总结
以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作具有一定的参考学习价值，如果有疑问大家可以留言交流，谢谢大家对毛票票的支持。