Saturday 8 July 2017

Tinkering with Oracle 12c on Linux - will the fun ever stop ?

I'm going back through the process of learning how to install Oracle 12c on Red Hat Enterprise Linux 7.3.

One niggle that I saw post-install was this: -

sqlplus / as sysdba;

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jul 8 05:23:05 2017

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

ERROR:
ORA-12547: TNS:lost contact


During the installation, I'd seen reference to a missing dependency: -

/usr/bin/ld: cannot find -ljavavm12
collect2: error: ld returned 1 exit status
make: *** [/home/oracle/app/oracle/product/12.1.0/dbhome_1/rdbms/lib/oracle] Error 1


I dug about and found the missing artefact: -

/home/oracle/app/oracle/product/12.1.0/dbhome_1/javavm/jdk/jdk7/lib/libjavavm12.a

which I placed here: -

/home/oracle/app/oracle/product/12.1.0/dbhome_1/lib

via: -

ln -s /home/oracle/app/oracle/product/12.1.0/dbhome_1/javavm/jdk/jdk7/lib/libjavavm12.a /home/oracle/app/oracle/product/12.1.0/dbhome_1/lib

Having linked the binary, I then re-ran dbca to delete the original borked database ( there was, of course, no data therein ) and create a new working database :-)

No comments:

Visual Studio Code - Wow 🙀

Why did I not know that I can merely hit [cmd] [p]  to bring up a search box allowing me to search my project e.g. a repo cloned from GitHub...