{"id":506,"date":"2018-08-21T01:24:43","date_gmt":"2018-08-21T01:24:43","guid":{"rendered":"http:\/\/www.asianux.org.vn\/?p=506"},"modified":"2018-08-21T01:24:43","modified_gmt":"2018-08-21T01:24:43","slug":"oracle-installation-errors-and-fixes","status":"publish","type":"post","link":"https:\/\/www.asianux.org.vn\/index.php\/2018\/08\/21\/oracle-installation-errors-and-fixes\/","title":{"rendered":"Oracle installation errors and fixes"},"content":{"rendered":"

This article will list all errors\/issues I encounter during Oracle installation with their fix.
\nIt will be updated with all new errors I will encounter.<\/p>\n

\n

In this article …
\n… “Fix prior install”<\/strong>\u00a0needs jar binary. Install it with the following command:<\/p>\n

$ yum -y install java-devel<\/pre>\n<\/div>\n
memcpy error in ins_ctx.mk<\/h2>\n
\n\n\n\n<\/colgroup>\n\n\n\n
Operating System:<\/strong><\/th>\nOracle Enterprise Linux 7<\/td>\n<\/tr>\n
Oracle version:<\/strong><\/th>\n11.2.0.1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Error output<\/h3>\n
\n
\n
\n
\n
INFO: gcc -o ctxhx -m64 -L\/u01\/app\/oracle\/product\/11.2.0\/db_1\/ctx\/lib\/ -L\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/ -L\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/stubs\/\u00a0 \/u01\/app\/oracle\/product\/11.2.0\/db_1\/ctx\/lib\/ctxhx.o -L\/u01\/app\/oracle\/product\/11.2.0\/db_1\/ctx\/lib\/ -lm -lsc_fa -lsc_ex -lsc_da -lsc_ca -lz\u00a0 -lctxhx -Wl,-rpath,\/u01\/app\/oracle\/product\/11.2.0\/db_1\/ctx\/lib -lsnls11 -lnls11\u00a0 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11\u00a0 `cat \/u01\/app\/oracle<\/code><\/span><\/span><\/div>\n
INFO: \/product\/11.2.0\/db_1\/lib\/sysliblist`<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: \/lib64\/libstdc++.so.5: undefined reference to `memcpy@GLIBC_2.14'<\/code><\/span><\/span><\/div>\n
collect2: error: ld returned 1 exit status<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: make: *** [ctxhx] Error 1<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: End output from spawned process.<\/code><\/span><\/span><\/div>\n
INFO: ----------------------------------<\/code><\/span><\/span><\/div>\n
INFO: Exception thrown from action: make<\/code><\/span><\/span><\/div>\n
Exception Name: MakefileException<\/code><\/span><\/span><\/div>\n
Exception String: Error in invoking target 'install' of makefile '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/ctx\/lib\/ins_ctx.mk'. See '\/u01\/app\/oraInventory\/logs\/installActions2015-04-17_10-00-15PM.log' for details.<\/code><\/span><\/span><\/div>\n
Exception Severity: 1<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
Solution<\/h3>\n
Fix prior install<\/h4>\n
Execute the following script:<\/p>\n
\n
\n
\n
\n
# Fix ctx\/lib\/ins_ctx.mk<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
ORACLE_SRC_INSTALL_DIR=<\/code>\/media\/sf_uxora_share\/database<\/code><\/span><\/span><\/div>\n
cd<\/code>\u00a0${ORACLE_SRC_INSTALL_DIR}<\/code>\/stage\/Components<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
jar_file=<\/code><\/span><\/span><\/div>\n
for<\/code>\u00a0i_file\u00a0<\/code>in<\/code>\u00a0$(\u00a0<\/code>ls<\/code>\u00a0.<\/code>\/oracle<\/code>.ctx<\/code>\/11<\/code>.2.0.1.0<\/code>\/1\/DataFiles\/filegroup<\/code>*.jar );\u00a0<\/code>do<\/code><\/span><\/span><\/div>\n
unzip -l ${i_file} ctx<\/code>\/lib\/ins_ctx<\/code>.mk 2>&1 1><\/code>\/dev\/null<\/code><\/span><\/span><\/div>\n
[[ $? -<\/code>eq<\/code>\u00a00 ]] && jar_file=${i_file} &&\u00a0<\/code>break<\/code><\/span><\/span><\/div>\n
done<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
cat<\/code>\u00a0<< __EOF__ >\u00a0<\/code>\/tmp\/memcpy_wrap<\/code>.c<\/code><\/span><\/span><\/div>\n
#include <stddef.h><\/code><\/span><\/span><\/div>\n
#include <string.h><\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
asm (<\/code>\".symver wrap_memcpy, memcpy@GLIBC_2.14\"<\/code>);<\/code><\/span><\/span><\/div>\n
void *wrap_memcpy(void *dest, const void *src, size_t n) {<\/code><\/span><\/span><\/div>\n
return<\/code>\u00a0memcpy(dest, src, n);<\/code><\/span><\/span><\/div>\n
}<\/code><\/span><\/span><\/div>\n
__EOF__<\/code><\/span><\/span><\/div>\n
unzip ${jar_file} ctx<\/code>\/lib\/ins_ctx<\/code>.mk 2>&1 1><\/code>\/dev\/null<\/code><\/span><\/span><\/div>\n
if<\/code>\u00a0[[ $? -<\/code>eq<\/code>\u00a00 ]];\u00a0<\/code>then<\/code><\/span><\/span><\/div>\n
sed<\/code>\u00a0-i -e 's\/\\$(INSO_LINK)\/\\$(INSO_LINK) -Wl,--wrap=memcpy_wrap \\$(ORACLE_HOME)\\<\/code>\/ctx<\/code>\\<\/code>\/lib<\/code>\\<\/code>\/memcpy_wrap<\/code>.o<\/code>\/g<\/code>' ctx<\/code>\/lib\/ins_ctx<\/code>.mk<\/code><\/span><\/span><\/div>\n
gcc -c\u00a0<\/code>\/tmp\/memcpy_wrap<\/code>.c -o ctx<\/code>\/lib\/memcpy_wrap<\/code>.o &&\u00a0<\/code>rm<\/code>\u00a0\/tmp\/memcpy_wrap<\/code>.c<\/code><\/span><\/span><\/div>\n
jar -uvf\u00a0 ${jar_file} ctx<\/code>\/lib\/ins_ctx<\/code>.mk ctx<\/code>\/lib\/memcpy_wrap<\/code>.o<\/code><\/span><\/span><\/div>\n
fi<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
Fix during install<\/h4>\n
This fix can only be done in GUI mode installer.
\nWhen the windows prompt this error message:<\/p>\n
Error in invoking target 'install' of makefile '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/ctx\/lib\/ins_ctx.mk'. See '\/u01\/app\/oraInventory\/logs\/installActions2015-04-17_10-00-15PM.log' for details.<\/pre>\n
Execute the following script then click\u00a0retry<\/code>\u00a0to resume install<\/p>\n
\n
\n
\n
\n
# Fix ctx\/lib\/ins_ctx.mk<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
ORACLE_HOME=<\/code>\/u01\/app\/oracle\/product\/11<\/code>.2.0<\/code>\/db_1<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
cat<\/code>\u00a0<< __EOF__ >\u00a0<\/code>\/tmp\/memcpy_wrap<\/code>.c<\/code><\/span><\/span><\/div>\n
#include <stddef.h><\/code><\/span><\/span><\/div>\n
#include <string.h><\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
asm (<\/code>\".symver wrap_memcpy, memcpy@GLIBC_2.14\"<\/code>);<\/code><\/span><\/span><\/div>\n
void *wrap_memcpy(void *dest, const void *src, size_t n) {<\/code><\/span><\/span><\/div>\n
return<\/code>\u00a0memcpy(dest, src, n);<\/code><\/span><\/span><\/div>\n
}<\/code><\/span><\/span><\/div>\n
__EOF__<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
if<\/code>\u00a0[[ -e\u00a0<\/code>\"${ORACLE_HOME}\/ctx\/lib\/ins_ctx.mk\"<\/code>\u00a0]];\u00a0<\/code>then<\/code><\/span><\/span><\/div>\n
sed<\/code>\u00a0-i -e 's\/\\$(INSO_LINK)\/\\$(INSO_LINK) -Wl,--wrap=memcpy_wrap \\$(ORACLE_HOME)\\<\/code>\/ctx<\/code>\\<\/code>\/lib<\/code>\\<\/code>\/memcpy_wrap<\/code>.o<\/code>\/g<\/code>' ${ORACLE_HOME}<\/code>\/ctx\/lib\/ins_ctx<\/code>.mk<\/code><\/span><\/span><\/div>\n
gcc -c\u00a0<\/code>\/tmp\/memcpy_wrap<\/code>.c -o ${ORACLE_HOME}<\/code>\/ctx\/lib\/memcpy_wrap<\/code>.o &&\u00a0<\/code>rm<\/code>\u00a0\/tmp\/memcpy_wrap<\/code>.c<\/code><\/span><\/span><\/div>\n
fi<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
ins_emagent.mk error<\/h2>\n
\n\n\n\n<\/colgroup>\n\n\n\n
Operating System:<\/strong><\/th>\nOracle Enterprise Linux 7<\/td>\n<\/tr>\n
Oracle version:<\/strong><\/th>\n11.2.0.1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Error output<\/h3>\n
\n
\n
\n
\n
INFO: ib\/amd64 -z lazyload -ljava -ljvm -lverify -z nolazyload -Wl,-rpath,\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib\/:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/jdk\/jre\/lib\/amd64\/server:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/jdk\/jre\/lib\/amd64 -Wl,--allow-shlib-undefined\u00a0\u00a0\u00a0 `cat \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/sysliblist` -ldl -lm<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib\/ins_emagent.mk:127: warning: overriding recipe for target `nmosudo'<\/code><\/span><\/span><\/div>\n
\/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib\/ins_emagent.mk:56: warning: ignoring old recipe for target `nmosudo'<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: \/usr\/bin\/ld: warning: -z lazyload ignored.<\/code><\/span><\/span><\/div>\n
\/usr\/bin\/ld: warning: -z nolazyload ignored.<\/code><\/span><\/span><\/div>\n
\/usr\/bin\/ld: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib\/\/libnmectl.a(nmectlt.o): undefined reference to symbol 'B_DestroyKeyObject'<\/code><\/span><\/span><\/div>\n
\/usr\/bin\/ld: note: 'B_DestroyKeyObject' is defined in DSO \/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libnnz11.so so try adding it to the linker command line<\/code><\/span><\/span><\/div>\n
\/u01\/app\/oracle\/product\/11.2.0\/db_1\/lib\/libnnz11.so: could not read symbols: Invalid operation<\/code><\/span><\/span><\/div>\n
collect2: error: ld returned 1 exit sta<\/code><\/span><\/span><\/div>\n
INFO: tus<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: make[1]: Leaving directory `\/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib'<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: make[1]: *** [\/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib\/emdctl] Error 1<\/code><\/span><\/span><\/div>\n
make: *** [emdctl] Error 2<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
INFO: End output from spawned process.<\/code><\/span><\/span><\/div>\n
INFO: ----------------------------------<\/code><\/span><\/span><\/div>\n
INFO: Exception thrown from action: make<\/code><\/span><\/span><\/div>\n
Exception Name: MakefileException<\/code><\/span><\/span><\/div>\n
Exception String: Error in invoking target 'agent nmhs' of makefile '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib\/ins_emagent.mk'. See '\/u01\/app\/oraInventory\/logs\/installActions2015-04-23_01-23-30PM.log' for details.<\/code><\/span><\/span><\/div>\n
Exception Severity: 1<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
Solution<\/h3>\n
Fix prior install<\/h4>\n
Execute the following script:<\/p>\n
\n
\n
\n
\n
# Fix sysman\/lib\/ins_emagent.mk<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
ORACLE_SRC_INSTALL_DIR=<\/code>\/media\/sf_uxora_share\/database<\/code><\/span><\/span><\/div>\n
cd<\/code>\u00a0${ORACLE_SRC_INSTALL_DIR}<\/code>\/stage\/Components<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
jar_file=<\/code><\/span><\/span><\/div>\n
for<\/code>\u00a0i_file\u00a0<\/code>in<\/code>\u00a0$(\u00a0<\/code>ls<\/code>\u00a0.<\/code>\/oracle<\/code>.sysman.agent\/*<\/code>\/1\/DataFiles\/filegroup<\/code>*.jar );\u00a0<\/code>do<\/code><\/span><\/span><\/div>\n
unzip -l ${i_file} sysman<\/code>\/lib\/ins_emagent<\/code>.mk 2>&1 1><\/code>\/dev\/null<\/code><\/span><\/span><\/div>\n
[[ $? -<\/code>eq<\/code>\u00a00 ]] && jar_file=${i_file} &&\u00a0<\/code>break<\/code><\/span><\/span><\/div>\n
done<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
unzip ${jar_file} sysman<\/code>\/lib\/ins_emagent<\/code>.mk 2>&1 1><\/code>\/dev\/null<\/code><\/span><\/span><\/div>\n
if<\/code>\u00a0[[ $? -<\/code>eq<\/code>\u00a00 ]];\u00a0<\/code>then<\/code><\/span><\/span><\/div>\n
sed<\/code>\u00a0-i -e 's\/\\$(MK_EMAGENT_NMECTL)\/\\$(MK_EMAGENT_NMECTL) -lnnz11<\/code>\/g<\/code>' sysman<\/code>\/lib\/ins_emagent<\/code>.mk<\/code><\/span><\/span><\/div>\n
jar -uvf\u00a0 ${jar_file} sysman<\/code>\/lib\/ins_emagent<\/code>.mk<\/code><\/span><\/span><\/div>\n
fi<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
Fix during install<\/h4>\n
This fix can only be done in GUI mode installer. When the windows prompt this error message:<\/p>\n
Error in invoking target 'agent nmhs' of makefile '\/u01\/app\/oracle\/product\/11.2.0\/db_1\/sysman\/lib\/ins_emagent.mk'. See '\/u01\/app\/oraInventory\/logs\/installActions2015-04-23_01-23-30PM.log' for details.<\/pre>\n
Execute the following script then click\u00a0retry<\/code>\u00a0to resume install<\/p>\n
\n
\n
\n
\n
# Fix ctx\/lib\/ins_ctx.mk<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
ORACLE_HOME=<\/code>\/u01\/app\/oracle\/product\/11<\/code>.2.0<\/code>\/db_1<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
if<\/code>\u00a0[[ -e\u00a0<\/code>\"${ORACLE_HOME}\/sysman\/lib\/ins_emagent.mk\"<\/code>\u00a0]];\u00a0<\/code>then<\/code><\/span><\/span><\/div>\n
sed<\/code>\u00a0-i -e 's\/\\$(MK_EMAGENT_NMECTL)\/\\$(MK_EMAGENT_NMECTL) -lnnz11<\/code>\/g<\/code>' ${ORACLE_HOME}<\/code>\/sysman\/lib\/ins_emagent<\/code>.mk<\/code><\/span><\/span><\/div>\n
fi<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
ORA-00845<\/h2>\n
\n\n\n\n<\/colgroup>\n\n\n\n
Operating System:<\/strong><\/th>\nOracle Enterprise Linux 7<\/td>\n<\/tr>\n
Oracle version:<\/strong><\/th>\nAny<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Error output<\/h3>\n
\n
\n
\n
\n
ORA-00845: MEMORY_TARGET not supported on this system<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
Solution<\/h3>\n
Reduce memory target parameter<\/h4>\n
…<\/p>\n
Increase the size of \/dev\/shm<\/h4>\n
\n
\n
\n
\n
# check filesystems<\/code><\/span><\/span><\/div>\n
$<\/code>\u00a0df<\/code>\u00a0-h<\/code><\/span><\/span><\/div>\n
Filesystem\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Size\u00a0 Used Avail Use% Mounted on<\/code><\/span><\/span><\/div>\n
\/dev\/mapper\/ol-root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14G\u00a0 5.0G\u00a0 9.0G\u00a0 36% \/<\/code><\/span><\/span><\/div>\n
devtmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.8G\u00a0\u00a0\u00a0\u00a0 0\u00a0 3.8G\u00a0\u00a0 0% \/dev<\/code><\/span><\/span><\/div>\n
tmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.8G\u00a0 1.9G\u00a0 2.0G\u00a0 48% \/dev\/shm<\/code><\/span><\/span><\/div>\n
tmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.8G\u00a0 8.9M\u00a0 3.8G\u00a0\u00a0 1% \/run<\/code><\/span><\/span><\/div>\n
tmpfs\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3.8G\u00a0\u00a0\u00a0\u00a0 0\u00a0 3.8G\u00a0\u00a0 0% \/sys\/fs\/cgroup<\/code><\/span><\/span><\/div>\n
\/dev\/vdb1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32G\u00a0\u00a0 11G\u00a0\u00a0 22G\u00a0 33% \/u01<\/code><\/span><\/span><\/div>\n
\/dev\/vda1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 497M\u00a0 150M\u00a0 348M\u00a0 31% \/boot<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
# increase \/dev\/shm accordingly to your max ram memory<\/code><\/span><\/span><\/div>\n
$<\/code>\u00a0mount<\/code>\u00a0-o remount,size=6G\u00a0<\/code>\/dev\/shm<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
# make this change permanent, add\/change \/etc\/fstab<\/code><\/span><\/span><\/div>\n
$<\/code>\u00a0vi<\/code>\u00a0\/etc\/fstab<\/code><\/span><\/span><\/div>\n
...<\/code><\/span><\/span><\/div>\n
tmpfs\u00a0 \/dev\/shm\u00a0 tmpfs\u00a0 defaults,size=6G\u00a0 0 0<\/code><\/span><\/span><\/div>\n
...<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
# update mount<\/code><\/span><\/span><\/div>\n
$<\/code>\u00a0mount<\/code>\u00a0-a<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
ORA-19502\/ORA-27072<\/h2>\n
\n\n\n\n<\/colgroup>\n\n\n\n
Operating System:<\/strong><\/th>\nOracle Enterprise Linux 7<\/td>\n<\/tr>\n
Oracle version:<\/strong><\/th>\nAny<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Error output<\/h3>\n
\n
\n
\n
\n
...<\/code><\/span><\/span><\/div>\n
ORA-19502: write error on file \"...\",<\/code><\/span><\/span><\/div>\n
block number 251905 (block size=512)<\/code><\/span><\/span><\/div>\n
ORA-27072: File I\/O error<\/code><\/span><\/span><\/div>\n
Linux-x86_64 Error: 25: Inappropriate ioctl for device<\/code><\/span><\/span><\/div>\n
...<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
Solution<\/h3>\n
Free disk space\/Add disk space<\/h4>\n
There is not enough disk space. Check disk space with\u00a0df -h <path><\/code><\/p>\n
ORA-28040: No matching authentication protocol<\/h2>\n
\n\n\n\n<\/colgroup>\n\n\n\n
Operating System:<\/strong><\/th>\nAny<\/td>\n<\/tr>\n
Oracle version:<\/strong><\/th>\nfrom 12.1.0.1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Error output<\/h3>\n
\n
\n
\n
\n
ORA-28040: No matching authentication protocol<\/code><\/span><\/span><\/div>\n
ORA-01017: invalid username\/password; logon denied<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
You may encounter this error with a new 12c database because Oracle Enterprise Cloud Manager 12c is still using the old 10g JDBC driver (ojdbc14.jar) to connect.<\/p>\n
Prior to version 12c, the default setting for\u00a0SQLNET.ALLOWED_LOGON_VERSION<\/code>\u00a0(deprecated parameter in 12c) was 8. Now in 12c the default value of the 12c equivalent parameters\u00a0SQLNET.ALLOWED_LOGON_VERSION_CLIENT<\/code>\u00a0and\u00a0SQLNET.ALLOWED_LOGON_VERSION_SERVER<\/code>\u00a0are now 11.<\/p>\n
Solution\/Workaround<\/h3>\n
\n
\n
\n
\n
# Set minimum logon authentification version in sqlnet.ora<\/code><\/span><\/span><\/div>\n
# To avoid ORA-28040: No matching authentication protocol<\/code><\/span><\/span><\/div>\n
[oracle]$<\/code>\u00a0cat<\/code>\u00a0>> $ORACLE_HOME<\/code>\/network\/admin\/sqlnet<\/code>.ora <<_EOF_<\/code><\/span><\/span><\/div>\n
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8<\/code><\/span><\/span><\/div>\n
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8<\/code><\/span><\/span><\/div>\n
_EOF_<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
# Recreate oracle user password to be compatible 10G<\/code><\/span><\/span><\/div>\n
# To avoid ORA-01017: invalid username\/password; logon denied<\/code><\/span><\/span><\/div>\n
[oracle]$<\/code>\u00a0sqlplus \/ as sysdba<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
-- Check password compatibility<\/code><\/span><\/span><\/div>\n
SQL><\/code>\u00a0select<\/code>\u00a0USERNAME,PASSWORD_VERSIONS from dba_users where USERNAME = 'SYS';<\/code><\/span><\/span><\/div>\n
USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PASSWORD_VERSIONS<\/code><\/span><\/span><\/div>\n
-------------------------------- -----------------<\/code><\/span><\/span><\/div>\n
SYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11G 12C<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
-- Reinitialize password<\/code><\/span><\/span><\/div>\n
SQL><\/code>\u00a0alter user SYS identified by OraSys_pw0 ;<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
User SYS altered.<\/code><\/span><\/span><\/div>\n
\u00a0<\/span><\/span><\/div>\n
-- Check again password compatibility<\/code><\/span><\/span><\/div>\n
SQL><\/code>\u00a0select<\/code>\u00a0USERNAME,PASSWORD_VERSIONS from dba_users where USERNAME = 'SYS';<\/code><\/span><\/span><\/div>\n
USERNAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PASSWORD_VERSIONS<\/code><\/span><\/span><\/div>\n
-------------------------------- -----------------<\/code><\/span><\/span><\/div>\n
SYS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10G 11G 12C<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
Now database instance will accept 10g authentification only with users who have 10G PASSWORD_VERSIONS compatibility.<\/p>\n
 <\/p>\n
Hope that helps,<\/p>\n","protected":false},"excerpt":{"rendered":"
This article will list all errors\/issues I encounter during Oracle installation with their fix. It will be updated with all new errors I will encounter. In this article … … “Fix prior install”\u00a0needs jar binary.…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-506","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/506","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/comments?post=506"}],"version-history":[{"count":1,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/506\/revisions"}],"predecessor-version":[{"id":507,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/posts\/506\/revisions\/507"}],"wp:attachment":[{"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/media?parent=506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/categories?post=506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.asianux.org.vn\/index.php\/wp-json\/wp\/v2\/tags?post=506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}