Application Express :: Installation On Oracle11gXE Database

Aug 27, 2012

I tried installing application express on oracle11gxe database.I running the scripts apexins and I got an error message SP2-0024: Nothing to change.

View 1 Replies


ADVERTISEMENT

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

Installation :: Oracle Database Express And Other Editions Installation Doc Difference?

Mar 20, 2013

My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...

I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.

So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...

That is for express version only.

My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?

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 :: 4.2 - Packaged Application Installation Error

Nov 9, 2012

URL....The upgade from 4.0 to 4.2 went fine, existing applications work, Builder works fine. But none of the packaged applications install, all of them fail with that error. Is there some post-upgrade step to complete to get this to work?

Also, it doesn't appear like we can select the application id when installing these applications! Our environment has a convention, of sorts, for application ids. Is there a way to over-ride the app id?

View 14 Replies View Related

Application Express :: General Apex Single Standalone Installation

Apr 29, 2013

Our goal is to create an light weight packaged application and provide to any customers who wants to install and use the tool.

Can an application with database be built on Apex and created as packaged installable, instead of hosting in any Application , middle and database server. A kind of quick, cost effective and light weight installation? If yes,

View 2 Replies View Related

Application Express :: Deploy Apex Environment - Installation And Configuration

Jun 5, 2012

We want to deploy an apex environment. I see that there are 3 methods for apex installation:

Scenario 1: Downloading from OTN and Configuring the Oracle Application Express Listener
Scenario 2: Downloading from OTN and Configuring the Embedded PL/SQL Gateway
Scenario 3: Downloading from OTN and Configuring Oracle HTTP Server

I think the applications that we will create in apex will have 50-100 users. We don't use RAC.

View 1 Replies View Related

Application Express :: Installation Of Oracle Developer 4.1 - Cannot See Administration Page

Sep 12, 2012

I am trying to install oracle developer days 4.1 to test the oracle apex 4.1. When I load the .ovf image into virtual box and launch it, I go to

[URL]........

but I cannot see the administration page, it doesn't show me anything. Is there any installations that I have to do or missed to make apex work ?

View 5 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 :: Changing Scenario To HTTP Server Or Listener From XE Installation?

Dec 4, 2012

I have installed Oracle 11g XE . After this , i have upgraded to Apex 4.2 All it's working fine, but..... by default XE installs and configure apex to use embebed pl/sql gateway.

In this scenario, the images are stored directly in the database within the oracle XML DB repository. This may be a problem because XE have a 11GB limit and my apex aplication is simple, but it may upload pictures for customers, etc, and in this schenma the pictures will consume space in the database instead consuming in the linux filesystem.Can i install HTTP server in a 11g XE and reconfigure apexr?, or can i change to apache+listener? or more easy....can i upload images outside the XML DB in my apex application easily?

View 1 Replies View Related

XE :: Installation Of Oracle Database 11g Express Edition On Ubuntu 12.10 LTS?

Mar 13, 2013

I am installed the Oracle database following the this link .

1.Downloaded 11g express edition

2.Created a new user 'oracle' under the group dba. Following steps are executed using this.

3.unzip oracle-xe-11.2.0-1.0.x86_64.rpm.zip and then Converted the rpm to the Ubuntu package

sudo alien --scripts -d oracle-xe-11.2.0-1.0.x86_64.rpm

4.Created /sbin/chkconfig file and added the entries as specified here

5.Created /etc/sysctl.d/60-oracle.conf and added the entries as specified in same link as above.

6.Below steps:

ln -s /usr/bin/awk /bin/awk
mkdir /var/lock/subsys
touch /var/lock/subsys/listener

7.sudo dpkg --install oracle-xe_11.2.0-2_amd64.deb (.deb generated in step 3)

8.sudo /etc/init.d/oracle-xe configure (left the default values as it is)

9.Set the following env variables in ~/.bashrc file

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe
export ORACLE_SID=XE
export NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export ORACLE_BASE=/u01/app/oracle
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin:$PATH

[code]....

Now when exectute any SQL statements on SQLplus, i end up with the following error

SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

I have increased the swap memory as specified in here

free -m
total used free shared buffers cached
Mem: 3901 3428 473 0 182 1988
-/+ buffers/cache: 1258 2643
Swap: 5066 0 5066

View 6 Replies View Related

Application Express :: Restarting APEX After Installation Configuration - Cannot Access Admin Screen?

Jul 20, 2012

I installed and configures APEX in standalone mode about 2 weeks ago and played with it for short time. Now after 2 weeks I came back to start where I left off but APex_admin page would not come up.

I did following tasks as were found on Installed Apex on Oracle 11g. But cannot access admin screen

SQL> SELECT STATUS FROM DBA_REGISTRY
2 WHERE COMP_ID = 'APEX';
STATUS
-----------
VALID
SQL> conn sys as sysdba
Enter password:

[code]...

warning me that XDB requires username password to be sent through insecure manner (Basic authetication without a secure connection

View 1 Replies View Related

Application Express :: Copy Team Development From Database To Another Database?

Feb 11, 2013

How can I copy Team Development from database to another database

View 3 Replies View Related

Application Express :: Database Authentication Via Database Link?

Jun 26, 2013

Is it possible to use Database authentication in APEX through database link, and how?Also is it posible to read roles from users through database link?

View 3 Replies View Related

Installation :: Oracle 11G Database For 64 Bit Windows Installation Error

May 6, 2013

I downloaded the 11G 64bit for windows and unzipped the files into one folder and ran the setup.exe as an administrator. It opened up the java screen and I chose, create and configure a database. Next screen I chose, Desktop Class, when I click next it dies. It does not show me teh next screen. I went to the appdata folder and saw this error but not sure what to do EXCEPTION_ACCESS_VIOLATION (0xc0000005).

View 10 Replies View Related

Application Express :: How To Connect Second Database From Another One

Apr 5, 2013

how can I connect a second database from another one?

Ex.My APEX application in a database instance DEVELOPER and I want to connect with tables in DEVELOPER_B instance.

View 4 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 :: Adding Users To A Database?

Nov 7, 2013

I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g. 

View 10 Replies View Related

Application Express :: Creating Procedure Using Database Package

Oct 23, 2012

I have created a procedure within a database package, but when I want to create a form based on procedure but I can't call it. I think that I have to use prefix, I am a beginner in database and I don't know how to do this.

View 4 Replies View Related

Application Express :: Database Monitor Module Missing In 4.2.2?

Jul 4, 2013

When login as a administrator, am unable to find the above in SQL Workshop / Utilities. it's not drop from 4.2.2 , very useful functions. 

View 2 Replies View Related

Application Express :: How To Retrieve Item Help Text From Database

May 23, 2013

I would like to let the customer edit the item help text. Is it possible to retrieve item help text from my own custom database table based via a PLSQL function call or something similar?

View 4 Replies View Related

Application Express :: Importing CSV Files To Database Backend

Dec 15, 2012

There is a report that is generated everyday in the .csv file format that i would want to load into the database. I want to completely automate this process. I don't want to use the load function available in APEX. I use APEX 3.2 Version.

What i mean by automation is that i will create the CSV file and automatically move to a location from which APEX can access the data. I would then write a procedure to fetch the content directly from CSV file and write to the database. What i need is the location from which APEX can access data directly ?

View 1 Replies View Related

Application Express :: 4.2 New Database Sessions Per Report Region?

Nov 22, 2012

Does version 4.2 create a new db session for each report run on a page?

The reason I ask is we have a page with 4 report regions, each querying a global temporary table that is populated in a 'Before Regions' page process. The first report displays the correct data, but the others return 'No Data Found' and it is because the Global Temporary Table has been cleared out following the first report. This did not happen in 4.1.

I know we should be using Apex Collections, and we will in future, but time is at a premium to get this live

View 3 Replies View Related

Application Express :: Validate Database Column Using Validations Tab?

Sep 11, 2012

I'm trying to validate a database column using the validations tab in APEX, the data entered will always be in 'A0000' format but i cannot work out how to set up the validation correctly

View 2 Replies View Related

Application Express :: Conditional Read Only That Saves To Database?

Nov 27, 2012

I have an item that does not save to the database.it is conditional read only based on the value in another column, when it is not read only it displays as a Select list.. then whatever is chosen triggers a dynamic action that sets other items.so setting it as a display only is not an option.

after upgrading from 4.0 to apex 4.2 this gives error:   Session state protection violation: This may be caused by manual alteration of protected page...

the only workaround I have found is to set the Read Only to none, then create a dynamic action that conditionally sets the field to disabled..This works, but my problem with it is that it looks different than the read only..read only was Black Text and no textbox..disabled is a text box with greyed out text that is hard to read for some of the users..

View 4 Replies View Related

Application Express :: Login User With Database Credential - Seen As APEX_PUBLIC_USER

Mar 29, 2013

I'm using Application Express 4.2.1.00.08

In the application, the authentication method used is the DB one, so the user (schema) must exist on the DB. This works fine.

For instance, I'm login as SCOTT

Creating the following query select upper(user) from dualshows that the real logged user is APEX_PUBLIC_USER and npot SCOTT.

How to create a connection with another "real" username ?

View 1 Replies View Related

Application Express :: Database Link Slows Down The Response Time

Jul 11, 2013

I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint and it worked when executed from

sql*plus or pl/sql developer.

It returns results in 3 seconds or even less. However, when i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins!

View 1 Replies View Related

Application Express :: Using A Variable Database Link For Interactive Report

Nov 5, 2013

I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?

View 8 Replies View Related

Application Express :: PDF File To Be Stored Directly In Database Using Jasper?

Jul 16, 2012

I am using jasper integration package ..from www.opal-consulting.de using apex 4 and i Am currently able to generate pdf invoice..using jasper and store in a database.. table.

I need to generate the pdf  invoice in the background ..without displaying in my screen..Without downloading on my machine..And  store directly into  the database table..

Below is my existing part of code..

DECLARE
l_blob BLOB;
l_mime_type VARCHAR2 (100);
l_blob2 BLOB;
l_mime_type2 VARCHAR2 (100);
mport varchar2(200);

[code]....

View 9 Replies View Related

Application Express :: Update Default Column Values In Database From Form

Sep 14, 2012

Application Express ver. 4.1

I have created a form. Some of the elements are hidden such as updated_by and update_date. I have provided the default values for these attributes as pl/sql expression in the "default section" (Application->page->edit page item). I am using the Process Row process that is automatically created when a form is created.

The problem is when I click the update button, the updated_by and update_date is passed as null values which throws an error from the database.

View 2 Replies View Related







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