ORA-12547: TNS: lost contact error Solution

Source: Internet
Author: User

Running Environment: Ubuntu + Oracle 11.2.0
 
ORA-12547: TNS: lost contact error occurs when the command starts oracle. Good afternoon, no matter in the afternoon. If the link is invalid, it will not work after Shutdown and restart. Then google found the solution below. In retrospect, the cause is the permission problem. At noon, I accidentally assigned the permission to the folder of the oracle installation directory. It seems that the permission of oracle cannot be changed at will.

Recommended reading:

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store

Cause

1. This cocould be due to kernel parameters settings
2. Incorrect permissions on the ORACLE executable
 
Solution
 
To implement the solution, please execute the following steps:
 
1.
This cocould be due to kernel parameters settings
Please check the notes below that provide the required settings for kernel parameters
Note 169706.1 Oracle Database on AIX, HP-UX, Linux, MacOSX, Solaris, Tru64
Note 201021.1 SOLARIS: Quick Start Guide-9.2.0 RDBMS Installation
 
2.
This cocould be due to Incorrect permissions on the ORACLE.exe
The 'LS' command shocould show permissions 6751 (as follows)
 
Please check the following:
 
$ Cd $ ORACLE_HOME/bin
$ Ls-l oracle
 
The output shocould be
-Rwsr-s -- x 1 oracle dba
 
If not then please execute the following
$ Chmod 6751 oracle
 
Please also verify if the following are correct
 
Echo $ ORACLE_HOME
Echo $ ORACLE_SID
Echo $ LD_LIBRARY_PATH
Echo $ PATH
 
3.
If the above does not resolve I suggest that you shutdown the database and listener and then
"Relink all"
Note 131321.1 How to Relink Oracle Database Software on UNIX
After completing the preceding steps, it is OK to start oracle again.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.