Thursday, 15 January 2009

Oracle: DBCA template reverse engineering problem solved

Silent create template
dbca -createTemplateFromDB -sourceDB lontestdb02:1521:NEWDEV4 -templateName ZPFL1 -sysDBAUserName sys -sysDBAPassword password -maintainFileLocations false -silent

When using the DBCA to create a RAC database when selecting next on the node selection screen are
receiving the following error: access denied (java.sql.SQLPermission setLog)
at java.lang.SecurityManager.checkPermission(
at java.sql.DriverManager.setLogStream(


The problem is that the user (oracle user) which use the DBCA does not have the permission to use the java packages for the RAC environment across the nodes. To create a file which set the permissions it will be checked and used to perform the action needed to be able to create the instances across the nodes


Create the file:

.java.policy on each node in the Oracle Users Home directory.

containing the following code.

grant {

When done, changed the permission to 770 for the .java.policy file for the files/nodes
Start the DBCA again.

Template created in $ORACLE_HOME/dbca


carlos said...

Excellent article!! I applied this solution not for a RAC, but for a single instance database... and it worked like a charm... Thanks!!!