INFOSEC

I am trying to configure Enterprise User Security in Oracle database using Enterprise Security Manager.

While Configuring Enterprise Database role under Enterprise Domain, I am always getting following exception in console.

============================

Exception occurred during event dispatching:java.lang.NoClassDefFoundError: oracle/jdbc/OracleDriver at oracle.sysman.vdb.VdbSessionFactory.construct(VdbSessionFactory.java:532) at oracle.sysman.vdb.VdbSessionFactory.(VdbSessionFactory.java:434) at oracle.sysman.vbo.VboDBServerFat.(VboDBServerFat.java:135) at oracle.sysman.vbo.VboDBServerFat.(VboDBServerFat.java:184) at ...........

==================================

While doing more research, I found that Oracle has configured esm.bat properly. They have defect in their classpath setting.

If you also face the same error, open esm.bat in notepad and replace following entry

SET JDBCCLASSES=C:\oracle\product\10.2.0\client_1\jdbc\lib\classes12.zip;C:\oracle\product\10.2.0\client_1\jdbc\lib\classes111.zip;C:\oracle\product\10.2.0\client_1/jdbc/lib/nls_charset11.zip

to

SET JDBCCLASSES=C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14.jar;C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14_g.jar;C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14dms.jar;C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14dms_g.jar;

"C:\oracle\product\10.2.0\client_1" is my Oracle_Home. You need to replace this with your oracle home.

This will fix the problem and you will able to configure global role.

I don't know how to report this defect to Oracle. Please do if you know the right channel.

Good Luck with Enterprise User Security