Oracel database problem ORA-12547 ORA-12571 resolution record

Tag: TNS Snr ack file in contact admin causes list str

Oracel Business Database recently appeared frequently: Ora-12547:tns:lost contact and ora-12571:tns:packet writer failure error

Troubleshooting port and listener issues, the Final Solution:

Modify Sqlnet.authentication_services= (NTS) in the Sqlnet.ora file to sqlnet.authentication_services= (NONE)

After the modification of the above error resolved, but there is a very slow connection problem, the connection success time of more than 10 minutes,

After a lengthy inspection, it is found that the Oracle related log files are too large, resulting in the subsequent log information write time is too long, the workaround:

Back up the original log file and empty the log file, the relevant log file is as follows:

X:\app\Administrator\diag\tnslsnr\xx-datebase-1\listener\trace\listener.log
X:\app\Administrator\product\11.2.0\dbhome_2\oc4j\j2ee\OC4J_DBConsole_xx-datebase-1_orcl\log\ Em-application.log

Where xx-datebase-1 represents the database server name.

There are many reasons for the problem of database, the above method does not mean that the same problem is effective in other environment. Avoid stepping on the pit ...

Oracel database problem ORA-12547 ORA-12571 resolution record