Oracle xe for openshift-Online

3735435

Hello,

i hope, i am here in the right Place to descripe our Issue

we are facing a problem with installing Oracle xe in Openshift-Online.

Oracle DB need to run as root. This is not allowed in Openshift-Online and we can't give access in Openshift-Online to run as root.

ist there any Planing to build an official Oracle Database Image for Openshift or any Workaround, how can we use Oracle Database in Openshift Online?

best regards,

Saied

Information from the Container:

sh-4.2$ ps -ef

UID        PID  PPID  C STIME TTY          TIME CMD

1004790+     1     0  0 08:46 ?        00:00:00 /tini -- /bin/sh -c /u01/app/oracle/start-oracle.sh

1004790+     7     1  0 08:46 ?        00:00:00 /bin/bash /u01/app/oracle/start-oracle.sh

1004790+    28     7  0 08:46 ?        00:00:00 sleep 1m

1004790+    29     0  0 08:46 ?        00:00:00 /bin/sh

1004790+    35    29  0 08:46 ?        00:00:00 ps -ef

sh-4.2$ sqlplus

sh: sqlplus: command not found

sh-4.2$ cd /u01/app/oracle/product/11.2.0/xe/bin/

sh-4.2$ ls

adapters     ctxkbtc  ctxload  dbfs_client  dbhome  dg4odbc  dumpsga  expdp   extjobo  imp    kgmgr    lsnrctl   mapsga  nid          oracle          oracle_env.sh  oraenv  osdbagrp  ott   sqlldr   sysresv  tnslsnr  trcroute  wrap

createdb.sh  ctxlc    cursize  dbfsize      dbv     dgmgrl   exp      extjob  extproc  impdp  loadpsp  lxchknlb  maxmem  nls_lang.sh  oracle_env.csh  oradism        orapwd  osh       rman  sqlplus  tkprof   tnsping  unzip     zip

sh-4.2$ ./sqlplus

Error 6 initializing SQL*Plus

SP2-0667: Message file sp1<lang>.msb not found

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

sh-4.2$ whoami

whoami: cannot find name for user ID 1004790000

sh-4.2$ /etc/init.d/oracle-xe configure

You must be root user to run the configure script.  Login as root user and

then run the configure script.

sh-4.2$ # Set path if path not set (if called from /etc/rc)

sh-4.2$ case $PATH in

>     "") PATH=/bin:/usr/bin:/sbin:/etc

>         export PATH ;;

> esac

sh-4.2$

sh-4.2$ # Save LD_LIBRARY_PATH

sh-4.2$ SAVE_LLP=$LD_LIBRARY_PATH

sh-4.2$ RETVAL=0

sh-4.2$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe

sh-4.2$ export ORACLE_SID=XE

sh-4.2$ export ORACLE_BASE=/u01/app/oracle

sh-4.2$ export PATH=$ORACLE_HOME/bin:$PATH

sh-4.2$ LSNR=$ORACLE_HOME/bin/lsnrctl

sh-4.2$ SQLPLUS=$ORACLE_HOME/bin/sqlplus

sh-4.2$ ORACLE_OWNER=oracle

sh-4.2$ LOG="$ORACLE_HOME_LISTNER/listener.log"

sh-4.2$

sh-4.2$ if [ -z "$CHOWN" ]; then CHOWN=/bin/chown; fi

sh-4.2$ if [ -z "$CHMOD" ]; then CHMOD=/bin/chmod; fi

sh-4.2$ if [ -z "$HOSTNAME" ]; then HOSTNAME=/bin/hostname; fi

sh-4.2$ if [ -z "$NSLOOKUP" ]; then NSLOOKUP=/usr/bin/nslookup; fi

sh-4.2$ if [ -z "$GREP" ]; then GREP=/usr/bin/grep; fi

sh-4.2$ if [ ! -f "$GREP" ]; then GREP=/bin/grep; fi

sh-4.2$ if [ -z "$SED" ]; then SED=/bin/sed; fi

sh-4.2$ if [ -z "$AWK" ]; then AWK=/bin/awk; fi

sh-4.2$

sh-4.2$ export LC_ALL=C

sh-4.2$

sh-4.2$ CONFIG_NAME=oracle-xe

sh-4.2$ CONFIGURATION="/etc/sysconfig/$CONFIG_NAME"

sh-4.2$

sh-4.2$ # Set hostname  in listener.ora

sh-4.2$ sed -i -E "s/HOST = [^)]+/HOST = $HOSTNAME/g" $ORACLE_HOME/network/admin/listener.ora;

sh-4.2$

sh-4.2$ # Source configuration

sh-4.2$

sh-4.2$ [ -f "$CONFIGURATION" ] && . "$CONFIGURATION"

sh-4.2$ echo $ORACLE_HOME

/u01/app/oracle/product/11.2.0/xe

sh-4.2$ $LSNR start

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 27-JUN-2018 08:53:32

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.2.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora

Log messages written to /u01/app/oracle/diag/tnslsnr/oracle-partner-5-49z8d/listener/alert/log.xml

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))

TNS-12555: TNS:permission denied

TNS-12560: TNS:protocol adapter error

  TNS-00525: Insufficient privilege for operation

   Linux Error: 1: Operation not permitted

Listener failed to start. See the error message(s) above...

sh-4.2$ $SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql

ERROR:

ORA-01031: insufficient privileges

ORA-01031: insufficient privileges

Gerald Venzl-Oracle

Nope, you are not!

Please post XE related questions and issues in the Oracle Database XE forum.

Timo Hahn

User, this is the Database Idea space where you add ideas on how to enhance the database. It's not for asking questions.

Product related question should be asked in the product space, in cour case

As ideas can't be moved to the normal product spaces, I'm asking @Chitrasai1-Oracle to delete this post from the idea space.

Timo