Amazon

Wednesday, December 6, 2017

Weblogic - Server Creation - Issues

Datasource creation using python script. 

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. 

No comments:

Post a Comment

Amazon Best Sellors

TOGAF 9.2 - STUDY [ The Open Group Architecture Framework ] - Chap 01 - Introduction

100 Feet View of TOGAF  What is Enterprise? Collection of Organization that has common set of Goals. Enterprise has People - organized by co...