ORACLE Connection Parameter |
  
|
ORACLE Connection Parameter |
|
Notes:
•The installation order of the Oracle client must be maintained as follows: first install the 64-bit client and finally the 32-bit client.
•When using the WebOffice extensions + ArcGIS Engine, a concurrent installation of the Oracle 64- and 32-bit client is required on the ArcGIS Server environment.
•In the Windows environment variables (PATH) the 64-bit client should be in front of the 32-bit client -> this setting is required by ArcGIS server.
•For more information see ArcGIS online help in the chapter Connect to Oracle from ArcGIS.
•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.
•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.
•In use of an Oracle database or client the user of the WebOffice extensions have to be granted access to the file tnsnames.ora. The access rights have to be applied accordingly.
•The following user also has to be granted access to the tnsnames.ora file: IIS_IUSRS.
The example shows a connection profile with the following values:
<GeoUserManagementConnection>
<Profile>Oracle</Profile>
<Host>myOracleConnection</Host>
<Port>0</Port>
<DatabaseType>Oracle</DatabaseType>
<DatabaseName></DatabaseName>
<Username>myuser</Username>
<Password>mypassword</Password>
<SchemaOwner>myschemaowner</SchemaOwner>
<ProviderExtension></ProviderExtension>
<DBOption></DBOption>
<KeepconnectionAlive>1</KeepconnectionAlive>
<WebOfficeURL></WebOfficeURL>
<WebOfficePassword></WebOfficePassword>
</GeoUserManagementConnection>
Property |
Description |
Profile |
Alias name that will be displayed in the Usermanagement Admin Web list of profiles |
Host |
TNS entry that is saved in tnsnames.ora Note: See the example below this table. |
Port |
? |
DatabaseType |
Oracle |
DatabaseName |
Leave this field blank |
Username |
User to be used for connection of Usermanagement Admin Web to the Usermanagement database. Note: This user has to have read and write rights. |
Password |
Password of the user Note: The administrator has to encrypt the password with the password.exe application. See chapter Creating an Encrypted Password for details. |
SchemaOwner |
Name of the Oracle schema owner when different than the one of the user that is used for login. Note: This functionality is required if the Oracle schema is created with a different user (e.g. UMDB_ADMIN) than the one used for connection with WebOffice (e.g. UMDB_USER). Note: Example Scenario: Note: The respective schema owner has to be configured in the application configuration as well. See chapter DB Connection Information for Read Access for details. Note: In order to execute a version upgrade the schema owner has to be used! A version upgrade is not possible with a user other than the schema owner. |
ProviderExtension |
? |
DBOption |
? |
KeepconnectionAlive |
? |
WebOfficeURL |
? |
WebOfficePassword |
? |
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.
myOracleConnection =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sde92)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)