If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below.

If you had gone through my blog entry here, i would have talked about using UDML as a way for automating migration from dev to test/prod environments. But the major problem with UDML is that one cannot update the passwords of Connection Pools, Users etc since the UDML expects them to be encoded. In such a case, for updating passwords alone we can use an undocumented command line switch option for the AdminTool. For example, look at the screenshot below.

Open Dev_Machine.rpd Administrator Administrator

SetProperty "Connection Pool" "orcl"."Connection Pool" "User" "sh"
SetProperty "Connection Pool" "orcl"."Connection Pool" "Password" "welcome1"
Save
Exit

Now, open up a command prompt and navigate to {OracleBI}\Server\Bin. Typein in the below command,

admintool /command commandlineswitch.txt

a
a
a
a

Popular posts from this blog

SOLUTION: Unable to start Oracle BI Presentation Services

Purging the Cache using iBots