OraFAQ Forum: Linux » TNS: lost contact !!

Home » Infrastructure » Linux » TNS: lost contact !! (11.2.0.1, Ubuntu)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS: lost contact !! [message #629235]

Thu, 04 December 2014 21:07

Acronis2286
Messages: 16
Registered: December 2014

Junior Member

Hello,

I have installed Oracle 11.2.0.1 on Ubuntu 10. Installation is successful. NetCA configuration is completed. However, there is a very unusual problem I am facing. The below logs will tell you all about it.

Basically, when I type commands like 'tnsping' or 'netca' I am not able to see any output! Then, when I try and login as 'sqlplus / as sysdba' then I am getting the 'ORA-12457: TNS: lost contact' error!

oracle@INMHPUUBUNTU13:~$ 
oracle@INMHPUUBUNTU13:~$ cat .bash_profile 
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_UNQNAME=ORCL; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ORCL; export ORACLE_SID
TNS_ADMIN=$ORACLE_HOME/network/admin
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH:$TNS_ADMIN; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
#CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
oracle@INMHPUUBUNTU13:~$ 
oracle@INMHPUUBUNTU13:~$ tnsping
oracle@INMHPUUBUNTU13:~$ 
oracle@INMHPUUBUNTU13:~$ lsnrctl
oracle@INMHPUUBUNTU13:~$ 
oracle@INMHPUUBUNTU13:~$ uname -a
Linux INMHPUUBUNTU13.10LAP21 3.11.0-12-generic #19-Ubuntu SMP Wed Oct 9 16:20:46 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
oracle@INMHPUUBUNTU13:~$ 
oracle@INMHPUUBUNTU13:~$ 
oracle@INMHPUUBUNTU13:~$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 5 08:22:08 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-12547: TNS:lost contact


Enter user-name: ^C
oracle@INMHPUUBUNTU13:~$

Any help in this matter is highly appreciated.
Kindly let me know in case of more information than provided above.

Best,
Suddhasatwa

Report message to a moderator

Re: TNS: lost contact !! [message #629236 is a reply to message #629235]

Thu, 04 December 2014 21:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

UBUNTU is NOT a supported OS

which OS user owns Oracle software?

which OS user produced posted session commands & results

Is GOOGLE broken for you?

http://www.google.com/search?q=ORA-12547%3A+TNS%3Alost+contact

Report message to a moderator

Re: TNS: lost contact !! [message #629237 is a reply to message #629236]

Thu, 04 December 2014 21:35

Acronis2286
Messages: 16
Registered: December 2014

Junior Member

I understand Ubuntu is not supported, but had no other choice.
'oracle' user owns the software and it is used to run the commands, as seen from my previous logs.

Thanks for the link, i did try out many of its options, but none seems to be working yet.
I will keep trying and update all.

any further pointers to this will be highly appreciated.

best,
suddhasatwa

Report message to a moderator

Re: TNS: lost contact !! [message #629238 is a reply to message #629237]

Thu, 04 December 2014 21:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I have installed Oracle 11.2.0.1 on Ubuntu 10. Installation is successful.

I am not convinced that above is true.

what results from below?

$ORACLE_HOME/bin/relink

It should not hurt & just might help

Report message to a moderator