Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How to check apex version. (Oracle 11g R2)
How to check apex version. [message #551654] Fri, 20 April 2012 00:52 Go to next message
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 #551658 is a reply to message #551654] Fri, 20 April 2012 01:00 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Run Apex. In its bottom right corner, you'll see something like

/forum/fa/10074/0/

Re: How to check apex version. [message #551664 is a reply to message #551658] Fri, 20 April 2012 01:09 Go to previous messageGo to next message
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 #551672 is a reply to message #551654] Fri, 20 April 2012 01:35 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
my apex version is 3.2 and
status in following query is "LOADING"
SELECT * FROM DBA_REGISTRY WHERE COMP_ID = 'APEX'

Chintan
Re: How to check apex version. [message #551689 is a reply to message #551672] Fri, 20 April 2012 02:03 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
... it doesn't show admin login

What does it show, then?
Re: How to check apex version. [message #551691 is a reply to message #551689] Fri, 20 April 2012 02:41 Go to previous messageGo to next message
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 #551695 is a reply to message #551691] Fri, 20 April 2012 03:06 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How did you connect to the database (what user)?

Note that I'm not a very experienced Apex installer; I always used tablespaces suggested by Documentation (SYSAUX & TEMP). I see that you are using APEX_DATE & APEX_TEMP. Did you pre-create these tablespaces? I checked installation script (apexins.sql calls coreins.sql), but all I managed to find is that it only USES these tablespaces - script doesn't create them for you.

So, what happens if you run it as suggested:
@apexins SYSAUX SYSAUX TEMP /i/


However, I might be wrong; someone else might know better.
Re: How to check apex version. [message #551696 is a reply to message #551695] Fri, 20 April 2012 03:23 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Thanks

APEX_DATA & APEX_TEMP is precreated table spaces.
Now i will remove the older apex and install it again as you suggest, hope its works.

Chintan
Re: How to check apex version. [message #551697 is a reply to message #551696] Fri, 20 April 2012 03:27 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Good luck!

After you remove Apex, maybe it would be OK if you shutdown & startup the database (of course, if you can do that, for example - if it is XE on your PC).

P.S. You ARE running it as SYS, aren't you?
Re: How to check apex version. [message #551699 is a reply to message #551691] Fri, 20 April 2012 03:41 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
I am surprising with one think that there is no any object named like "dba_lock" in sys schema.

Chintan

Re: How to check apex version. [message #551700 is a reply to message #551699] Fri, 20 April 2012 03:53 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Ask your DBA to run the catblock script. tell him he should have run it already.
Re: How to check apex version. [message #551701 is a reply to message #551700] Fri, 20 April 2012 04:01 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Thank a lot

After execute the catblock.sql dba_lock object is found.

Chintan
Re: How to check apex version. [message #551704 is a reply to message #551701] Fri, 20 April 2012 04:11 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right! I thought that someone *will* know better. Today I learnt something new (catblock!).
Re: How to check apex version. [message #551707 is a reply to message #551704] Fri, 20 April 2012 04:17 Go to previous messageGo to next message
John Watson
Messages: 8919
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 messageGo to next message
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
  • Attachment: apex_page.jpg
    (Size: 50.21KB, Downloaded 1485 times)
Re: How to check apex version. [message #551723 is a reply to message #551722] Fri, 20 April 2012 05:51 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Speaking from my own experience.

According to a screenshot you posted, I'd say that images directory is incorrectly set.

According to Installation Guide, for a new installation you should have ran "apex_epg_config.sql" file (if upgrading for a previous installation, it is the "apxldimg.sql"). (See sections 3.4.5.1 and 3.4.5.2).

Try with
@apxldimg.sql SYSTEM_DRIVE:\TEMP
where "SYSTEM_DRIVE:\TEMP" means Quote:

the file system path to the base directory where the Oracle Application Express software was unzipped
Pay attention and correctly set that directory; otherwise, images won't appear and you won't be able to connect.
Re: How to check apex version. [message #551725 is a reply to message #551723] Fri, 20 April 2012 06:09 Go to previous messageGo to next message
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 #551727 is a reply to message #551725] Fri, 20 April 2012 06:18 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Chintan, it is time you started thinking. If you look at the script apex_epg_config.sql you will see that you are not running it correctly.

[Updated on: Fri, 20 April 2012 06:18]

Report message to a moderator

Re: How to check apex version. [message #551729 is a reply to message #551727] Fri, 20 April 2012 06:21 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
sir i am working on linux & run as per the document suggests.

On UNIX and Linux:

@apex_epg_config /tmp



Chintan
Re: How to check apex version. [message #551730 is a reply to message #551729] Fri, 20 April 2012 06:25 Go to previous messageGo to next message
John Watson
Messages: 8919
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 messageGo to next message
Littlefoot
Messages: 21805
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 #551741 is a reply to message #551730] Fri, 20 April 2012 07:03 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
i think i cant properly understood it, can u please suggest me the connand.

Chintan
Re: How to check apex version. [message #551742 is a reply to message #551738] Fri, 20 April 2012 07:03 Go to previous messageGo to next message
John Watson
Messages: 8919
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.
Re: How to check apex version. [message #551745 is a reply to message #551742] Fri, 20 April 2012 07:14 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think I understand what you are saying (your "Oracle Home" vs. my "directory into which you unzipped Apex installation").

What I suggested is based on my own troubleshooting, when APXLDIMG miserably failed and I was unable to run Apex. Then I took a note (which I presented here, in my previous message).

Database I use(d) was XE (different versions, from 10g to 11g) whose Oracle Home is very different from Apex "Oracle Home"; I never used DB Oracle Home as APXLDIMG parameter. Well, maybe I did it wrong, but what can I say ... my Apex works properly.



P.S. (After re-reading what's being said so far)

We are talking about different scripts! You: APEX_EPG_CONFIG.SQL; me: APXLDIMG.SQL. It might be that both of us are right.
Re: How to check apex version. [message #551749 is a reply to message #551745] Fri, 20 April 2012 07:32 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
Thanks a lot

Your Idea runs perfectly and now apex runs fine.

Chintan

Re: How to check apex version. [message #551750 is a reply to message #551749] Fri, 20 April 2012 07:36 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"Your idea" is exactly whose idea? John's or mine?

(I mean ... I'm glad you fixed it, but I'd like to know which SQL script you ran and exactly how - what parameter(s) did you provide)?
Re: How to check apex version. [message #551752 is a reply to message #551750] Fri, 20 April 2012 07:43 Go to previous messageGo to next message
chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad
Senior Member
i am provide oracle home as a parameter.

SQL> @apex_epg_config /oracle/home


Thanks again
both of you littlefoot and johns.
Re: How to check apex version. [message #551753 is a reply to message #551752] Fri, 20 April 2012 07:44 Go to previous message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Understood; thank you!
Previous Topic: Delete the Column Without Value
Next Topic: Pie chart is showing ID number with , comma
Goto Forum:
  


Current Time: Tue Mar 19 02:51:19 CDT 2024