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