How to check apex version. [message #551654] |
Fri, 20 April 2012 00:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Hi Friends
I have one question regarding apex version that how can i come to know the installed version of application express.
Chintan
|
|
|
|
Re: How to check apex version. [message #551664 is a reply to message #551658] |
Fri, 20 April 2012 01:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Thanks
Another problem is that i had install apex using Embedded PL/SQL Gateway, step by step as per documentation but after installation
when i tried to access by
http://test1.test.com:8080/apex/apex_admin
it doesn't show admin login. how can i come up with this problem.
Chintan
|
|
|
|
|
Re: How to check apex version. [message #551691 is a reply to message #551689] |
Fri, 20 April 2012 02:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
I am removing application express from the database by using the script @apxremov.sql and then install from the first step as documentation using the scrip @apexins APEX_DATA APEX_DATA APEX_TEMP /i/ . As per installation log, installation process terminated from the following lines
grant select on sys.dba_lock to APEX_030200
*
ERROR at line 1:
ORA-00942: table or view does not exist
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Now Please let me know the way to comeout from this.
Thanks IN Advance
Chintan
|
|
|
|
|
|
|
|
|
|
Re: How to check apex version. [message #551707 is a reply to message #551704] |
Fri, 20 April 2012 04:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
LF, I learn something here every day. That's why I attend. Sometimes I learn from reading answers, usually I learn from researching questions.
For example, a question recently on how to use a trigger to check am inserted value. I thought "I bet one could do that with a check constraint" but I didn't know how, so I looked it up and did it. Cool: I learnt something! Didn't get the glory though, someone else had already answered.
I'm fortunate in that a lot of my work now is on-call and R&D, so I can usually take a few minutes out for study.
|
|
|
Re: How to check apex version. [message #551722 is a reply to message #551707] |
Fri, 20 April 2012 05:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Apex Script completed successfully, now when i enter URL in address bar then the login page comes but not working it gives some java scrip errors like
first_field is not defined.
and also some images not displayed.
Please Check Attachments,
Chintan
|
|
|
|
Re: How to check apex version. [message #551725 is a reply to message #551723] |
Fri, 20 April 2012 06:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
chintan.patel
Messages: 162 Registered: July 2008 Location: Ahmedabad
|
Senior Member |
|
|
Script Returns Following Errors
SQL> @apex_epg_config /tmp
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/tmp/apex/images'
Directory created.
old 47: if '&IMGUPG' != '' then
new 47: if '' != '' then
old 48: l_mv_folder := '&IMGUPG';
new 48: l_mv_folder := '';
declare
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.XMLTYPE", line 296
ORA-06512: at line 18
Commit complete.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Load Images
Elapsed: 00:00:00.10
Session altered.
PL/SQL procedure successfully completed.
Commit complete.
Session altered.
Directory dropped.
SQL>
Chintan
|
|
|
|
|
Re: How to check apex version. [message #551730 is a reply to message #551729] |
Fri, 20 April 2012 06:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I did suggest that you look at the script. These two lines are clear:
Rem This script should be run as SYS and takes one argument, the path
Rem to the Oracle Home. The script will load the images into XDB and then configure
|
|
|
Re: How to check apex version. [message #551738 is a reply to message #551730] |
Fri, 20 April 2012 06:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Linux, eh? I'm a 100% dummy about it.
Nonetheless: a directory you specify should be as follows (Windows terminology, but you'll get the idea, I hope).
- When you downloaded Apex, it was a ZIP file. You put it into c:\temp, so its path was c:\temp\apex.zip.
- Then you extracted it, and Apex files were created in c:\temp\apex directory.
- apxldimg.sql should accept c:\temp as a parameter, NOT c:\temp\apex:
-- connect as SYS
SQL> @apxldimg c:\temp
[Updated on: Fri, 20 April 2012 06:59] Report message to a moderator
|
|
|
|
Re: How to check apex version. [message #551742 is a reply to message #551738] |
Fri, 20 April 2012 07:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I disagree, LF: I know nothing about Apex, but this is the file (same on Linux as windows:db $ cd $ORACLE_HOME/apex
db $ cat apex_epg_config.sql
Rem
Rem
Rem apex_epg_config.sql
Rem
Rem Copyright (c) 2004,2006,2008 Oracle Corporation. All rights reserved.
Rem
Rem NAME
Rem apex_epg_config.sql - Application Express Embedded PL/SQL Gateway Configuration
Rem
Rem DESCRIPTION
Rem This script should be run as SYS and takes one argument, the path
Rem to the Oracle Home. The script will load the images into XDB and then configure
Rem a DAD for use by Application Express in the Embedded PL/SQL Gateway.
Rem
Rem
Rem MODIFIED (MM/DD/YYYY)
Rem jstraub 09/09/2008 - Created to support OTN and DB distributions, moved logic to apex_epg_config_core.sql
define IMGUPG = ''
@@apex_epg_config_core.sql '&1'
db $
the instructions are clear, and it works for me when I pass the Oracle Home as an arguement. Possibly your technique is applicable only if your DB software is older (I'm using 11.2.0.3) and you have had to install/upgrade Apex with software from somewhere else. I tested n windows, by the way.
|
|
|
|
|
|
|
|