Application Express :: Installation On Oracle11gXE Database
Aug 27, 2012I 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 RepliesI 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 RepliesO/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.
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?
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.
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?
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,
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.
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 ?
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?
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?
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
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
How can I copy Team Development from database to another database
View 3 Replies View RelatedIs 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 RelatedI 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 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.
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.
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 RelatedI 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 RelatedWhen 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 RelatedI 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 RelatedThere 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 ?
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
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 RelatedI 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..
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 ?
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!
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 RelatedI 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]....
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.