If you specify the Oracle database for SAS Shared Services, the following error might occur:

-------------------------------
WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while attempting to 
get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: 
(java.lang.reflect.UndeclaredThrowableException)
	at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection
(LocalManagedConnectionFactory.java:190)
 ...
 Caused by: java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole
        at oracle.jdbc.driver.DMSFactory.(DMSFactory.java:50)
        at oracle.jdbc.driver.PhysicalConnection.createDMSSensors(PhysicalConnection.java:3602)
               ... 244 more
Caused by: java.lang.ClassNotFoundException: No ClassLoaders found for: oracle.dms.console.DMSConsole
        at org.jboss.mx.loading.LoadMgr3.beginLoadTask(LoadMgr3.java:212)
        at org.jboss.mx.loading.RepositoryClassLoader.loadClassImpl(RepositoryClassLoader.java:521)
        ...

This error occurs when multiple Oracle Java Database Connectivity (JDBC) drivers exist in the path that you specify in the SAS^® Deployment Wizard when it prompts you for the directory that contains the JDBC driver .jar file for Oracle. During the SAS Deployment Wizard configuration phase, all .jar files are copied into the file structure for the Web application server from the path that you specify. When the Web application server is started, the application might select the wrong JDBC driver, thereby causing the error.

To correct the problem, copy the appropriate JDBC driver .jar file for Oracle into a separate directory. Then enter the directory path in the wizard when you are prompted.

If you have already completed the deployment process, follow these steps:

1. Determine the correct Oracle JDBC driver .jar file to use.
2. Delete all other Oracle JDBC driver .jar files from the file structure in the Web application server and in the SAS configuration directory.

During the deployment process, the JDBC driver .jar files are copied to the SAS configuration directory /Lev1/Web/Applications/SASSharedServices9.2/JDBCDrivers/. If you use JBoss as the Web application server, the files are copied to /JBoss-home-directory/server/SASServer1/lib directory.

Operating System and Release Information