Connection to Oracle Databases

<< Click to show table of contents >>

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 R4 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 R4 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

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

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

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.