Total Pageviews

Sunday, October 16, 2022

ORA-01017 Invalid username/password logon denied

In Oracle 11g a new parameter called SEC_CASE_SENSITIVE_LOGON which is defaults to TRUE for case sensitive passwords. My SCOTT password was "tiger" is small case and Forms 10g was taking it as "TIGER" on runtime.

Solution 1:

- Connect as sys and change the parameter to false.

      alter system set SEC_CASE_SENSITIVE_LOGON = FALSE; 

ORA-00845: MEMORY_TARGET not supported on this system

 The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: SQL> sh...