Create the Distributed Processing Server User Account
You must run a script to create the Distributed Processing (DP) Server database account cdr_dpserver
and set its password. Use this account to start the DP Server.
Note:
When you start the DP Server on each service location, you need this password. You should change the default password for use within your company.
To change a password:
-
Log in to SQL*Plus.
-
Enter the following:
alter user
old_password
identified by
new_password
To run the script:
-
Log in to the application server.
-
Source the RUN file system environment file from the Oracle LSH application server by using the following command:
source /<BASE_LOCATION>/EBSapps.env RUN
-
Go to $CDR_TOP/patch/115/sql.
-
Log in to SQL*Plus as apps
-
Run the script:
cdrcreatedpserveruser.sql
At the prompt, enter the password you want to use for the cdr_dpserver account.
-
Exit from SQL*Plus.
Parent topic: Set Up the Distributed Processing Server