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.8 SP2 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.8 SP2 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 user management 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 user management groups can be read from the Oracle database. If this is not the case, the problem can be localized to the database.
Comments
0 comments
Please sign in to leave a comment.