Home » Infrastructure » Linux » TNS: lost contact !! (11.2.0.1, Ubuntu)
icon9.gif  TNS: lost contact !! [message #629235] Thu, 04 December 2014 21:07 Go to next message
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
Re: TNS: lost contact !! [message #629236 is a reply to message #629235] Thu, 04 December 2014 21:17 Go to previous messageGo to next message
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
Re: TNS: lost contact !! [message #629237 is a reply to message #629236] Thu, 04 December 2014 21:35 Go to previous messageGo to next message
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
Re: TNS: lost contact !! [message #629238 is a reply to message #629237] Thu, 04 December 2014 21:56 Go to previous messageGo to next message
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
Re: TNS: lost contact !! [message #629239 is a reply to message #629238] Thu, 04 December 2014 22:25 Go to previous messageGo to next message
Acronis2286
Messages: 16
Registered: December 2014
Junior Member
relink completes without any error, however still the oracle and config.0 files are 0 bytes in size!
Re: TNS: lost contact !! [message #629240 is a reply to message #629239] Thu, 04 December 2014 22:27 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from OS command below

ls -ltr $ORACLE_HOME/bin/ | tail -50
Previous Topic: Permission denied error occur during the installation of database
Next Topic: How to view my .profile file
Goto Forum:
  


Current Time: Thu Mar 28 18:02:37 CDT 2024