Hi, SE 12.1 APEX 5.1
Im trying to tidy up my database by doing a full export, creating a new database, then dong a full import. Mainly to tidy up a lot of empty space in some tablespaces, but also as a test for restoring in case of primary failure.
So, on my backup Server I have a working copy of the primary database with APEX 5.1 running, along with Tomcat6 and ORDS v2, and the static files in tomcat6/webapps/i/
This configuration all works fine, and I can log in and use APEX.
Then I
1) Take a full export
2) Delete the database using dbca
3) Create a new standard database using DBCA
4) Manually recreate the tablespaces I need to shrink
5) Do a full system import (no errors of any significance (and by that I mean it complains about some packages that wont compile in some unused schemas))
6) set the Local_listener parameter to (address_list=(address=(protocol=tcp)(host=localhost)(port=1521))) (By default its blank on a new database)
7) restart tomcat
8) load my APEX login page
At this point, I can see the source of the page if I check, but the page itself is blank. My Chrome console shows
f?p=4550:1:6710328852669:35 Uncaught TypeError: Cannot read property 'framebreaker' of undefined at f?p=4550:1:6710328852669:35
I look at the source, and its showing:
<script type="text/javascript">
var apex_img_dir = "/i/", htmldb_Img_Dir = apex_img_dir;
</script>
<script src="/i/libraries/apex/minified/desktop_all.min.js?v=4.2.0.00.27" type="text/javascript"></script>
<script src="/i/libraries/apex/minified/legacy.min.js?v=4.2.0.00.27" type="text/javascript"></script>
<style> html {visibility:hidden;} </style>
<script type="text/javascript">
apex.security.framebreaker("D");
</script>
So I know its got something to do with the static files, but nothing on the tomcat side has changed.
if I use http://192.168.0.72:8090/i/apex_version.txt I get back the APEX version number..
If anyone can help with any suggestions. Id be grateful.
Rgds
Richard