Skip to main content

Apex 4.2 Installation failed on Oracle Database 10.2.0.3


Question: Apex 4.2 Installation failed on Oracle Database 10.2.0.3

Answer:
Application Express 4.0 cannot be installed on Database version 10.2.0.3 on Linux and potentially other platforms as well. The installation will end with "ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters".
Solution for this problem Apply the patch for bug 5890966 (related bug) or apply the 10.2.0.3 Patch 6 on Windows Platforms (if on Windows Platforms) or apply the 10.2.0.4 database patch set or upgrade to 11gR1 or later.


Question: Oracle Report 6i connections problem with Oracle 11g Database ?

Answer:

Oracle 11g database has a new parameter SEC_CASE_SENSITIVE_LOGON (case sensitive password enabled for logon) - default is TRUE.

But Forms transforms (for example) "scott/tiger" to "SCOTT/TIGER".

We can do this:
  alter user scott identified by TIGER
  OR
 set SEC_CASE_SENSITIVE_LOGON to FALSE
Labels:

Comments

Post a Comment

Popular posts from this blog

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN    command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.
Post a Comment
Read more

Checking operating system version: must be 5.0, 5.1 or 5.2 Actual 6.1 Failed

This error occurred when we are installing old oracle software in latest OS (Operating System).   Basically Its’s occurring on windows platform.
Post a Comment
Read more

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why  it's not working ???
Post a Comment
Read more