Application Express :: Install 3.0.1 On RDBMS 11gR2?
Sep 19, 2012
if it is possible to install APEX version 3.0.1 on oracle database version 11.2.0.3? We currently have a 10g database with APEX 3.0.1 installed. Now for an upgrade project we need install the latest database version. Unfortunately we do not have enought time to migrate the APEX application. Therefore the APEX version should stay the same.
So any experiences with APEX 3.0.1 and RDBMS 11.2?(I searched for oracle documentation but couldn't find anything useful.)
I read the manual, searched the Forum and Googled, but I can't get websheets demo app to install. No matter what I try, I get "The database objects required to create Websheet applications are either invalid or do not exist." I tried: Create Application -> Websheet. Get message "Invalid Websheet Objects". I then click in that window ate bottom "install sample applications". Chose AnyCo IT Department -> install application -> Get message "Invalid Websheet Objects"
And round and round we go.
I checked in the instance that "Feature Configuration" is set to "Yes"
Note: I have created a new workspace and that one works ok. I can load websheet applications.
I have installed Oracle 11g XE with Apex 4.2 and I want to upgrade it to the apex 4.2.2. However, I do not have access to My Oracle connect. How do I uninstall apex 4.2 and install apex 4.2.2 full version from OTN?
We just did an upgrade to 4.2 on a new WebLogic server. We are using the latest Apex Listener as well.The install seemed to go well (no errors during the DBA install) and we configured the Listener to connect to the database using the basic connection settings.I was able to login to the Admin console and create my workspace and users, but I cannot even get the workspace login screen to appear.All we get it is:
Error Error processing request. ORA-01403: no data found
This is the only thing that shows up when going to the default Apex URL....
We are unable to connect our admin account for some unknown reason. We keep receiving the following message "Invalid Login Credentials". We tried to change the admin credentials with sqlplus. We tried the usual procedure "apxchpwd" successfully, but we still cannot log in.We then tried to create a new admin2 account with the following pl/sql block.
SQL> connect APEX_030200 as sysdba Enter password: Connected. [code]....
I am trying to install ORACLE 11gR2 RAC on CentOS 5.5 .
when run root.sh on first node. I am gettign 2/3 failed command lines but the end went successful
======================================================================= ohasd is starting ADVM/ACFS is not supported on centos-release-5-5.el5.centos ... add nodeapps -n perflabhp03 -A perflabhp03-vip/255.255.254.0/eth0 on node=perflabhp03 ... failed ... PRCR-1001 : Resource ora.net1.network does not exist add scan=perflab-cluster-scan ... failed, Configure Oracle Grid Infrastructure for a Cluster ... failed ... 'UpdateNodeList' was successful. =========================================================================
Because of this output, when see the ./crsctl stat res -t , it showing LISTENER offline for perflahp03, and I can not see any status line for "perflabhp03-vip " and "Scan-listener".
Do I need to reinstall the entire cluster setup because of VIP issue?
I've inherited a 10.2 instance here in Kuwait and I'm attempting to migrate to a brand new server; I downloaded and attempted to install 11gR2 (11.2.0.1.0) on my brand new HP clean and patched server running Windows 2008 R2 Enterprise.
I've tried clean install, re-install, install software first then database, install all together, a complete default install (other than putting the database on a different drive letter)... every time I get the same error-
Enterprise manager configuration succeeded with the following warning -
Error starting database control. Please execute the following command(s)
1) Set the environment variable ORACLE_UNQNAME to database unique name
2) ...emctl start dbconsole
There is plenty about this on the internet, google, forums. Some suggest dropping and reconfig of EM; tried that. One error leads to another error and I think I'm getting close, then some other error, more obscure than the last. VERY FRUSTRATING!
- Is this distribution broken?
- Should I try the 32-bit or just install and run the 10.2 on my brand new 64-bit server (that kinda hurts my head but I bet it would work!)
I've tried numerous re-boots, several fresh clean installs (after using the Oracle uninstaller and cleaning out the registry and deleting old files), I've set every environmental variable that I can in the system variables section including ORACLE_HOSTNAME, ORACLE_SID and ORACLE_UNQNAME.
I've tried unlocking SYSTEM and SYSMAN user accounts, I've deconfig'd the EM and have recreated the repository, reconfig'd...
Database is installed and working find. SQL plus is working and fine. It's just EM that's broken and I... just... can't... fix... it.Web page for EM starts just fine... log in (oddly, won't let me log in as SYSDBA from the web) then throws this error:
Error Internal Error has occurred. Check the log file for details.
The log files are pages long and I'm not sure what I'm looking at.
- Install different distro (like the 32-bit 11g)
- Install 10.2 and get on with my life- maybe upgrade later
I am working on SLES 11 SP2 on zLinux and I am trying to install oracle 11gr2 silently. I was able to install the GI and it is running but when I try to install the oracle binaries I keep getting this error:
[FATAL] [INS-32035] Unable to create a new central inventory directory : /opt/oraInventory. CAUSE: The central inventory location provided is not empty.
The GI install created /opt/oraInventory and all the files are in there. I even changed the owner from grid:oinstall to oracle:oinstall but that did not work. When I did the install on SLES 11 SP1 I did not get this error.
We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.
When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.
The APEX listener appears to be more than just a Java PL/SQL gateway.
Is there a minimum version of APEX the APEX Listener supports?
We try to upgrade the 10g to 11g oracle instance and asm instance.Below steps we r done;
1)First we are install the 11.2.0.3 database and grid infrastructure in separate home.
2)after that i try to upgrade asm instance so i drop old 10g asm localconfig cd $ORACLE10g_HOME./localconfig deletecd $ORACLE11g_HOME./localconfig add but here i can not find localconfig Note:database and grid installed without error....
3)Even we are try dbua but it run 10g dbua we are not able to run dbua for 11g
4)inventory is corrupted how to recreate inventory
5)provide the steps for upgrade 10g asm to 11g asm
I am a oracle DBA with 2 and a half year experience.What I am hearing is some new tech nosql database which will take over from rdbms databases in a few years time. Is it true and can nosql used for OLTp environments.
I am installing oracle 11g under ubuntu 12.10(32bits) and getting an error 'all_no_orcl' 'ins.rdbms.mk'. It occurs when it tries to invoke the file.my laptop is 32 bits, 30.7 hd, 1.5 GB ram, 2MB cahe. The OS is installed on an external drive.
I have two Oracle databases (test1- 10gr2,test2 - 11gr2) on rhel 5.5. is it possible to find which particular oracle process belongs to which home from OS level. was trying to find which db processes are consuming more resources on my host.
Environment: Oracle RDBMS 10g R2. DB OS: HP Itanium
We use Oracle EBS R12.1.2 in our company and one of the analyst reported performance with saving the configuration in Pricing module. The common fix is to gather stats on BOM_EXPLOSIONS table. Recently, when the issue occurred I collected statistics on the table. The performance didnt improve. I went ahead and decided to trace the Oracle form session using the profile 'Initialization SQL Statement - Custom" at user level.
I also monitored the session in OEM 10g grid. The analyst performed the same set of steps and the performance was normal and acceptable. Analyst tried again and performance was matching with the expectation. I cleared the trace profile and analyst tried again. This time analyst had worse performance as the original issue. The issue got fixed later part of the day on its own. This has made me curious and thought to discuss it here.
I have had similar experience with 10g and 11g, when I enable the trace on the issue cannot be reproduced and when trace is off the issue pops back up.
I am new to this forum. I want to install XE 11g Release 2 in windows 7 64 bit. Can I intall 'Oracle Database Express Edition 11g Release 2 for Windows x32' or is there is 64bit version?
i am on RAC 11G R2 RHEL 5 , when i install rac can i run root.sh on all nodes in parallel ? or do i have to wait for first node to finish root.sh completely and then i shud run root.sh on second node and so on on third node
I have a deadlock trace file to analyse and i used to be able to see the rowid as a 16 bit hex value in the trace file, which i could then query on to get the actual real world row name.I see in the 11GR2 deadlock trace the formatting is different and for the life of me i am unable to see the rowid. Has Oracle stopped reporting this now, or is their another way to get this value? The deadlock graph shows me
I am trying to apply 11.2.0.2.5 psu on a 2-node cluster running on RHEL 5.5 vms. Followed ORACLE-BASE examples when installed this laptop RAC. I am not using any ACFS and none of GI and DB homes are shared. But, on node 2, cluvfy THINKS database home is shared.
I've just patched a development oracle environment (RAC 11GR2) with temporary patch 8730312. I would like to do same thing on Production RAC. Is it necessary to test all applications on dev environment with this kind of patch before deploy it on Production ?
I have recently setup a 2 node Rac on oracle linux 5.4 with oracel 11gR2, the installation went smoothly and all the cluster resources are up and running however the data is not syncing across the nodes, when I create a table it shows up on the other node but when I insert rows into the tables they don't show up on the other node and when I restart the cluster the inserted rows are completely gone even from the node where I inserted them.
We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.
The three header variables which are configure in OAM right now are: Header variable name Value 1. OAM_REMOTE_USER $user.userid 2. OAM_REMOTE_USER_EMAIL $user.attr.mail 3. OAM_REMOTE_USER_GROUPS $user.groups
We need an additional header variable as mentioned below: Header variable name: OAM_SAMACCOUNTNAME Value: $user.attr.samaccountname
The new header variable was added in the OHS server's dads.conf file like shown below: =========== dads.conf ============= ... PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME
But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable: =================== begin :P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' ); end;
The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.
I have multiple application set-up using session sharing within the workspace.Technically all works fine, however it does not play nice with user behaviour.
Example: Users logs into APP_ID:100. Since he isn't authenticated yet, he provides user/pass and the APP_SESSION is authenticated. Now if the user switches using to another application (using a link provided in application 100) he gets redirect to APP_ID:101:APP_SESSION all is fine.
The session is already authenticated, the application shares the session and the user gains access to app 101 without having to authenticate again. All's fine!
However users don't behave they way. Instead of using an easy link in the application. They will use their own bookmark or type in the url for app 101 manually. That way the next application is either called with f?p=101:1:[SOME OLD SESSIONID FROM BOOMARK] or f?p=101 (with no further page or session info) In both cases instead of using the already authenticated session apex spawns a new session, which of course isn't authenticated yet thus forcing the user to authenticate and come complaining they have to login again.
Similar behaviour problems exists when the user opens a browser and tries to open both applications in each in a tab next to each other.Both tabs fetch there own initial session id and start writing it to the same cookie each in turn invalidating the other tab's session.These can lead to some fanatic ping pong actions. Thus it's impossible to open 2 applications sharing session in the same browser.
Is there any remedy for these situations?Can apex be as smart as for instance first trying to resume the session stored in the cookie and only if that session is invalid, start a new session?
how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...
When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:
<input type="checkbox" name="*f10*" value="3" />
And this one stands for array name "g_*f10*".However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly.
