garden3.jpg

Disclaimer: Apply to a TEST environment first. Use on production systems is at DBAs own risk.

Errors:

jbo-26061 error while opening jdbc connection

ora-01017 invalid username/password logon denied

In our testing this error had to do with Oracle database 11g and 12c being case sensitive for password.

Logon to Oracle as sysdba:

SQL> connect /as sysdba

Connected.

Verify Current setting:

SQL> SHOW PARAMETER SEC_CASE_SENSITIVE_LOGON

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

sec_case_sensitive_logon boolean TRUE

SQL> show parameter pfile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

spfile string D:\APP\ORACLE\TESTDB\12.1.0\DA

TABASE\SPFILETEST12C.ORA

Set password case sensitivity to false:

SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE scope=both;

System altered.

Latest Blog Items

email

Thank you for your interest in idbasolutions.

Contact us using this email: contact.us@idbasolutions.com