Identity Manager Connectors Uninstall Error with ORA-00942 (Doc ID 2273088.1)

Last updated on JUNE 13, 2017

Applies to:

Identity Manager - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

 The following error occurs when uninstalling the connector.


[oracle@hostname bin]$ ./uninstallConnector.sh
For running the Utilities the following environment variables need to be set
APP_SERVER is weblogic
OIM_ORACLE_HOME is /home/oracle/Oracle/Middleware2/Oracle_IAM
JAVA_HOME is /home/oracle/app/home2/Middleware/jdk1.6.0_45
MW_HOME is /home/oracle/Oracle/Middleware2
WL_HOME is /home/oracle/Oracle/Middleware2/wlserver_10.3
DOMAIN_HOME is /home/oracle/Oracle/Middleware2/user_projects/domains/IAMDomain
*********************************************************************
* This utility deletes data from the OIM database directly and is *
* meant to be used in development/staging environments. *
* *
* WARNING: DO NOT USE IN PRODUCTION. *
*********************************************************************
[Enter the DB Password :]
[Enter OIM Administrator Name :]xelsysadm
[Enter the OIM Administrator Password :]
[[Enter serverURL (Ex. t3://oimhostname:oimportno for weblogic or corbaloc:iiop:localhost:2801 for websphere)]:]t3://localhost:14000
[[Enter context Factory (i.e.: weblogic.jndi.WLInitialContextFactory for weblogic or com.ibm.websphere.naming.WsnInitialContextFactory for websphere)]: ]weblogic.jndi.WLInitialContextFactory
Connector 'Oracle EBS User Management 11.1.1.5.0' will be un-installed
Do you want to continue with the connector un-install [y|n]:y
ERROR,02 6 2017 16:03:47,969,[ConnectorUninstall.log],oracle.iam.connectormgmt.uninstall.UninstallUtility Error encountered while getting connector name and release :java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

ERROR,02 6 2017 16:03:47,971,[ConnectorUninstall.log],ORA-00942: table or view does not exist

java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
at oracle.iam.connectormgmt.uninstall.UninstallUtility.verifyConnectorInstalled(UninstallUtility.java:744)
at oracle.iam.connectormgmt.uninstall.UninstallUtility.executeDirectDeletion(UninstallUtility.java:318)
at oracle.iam.connectormgmt.uninstall.ConnectorUninstall.doConnectorDeletion(ConnectorUninstall.java:389)
at oracle.iam.connectormgmt.uninstall.ConnectorUninstall.main(ConnectorUninstall.java:85)
ERROR,02 6 2017 16:03:47,972,[ConnectorUninstall.log],oracle.iam.connectormgmt.uninstall.UninstallUtilityError encountered while getting connector name and release :java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

oracle.iam.connectormgmt.uninstall.ConnectorUninstallException: oracle.iam.connectormgmt.uninstall.UninstallUtilityError encountered while getting connector name and release :java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.iam.connectormgmt.uninstall.UninstallUtility.verifyConnectorInstalled(UninstallUtility.java:755)
at oracle.iam.connectormgmt.uninstall.UninstallUtility.executeDirectDeletion(UninstallUtility.java:318)
at oracle.iam.connectormgmt.uninstall.ConnectorUninstall.doConnectorDeletion(ConnectorUninstall.java:389)
at oracle.iam.connectormgmt.uninstall.ConnectorUninstall.main(ConnectorUninstall.java:85)
ConnectorUninstallException: oracle.iam.connectormgmt.uninstall.UninstallUtilityError encountered while getting connector name and release :java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Check the Logs for more details.

Changes

 None

Cause

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