LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices



Reply
 
Search this Thread
Old 01-17-2006, 08:13 AM   #1
Dtsazza
Member
 
Registered: Oct 2005
Location: Oxford, UK
Distribution: Debian Etch (w/ dual-boot XP for gaming)
Posts: 282

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


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
 
Old 01-18-2006, 02:40 AM   #2
gilead
Senior Member
 
Registered: Dec 2005
Location: Brisbane, Australia
Distribution: Slackware64 14.0
Posts: 4,123

Rep: Reputation: 162Reputation: 162
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...
 
Old 01-18-2006, 07:00 AM   #3
Dtsazza
Member
 
Registered: Oct 2005
Location: Oxford, UK
Distribution: Debian Etch (w/ dual-boot XP for gaming)
Posts: 282

Original Poster
Rep: Reputation: 30
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.
 
Old 01-18-2006, 02:02 PM   #4
gilead
Senior Member
 
Registered: Dec 2005
Location: Brisbane, Australia
Distribution: Slackware64 14.0
Posts: 4,123

Rep: Reputation: 162Reputation: 162
No problem - glad it worked
 
Old 04-25-2009, 10:54 AM   #5
shivam6565
LQ Newbie
 
Registered: Apr 2009
Posts: 2

Rep: Reputation: 0
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
oracle database 10g on slackware 10.1 yoz Linux - Software 3 03-15-2005 04:43 PM
Oracle 10g and Fedora 2.0 "Session lasted lesst than 10 seconds" ushradha Linux - Software 6 11-19-2004 11:04 PM
ORA-01034: ORACLE not available ORA-27101? suresheva31 Linux - General 0 10-18-2004 02:49 PM
TNS: lost contact jerrymei Linux - Software 0 05-26-2004 04:58 AM
Oracle 10g says "end of file" cyclic redundancy error mmjulian Linux - Software 2 05-22-2004 03:57 AM


All times are GMT -5. The time now is 06:01 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration