Navigation:  Getting Started > Configure the application > Configure the file Web.config > ORACLE connection parameter

The example shows a connection profile with the following values:

•Name: Oracle,

•TSN: sde92,

•Database user: testum5

•Encrypted password: testum5

 

<GeoUserManagementConnection>

<Profile>My Oracle Profile</Profile>

<Host>sde92</Host>

<DatabaseType>ORACLE</DatabaseType>

<DatabaseName></DatabaseName>

<Username>testum5</Username>

<Password>gwevK9CkpU0=</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’s not possible for WebOffice author to connect to the User Management database and to write the required base information to database.