Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to install Oracle APEX 5

buggleboy007Oct 17 2017 — edited Oct 18 2017

Hi all,

Last night I reformatted my computer and installed a fresh copy of Windows 7 professional. After this I installed Oracle12c enterprise edition database 64 bit (no Java RTE or nothing connected to Java was or has been installed so far). Oracle 12c Release 1 installation was successful (I choose to install without selecting "Create as Container Database" option). End of the day this installation was successful.

Then I downloaded Oracle APEX 5.0 (I did not deliberately download APEX 5.1) and ran the installation procedure as per Oracle documentation and also observing a few videos on You tube. The apex install (.sql) file installation was successful. Then I ran the apex_epg_config.sql file and was constantly getting errors that said "ORA-22288". It appears that the images did not load successfully and finally when I typed my local host address on chrome browser. I got the environment issue error.

I even ran the reset image .sql file by following this article : https://ruepprich.wordpress.com/2011/04/14/changing-the-image-path-andor-directory-in-apex/

I have reformatted my computer two times but to no avail. I have deliberately chosen not to install too many things/other software at this time. Do you think non installation of Java RE or any Java development component or middleware like webserver is the reason behind this issue?

Here are the screenshots of the errors that I encountered.

pastedImage_0.png

pastedImage_1.png

Could any one of you point out what the issue is?

This post has been answered by buggleboy007 on Oct 18 2017
Jump to Answer

Comments

use preferred abbreviation - here are two pictures
Attribute_pref_abbreviation.png
engineering_pref_abbrev.png
Philip

Mike Kutz

@philip-stoyanov-oracle
The PK Attribute on the Parent Entity comes from "Create Surrogate key" on the parent Entity (image 1)
The Attribute I want to modify isn't listed on the Child Entity (image 2).
Beyond that, it looks like this trick should work.
MK
Image 1 - PK on Parent is auto-created
image.png
Image 2 - no Attribute to modify.
image.png

is there a rule for that name?
Philip

Mike Kutz

Where to check?
I'm just starting to use SDDM. I don't think I defined any naming rules.
I've modified the Naming Templates (image). But that should be it. maybe a few check boxes for Engineering.
MK
image.png

HansJK

You can also just type the name you want while editing that attribute in the attribute list.
It will get overridden if you should re-run naming conventions. So I paste my chosen name into the comments of that attribute (not RDBMS comments, just tool comments). then at least I can copy paste it back or I make sure to re-run naming conventions opton without foreign key columns applied.

well, if you want the name to not change then you can use "Tools>Object names administration" utility to make that name unchangeable

Philip

HansJK

Thank you @Philip Stoyanov-Oracle. That is cool.
If I may, it would have been nice if a direct "link" to that feature would be that I could on the relevant object/attribute indicate/tick that it must be fixed and not have to go to another screen to achieve this. Also having this "central" place/way of being able to see all things flagged as fixed.
Just my two cents...

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 15 2017
Added on Oct 17 2017
2 comments
854 views