OraFAQ Forum: Linux » (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04

Home » Infrastructure » Linux » (ORA-12547: TNS:lost contact | ORA-12541: TNS:no listener)Installing Oracle 11gR2 on Ubuntu 12.04

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

(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

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

Report message to a moderator

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

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?

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

any database is only a figment of your imagination.

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

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

Report message to a moderator

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

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Well, DBCA seems to not work correctly.

You could try creating a database manually.

Report message to a moderator

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

John Watson
Messages: 8962
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;

Report message to a moderator

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

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

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

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

Yes Littlefoot
Its working fine on Ubuntu.

Report message to a moderator

Previous Topic:	Problem with user oracle .bash_profile
Next Topic:	Oracle Database 12c install on existing 11g system

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 11:01:48 CST 2025