GlassFish DNS mapping - ORDS, SODA & JSON in the Database

Hello,
Again but now for the GlassFishv3.
How can I map a domain name www.mydomain.com to Oracle APEX applications.
I have more than domain name, each domain name should go to its apex application.
www.domain111.com www.domain111.com/apex/f?p=111:1
www.domain222.com www.domain222.com/apex/f?p=222:1
www.domain333.com www.domain333.com/apex/f?p=333:1
All domains assigned to one IP address, the IP address assigned to the server I run.
My build:
Oracle Database SE1 11.2
Oracle APEX 4.0
Oracle Listener 1
JDK 6u20
Thanks,
Fadi. 

You should check in the glassfish doc/forums on url rewriting. This is not a feature of the listener.
-kris 

Kris,
The reason I posted this question here that I have checked every single thread on glassfish and redirect, none of them addressing the way to do it for APEX.
I can redirect normal php, html, (web file) but this is much different from what APEX use ( there is no page or file directory).
Redirect is essential for public website, I think it's very helpful if you put few lines how implementing an APEX URL redirect using galssfish server.
thanks,
Fadi. 

Sorry , I can't help much here. This is what I found in a few minute on google but not sure if it will do what you need.
http://serverfault.com/questions/169643/how-can-i-rewrite-redirect-urls-in-glassfish-v3
-kris 

I still cant find a solution... I asked in a diferent thread Re: Need to make an app URL as default for a domain and got not a very informative reply. There must be someone who has done this? 

I updated the broken references in the thread you opened before. I personally have used the proxy approach I suggested there.
Please ask, if you have need additional information on how to implement it, if the referenced thread doesn't give you the details you need.
-Udo
P.S.: I suggest to proceed in your original thread.

Related

|Apex Listner and Custom Authentication

Hi All,
I have spent a long time looking through the forums and beyond, but cannot seem to get to the bottom of this.
I have recently installed Apex Listener (on glassfish) with Apex 4 and 10g on an XP box, and it all works fine. However, when I import an application that was developed using EPG, I cannot log into it, getting the following message:
Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.
     Error      ERR-7621 Could not determine workspace for application (:) on application accept.
OK      The application uses custom authentication and authorisation, maintaining info in session.
I am suspicious that the environment will not let me store a cookie, but I'm not sure. It is a little frustrating, because I wanted to simply use the recommended default configuration for Apex 4. i.e. using the listener. However, now at customer site and just losing so much time on this.
Can anybody help?
thanks
paul 
I guess no one has the answer to this or even a thought ...
or nothing helpful at all.
Thats really disappointing.
I will have to go back to EPG or APache.
Why bother with the big hollbollo about the listener .... 
Hi PJ,
what is the exact version of APEX? And does your application use a page sentry function for custom authentication?
Does your application work when you call it through EPG/mod_plsql? Does only the APEX listener call fail?
Regards
Patrick
-----------
My Blog: http://www.inside-oracle-apex.com
APEX 4.0 Plug-Ins: http://apex.oracle.com/plugins
Twitter: http://www.twitter.com/patrickwolf 
Patrick
Thanks for the reply. The problem has been fixed when I upgraded to 4.0.2.00.07.
Paul

Workspaces in APEX

Hello,
I've successfully installed APEX with the following arquithecture:
APEX 4.0.2 en
Oracle 11gR2 on RAC
Windows Server 2008 x64
Weblogic with Oracle Application Express Listener
My question is: Is it possible to create an workspace using a different database? Other than the one that has the APEX_PUBLIC_USER, APEX_040000.
Thanks,
Edited by: neoon on 9/Mai/2011 4:39 
Hello,
with "database" you refer to "schema", right?
Usually, you'll be asked to asked to assign an existing or new schema to your new workspace, so I assume you haven't created a workspace yet.
Login to the APEX internal administration (http://yourhost:yourport/apex/apex_admin) as admin, go to "Manage Workspaces" and start the "Create Workspace" wizard.
For existing workspaces, you can add additional schemas to be available for application development in APEX. The wizard can be found in "Manage Workspaces" > "Manage Workspace to Schema Assignments".
Note that this is a general APEX question, whereas this forum is dedicated to the APEX Listener.
If you need additional information on how to use APEX, please post in {forum:id=137}
Thanks,
-Udo 
Hi,
Thanks for the reply.
But when i mean database i mean database not schema. :o)
Is it possible?
Regards, 
Hi,
no, APEX can only access schemas in the same database instance you have that APEX installed to. If you want to access a different database instance, you need to install APEX there. Of course, you can deploy or start a second APEX Listener instance that points to this second database instance.
To access data in different database instances, you'll have to use 'conventional' means like database links. Of course, you could also use APEX Listeners Resource Templates to include certain data from a second instance in an application located in your primary instance.
-Udo 
Thanks for the reply.
tell me one more thing... if you know.
how can i change the Service Name on Oracle Application Listener?
It is "blocked".
thanks, 
Actually, the database configuration is the only "read only" item in listenerAdmin. This is due to the fact that once you've configured the connection parameters, you have a living connection pool you'd have to reset. This might cause more trouble as this reset might be seen as an invisible side-effect and may not even be supported without application restart on some platforms.
You need to stop the APEX Listener instance, edit the corresponding parameter in the apex-config.xml, and start the Listener again.
You'll find the apex-config.xml in +${java.io.tmpdir}/apex+ if you haven't configured the application to use a different location.
-Udo 
Thanks for the reply.
But how do i stop the listener service?
This is new to me.
Regards, 
Well, the Listener is just one application in your WLS.
I'm not sure which WLS version you use, but here is a good step-by-step description for starting/stopping applications in WLS: http://download.oracle.com/docs/cd/E12839_01/apirefs.1111/e13952/taskhelp/applications/StopDeployedEnterpriseApplications.html
-Udo 
Thanks for the reply again
ok i use weblogic and already stoped the service. know i have to figure out where is the apex-config.xml.
Man this is hard...
Many thanks 
Hello,
I just can't find apex-config.xml
This is horrible 
Hello again,
it should be in your "java.io.tmpdir". If you didn't configure any special value for that environment variable, it'll be on its default. However, I assume you've already run a file system search for that file. As far as I know, WLS cleans up tmpdir on restart. I wasn't sure if this happens when the application is stopped or when it is started again - probably it happens in both cases to ensure the application doesn't hit old temporary content.
If this is true, you need to start the application again and configure it for your desired instance. You should find the apex-config.xml afterwards. Make a copy of it to some place outside the tmp. Then start to configure the APEX Listener to use a different place for storing/searching the config file, because you'll obviously lose the configuration every time your temp is cleaned up otherwhise, and this might not only be on restart, but also after a certain period of time.
For details on configuring, see section A-1 of the "Installation and Developer Guide" for the APEX Listener or Colm's post: {message:id=9533521} (or some other post concerning the config file location - you'll find plenty here).
-Udo 
Men... you have been very helpfull 
You're welcome - that's what this forum is supposed to be. ;)
I'm glad about every user who starts to use APEX Listener, so I'm glad to hear you get it running.
-Udo 
Aaarrrggghhh,
What am i doing wrong?
We have changed the apex.war to apex_2.war to correct the issue with the apex-config.xml.
Unwar the file changed the web.xml on the config.dir, uncomment and changed the dir to: D:/Applics/BI. And then war again.
And now it stop showing the beautifull login page of the Oracle Application Listener. Better, it shows a web page with no icons, only the items in the listenerConfigure page. And gives me an error when i try to Apply the values that i give in.
Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException
Help please 
it seems that, some away, ive locked APEX_PUBLIC_USER and FLOWS_40000.
Solution unlock these users
Problem solved.
Thanks again Udo

Create .war with APEX images

I have problems with the deployment of the created i.war with the APEX images.
I create i.war according the listener guide:
jar –cvf0 <temp directory>\i.war –C <apex directory>\images .
When I deploy this file in a OC4J standalone environment then it gives me an error message: unknown format.
Do I need to use a web.xml and/or application.xml and what should be the contents? 
Hello,
it seems you've run into the common copy&paste problem with the hyphen. Please try the following command (using a "minus" instead)
jar -cvf0 <temp directory>\i.war -C <apex directory>\images .-Udo
P.S.: You can also map the images (and other static files) by configuring a virtual directory mapping in OC4Js orion-web.xml. I'd recommend this at least if you use custom contents. See the [url http://docs.oracle.com/cd/B31017_01/web.1013/b28959/xmlfiles.htm#CJACEDDD]OC4J documentation on that parameter. 
I see a lot of orion-web.xml. Which one should I change? 
That depends on your OC4J (which is probably why it is not part of the documentation for APEX Listener)...
$ORACLE_HOME/j2ee/home/application-deployments/default/defaultWebApp
If you use the "home" container and still have the default application in it (including the "Welcome to Oracle Containers..."-page), you could even just copy the images into that context
$ORACLE_HOME/j2ee/home/default-web-app
-Udo 
Udo,
Thanks, this helped.
Does this directory also exist in a full OAS environment?
Ron 
Hi Ron,
usually it does. But depending on your OAS setup you might not only have the home-"island", but another one that is intended for non-administrative applications.
If you have the full OAS installed, you might as well put the images onto the OHS and configure this as (reverse) proxy for the APEX instance. This is what we do at customers that use OAS just for Forms/Discoverer and run a different JEE container where APEX Listener is deployed. That way you have a single interface to the client.
-Udo
P.S.: If your question is answered, don't forget to close this thread and mark any helpful or correct answer accrondingly, so other users searching this forum can spot relevant posts easily.
Thanks! 
Hi Udo,
I don't have experience with the full OAS, so I don't know waht you mean by "you might as well put the images onto the OHS and configure this as (reverse) proxy for the APEX instance".
What is OHS and reverse proxy?
Best regards,
Ron 
Hi Ron,
OHS is short for Oracle HTTP Server, which is the HTTP Server component usually included in OAS (if not disabled).
Since the OHS is based on Apache HTTP Server, you can configure it to act as HTTP proxy using mod_proxy. This means it acts as front end towards clients and forwards requests to the APEX Listener on their behalf. Additionally it can be used to serve static contents, as any Apache HTTP Server can - simply out of the "htdocs".
-Udo 
Hi, can you help me? I Also would like to use OAS to control the APEX, in the same way that today it is controlling all systems that we have already developed using Forms/Reports.
My OAS was configured different from the default. I have two FARMS in OAServer Console. The first one is INFRA and the second one is FORMS.
I have already tried to install the APEX in this environment with Oracle Support Help (MyOracleSupoort), but they don't give suggestions different from the ones that they considered as 'standards':
Standalone, configurating a private https or apexlistener. In other words, they don't accept the use o OAS to also control APEX. But as we now, it is a Apache server...
I would like to create another Entrance, besides the ones that I already have (Infra and Forms). Thus I would have INFRA, FORMS and APEX.
Of course, to the APEX area I also have to configure everything to be accessed in Intranet and/or Internet.
Do you have any document that explain how to proceed? Can you help me??? 
Hi,
can you help me?I'll try. But your question seems to be different from the topic discussed in that thread. Please open your own thread instead of "hijacking" this one, especially because it has been marked as answered by the original poster before.
Thanks,
Udo

The URL from Apex Listener.

Hi everybody!
I set up my Apex Listener in a Standalone Mode
How can I set up my URL with my words such as: http:/localhost:8585/myapplication/f?.......
replace for the default URL: http:/localhost:8585/apex/f?.......
I don't know where my DAD is, and how many steps should I do to complete this changes?
And how about
http://localhost:8585/apex" or "http://localhost:8585/apex/apex_admin?
Thanks for any help. 
Hi,
the APEX Listener has fixed (hard coded) contexts in Standalone Mode, so you can't do that. Either deploy the war file to a regular JEE server where you can choose the context, or put a HTTP (reverse) proxy in front to do the switch for you.
Note that Standalone Mode is not intended to be used for productive deployments, but for testing and development purposes only.
-Udo 
thanks very much Udo! 
I'm glad I could help.
Please mark this thread as answered and any helpful or correct answer accordingly, so other users searching the forum might spot relevant posts easily.
Thanks,
Udo

listenerAdmin not working in WebLogic

I seem to be having the same issue that folks are having within the Glassfish server. I've configured the APEX listener on WebLogic 11g (10.3.5). Followed the instructions to create the adminlistener and managerlistener and their respective groups: Admin and Manager and assigned the users apppropriately (followed the installation instructions). I've used listenerConfig to configure the listener but when trying to access listenerAdmin URL I get the dreaded 403 error. Any help would be appreciated.
Thanks,
Jack 
Hi Jack,
could you post some additional information of what exactly you did and which version of APEX Listener you use?
And did you try to reset your browsers authentication cache? As I've learned when investigating similar problems (also discussed here) both listenerStatus and listenerAdmin use the same realm for basic authentication ("APEX"). If your browser stores your authentication information for one of these realms (which it usually does) and you try to enter the other part, it resends these information, which can lead to a 403 (as discussed in Link http://localhost:8080/apex/listenerConfigure not working).
Possibly this caching is even instance-independent (as the realm doesn't include any host/instance/... information), so if you've entered different credentials for another instance, this could be an explanation as well. Could you try to erase any entry concerning APEX Listener from your browser cache? Or try a different browser you ususally don't use, perhaps even a portable version of Firefox or something like that, where you can be sure you have a fresh start and can safely abandon everything once you've done?
The latter case would only be relevant if you aren't even asked before you get the 403. So the question is: Can you enter the credentials at all, or do you get the 403 right away?
Another possibility: Did you try with a simple password (without any special character)? And did you restart your WLS after adding those users? Possibly these changes aren't effective immediately.
-Udo 
Thanks for the quick reply Udo. From the looks of it, you must live in this forum.
I resolved my problem. The documentation says to create roles called Admin and Manager but when I looked into the web.xml file to verify that I was typing things in correctly, it says that the two roles are ApexAdmin and ApexManager. :(
I made the adjustment in the console and voila, it worked. By the way, I'm using Apex Listener version 1.1.3.243.11.40 
Hello,
From the looks of it, you must live in this forum. Well, it's more like there's not very much other users are watching it...
I resolved my problem. The documentation says to create roles called Admin and Manager but when I looked into the web.xml file to verify that I was typing things in correctly, it says that the two roles are ApexAdmin and ApexManager. :(That's strange. Where did you get the file from? It's definetly not the original web.xml. The one you get from OTN download actually fits to the documentation. I just did a download and re-checked that everything's still as it should be...
I made the adjustment in the console and voila, it worked.Great to hear that, anyway! ;)
Have fun using APEX Listener!
-Udo
P.S.: Please mark this thread as answered and any helpful or correct answer accordingly, so other users searching the forum for a similar problem can spot relevant posts easily. Thanks!

Categories

Resources