ORA-12547: TNS: Lost contact

Today do ETL, Connection source library error, ORA-12547: TNS: Lost contact, online find the reason, there are many ways, do not know which is accurate, the production database is owned by other manufacturers at the same time,

 

Has anyone handled a similar situation? If I use PLSQL to log on, this error is reported.

 

 

ORA-12547: TNS: Lost contact

The official explanation is:
ORA-12547: TNS: Lost contact
Cause: partner has unexpectedly gone away, usually during process startup.
Action: Investigate partner application for abnormal termination. On an interchange, this can happen if the machine is overloaded.
Solution: Install libaio-0.3.105-2.i386.rpm reboot system TNS-12547 TNS: Lost contact

Cause: partner has unexpectedly gone away, usually during process startup.

Action: Investigate partner application for abnormal termination. On an interchange, th... [/quote]
According to his explanation, this problem should be caused by the overload of the operating system! But it won't be too bad !!! ORA-12547: TNS: Lost contact error, it is reasonable to say that Oracle Enterprise Linux is for Oracle, how can this error appear, search for it on the internet, it may be because the libaio package is not installed. Let me try it.

In the installation disk 3rd found in the libaio-0.3.105-2.i386.rpm and libaio-devel-0.3.105-2.i386.rpm, if there is no installation disk around, you can go to the http://rpmfind.net to search, after installation, restart the computer, the previously installed Oracle unmount, re-install, no problem.

Note that this package will be selected during Linux installation.

 

 

Ubuntu8.10 install Oracle10g, in the final configuration of the database prompts ORA-12547: TNS: Lost contact, then open a new terminal, install libaio-Dev.

 Sudo apt-Get install libaio-Dev

 

 

This problem occurs when you log on to pl SQL when adding a database today.

I have not installed many packages on the Internet ?!

I remembered it. I renamed the computer a few days ago.

Solution:

Open net manager, find the newly added database, and change the host name to the name of the current computer. Done!