Admin Password Reset Script Fails with Error 'java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver' (Doc ID 1531209.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.6.4 and later
Oracle Enterprise Governance, Risk, and Compliance Manager - Version 8.6.4 and later
Information in this document applies to any platform.

Symptoms

While running the script - GRC_reset_password.sh for resetting admin user password in GRC 8.6.4., the following error occurs.

Error:

Schema information validated.  Connecting to schema.  Please wait ...


Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
       at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
       at java.security.AccessController.doPrivileged(Native Method)
       at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
       at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
       at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
       at java.lang.Class.forName0(Native Method)
       at java.lang.Class.forName(Class.java:169)
       at oracle.apps.grc.utility.admin.PasswordManager.open(PasswordManager.java:201)
       at oracle.apps.grc.utility.admin.PasswordManager.doReset(PasswordManager.java:112)
       at oracle.apps.grc.utility.admin.PasswordManager.main(PasswordManager.java:245)

 

Steps to Reproduce:

1) Login to the GRC server as the user who owns the webapp
2) Download GRC_reset_password.sh to the GRC server and place it in the GRC lib directory (typically For Weblogic: <MW_HOME>/<GRC_DIR>/grc/WEB-INF/lib or For Tomcat :<TOMCAT_HOME>/webapps/grc/WEB-INF/lib)
3) Set the JAVA_HOME environment variable to the java version used by the webapp
    For example: export JAVA_HOME=/usr/local/jdk1.6.0_10
4) Set the PATH and CLASSPATH to include the JAVA_HOME
    For example:
        export PATH=$JAVA_HOME/bin:$PATH
        export CLASSPATH=$CLASSPATH:$JAVA_HOME/lib
4) Use the UNIX 'cd' command to change directory to the GRC lib directory
    (typically Weblogic: <MW_HOME>/<GRC_DIR>/grc/WEB-INF/lib or For Tomcat :<TOMCAT_HOME>/webapps/grc/WEB-INF/lib)
5) Run this command:
    dos2unix GRC-reset-password.sh  GRC-reset-password.sh
    chmod +x GRC-reset-password.sh
6) Run this script:
    ./GRC-reset-password.sh <APP_LIB_DIR>
    where APP_LIB_DIR is the application server library directory.
    For Weblogic:

   ./GRC-reset-password.sh <MW_HOME>/wlserver_10.3/server/lib

   For Tomcat:

   ./GRC-reset-password.sh <TOMCAT_HOME>/lib

7) This will run the password reset utility. You will be prompted for your GRC Schema info as well as the location of your grc.properties file. You will then be prompted to enter a new GRC admin password.
8) The Script fails with the above error.

 

Business Impact:

Due to this issue, users cannot reset admin password.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms