Changing db version from oracle 10 to oracle 11/12 gives ora-28040
Hello, I'm using TOS 4.1.2. My problem is the same with DI5.6 and DI 6.2 (i've installed both, imported my project and tried the same actions except that i choosed Oracle 12 in 5.6 and 6.2).
I've designed many jobs. All jobs have at least one context group for db connection wich is in context. I'm migrating from oracle 10 to oracle 12 so i have changed my connection because i have to change db version from Oracle 10 to Oracle 11. I did it this way :
-dissociated connection from context (previous context group created when exporting db connexion to context was named CNX_infocentre) -changed db version from oracle 10 to oracle 11 -exported db connection to context (new context group created when exporting db connexion to context is named infocentre)
All existing jobs were updated (when i open any job and i look at db version i see oracle 11) but when i run a job i have an oracle error message "ORA-28040: No matching authentication protocol".
When i verify the connection, i works. I can run Jobs with no sub jobs but i can't run jobs with sub jobs.
The only way i have found to make it work is to remove previous context group associated with the connection and to add the new one wich contains exactly the same variables (db version is not in the context group, only in the connection). Last thing : i tried in DI 5.6 and 6.2 to re-use existing context group when exporting (wich is not possible in TOS 4.1.2) but it did not solve the problem. Because i have many jobs, i would prefer not to have to remove old context group and add new one to all my jobs.
-"is it normal that updating the connexion doesn't work with all jobs ?" -"is it possible to add one context group to all jobs in one action ?"
