Apex listener with Weblogic  server - ORDS, SODA & JSON in the Database

Hi Folks,
I am trying to configure the apex listener with weblogic
DB : 11.2
Apex : 4.0
Listener version : latest.
followed the document for configuring the listener.
when i am trying to access the page the page doesnt load properly and it doesnt accept the username and password.
Any kind of ideas would be very helpful.
Thanks,
Vamshi .D 

Vamshi,
I need more details. Which weblogic? Are there errs in the log file? Which page is "the page"? What username/password, database, listener admin , apex?
-kris 

Hi Kris,
Thanks for your reply.
I need more details. Which weblogic? Are there errs in the log file? Which page is "the page"? What username/password, database, listener admin , apex?
1. Weblogic Server 10.3
2. the page i am not sure for now will check and let you know.
3. apex_public_user user i am using and configure the apex listener.
i get the login page but the page doesnt load properly with images.
Thanks,
Vamshi .D 

This is the key >>>i get the login page but the page doesnt load properly with images.
You have setup the /i/ directory on your weberver. There should be some docroot where you need to make a /i/ and put all of apex's images into it.
-kris 

i have made the jar -czf0 i.war images directory and deployed it as application.
i faced the case you are saying back in days with Oracle http server but this is weblogic server
do you think i need to do some changes.
Thanks,
Vamshi .D 

You may want to ask over in the WLS forum. I'm not an expert on that so they may get you and answer quicker.
WebLogic Server - Upgrade / Install / Environment / Migration
-kris

Related

Apex listener images folder issue

Hi expert,
I'm newbies in oracle apex listener and would like to know more about oracle apex listener from all the expertise.
My situation is like that i would like to install apex listener (standalone mode) in a server to browser apex application from another server with oracle database 11g and oracle apex development.
My installation step as below;
1. I copy images folder from database server apex\images folder to apex listener installation folder before i install apex listener (called "apexlistener").
2. Run cmd "java -Dapex.home=c:\apexlistener -Dapex.images=c:\apexlistener\images -Dapex.port=8585 -Dapex.erase -jar c:\apexlistener\apex.war" to install apex listener.
Just a question, if i amended oracle apex application in database server, should i need to copy the images folder again to apex listener server?
What is the main source in images folder used in oracle apex listener server?
My experience is i tried to copy images folder from database server A with apex application (in runtime mode) to apexlistener folder server B. And i configure the database connection to server c with same oracle apex application as well. I tried to browser oracle apex application in server c from server B. I found out my apex application is not running properly due to the javascript is not installed properly. I would like to ask, is the images files in apex listener server must same with apex application server?
Anyone have idea on automatically start apex listener when the server reboots?
How to run apex listener in backend?
Hope can get some idea and solution from all the expertise!
Thanks in advance!
Best regards,
Apex Junior 
Hi,
Too many questions, and too little input, for one post.
I'm newbies in oracle apex listener and would like to know more about oracle apex listener from all the expertise.My situation is like that i would like to install apex listener (standalone mode) in a server to browser apex application from another server with oracle database 11g and oracle apex development.
My installation step as below;
1. I copy images folder from database server apex\images folder to apex listener installation folder before i install apex listener (called "apexlistener").
2. Run cmd "java -Dapex.home=c:\apexlistener -Dapex.images=c:\apexlistener\images -Dapex.port=8585 -Dapex.erase -jar c:\apexlistener\apex.war" to install apex listener.
Just a question, if i amended oracle apex application in database server, should i need to copy the images folder again to apex listener server?
>
The images folder has a relation with the Apex Version installed on the database, not with the applications in the Apex.
Depends on what you mean by amending applications. If you add custom CSS, JS ,etc to the application , and are not uploading the files to WORKSPACE_IMAGES, then you need to copy the external files to the images folder. But not copy it all over again.
If no custom files then no need to copy the images folder.
>
What is the main source in images folder used in oracle apex listener server?
>
The images folder, what else?
>
My experience is i tried to copy images folder from database server A with apex application (in runtime mode) to apexlistener folder server B. And i configure the database connection to server c with same oracle apex application as well. I tried to browser oracle apex application in server c from server B. I found out my apex application is not running properly due to the javascript is not installed properly. I would like to ask, is the images files in apex listener server must same with apex application server?
>
As stated earlier, the contents of the images (/i/) folder are related to the Apex Version. If your two db servers have different versions of Apex then the same images folder will not work with both. It will work with only one, the one that has the Apex Version compatible with the images folder.
>
Anyone have idea on automatically start apex listener when the server reboots?
>
How to suggest without knowing OS?
You can write a batch file that runs on bootup to achieve this.
>
How to run apex listener in backend?
>
What is backend? Do you means background or as a service?
Cheers, 
Hi Prabodh,
Thanks for your reply.
My database is running on window 7 with oracle database 11g R2. Just to double confirm, where is the correct path to get the images file?
I do not need to copy the image file from database server to listener server if i uploaded css or js to workspace_image?
Can i installed apex listener in PC without database installed?
About auto start apex listener. Current i created a batch file, create shortcut for batch file and make a copy to startup folder.
So i work fine when system reboots.
Just an issue how can i hidden the command to avoid user an accidently closed command.
Batch file as below;
cd \
java -Dapex.home=c:\apexlistener -Dapex.images=c:\apexlistener\images -Dapex.port=8585 -Dapex.erase -jar c:\apexlistener\apex.war
Thank you! 
My database is running on window 7 with oracle database 11g R2. Just to double confirm, where is the correct path to get the images file?Depends on the Edition? Use Windows Explorer to find the ...\apex\images under %ORACLE_HOME%. Or, in the Apex installable you used to install it, if you installed Apex.
>
I do not need to copy the image file from database server to listener server if i uploaded css or js to workspace_image?
>
Yes, you need to copy the images folder from the DB serverto the one that is running ApexListener, if they are different machines.
WORKSPACE_IMAGES is only for, as the name suggests, for Workspace and Application specific files. Not equivalent of /i/
>
Can i installed apex listener in PC without database installed?
>
Yes.
>
About auto start apex listener. Current i created a batch file, create shortcut for batch file and make a copy to startup folder.
So i work fine when system reboots.
Just an issue how can i hidden the command to avoid user an accidently closed command.
>
1. Deploy ApexListener in a J2EE container. That is the right thing to do.
2. Making a service out of it may not be simple. I have not tried it. You could try some of the techniques shown here.
>
Batch file as below;
cd \
java -Dapex.home=c:\apexlistener -Dapex.images=c:\apexlistener\images -Dapex.port=8585 -Dapex.erase -jar c:\apexlistener\apex.war>
Cheers, 
Hi,
My database is running on window 7 with oracle database 11g R2. Just to double confirm, where is the correct path to get the images file?It can be anywhere. You have to configure your APEX Listener to use a path that contains the static contents ("images") that fit to the APEX version it shall host. If you are about to use the APEX version that shipped with your database, you may find these files among your database installation, depending on your actual database edition and installation procedure. The safest way would be to download the APEX installation package that corresponds to your APEX instance and use the "images" folder included in there.
I do not need to copy the image file from database server to listener server if i uploaded css or js to workspace_image?Right. Workspace images are always hosted by your database.
Can i installed apex listener in PC without database installed?Yes, APEX Listener can be installed on any machine. Just make sure firewall rules allow it to connect to the database listener that services the database instance that "carries" your APEX environment.
About auto start apex listener. Current i created a batch file, create shortcut for batch file and make a copy to startup folder.
So i work fine when system reboots.
Just an issue how can i hidden the command to avoid user an accidently closed command.Concerning your "Run as Service" question, you wouldn't even have to use google, as we have several threads on that issue here as well, e. g. {message:id=9606494}
Despite that kind of "trick" for Standalone Mode, you may also want to think about deploying APEX Listener to a JEE container that comes with it's own service wrapper and other useful features you don't have in Standalone Mode.
-Udo 
Hi Udo,
Thanks for your reply and info.
I'm now successfully setup apex listener on window server 2008. I able to browser my apex application from apex listener to database server. The performance is good.
But now i having an issue on browser my apex application from my laptop to apex listener, then from apex listener to connect to database server. Unfortunately, the performance is bad.
Too slow to browser a page.
Can you advice on it, how can i improve my broswer performance?
What setting can i do?
The performance is good if i browser my apex application from my laptop to database server.
Hope to hear from you soon!
I need the solution urgent.
Thanks 
Hi,
I'm now successfully setup apex listener on window server 2008.I'm glad to hear that.
But now i having an issue on browser my apex application from my laptop to apex listener, then from apex listener to connect to database server. Unfortunately, the performance is bad.So it basically works, but is seems to be slow. Hmm, how much time does a page take to render from your laptop and how much would it be for the same page on your server?
Also, I'm not quite sure which service is running on which node in the slow scenario. Do you run APEX Listener on your Laptop, or are you trying to access the same APEX Listener installation (on your Windows Server 2008) and just access it from your laptop instead of browsing locally on your Windows Server?
If it's the latter, than the question would be how your laptop is connected to the server? Could some bandwidth limitation cause that issue?
And is your laptop able to render other pages (e.g. some regular web page) with satisfying performance at the same time the performance for the APEX page is bad?
-Udo 
Hi Udo,
Thanks again.
Basically my flows is in this way. I installed oracle database 11g R2 with oracle apex 3.1 application on Window server 2008 standard (server A) and apex listener is installed on window server 2008 standard (server B). I will browser the apex application allocated at server A from my laptop thru apex listener.
The time to browser apex page is slower than directly browser to server A. It will take about more than 30 second.
I tried to install apex listener in my own laptop and i browser apex application from server B thru apex listener on my laptop. Everything is running fine and fast.
Do you have any idea or solution on it? 
The time to browser apex page is slower than directly browser to server A. It will take about more than 30 second.30 seconds, wow, this is a huge delay... Sounds like some network timeout, e.g. some issue with name resolution (DNS). Possibly your client PC doesn't have a valid entry in your domain. Try to add it to your DNS or at least to the hosts list of your server A and see if things change.
-Udo 
Hi Udo,
Many thanks for your reply!
30 sec delay issue is solved.
Now there are new issue coming from client side.
My client pc is running in Window XP (with IE 8). When they browser apex application thru apex listener, the browsing performance is slower than window 7.
If client browser apex application directly to database server (without go thru apex listener), the performance is good.
I'm curious to know, is there any setting or limitation on apex listener?
What client pc requirement is need in order to browser apex application thru apex listener?
Or can you advice, how can i improve the browsing performance for window XP?
Thanks a lot in advance! 
Hi Udo,
Thanks for your reply!
i had solved 30 sec performance issue.
Now there is another new issue coming from client side.
My client pc is running in window XP (IE 8). When client browser apex application thru apex listener, the performance is slower than window 7.
If client browser apex application directly from database server (Without go thru apex listener server), the performance is good as window 7.
So i'm curious to know, is there any limitation or setting need for client to access apex application thru apex listener?
What is the client pc requirement need?
Can you advice on it to improve browsing performance for window 7?
Thanks a lot in advance!

issues when  deploying apex listener to tomcat

Hi
I'm looking for a set of instructions (pretty much foolproof) for installing the apex listener to tomcat.
So far I have managed to deploy the listener and tomcat tells me that the listener is configured.
I do realise I have to copy the images to the tomcat directory (I rolled back to try and get it going again).
So the images go into tomcat/root /i
I assume we rename images directory to i . so what was tomcat/root/images becomes tomcat/root/i
I can see the apex war has been deployed.
Where does apex_config.xml go?
are we supposed to run the sample_capture.sql script?
When I run http://localhost:8080/apex/ListenerConfigure I get message now:
"The APEX Listener is already Configured. Please login as Administrator to access APEX Listener Administration."
When I run http://localhost:8080/apex/ListenerAdmin i get prompted for username and password.
if I put in apexAdmin as username and admin as password , the values are not accepted.
Finally (3rd attempt) I get "This request requires HTTP authentication"
There is a similar problem with ApexStatus.
Finally If I type http://localhost:8080/apex/ I get Requested url http://localhost:8080/apex/ is not allowed.
Is there a step by step guide for installing apex listener under tomcat ?? 
Tomcat is not a supported configuration, so the best you'll get are other experiences and nothing concrete (especially not from Oracle itself). Also note that they can change the listener at any time and break your existing configuration.
Just making that comment. Sorry I have nothing else to add. 
I just posted a new version. That should fix this. In tomcat http://localhost/apex/ had an issue where if you did http://localhost/apex/apex it would work. Basically the default page wasn't working in tomcat.
-kris

Configure Glassfish with APEX Listener V1

I am in the process of configuring the Glasssfish listener. I am doing the DEPLOY Application step. After entering the requested information, I just get a blank screen back. If click on DEPLOY again, I do see my Application. Is this normal? I then tried configuring the APEX listener hoping the DEPLOY was ok. I entered http://xxxx.xxx.xxx:4848/apex_orat/listenerConfigure but get a bad url error. Is this the right port? Does this mean the DEPLOY was not successful? I did stop/start the domain but no help. 
It does sound like something went wrong. I would undeploy the listener from glassfish and try again. I've not had glassfish do that to me in all the testing I've done.
-kris 
I have already done that a couple of times. 
Hello jbecktrom,
do you see any error in the log for the application or the server instance? If so, could you please post it?
Thanks,
-Udo 
I changed the port for doing on the URL for the listener config and that got its config screen. Don't why the Deploy never returned a confirmation but apparently it worked.

Apex 4.1 listener Administration

1) Apex 4.1 listener is configured.
2)Connection,security,caching is configured.
after configuration , i tried to use apply function and nothing displays on the web page.need help 
Hello user10696317,
1) Apex 4.1 listener is configured.Could you please provide some additional information on that? You use APEX 4.1, but...
a) Which version of the APEX Listener do you use
b) hosted on which JEE Server (or do you use it in Standalone Mode)
c) on which OS
d) and which database is your APEX located in
2)Connection,security,caching is configured.Could you please provide some more details on these configuration details?
I conclude you've been able to deploy/start the APEX Listener and called the URL <somehost>:<someport>/apex/listenerConfigure .
Which parameters did you configure there?
after configuration , i tried to use apply function and nothing displays on the web page.Do you see anything in the APEX Listeners log? If you run standalone mode, this will be the console output, otherwhise some log file of your JEE Server.
-Udo

Change DAD Name

Hi
I am using APEX 4.1.1 with APEX Listener + Oracle XE 11g on Centos 5.5.
Currently we use APEX with http://<hostname:port>/apex. For some reason my customer wants to have its company name instead of /apex. It should be like http://<hostname:port>/customername
Can this be done. If yes please describe how?
Any help will be much appreciated.
Habib 
Hi Habib,
it seems you are using APEX Listener in Standalone Mode. It's not possible to change the context in that scenario unless you add another component:
a) a (reverse) proxy in front of your APEX Listener that maps /customername to /apex
b) a full-featured JEE Container (e.g. GlassFish, WLS, OC4J) that allows you to deploy the apex.war to a custom context
-Udo 
Thanks Udo
I am already using NGINX as reverse proxy. Can you please guide me how to do that with NGINX? How this mapping is done?
I am already trying something like below but it does not work. It keeps changing the URL in the browser with a separate session ID every second.:
location /customername {
proxy_pass http://localhost:9091/apex;
}
It works fine when I use /apex instead of /customername
Habib 
Hi Habib,
I'm sorry, but when reading my previous post again I have to admit it's a little ambiguous.
You can't do that with APEX Listener in Standalone Mode, but need b) (a regular JEE Container) in any case. See other posts on that topic, e.g. {message:id=10171761}, where you'll find some hints on how to setup a reverse proxy (Apache HTTPD in that case).
Note that using APEX Listener in Standalone Mode isn't recommended for production scenarios anyway.
-Udo

Categories

Resources