Shulou(Shulou.com)06/01 Report--

After installing oracle 11g using clones, then use cadb to build the database and report an error: ORA-12547: TNS:lost contact

For such an unobvious mistake, it is really difficult to locate and confirm the problem, and a lot of advice has been given online:

1. Missing package, libiao, ksh, etc.

2. Configuration file error

3. The environmental variables are incorrect.

4. Incorrect permissions of Oracle directory

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

In view of the above problems, a more serious inspection has been made, but no problem has been found.

At the same time, the execution of sqlplus / as sysdba is tracked using strace, and no obvious exception is found.

# strace-f-o / tmp/trace.1.log $ORACLE_HOME/bin/sqlplus / as sysdba

Finally, delete the configuration files such as / etc/security/limits.conf and / etc/sysctl.conf, and solve the problem after the new configuration.

Finally, all the configuration files are compared.

Send the original configuration file / etc/security/limits.conf 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 is appended when modifying the configuration file, and the original configuration file that begins with * will not be deleted first, so the following line of configuration does not take effect.

* soft stack 1024 # effective oracle soft stack 10240 # does not take effect

When using the strace sqlplus / as sysdba trace, I found that an exception ORA-12547 was thrown after opening a 1.1m file. The original problem lies in the configuration file.

Summary:

Sometimes, due to some unexpected reasons, our modified configuration file does not take effect, so we can add a verification section, and to solve this problem, 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, 2008, 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 have not been linked correctly

Attached: detailed error report 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%

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.