Forum Stats

  • 3,734,276 Users
  • 2,246,935 Discussions
  • 7,857,216 Comments

Discussions

APEX 19.2. Install fails with 'invalid table name ' on Ora 12.1.0.2 DB

NorbertKl
NorbertKl Member Posts: 20 Blue Ribbon
edited Nov 8, 2019 6:30AM in APEX Discussions

Hello all,

I try to install APEX 19.2. on an Oracle 12.1.0.2 under AIX.

apexins fails with :

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

Installing SYS views

...sys_core_views.sql

core_grants.sql

...grant APEX owner core privileges

declare

*

ERROR at line 1:

ORA-00903: invalid table name

ORA-06512: at line 12

ORA-06512: at line 131

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

I set echo on and got the offending line

-------

131      ddl(p_sql => 'grant execute on "SYS"."java/security/cert/CertificateFactory" to ^APPUN');

.....

143      ddl(p_sql => 'grant execute on "SYS"."javax/crypto/Cipher" to ^APPUN');

144  end;

145  /

declare

*

ERROR at line 1:

ORA-00903: invalid table name

ORA-06512: at line 12

ORA-06512: at line 131

------

What can I do to investigate further ?

Thanks for your Time

Norbert

Tagged:

Best Answer

  • Carsten Czarski-Oracle
    Carsten Czarski-Oracle Member Posts: 1,139 Employee
    edited Nov 8, 2019 6:08AM Accepted Answer

    Hi Norbert,

    when did you download the APEX ZIP archive ...?

    The issue is a known one (bug #30510614) and should already be resolved. When you download APEX from the OTN page anew and re-attempt the install, the issue should not occur any more. Can you please verify?

    Best regards

    .Carsten

Answers

Sign In or Register to comment.