Partition Archiver service logon denied
I'm trying to configure partition archiver on a new system build in FIPS mode following the ESM 5.5 install guide.
No problems importing the certificates.
No problem running the agentsetup wizard and registering with the ESM. ESM sees the partition archiver connector.
Then I try to configure the archiver service on the db server. It says you have to use the user which is the oracle software owner which by default is oracle. I have tried that and it adds the service. But in the partitionarchiver.log it fails to connect to the database with a logon denied error.
I have also read in the documentation that archiver connects to the database with the same account as the ESM which is "arcsight". I reset the password on the arcsight database account and updated it on the ESM as per KM1270129. The ESM successfully connects. But it won't let me add the service with user arcsight, only oracle.
I tried running "arcsight database pc" from <ArcSight Home>/bin on the database server. When I get to the point to enter the user name and password for the ArcSight database I use arcsight and the password just like I used on the managersetup on the ESM but it fails. Gives errors ORA-00604: error occurred at recursive SQL level 1, and ORA-01882: timezone region not found.
Is the partition archiver service on the database server supposed to use the oracle user or arcsight user accounts?