1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

R3trans could not connect to database after upgrading to Oracle 11g

Tuesday, 31 July 2012 11:10

Written by Vijayasarathy S

Print E-mail


Symptom:

 

After upgrading the SRM system database to Oracle 11G (11.2.0.3), R3trans could not connect to database with the error message mentioned below. Even after changing the schema and system password, the issue did not get resolved.

Error message:  ORA-01017: invalid username/password; logon denied (in trans.log / developer traces)

Reason: Case sensitive passwords (and auditing) are a default feature of newly created Oracle 11g databases. The Database Configuration Assistant (DBCA) allows you to revert these settings back to the pre-11g functionality during database creation.

Solution:

The SEC_CASE_SENSITIVE_LOGON initialization parameter gives control over case sensitive passwords. If existing applications struggle to authenticate against 11g, you can use the ALTER SYSTEM command to turn off this functionality.

 

 

 

{fcomment} {flike}

Share

R3trans could not connect to database after upgrading to Oracle 11g