"ORA-12547: TNS:lost contact" when creating database in Oracle 10g

Dtsazza · 01-17-2006, 07:13 AM

Hi all,

I've recently tried to install Oracle 10g on my Debian Etch system for testing and development purposes. Using the guides at http://www.togaware.com/linux/survivor/Oracle_10g.shtml and http://www.penlug.org/twiki/bin/view...tOracleInstall, and a little ingenuity, I managed to get the base system to install properly.

Or so it seemed... I didn't opt to create a database at install time, and when trying to do so later using the dbca tool, I keep getting the error "ORA-12547: TNS:lost contact" popping up. If I check the option to create a script that I'll run later, running the script throws lots of lines like

Code:

oracleadoyletest: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

and exits with an error along those lines.

The library mentioned sounds like a useful clue - though I don't have it on my system and it sounds like it's *being* called but failing because of something else. If anyone can shed some light on this I'd be most pleased.

Cheers,
Andrzej

gilead · 01-18-2006, 01:40 AM

libaio is the asynchronous IO library for linux. I downloaded the rpms (libaio-0.3.104-2.i386.tgz & libaio-devel-0.3.104-2.i386.tgz) from http://download.fedora.redhat.com/pu...s/Fedora/RPMS/ and then ran rpm2tgz so I could install them under Slackware. I used the Fedora libs because they worked first time when I ran Oracle 10g under Fedora Core 4.

Under Slackware I had to run:

Code:

/u01/app/oracle/product/10.2.0/db_1/bin/relink all

before I could run dbca or netca successfully.

Hope that helps...

Dtsazza · 01-18-2006, 06:00 AM

Thanks, the Fedora libaio RPMs (and alien!) worked perfectly.

After a few more hurdles, I've managed to get the database installed, created and running properly. Cheers for your assistance.

gilead · 01-18-2006, 01:02 PM

No problem - glad it worked

shivam6565 · 04-25-2009, 09:54 AM

I am getting the same error "TNS lost contact" while installing oracle 10gR2 on Ubuntu 8.10, and the database creation fails. Could you tell me exactly how to solve this problem? Thank you in advance.