Friday, May 19, 2006

If you change the database password, there are two places that need to be encrypted

1) server.conf
2) knta_users table - password field server.conf relates to connecting to the itg server ie: starting up ITG knta_users password field relates to being able to login as a user. It is necessary to update this field eg: update knta_users set password = 'BQq*2l*}Mrb)u+W1myD4@^R1=+r6lPvl1<*Vnt+J/Wu=B:w(}pr:B}z)Q(-/ZIR2>V6R+A^0$FTs4IX46?:'

It sets all users with the same password. If you don't do this, you get this error in the servertext.log: Text doesn't appear to be encoded or there is an encryption key mismatch.

If there is an "&" in this string, sqlplus will think that it is a parameter, so the way to handle this is to do:
set scan off

1 Comments:

Blogger oooo said...

Hi,

I am facing the similar issue.
But above solution is not working.

3:22 AM  

Post a Comment

<< Home