Oracle Silent installation cadb error Tns-12547:tns:lost contact

Use Cloning to install Oracle 11g, then use CADB to build the library error:ora-12547:tns:lost Contact

For such a not obvious mistake, it is very difficult to locate the problem of confirmation, the Internet gave a lot of advice:

1, lack of bags, libiao, ksh, etc.

2. configuration file Error

3, the environment variable is not correct

4, the Oracle directory permissions are not correct

5. $ORACLE _home/bin/oracle file permissions or file size is incorrect

In response to the above questions to do a more serious examination, did not find the problem.

At the same time, the execution of Sqlplus/as sysdba was tracked using strace , and no obvious anomalies were found.

#strace-F-o/tmp/trace.1.log $ORACLE _home/bin/sqlplus/as sysdba

Finally, the configuration files such as /etc/security/limits.conf,/etc/sysctl.conf are deleted, and the new configuration problem is resolved.

Finally, all the configuration files are compared.

Send the original configuration file/etc/security/limits.conf content as follows:

*               soft     nofile          65534*                hard    nofile           65534*                soft    stack            1024*                hard    stack            1024*                soft    nproc           65534 *               hard    nproc            65534oracle               soft    nproc   2047oracle               hard    nproc    16384oracle               soft    nofile  1024oracle               hard    nofile  65536oracle               soft    stack    10240oracle               soft    memlock         unlimitedoracle               hard    memlock          unlimited

The original installation script when modifying the configuration file is an append form, for the original * beginning of the configuration file will not be deleted, resulting in the following line configuration does not take effect

* Soft stack 1024x768 #生效oracle soft stack 10240 #不生效

When using the Strace sqlplus/as sysdba Trace, it is found that after opening a 1.1M file throws an exception ORA-12547, the original problem is in the configuration file here.

Summarize:

Sometimes, because of some unexpected reasons, the configuration file that caused us to modify is not effective, so we can add a verification link, we can use ulimit-a to check whether each resource limit is OK.

Reference:

https://oracledbamasters.wordpress.com/2014/02/25/ora-12547-tns-lost-contact/

ERROR:
$sqlplus/as SYSDBA
Sql*plus:release 11.1.0.7.0–production on Wed Mar 30 11:59:06 2011
Copyright (c) 1982, the Oracle. All rights reserved.
ERROR:
Ora-12547:tns:lost Contact

Cause:

1) to Kernel parameters settings
2) Incorrect permissions on the ORACLE executable
3) Insufficient ulimit setting for stack
4) $ORACLE _home/rdbms/lib/config.o is 0 bytes
5) Oracle binaries has not been linked correctly

Attached: detailed error log

Copying Database files

dbca_progress:1%

dbca_progress:2%

Ora-12547:tns:lost Contact

Ora-12547:tns:lost Contact

dbca_progress:4%

dbca_progress:37%

Creating and Starting Oracle instance

Ora-12547:tns:lost Contact

dbca_progress:38%

Ora-12547:tns:lost Contact

dbca_progress:40%

Ora-12547:tns:lost Contact

dbca_progress:45%

dbca_progress:50%

dbca_progress:51%

Ora-12547:tns:lost Contact

dbca_progress:56%

Ora-12547:tns:lost Contact

Ora-12547:tns:lost Contact

Ora-12547:tns:lost Contact

dbca_progress:57%

Ora-12547:tns:lost Contact

dbca_progress:61%

dbca_progress:62%

Completing Database Creation

dbca_progress:66%

dbca_progress:70%

Ora-12547:tns:lost Contact

dbca_progress:73%

dbca_progress:74%

Ora-12547:tns:lost Contact

dbca_progress:85%

Ora-12547:tns:lost Contact

dbca_progress:86%

Ora-12547:tns:lost Contact

Ora-12547:tns:lost Contact

Ora-12547:tns:lost Contact

dbca_progress:98%

dbca_progress:100%

This article is from the "composer" blog, make sure to keep this source http://zuoqujia.blog.51cto.com/9151800/1657148

Oracle Silent installation cadb error Tns-12547:tns:lost contact