Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-01919: role 'JAVA_ADMIN' does not exist

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We are using Oracle Data Pump to migrate Oracle data from the v18 server to the v20 server.

    I tried 'grant JAVA_ADMIN to aleph_admin WITH ADMIN OPTION' but got the error
    ORA-01919: role 'JAVA_ADMIN' does not exist

    How can I proceed with the Oracle Data Pump?

    Resolution:
    This error means that JAVA_ADMIN role doesn’t exist in your database. In this case run Oracle Data Pump export and gzip the output file even if you are not going to transfer it anywhere:

    csh -f util/zip_after_expdp.csh

    Then run the import (no need to unzip the file). This would eliminate the need for the JAVA_ADMIN role.

    Additional information
    The zip_after_expdp.csh proc requires the oracle password. If you don't know that, you can execute the commands in the script zip_after_expdp.csh manually one by one:

    $ su - root
    # su - oracle

    [as UNIX user oracle]
    $ cd /exlibris/aleph/upgrade_express_2001_2101
    $ chmod 777 data/a18_1/abc00/files/dpdir/*
    $ chmod 777 data/a18_1/abc01/files/dpdir/*
    $ chmod 777 data/a18_1/abc10/files/dpdir/*
    $ chmod 777 data/a18_1/abc30/files/dpdir/*
    $ chmod 777 data/a18_1/abc50/files/dpdir/*
    $ chmod 777 data/a18_1/abc60/files/dpdir/*

    $ exit
    # exit

    [as UNIX user aleph]
    $ cd /exlibris/aleph/upgrade_express_2001_2101/data
    $ tar zcf a18_1.tar.gz ./a18_1

    Additional Information

    Oracle data pump ORA-01919 JAVA_ADMIN does not exist


    • Article last edited: 4/16/2014