Python Script was failing after creating Datasource.
From UI Admin Console, if I try to activate changes done by Python Script, datasource was not getting connected with DB.
I was getting -
ORA-01017: Invalid Username/Password; Logon Denied
Trust me- user name and password was correct.
But both were entered in UPPER case in script. Although Username/Password as given in upper case in Schema as well.
So what is the problem.
I guess, Weblogic encrypts password while creating Datasources. But while connecting to Db its decrypting in lower case and due to that it was not connecting with DB.
But how come oracle is not connecting with different case password, because its case in-sensitive. This is not correct since last version of Oracle.
We need to make below parameter false and restart DB.
SEC_CASE_SENSITIVE_LOGON
After making - SEC_CASE_SENSITIVE_LOGON to false, datasource started connecting to DB.
