Home » Infrastructure » Linux » (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04
(ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600220] Sun, 03 November 2013 09:28 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Hi

I have installed Oracle 11gR2 on Ubuntu 12.04 on amazon VM using following doc.
http://www.gizmojunkee.com/2012/05/installing-oracle-11gr2-on-ubuntu-12-04/

all components installed successfully but 'Database Configuration Assistant' failed so database also didn't installed successfully.
I have created new database using dbca. database created successfully but keep giving the warning 'ORA: 12547: TNS: lost contact' many times within database installation.

After that i try to connect database but failed.

when i give complete string "sqlplus user/pwd@service"
it give following error
ORA-12541: TNS:no listener

when i connect as "sqlplus /nolog"
it connect to sql prompt
then on sql prompt i do "SQL> conn /as sysdba"
it give following error
ORA-12547: TNS:lost contact

Moreover my service is working but listener is not responding at all.
if i pass any of following command the os didn't return any error or warning or anything and os prompt jump to next line.
lsnrctl
lsnrctl status listener_name
lsnrctl start listener_name
lsnrctl stop listener_name

what i have already done by reading the different forums is as under, but it didn't worked.

cd $ORACLE_HOME/bin
chmod 6751 oracle
above didn't worked for me.

$ORACLE_HOME/root.sh from root
above didn't worked for me.

cd $ORACLE_HOME/bin relink
above didn't worked for me.

can some one help me out of (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)?

I wonder the installation doc i use may missed any package need install on os.

Thanks
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600221 is a reply to message #600220] Sun, 03 November 2013 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
UBUNTU is NOT a supported OS & therefore you have NO guarantee that Oracle will ever work on this system

>Moreover my service is working
please post COPY & PASTE proof that above is true.

what clues exist near the tail end of the alert_SID.log file for this instance?

what is ORACLE_SID for this instance?
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600222 is a reply to message #600221] Sun, 03 November 2013 10:08 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member


>Moreover my service is working
please post COPY & PASTE proof that above is true.

racle@ip-10-4-35-6:~$ tnsping orcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 03-NOV-2013 16:01:34

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

Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server_name_changed)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
TNS-12541: TNS:no listener

---------------------------------
what clues exist near the tail end of the alert_SID.log file for this instance?
locate command didn't show any file with name alert_SID.log or alert_ORCL.log, please tell me where can i find it.

-----------------------
what is ORACLE_SID for this instance?


echo $ORACLE_SID
ORCL
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600223 is a reply to message #600222] Sun, 03 November 2013 10:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
find / -name alert_ORCL.log -ls 2>/dev/null

what results from OS command below

ps -ef | grep -i pmon
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600224 is a reply to message #600223] Sun, 03 November 2013 10:35 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Thanks BlackSwan

find / -name alert_ORCL.log -ls 2>/dev/null
no result (may be oracle never get started to write any log)

ps -ef | grep -i pmon
oracle 7608 7382 0 16:34 pts/5 00:00:00 grep --color=auto -i pmon

Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600226 is a reply to message #600224] Sun, 03 November 2013 11:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Contrary to any previous claims, it does not appear that you have any actual database; least with the SID of ORCL

find / -name alert_\*.log -ls 2>/dev/null
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600227 is a reply to message #600226] Sun, 03 November 2013 11:54 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Thanks Again BlackSwan

I do have a database ORCL, i have created it with dbca and after your last post I have reconfirm it with dbca, dbca shows this database in delete database options. (thats the only way i can confirm its existence at the moment)

Thanks
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600228 is a reply to message #600227] Sun, 03 November 2013 11:57 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results of the following OS commands

find / -name alert_\*.log -ls 2>/dev/null
ls -ltr $ORACLE_HOME/dbs
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600229 is a reply to message #600228] Sun, 03 November 2013 12:18 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

BlackSwan

find / -name alert_\*.log -ls 2>/dev/null
no result

ls -ltr $ORACLE_HOME/dbs
total 8
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r----- 1 oracle oinstall 1536 Nov 2 15:04 orapwORCL

Moreover when I created the database using dbca it keep popping up the alter 'ORA-12547: TNS:lost contact' but show successful creation in end.
few moments ago I try to reconfigure the database with dbca (as its only way i have to view it) when I give user/pwd on dbca interface to reconfigure database it showed 'Retreveing Information' popup but again 'ORA-12547: TNS:lost contact' alert arrive and 'Retreveing Information' popup disappear.
so dbca also only show this db but cant connect it.

[Updated on: Sun, 03 November 2013 12:20]

Report message to a moderator

Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600230 is a reply to message #600229] Sun, 03 November 2013 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
any database is only a figment of your imagination.
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600233 is a reply to message #600230] Sun, 03 November 2013 22:31 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

BlackSwan

Ok if there is no database, then please tell me how can I create a database in my situation? as 'ORA-12547: TNS:lost contact' not let dbca create a database.
How can I overcome 'ORA-12547: TNS:lost contact' so that I can create new database using dbca.
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600238 is a reply to message #600233] Mon, 04 November 2013 00:04 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You're back to the first reply you got - maybe you won't make it work, ever, on Ubuntu.
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600248 is a reply to message #600238] Mon, 04 November 2013 03:24 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Ok i have no database created I have seen the log of database creation by dbca and its full of error 'ORA-12547: TNS:lost contact'
So here is my status.
Oracle installed but database creation failed.
Tried to create database with dbca but failed with 'ORA-12547: TNS:lost contact'
Can someone help me out of 'ORA-12547: TNS:lost contact'?

Thanks
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600249 is a reply to message #600248] Mon, 04 November 2013 04:47 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, DBCA seems to not work correctly.

You could try creating a database manually.
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600253 is a reply to message #600249] Mon, 04 November 2013 07:20 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Let's make it even simpler. Use vi to create a file:
vi $HOME/initorcl.ora

insert just one line into this file,
db_name=orcl

Then launch SQL*Plus, like this:
sqlplus / as sysdba

and issue this command:
startup nomount

I tihnk you will get your error at that point. If you don't, create your database:
create database;



Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600397 is a reply to message #600220] Wed, 06 November 2013 01:09 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

thanks every one who tried to help me out.
I got it done finally , there was no possible solution I have for my error 'ORA-12547: TNS:lost contact' in my case.
So I dorp the os user 'oracle' and start a fresh/clean installation.

What different I did this time is that, I followed a different documentation this time.
I followed this doc as primary
http://sumitkumarojha.blogspot.com/2013/01/install-oracle-11g-r2-on-ubuntu-1204-64.html

and this doc as secondary
http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bits

and the old doc that I used as only doc at previous installation as last doc
http://www.gizmojunkee.com/2012/05/installing-oracle-11gr2-on-ubuntu-12-04/

with combination of above 3, I got a clean installation (but 'database creation' failed at installation time)
but as there was no 'ORA-12547: TNS:lost contact' this time so i have created new database with dbca and its up and working now.

One more thing i change is that inventory directory was pointing to path '/mnt/u01/.....' and i can't change it so finally i find that inventory path is hardcode in file '/etc/oraInst.loc'
i modified the path in above path to more appropriate path.

thanks John Watson
thanks ThomasG
thanks Littlefoot
special thanks BlackSwan

[Updated on: Wed, 06 November 2013 01:12]

Report message to a moderator

Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600402 is a reply to message #600397] Wed, 06 November 2013 01:36 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK then, it is, after all, possible to install Oracle on Ubuntu. Thank you for sharing documents you found useful when solving the problem! I hope you'll be able to use Oracle as well (because, that's the whole point, I suppose).
Re: (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04 [message #600422 is a reply to message #600402] Wed, 06 November 2013 06:15 Go to previous message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member

Yes Littlefoot
Its working fine on Ubuntu.
Previous Topic: Problem with user oracle .bash_profile
Next Topic: Oracle Database 12c install on existing 11g system
Goto Forum:
  


Current Time: Thu Mar 28 09:51:56 CDT 2024