Connection to Oracle Databases

If problems with the connection to an Oracle user management database or the correct query from the Oracle database cannot be excluded, there is a possibility to check this by using the Oracle SQL Developer tool.

 

Step 1: Connection to the Oracle Database

After installation the tool on the server where the WebOffice 10.9 SP1 application is running, the first step is to connect to the database.

The following parameters must be filled in for this purpose:

 

Parameter

Description

Connection name

Connection name used to display the connection to the Oracle database in SQL Developer.

User name

User name, for the connection to the database, which was also configured for the connection in the WebOffice 10.9 SP1 application configuration.

Note: For more information on how to connect a user management database in the application configuration, see the DB Connection Information for Read Access chapter.

Password

Password that allows access to the database in connection with the specified user name.

Connection type

TNS is selected from the list as the connection type

Network alias

The network alias can be found in the tnsnames.ora file.

 

 

Connection to the Oracle Database via SQL Developer

Connection to the Oracle Database via SQL Developer

 

If all parameters are filled in accordingly, the connection can be tested via the Test button. If the test is successful, the connection can be created by clicking the Login button.

 

Step 2: SQL command to query the UserManagement groups

In the next step, it can be verified whether the correct groups can be read out from the Oracle user management database.

For this purpose, an SQL worksheet must first be opened (if not already opened) via the context menu of the created database connection:

 

open SQL Worksheet

open SQL Worksheet

 

 

 

Then enter the following SQL command and execute the input using the corresponding button:

SELECT UM_GROUP.NAME FROM UM_GROUP

 

Querying the user management groups from the Oracle database

Querying the user management groups from the Oracle database

 

 

In the lower area of the screenshot, you can check whether the expected UserManagement groups can be read from the Oracle database. If this is not the case, the problem can be localized to the database.