• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1522
  • Last Modified:

Error granting roles

I am executing the following command
while connected as internal

SQL>  grant javasyspriv to test;

But I am getting the following error

 grant javasyspriv to test
       *
ERROR at line 1:
ORA-01919: role 'JAVASYSPRIV' does not exist

Oracle says this role will be automatically created. But looks like that is not the case. How do I create this role (which Oracle supplied script).

Thanks in advance.

0
srikumar_p
Asked:
srikumar_p
  • 2
1 Solution
 
sbenyoCommented:
Hi,

Check for this settings:

shared_pool_size to be set to 50MB minimum
compatibility = 8.1.0      

Run this script connected as internal.

$ORACLE_HOME/ORANT/JAVAVM/INSTALL/initjvm.sql

This should create the role.

0
 
sbenyoCommented:
Also make sure you have:

JAVA_POOL_SIZE of 20MB
and additional 50MB of System Tablespace and enough rollback
segments (500MB).

This is because this script loads the initial set of Java classes in the SYS
schema, initializes the tables for supporting Java and for the CORBA namespace.

The package DBMS_JAVA is also created by this script.


0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now