REP-0501 ORA-01017 unable to connect to
the specified database
Applies
to:
Enterprise Linux Version 5.7
Database 11gR2
Oracle Forms/Reports 6i
Description:
We have an in-house developed application
on Oracle Form/Reports 6i with Oracle Database 9.2 32bit on Windows Server 2008
32bit. Application is working fine. I have assigned a task from my manager to
upgrade the database and also migrate the database server on Linux. I have done
all the activities successfully. After that, Application is working fine except
reports. When I run any report from application the report engine log give me
the following error:
REP-0501: Unable to connect to the specified
database.
ORA-01017: invalid username/password; logon denied
ORA-01017: invalid username/password; logon denied
Solution:
After
some research work I have found the following solution:
If you have recently
created an 11g database, one behavior change that you may find confusing is
that passwords are now case-sensitive by default. This behavior is controlled
by the SEC_CASE_SENSITIVE_LOGON parameter.
Check the current
value of above parameter:
SQL> connect system/oracleConnected.
SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE
------------------------ ------- -----
sec_case_sensitive_logon boolean TRUE
Default value of this
parameter is TRUE, change it to FALSE. After restart the database reports are working
fine without any error.
Your comments, especially which will help us
improve the functionality, will be greatly appreciated. :)
