OraFAQ Forum: Application Express, ORDS & MOD_PLSQL

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How to check apex version. (Oracle 11g R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check apex version. [message #551654]

Fri, 20 April 2012 00:52

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

Report message to a moderator

Re: How to check apex version. [message #551658 is a reply to message #551654]

Fri, 20 April 2012 01:00

Littlefoot
Messages: 21824
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/

Attachment: apex_version.png
(Size: 20.54KB, Downloaded 8557 times)

Report message to a moderator

Re: How to check apex version. [message #551664 is a reply to message #551658]

Fri, 20 April 2012 01:09

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

Code: [Select all] [Show/ hide]

http://test1.test.com:8080/apex/apex_admin

it doesn't show admin login. how can i come up with this problem.

Chintan

Report message to a moderator

Re: How to check apex version. [message #551672 is a reply to message #551654]

Fri, 20 April 2012 01:35

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

Report message to a moderator

Re: How to check apex version. [message #551689 is a reply to message #551672]

Fri, 20 April 2012 02:03

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

... it doesn't show admin login

What does it show, then?

Report message to a moderator

Re: How to check apex version. [message #551691 is a reply to message #551689]

Fri, 20 April 2012 02:41

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

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: How to check apex version. [message #551695 is a reply to message #551691]

Fri, 20 April 2012 03:06

Littlefoot
Messages: 21824
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:

Code: [Select all] [Show/ hide]

@apexins SYSAUX SYSAUX TEMP /i/

However, I might be wrong; someone else might know better.

Report message to a moderator

Re: How to check apex version. [message #551696 is a reply to message #551695]

Fri, 20 April 2012 03:23

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

Report message to a moderator

Re: How to check apex version. [message #551697 is a reply to message #551696]

Fri, 20 April 2012 03:27

Littlefoot
Messages: 21824
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?

Report message to a moderator

Re: How to check apex version. [message #551699 is a reply to message #551691]

Fri, 20 April 2012 03:41

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

Report message to a moderator

Re: How to check apex version. [message #551700 is a reply to message #551699]

Fri, 20 April 2012 03:53

John Watson
Messages: 8977
Registered: January 2010
Location: Global Village

Senior Member

Ask your DBA to run the catblock script. tell him he should have run it already.

Report message to a moderator

Re: How to check apex version. [message #551701 is a reply to message #551700]

Fri, 20 April 2012 04:01

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

Report message to a moderator

Re: How to check apex version. [message #551704 is a reply to message #551701]

Fri, 20 April 2012 04:11

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Right! I thought that someone *will* know better. Today I learnt something new (catblock!).

Report message to a moderator

Re: How to check apex version. [message #551707 is a reply to message #551704]

Fri, 20 April 2012 04:17

John Watson
Messages: 8977
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.

Report message to a moderator

Re: How to check apex version. [message #551722 is a reply to message #551707]

Fri, 20 April 2012 05:41

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

Code: [Select all] [Show/ hide]

first_field is not defined.

and also some images not displayed.

Please Check Attachments,

Chintan

Attachment: apex_page.jpg
(Size: 50.21KB, Downloaded 2096 times)

Report message to a moderator

Re: How to check apex version. [message #551723 is a reply to message #551722]

Fri, 20 April 2012 05:51

Littlefoot
Messages: 21824
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

Code: [Select all] [Show/ hide]

@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.

Report message to a moderator

Re: How to check apex version. [message #551725 is a reply to message #551723]

Fri, 20 April 2012 06:09

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Script Returns Following Errors

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: How to check apex version. [message #551727 is a reply to message #551725]

Fri, 20 April 2012 06:18

John Watson
Messages: 8977
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

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

sir i am working on linux & run as per the document suggests.

Code: [Select all] [Show/ hide]

On UNIX and Linux:

@apex_epg_config /tmp

Chintan

Report message to a moderator

Re: How to check apex version. [message #551730 is a reply to message #551729]

Fri, 20 April 2012 06:25

John Watson
Messages: 8977
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

Report message to a moderator

Re: How to check apex version. [message #551738 is a reply to message #551730]

Fri, 20 April 2012 06:58

Littlefoot
Messages: 21824
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:
Code: [Select all] [Show/ hide]
```
-- 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

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

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

John Watson
Messages: 8977
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:

Code: [Select all] [Show/ hide]

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.

Report message to a moderator

Re: How to check apex version. [message #551745 is a reply to message #551742]

Fri, 20 April 2012 07:14

Littlefoot
Messages: 21824
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.

Report message to a moderator

Re: How to check apex version. [message #551749 is a reply to message #551745]

Fri, 20 April 2012 07:32

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Thanks a lot

Your Idea runs perfectly and now apex runs fine.

Chintan

Report message to a moderator

Re: How to check apex version. [message #551750 is a reply to message #551749]

Fri, 20 April 2012 07:36

Littlefoot
Messages: 21824
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)?

Report message to a moderator