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

There is a solution to the ORA-12537: TNS:connection closed problem in the database. In view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Environment: oracle linux5.5 + oracle 11g rac

Problem description: the client cannot connect to the database and reports an error: ORA-12537: TNS:connection closed

Lsnrctl status snooping is normal, lsnrclt stop/start can start normally, try to connect, still report the same error, check the monitoring log, no obvious error message is found, and then find a solution on the Internet (link: http://blog.itpub.net/post/38575/530168):

Modify the permissions of the oracle file under $ORACLE_HOME/bin

Specific operation process:

[oracle@rac1 ~] $cd $ORACLE_HOME/bin/

[oracle@rac1 bin] $ls-l oracle

-r-xr-sr-x 1 oracle asmadmin 173515905 Dec 21 16:46 oracle

[oracle@rac1 bin] $chmod 6751 oracle

[oracle@rac1 bin] $ls-l oracle

-rwsr-s--x 1 oracle asmadmin 173515905 Dec 21 16:46 oracle

Reconnect, OK!

The solution to the problem of ORA-12537: TNS:connection closed in the database is shared here. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.