Navigation:  WebOffice > Installation > WebOffice usermanagement (Application Server) > Configure the File web.config > ORACLE Connection Parameter

The example shows a connection profile with the following values:

 

<GeoUserManagementConnection>

 <Profile>My Oracle Profile</Profile>

 <Host>sde92</Host>

 <DatabaseType>ORACLE</DatabaseType>

 <DatabaseName></DatabaseName>

 <Username>testum5</Username>

 <Password>KH4yhJLabVaPSxrXOGCb7g==</Password>

 <ProviderExtension></ProviderExtension>

</GeoUserManagementConnection>

 

Note: At the server where the web application UserManagement Admin Web is installed, at least an Oracle client has to be installed to connect to the Oracle database.

 

Therefore the file tnsnames.ora (located e.g. in C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\) has to contain an according host name (=TNS entry):

 

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

 

SDE92 =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = TCP)(HOST = w-as-sde-92)(PORT = 1521))

   )

   (CONNECT_DATA =

     (SERVICE_NAME = sde92)

   )

 )

 

EXTPROC_CONNECTION_DATA =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

   )

   (CONNECT_DATA =

     (SID = PLSExtProc)

     (PRESENTATION = RO)

   )

 )

 

Note: Also at the server where WebOffice author is used an Oracle client has to be installed – else it is not possible for WebOffice author to connect to the User Management database and to write the required base information to database.