I'm installing CDH 6.2 on rhel7 and using Oracle19C as metastore and backend db for all components wherever required. All services start normally, however when trying to login to hue, the page throws error.

CDH Parcel Version: CDH-6.2.0-1.cdh6.2.0.p0.967373

Oracle DB: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Oracle Client: 19.3.0.0.0

Tried with three cx_Oracle versions: cx_Oracle-5.2.1-py2.7 / cx_Oracle-5.3-py2.7 / cx_Oracle-7.2.0-py2.7

Environment:


Request Method: GET
Request URL: http://<URL>:8888/hue/accounts/login?next=/

Django Version: 1.11
Python Version: 2.7.5
Installed Applications:
['django.contrib.auth',
 'django_openid_auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.staticfiles',
 'django.contrib.admin',
 'django_extensions',
 'babeldjango',
 'desktop',
 'axes',
 'about',
 'beeswax',
 'filebrowser',
 'help',
 'impala',
 'jobbrowser',
 'jobsub',
 'metastore',
 'oozie',
 'pig',
 'proxy',
 'rdbms',
 'security',
 'useradmin',
 'indexer',
 'metadata',
 'notebook',
 'dashboard',
 'kafka']
Installed Middleware:
['desktop.middleware.MetricsMiddleware',
 'desktop.middleware.EnsureSafeMethodMiddleware',
 'desktop.middleware.AuditLoggingMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'desktop.middleware.SpnegoMiddleware',
 'desktop.middleware.HueRemoteUserMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'babeldjango.middleware.LocaleMiddleware',
 'desktop.middleware.AjaxMiddleware',
 'django.middleware.security.SecurityMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'desktop.middleware.ContentSecurityPolicyMiddleware',
 'desktop.middleware.LoginAndPermissionMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'desktop.middleware.NotificationMiddleware',
 'desktop.middleware.ExceptionMiddleware',
 'desktop.middleware.ClusterMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.middleware.http.ConditionalGetMiddleware',
 'desktop.middleware.MimeTypeJSFileFixStreamingMiddleware',
 'desktop.middleware.EnsureSafeRedirectURLMiddleware',
 'useradmin.middleware.LastActivityMiddleware']



Traceback:

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/handlers/exception.py" in inner
  41.             response = get_response(request)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/handlers/base.py" in _legacy_get_response
  249.             response = self._get_response(request)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/handlers/base.py" in _get_response
  187.                 response = self.process_exception_by_middleware(e, request)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/core/handlers/base.py" in _get_response
  185.                 response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/utils/decorators.py" in inner
  185.                     return func(*args, **kwargs)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py" in decorated_login
  267.         if is_already_locked(request):

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py" in is_already_locked
  357.     if not is_user_lockable(request):

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/django_axes-2.2.0-py2.7.egg/axes/decorators.py" in is_user_lockable
  172.         user = get_user_model().objects.get(**kwargs)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/models/manager.py" in manager_method
  85.                 return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/models/query.py" in get
  373.         num = len(clone)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/models/query.py" in __len__
  232.         self._fetch_all()

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/models/query.py" in _fetch_all
  1102.             self._result_cache = list(self._iterable_class(self))

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/models/query.py" in __iter__
  53.         results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/models/sql/compiler.py" in execute_sql
  876.             cursor.execute(sql, params)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/utils.py" in execute
  65.                 return self.cursor.execute(sql, params)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/utils.py" in __exit__
  94.                 six.reraise(dj_exc_type, dj_exc_value, traceback)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/utils.py" in execute
  65.                 return self.cursor.execute(sql, params)

File "/opt/cloudera/parcels/CDH-6.2.0-1.cdh6.2.0.p0.967373/lib/hue/build/env/lib/python2.7/site-packages/Django-1.11-py2.7.egg/django/db/backends/oracle/base.py" in execute
  481.         return self.cursor.execute(query, self._param_generator(params))

Exception Type: DatabaseError at /hue/accounts/login
Exception Value: ORA-00942: table or view does not exist

 Appreciate if anyone has faced similar issues and can assist.

Thanks.