Users unable to view their own DB Objects in SQL Developer 4.0.x & 4.1.x versions

(Doc ID 2059545.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle SQL Developer - Version 4.0.3 and later
Information in this document applies to any platform.


On : SQL Developer 4.0.3.x.x & 4.1.x.x.x version, Browsing Objects
OS : MS Windows 7 (64 bit)

After switching from Instant Client from to and SQL Developer 4.0.3.x.x users are not able to view their own DB objects. When the same users login via SQL*Plus it gives ORA-28011 error and connects to DB.

ORA-28011 : The account will expire soon; change your password now
Vendor Code: 28011












In SQL Developer 4.1.x.x.x you will be able to login fine for the first time. However, Subsequent logins will throw following error & then SQL Developer session hangs.












If you Click on the 'Details' button you will see the below detailed exception.

java.lang.ArithmeticException: / by zero
at oracle.jdbc.driver.OraclePreparedStatement.<init>(
at oracle.jdbc.driver.OracleCallableStatement.<init>(
at oracle.jdbc.driver.T2CCallableStatement.<init>(
at oracle.jdbc.driver.T2CDriverExtension.allocateCallableStatement(
at oracle.jdbc.driver.PhysicalConnection.prepareCall(
at oracle.jdbc.driver.T2CConnection.prepareCall(
at oracle.jdbc.driver.PhysicalConnection.prepareCall(
at oracle.jdbc.driver.T2CConnection.prepareCall(
at oracle.dbtools.db.OracleUtil.checkAccess(
at oracle.dbtools.db.DBUtil.hasAccess(
at oracle.dbtools.raptor.query.QueryUtils.checkNonOracleAccess(
at oracle.dbtools.raptor.query.QueryUtils.getQuery(
at oracle.dbtools.raptor.query.QueryUtils.getQuery(
at oracle.dbtools.raptor.query.ObjectQueries.getQuery(
at oracle.dbtools.raptor.navigator.db.xml.XmlObjectFactory.createFolderInstance(
at oracle.dbtools.raptor.navigator.db.xml.XmlTypeOwnerInstance.listTypeFolders(
at oracle.dbtools.raptor.navigator.db.impl.TypeContainerTreeNode.loadTypeFolders(
at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(
at oracle.dbtools.raptor.navigator.db.impl.DatabaseTreeNode$LoadTask.doWork(
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$
at java.util.concurrent.Executors$
at java.util.concurrent.ThreadPoolExecutor.runWorker(
at java.util.concurrent.ThreadPoolExecutor$



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms