Activation fails with the below errors in the event_log.
Info 2011-06-10 14:03:06.490528 17374 3597182688 Activation launched, pid = 17374 (activating sid SAND)
Error 2011-06-10 14:03:06.582409 17374 384165600 Activation: 12035 - OCISessionBegin failed with ORA-1017. (activating sid SAND) [module osp]
Error 2011-06-10 14:03:06.582954 17374 384165600 Compile of "sample_config" for sid o.SAND failed: Oracle Error: connect failed for database o.SAND -
Info 2011-06-10 14:03:06.585223 15271 3597182688 Activation exited with code=1, pid = 17374 (activating sid SAND)
Shareplex DB user ID / Password changed and Activation could not connect to the DB.
1. Change the password back to original.
2, Run Ora_chpwd utility. Steps below:
Shutdown Shareplex
Run ora_chpwd utility from proddir/bin directory.
Activate the config.
Open paramdb file from vardir/data on source, check for the "SP_ORD_OWNER". Value next to this parameter is the Database User. Try login to the Database with the DB User and check if the password is changed for this.
Starting with SharePlex 8.6, the login credentials of SharePlex user are written to and stored in the file named connections.yaml located in /vardir/data subdirectory of SharePlex (where vardir refers to the Variable directory of SharePlex). Here is a sample entry: alvsupu07 # cat connections.yaml o.SYAM: password: 5787d4def4 user: SHA86 In the above, the first line has SID info. The second line has encrypted password and the third line has the name of the SharePlex user that makes connections to the database.
