Oracle dbca times: ORA-12547: TNS: lost contact error resolution, dbcaora-12547

Oracle dbca times: ORA-12547: TNS: lost contact error resolution, dbcaora-12547

Preface

Recently encountered a problem in the work, the error is Oracle dbca reported error: ORA-12547: TNS: lost contact, by looking for relevant information finally found the solution, below to share with you, let's take a look at the detailed introduction.

Environment:

• X86-64bit OS: RHEL6.5
• DB: 11.2.0.4 for Linux 86-64bit

Ideas:

DBCA error, first check the DBCA log, the log is also reported ORA-12547: TNS: lost contact

So sqlplus/as sysdba again press enter, also report ORA-12547: TNS: lost contact,

Based on previous engineering experience, go to bdump to find the trc file, but there is no trc generated in bdump.

Find the trc file in/u01/app/oracle/product/11.2.0/db_1/rdbms/log:

[Oracle @ dg1 log] $ pwd/u01/app/oracle/product/11.2.0/db_1/rdbms/log [oracle @ dg1 log] $ ls-lrt total 9808-rw-r -----. 1 oracle oinstall 401207 Feb 1 dbua1557284_ora_8053.trc-rw-r -----. 1 oracle oinstall 401207 Feb 1 dbua1557284_ora_8062.trc-rw-r -----. 1 oracle oinstall 401207 Feb 1 dbua1557284_ora_8065.trc-rw-r -----. 1 oracle oinstall 401373 Feb 1 dgw.ora_8227.trc-rw-r --- --. 1 oracle oinstall 401228 Feb 1 dgw.ora_2701.trc-rw-r -----. 1 oracle oinstall 401228 Feb 1 dgw.ora_2706.trc-rw-r -----. 1 oracle oinstall 401410 Feb 1 dgw.ora_2715.trc-rw-r -----. 1 oracle oinstall 401228 Feb 1 dgw.ora_2722.trc-rw-r -----. 1 oracle oinstall 401244 Feb 1 dbua3144297_ora_2792.trc-rw-r -----. 1 oracle oinstall 401244 Feb 1 dbua3144297_ora_2801. Trc-rw-r -----. 1 oracle oinstall 401244 Feb 1 dbua3144297_ora_2804.trc-rw-r -----. 1 oracle oinstall 401410 Feb 1 dgw.ora_2930.trc-rw-r -----. 1 oracle oinstall 401341 Feb 1 dgw.ora_3181.trc-rw-r -----. 1 oracle oinstall 401090 Feb 1 dgw.ora_3187.trc-rw-r -----. 1 oracle oinstall 401341 Feb 1 dgw.ora_3190.trc-rw-r -----. 1 oracle oinstall 401090 Feb 1 dgw.ora_3 205. trc-rw-r -----. 1 oracle oinstall 401341 Feb 1 dgw.ora_3210.trc-rw-r -----. 1 oracle oinstall 401090 Feb 1 dgw.ora_3214.trc-rw-r -----. 1 oracle oinstall 401090 Feb 1 dgw.ora_3313.trc-rw-r -----. 1 oracle oinstall 401341 Feb 1 dgw.ora_3329.trc-rw-r -----. 1 oracle oinstall 401090 Feb 1 dgw.ora_3341.trc-rw-r -----. 1 oracle oinstall 401090 Feb 1 dgw.ora_3344. Trc-rw-r -----. 1 oracle oinstall 401341 Feb 1 dgw.ora_32.16.trc-rw-r -----. 1 oracle oinstall 401341 Feb 1 dgw.ora_3375.trc-rw-r -----. 1 oracle oinstall 401090 Feb 1 dgw.ora_3378.trc [oracle @ dg1 log] $ [oracle @ dg1 log] $ vi dgw.ora_3369.trc Dump file/u01/app/oracle/product/11.2.0/db_1/rdbms /log/dgw.ora_32.16.trc *** 17:40:23. 652 Oracle Database 11g Enterprise Edition Re Lease 11.2.0.4.0-64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1 System name: Linux Node name: dg1 Release: 2.6.32-431. el6.x86 _ 64 Version: #1 SMP Sun Nov 10 22:19:54 EST 2013 Machine: x86_64 Instance name: dg1 Redo thread mounted by this instance: 0 <none> Oracle process number: 0 Unix process pid: 3 369, image: oracle @ dg1 *** 17:40:23. 652 skgm error 27135: errno = 0, info = 0, 0, 0, 0, 1048576,209 7152, 0 skgm error 27135: errno = 0, info = 0, 0, 0, 0, 1048576,209, 0 *** 17:40:23. 654 Exception [type: SIGSEGV, Address not mapped to object] [ADDR: 0x3D8] [PC: 0x95BE6EB, opiodr () + 11347] [flags: 0x0, count: 1] Registers: % rax: 0x000000000c0ea630% rbx: 0x000000000c0ea638% Rcx: 0 x 0000000000000000% rdx: 0 x 0000000000000000% rdi: 0x000000000c0ccba0% rsi: %% rsp: %% rbp: %% r8: 0x00007fffa308d970% r9: %% r10: %% r11: 0x00007fab40ec1538% r12: 0x000000000000003c % r13: 0 x 0000000000000004% r14: 0x00007fffa308e6f8% r15: 0 x 0000000000000002% rip: 0x00000000095be6eb % efl: 0x0000000000010246 opi Odr () + 11325 (0x95be6d5) lea (% rax, % rbx), % rdx opiodr () + 11329 (0x95be6d9) mov % rdx, (% rcx, % rbx) opiodr () + 11333 (0x95be6dd) mov 0x2b34a84 (% rip), % rax opiodr () + 11340 (0x95be6e4) mov 0x178 (% rax), % rdx> opiodr () + 11347 (0x95be6eb) movzwl 0x3d8 (% rdx), % ecx opiodr () + 11354 (0x95be6f2) test $0x100, % ecx opiodr () + 11360 (0x95be6f8) jz 0x95bc8c7 opiodr () + 11366 (0x95be6fe) mov-0x18 (% rbp), % eax opiodr () + 11369 (0x95be 701) cmp $60, % eax *** 17:40:23. 660 dbkedDefDump (): Starting a non-incident diagnostic dump (flags = 0x1, level = 3, mask = 0x0) ----- Error Stack Dump ----- ORA-07445: exception encountered: core dump [opiodr () + 11347] [SIGSEGV] [ADDR: 0x3D8] [PC: 0x95BE6EB] [Address not mapped to object] [] ORA-27135: operating System hard stack limit is set too low ----------- >>>>>> note the Additional information: 1048576 Additional information: 2097152 ----- SQL Statement (None) ----- Current SQL information unavailable-no SGA. The following is omitted...

Solution

Finally, check whether the file/etc/security/limits. conf is correct:

Oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 1024 ---> Here it should be 10240, based on: requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64) (Document ID 1441282.1)

After the modification, close the dbca interface, exit the oracle user, su-oracle user, and then re-initiate dbca.

Summary

The above is all the content of this article. I hope the content of this article has some reference and learning value for everyone's learning or work. If you have any questions, please leave a message to us, thank you for your support.