Return
-
Title
How to use Oracle Servicename instead of SID -
Description
Is it possible to connect to an Oracle Servicename instead of a SID?
In some environments the SID is subject to change when patches are applied to the system or other maintenance is performed.
-
Resolution
For initial database installation:
Unfortunately the Configuration Wizard (in 6.1.2) will only accept the usage of an Oracle client or "Direct access" with entering an SID for installing an new database.
After the successful database installation:
To "switch" from SID to Service Name:
* Open the Designer. Go to "Base data" > "Database". There is the field "Connection parameter" in the "Properties" editor. This field contains the connection string used by the job service while executing process steps. Enter a connectionstring, for example:
User Id=<User_Name>;Password=<User_PWD>;Server=<Oracle_Server>;Direct=True;Service Name=<Service_Name>
* While (re-) configurating the front ends, job services and web front ends - When required to enter a new database connection: Fill in all fields except the SID. Use the "Options" Button in the lower left corner and choose "Advanced options". Scroll down to the "Source" section and enter the service name into the Service Name field. Use "Options" > "Test connection" to verify the information.
* Optional: Delete all connections that don't use the service name.
For History Database:
The database connection for direct import of historical data uses a database link. Using this kind of link the oracle server hosting the History database connects directly to the oracle server hosting the Identity Manager database. -> No reconfiguration needed.
For the History Database itself, History Database job service and front ends connecting to the History Database, proceed as in "To 'switch' from SID to Service Name:" above.