Knowledge Exchange Cannot Connect to Oracle Database

Metastorm

The information in this article applies to:

Product: Knowledge Exchange
Version: 6.1.2

Issue

• A user fails to access Knowledge Exchange through WebVision. An Oracle error that includes \[servername\].KEServer.base.proException: An error occurred on the server is written to the KEServer.log file, or a message is displayed stating that you are unable to connect to the admin database.

Resolution

• This is a probably a database connectivity issue.

• Verify the following:

  1. The database is running.
  2. The correct username and password are used.
  3. The database user has the following privileges: CREATE SESSION, CREATE TABLE, CREATE PROCEDURE, CREATE TRIGGER.
  4. The Oracle listener is running.
  5. The listener port number and the database service/SID listener port number are the same.
  6. The database server is not behind a firewall.
  7. The Oracle OPEN\_CURSORS parameter is set to 10000.