TNS:lost contact during /tmp/create in step2

[dherben]

I'm trying to build the image, but I get the following error when running the /tmp/create script during step2:

Tue Nov 17 08:19:56 UTC 2015
Creating database...

SQL*Plus: Release 12.1.0.2.0 Production on Tue Nov 17 08:19:56 2015

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

ERROR:
ORA-12547: TNS:lost contact


SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected
SP2-0640: Not connected

Tue Nov 17 08:19:56 UTC 2015
Creating password file...

Tue Nov 17 08:19:56 UTC 2015
Running catalog.sql...

Running sqlplus manually with various invocations also gives the same problem. To me, it looks like nothing is listening, although I've followed the steps as described. ps aux also does not show any useful running process.

Could you please point me in the right direction?

[weatheredwatcher]

I get the same. Any progress?

[blagerweij]

I had the same issue, which I was able to resolve by changing the kernel shared memory settings (in sysctl.conf):

kernel.shmall = 18446744073692774399
kernel.shmmax = 18446744073692774399

(Values depending on the amount of memory you have in the machine)

[akloeber]

Same here, +1

[cosminj]

I still get the same TNS:lost contact error even if i change the kernel memory settings.
After changing them and reloading them with sysctl --system, do you do anything else?
How do you restart the TNS Listener oracle service on this container ?

[nollymar]

@cosminj I solved the problem executing a relink all.

My problem was that these files were empty:
$ORACLE_HOME/bin/oracle
$ORACLE_HOME/rdbms/lib/config.o

Take a look at this page: https://oracledbamasters.wordpress.com/2014/02/25/ora-12547-tns-lost-contact/

[linkcrux]

@blagerweij / @nollymar ,

Can you please list me the instructions how you could resolve it ?

1. I tried kernel settings inside the docker instance step2, before step2 Step 2.3 fails - ORA-12547: TNS:lost contact #3 :

/tmp/create

No luck, I still get 'lost contact'

1. I tried 'relink all' (as my $ORACLE_HOME/bin/oracle is zero bytes), but it fails with error :

./relink: line 168: 66 Segmentation fault (core dumped) $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/install/modmakedeps.pl $ORACLE_HOME $ORACLE_HOME/inventory/make/makeorder.xml > $CURR_MAKEORDER
writing relink log to: /u01/app/oracle/product/12.1.0/dbhome_1/install/relink.log

With below error in the log :

oracle.xml.parser.v2.XMLParseException: Start of root element expected.
at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:323)

Anything you can suggest ?

[nollymar]

@linkcrux I just shutdown the database and listener and then executed “relink all”.

I have an extension of the docker image created by @wscherphof where I fix this problem. It could be useful if you want to use CDB/PDB feature as well. Have a look at https://github.com/nollymar/oracle-12c-cdb

[marvin-w]

@linkcrux

I have the same issue and it seems that its related to installing oracle on a Mac.

See here: https://forums.docker.com/t/perl-segmentation-fault-oracle-12c-install-docker-mac-mac-pro/18256

[nollymar]

@linkcrux, did you solve the problem?

@pointerxr, for the installation I used a Mac and could solve the problem as recommended above.

[yin]

Guy's, I had this problem last year. I solved it by downgrading my VM to Ubuntu 14.04 and then building the image in it. This was tried twice, hope this helps.

[linkcrux]

@nollymar your repo is the one I had real success creating oracle 12c docker container. Thank you for the PDB, am trying out different options that fit my project. Will message you in case I run into issues.