Application Express :: Oracle 11g XE - 4.2.3 Upgrade

Nov 13, 2013

I have downloaded Oracle 11g XE and installed it on my laptop, Win 7 Enterprise Everything works great, DB admin page comes up, APEX comes up (4.0.2.x). I download the Apex_4.2.3_en.zip. I extract the zip file and then follow the instructions in, Downloading from Oracle Technology Network  essentially the apexins.sql, apxldimg.sql with the admin password changes and anonymous user unlock. 
This is the install command, @apexins SYSAUX SYSAUX TEMP /i/ 

I get the  Error processing request  ORA-010403: no data found.

View 3 Replies


ADVERTISEMENT

Application Express :: Oracle SSO Authorization Not Working After Upgrade To 4.2.1

Jan 3, 2013

I have enabled SSO for my application. It was working in 4.1 version. I have upgraded to 4.2 now and the same code doesn't work now.I have created an authentication scheme where i check if a particular person is an employee based on a flag. If he is, then I return 1 to the authorization scheme i have created. This always returns 0 even if the flag is set to 'Y'. I have tried hard coding the user_id as well. It doesn't work.

I tried printing the :APP_USER but it does not give any output.

View 1 Replies View Related

Application Express :: Upgrade Within Oracle XE Database Installation On Windows 7

Aug 28, 2012

O/S: Windows 7 64-bit
DB: Oracle XE 11g2 32-bit
APEX: 4.0.2
=============

Trying to upgrade APEX within an Oracle XE database installation on Windows 7. The version of APEX that came with Oracle XE is 4.0.2. Trying to upgrade to 4.1.1 and, from the SQL*Plus command-line (ie. the 'Run SQL Command' tool which comes with Oracle XE), I try to run @apexins.sql.

It starts to run momentarily, then the MS-DOS windows just closes. Can not find any install log to determine the cause.

View 2 Replies View Related

Application Express :: Errors In Lib After 4.2 Upgrade

Jan 15, 2013

We have upgraded our environment to Apex 4.2.1. We have an older application that makes use of Apex Lib. We cannot remove Apex Lib from the application without a lot of work.

Apex Lib is now throwing an error:

in package apexlib_error procedure addApexValidationErrors WWV_Flow.g_validation_ids_in_error does not exist.

View 2 Replies View Related

Application Express Listener :: How To Upgrade From 1.1.4 To 2

Feb 18, 2013

how to upgrade Oracle apex listener from 1.1.4 to 2.We are using Oracle apex listener with Glassfish 3.1.2.

View 0 Replies View Related

Application Express :: 4.2.2 Upgrade Not Working?

Aug 7, 2013

We have upgraded our apex installation from APEX 4.0.2 to 4.2.2 and APEX listener to 2.0.2

Below is our configuration

Host 1 : Oracle databaseOracle database - 10.2.0.5APEX - 1.1.3
Host 2 : Apex listener on Weblogic serverWeblogic server - 10.3.5 APEX listener - 2.0.2

Post the upgrade , applications that were existing before the upgrade are not working properly.

Errors faced:1.When we edit any page in application - we get no data found error2.

When we run any application - We get no data found error We are able to create new applications without any issues.Luckily , we had the export backup of one application taken before upgrade. We imported that back( only one application ) and that application is working fine. We imported the application in apex.oracle.com as well and get the same error[URL]... occurs during page 'Edit' as well.

View 11 Replies View Related

Application Express :: Email Not Working After 4.1 Upgrade

Jun 11, 2012

O/S: Windows 2003
DB: 11gR1

Email no longer working for users after upgrading from 4.0 to 4.1. New 'principal' APEX_040100 added to same ACL as previous version's principal APEX_040000. In fact, both still exist in ACL.

Error code in APEX Admin Mail Queue: ORA-24247: network access denied by access control list (ACL)

What could be causing the email facility within APEX to no longer work?

View 1 Replies View Related

Application Express :: Upgrade Failed In Database From 10g To 11g

Jul 30, 2012

When we upgraded the database from 10g to 11g, Apex upgrade failed. Due to the failure, I removed the old schema and did a fresh install of Apex 4.1. It is working but we lost the applications from previous Apex.

What is the best strategy when you need both database and Apex upgrades? We are a Linux workshop, setting up Apex in Oracle Fusion Middleware 11g environment.

View 0 Replies View Related

Application Express :: Delete Message Not Displaying When Upgrade To 4.1

Jul 31, 2012

I am in the middle of upgrading my application to Apex 4.1 from 3.2.1. I have been using the default delete message and now it won't work.

<script langues="javascript" type ="text/javascript"
<!--
htmldb_delete_message='"DELETE_CONFRIM_MSG"';
//-->
</script>
button action

redirect to url ----> javascript:confirmDelete(htmldb_delete_message,'DELETE_RATING');

now all I receive is a message from the webpage, instead of the message.

View 4 Replies View Related

Application Express :: 4.2 Theme Upgrade - Best Way To Reorganize Pages

Nov 14, 2012

I have been given the task to modify our company's Apex from 4.1 to 4.2. The upgrade has been completed; in addition, the current UI, blue and tan has been updated to BlueJay. I have noticed the structure of the page gets shuffled as well as contents within modules. What would be the best way to "re-organize" my pages.

- Would it be easy for me modify the page, if so how do I do this. The settings look identical, so what would I change ?
- Do I recreate the entire page from scratch ?

View 15 Replies View Related

Application Express :: No Page Edit Functionality After Upgrade To 4.2.2?

Jul 12, 2013

Apex has been upgraded from 4.1 to 4.2.2. I don't know if the upgrade was done correct or not by the administrator, but I don't have the page edit link anymore,

and anytime I run a individual page from the Edit Application, I have to Log in. Did something went wrong during the upgrade or is this the behavior of Apex now, which I don't think so.

View 1 Replies View Related

Application Express :: 4.2.2 Upgrade Now Giving Apex_mail ORA_2427 ACL Error

Sep 30, 2013

We just upgraded to APEX 4.2.2.00.11 and we are getting ORA-24247: network access denied by access control list (ACL) errors form apex_mail. This had been working correctly prior to the upgrade.

View 4 Replies View Related

Application Express :: 4.2 Upgrade - Unable To Test Report Queries?

Apr 5, 2013

After upgrading to Apex 4.2 I'm now unable to test Report Queries. Each time I click on the Test Report button via Shared Components|Report Queries I recieve the following error message:

ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.

I still have Apex version 4.1 installed on a different server and it appears to be working fine.

View 1 Replies View Related

Application Express :: Installation (or Upgrade) Supporting Objects On Command Line

Mar 31, 2013

is it currently possible to install the supporting objects using sqlplus?

When I export an APEX application which contains supporting objects (scripts to install images, css files, tables and seed data) I can run this script on the command line using sqlplus to install the application into the target environment.

After installing the application (which works fine), I cannot invoke the installation of the supporting objects nor the upgrade of the the supporting objects.

Am I overlooking the obvious, have checked APEX_APPLICATION_INSTALL but there is no function available for that purpose?

View 0 Replies View Related

Application Express :: 4.2 Upgrade - Update Record Button Apply Changes Disappeared

Aug 27, 2012

I got a bug related to update information in APEX.

the situation occurs when I go to update a record the button Apply changes disappeared, it shows me only the button create, so when the user click on it, it creates a duplicate.. so how can i have the button "apply changes" back?

View 7 Replies View Related

Application Express :: 4.2 Upgrade - Static File Upload Mim - Type Error?

Apr 17, 2013

After Upgrading to Apex 4.2

When uploading a static text/javascript file (i.e. filename = 'thisFile.js') the file Mime Type defaults to 'application/octet-stream' (instead of 'text/javascript'). This issue occurs in I.E. 8 but not in Firefox.

View 0 Replies View Related

Application Express :: JQuery Mobile Layout Grid Not Working After 4.2 Upgrade

Nov 4, 2012

I'm running a mobile application on a hosted Apex environment which uses lots of jQuery mobile. The environment has been updated to 4.2 recently, and since that happened pages that I had setup to use the content grid, to show content in 3 columns no longer works, there only appears to be 1 column now.

Code as below: -
<div class="ui-grid-b">
<div class="ui-block-a">Block A</div>
<div class="ui-block-b">Block B</div>
<div class="ui-block-c">Block C</div>
[code]........

View 1 Replies View Related

Application Express :: Failed To Load Background Images After Upgrade To 4.1.1 In Mozilla Firefox

Aug 27, 2012

I have recently upgraded our test APEX environment from 3.2.1 to 4.1.1.00.23. Everything went smoothly - I have only one small but annoying problem. In both administration and administration services some background graphics are not displayed. This issue occurs only under Mozilla Firefox (in MS IE it OK). The application frontend is OK in both browsers.

Under Firefox, I inspected the sourcecode in Firebug and the relative links to images. e.g.

background: url("../apex/builder/bg-region-darkblue-r.gif") no-repeat scroll

show message "Failed to load the given URL".

somehow related to the fact that our application is accessed via apache proxy. Because when I open the administration and/or administration services page in FF directly on the server, it displays correctly (incl. images).

But the network (Apache proxy) configuration is exactly the same as in the previous version of APEX where we had no problem. Something must have changed in the sourcecode of the new version.

View 3 Replies View Related

Upgrade :: Oracle 11.2.0.3.0 Database Upgrade Changes DATA_PUMP_DIR

Jun 6, 2012

Along with existing RMAN backups we do Exports - of our DB using and OS User and Oracle Wallet.Of the DB's we have upgraded the Data Pump Directory

Select * from dba_directories; (there are other commands to get this info as well).

I captured screens from the DBUA upgrades, but did not see an option to change this information.Is there a way to feed this information to the install moving forward. IE, ./DBUA -silent ?

Also, anyone tracked the percentage of storage increase from 10.2/11.1 to 11.2.

View 4 Replies View Related

Upgrade :: Patchset Number To Upgrade Oracle

Jun 14, 2012

Know the Patch set number to upgrade a Oracle 10.2.0.1 to 10.2.0.5 on Solaris 10 Spark 64bits?

View 1 Replies View Related

Upgrade :: Oracle Upgrade 11.1.0.7 To 11.2.0.3 - Compatible

Jul 19, 2013

I am going to upgrade database from 11.1.0.7 to 11.2.0.3

1) If compatible is set to 10.2.0 in 11.2.0.3, will it work ?
2) If compatible set to maximum level, will it affect our application ?
3) Whether any code related problem occurred after upgrading like PL/SQL codes ?

View 6 Replies View Related

Upgrade :: Oracle Database Upgrade

Mar 13, 2013

We are planning to upgrade our database from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi to Oracle Standard Edition 11g . We also have oracle apex installed on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi database with oracle apex 3.1

No our plan to upgrade the database and oracle apex to 4.2. Since Oracle Enterprise Edition is licensing is very expensive we though of buying standard edition and upgrade to this version.

can we upgrade the oracle database from enterprise edition to latest standard edition?

View 3 Replies View Related

Application Express :: How To Protect Oracle Application From Code Edit On Client Side Installation

Sep 12, 2013

We have developed an application for our clients,planning to deploy it in client server soon. we have plans to support the application in future,so we want to restrict the clients from any modifications. By Doubt is, 'build_status=Run only' alone,cannot protect our application from client developers to edit our application,

Because though we install our application as 'Run Only' at the time of installation in client instance,we can still import the original application and change the type to 'Build and Run Application',and run the new application as 'Build and Run'.(which is not supposed to) we want to make sure,if there is any way we can protect our application from modifications after client side installation.  

View 1 Replies View Related

Application Express :: Downloading Oracle 11g And Then Oracle APEX

Aug 7, 2012

This time i am downloading the Oracle 11g and then the Oracle APEX...(they are not in one package...right ? i mean they both have to download separately)i really new in oracle / PL/SQL. I'm not a programmer but i interest about database programming.For now i still use Ms. Access to develop an aplication and i really suprised i found this Oracle APEX because it an RAD tool too same as Access but more powerfull i think.

View 2 Replies View Related

Upgrade :: Oracle 10g To 11g Upgrade

Feb 21, 2013

I am trying to come up with a plan for an upgrade that is needed for a server I maintain. It is a Windows 2003 32bit running Oracle 10.2.0.3 on old Hardware. It also has two obscure 3rd party applications that are running on it that directly access the database. These applications are supported by off site consultants.

My initial plan was to Create a Windows 2008 R2 Virtual Server and install the same version of Oracle 10.2.0.3. Using Rman clone the database to the new server. Have the consultants come in and get the applications working. Once everything in the new environment seems to be working fine, run RMAN again and reclone the database to have all the latest data. Then at a later time upgrade the database to 11g 32bit. Virtually no downtime and we could spend all the time we needed getting the applications working and testing the new environment.

The plan is dead right of the bat though because I realize 10.2.0.3 is not supported by Windows 2008 R2. I really did not want to add an Oracle DB upgrade into the mix at the same time. Just because their are so many changes from the old environment to the new that I want to break this down into manageable chunks. And I can maybe get by with 1 day of down time.

So now I am looking at installing 11g on my Virtual Server, Clone the database, upgrade the database, have the consultants come in and get the applications working. All the while we are down. If we run into any problems, which you always do, it just completely blows the schedule.

View 1 Replies View Related

Upgrade :: Oracle Upgrade 10.2.0.5 Non-ASM 11.2.0.3 ASM?

Jun 29, 2012

I need to upgrade our current system 10.2.0.5 (non Asm) to 11.2.0.3(ASM) on the same host.

So a few options : install ASM on current 10.2.0.5, create volumes etc and shift DB into ASM

upgrade to 11.2.0.3 GI - standalone

upgrade DB to 11.2.0.3

install 11.2.0.3 GI, configure ASM and run against 10.2.0.5

DB upgrade DB to 11.2.0.3

The DB upgrade has to come last I've been told.

View 1 Replies View Related

Application Express :: Oracle XE In Production

Jan 1, 2013

I am trying to use the APEX (as a substitute for my PHP forms base application) for a new client. Can I use the APEX and Oracle XE in production, without spending any money for a license from Oracle - i.e. for listener, Web server, etc,?

I already have setup the APEX that works fine on my laptop, able to see and work with the form on the browser, so can I take the same to a server as a production?

View 4 Replies View Related

Application Express :: How To Get Online With Oracle

Dec 17, 2012

I am going for a presentation at my University. But the students are not very interested in Oracle or Databases. So I need a title for the Apex topic which gets the other students to visit my presentation.

The presentation should show the basics of apex and how to earn money with this.I thought of:

1) Oracle in the world of Web 2.0

2) How to get online with Oracle

3) What to show if some1 tells you Access is a Database

4) Oracle in a drag and drop environment even for developers

5) Best of Breed: Oracle SQL / PL/SQL, HTML, XML and Java in a nutshell

View 8 Replies View Related

Application Express :: 4.2 Configuration With Oracle EBS R12

May 21, 2013

Tried installing APEX 4.2 with Oracle EBS 12.1.3. I have installed APEX into the Oracle EBS database (11.2.0.3)

I am trying to install the APEX listener on the Web Tier however it starts the listener and gives the url as

[URL]........

Is there a way to set this with actual hostname of the server.

View 2 Replies View Related

Export Whole Workspace From Oracle Application Express

Nov 24, 2012

I need to export my whole workspace/application from Oracle Application Express so if i was to move onto a new pc and install oracle again. I can import this file and everything will be as it was without need of editing anything.

Is this possible if so how? - Preferably export into 1 big file so importing will be with 1 mouse click instead of exporting to seperate database files etc.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved