Erman Arslan's Oracle Forum › EBS 12.1/12.0/11i

LoadBalancer

Classic

List

Threaded

17 messages Options

latifa

Nov 14, 2017; 2:32pm

LoadBalancer

403 posts

Hi Erman,

I am configuring the load balancing in Oracle EBS R12.1.3 :

I have modified these parameters:

s_external_url from http://server1.domain1 to http://LBR.domain2
s_webentryhost: from servers1 to LBR
s_webentrydomain : domain2
s_login_page : from http://server1.domain1/OA_HTML/AppsLogin to http://LBR.domain2/OA_HTML/AppsLogin.

and also:
s_webport no change : 10000
s_active_webport from 10000 to 80

But I have no DNS so I put
@IP LBR.domain2 in /etc/hosts of server1
@IP LBR.domain2 in the /etc/hosts of windows server

However I can't connect to the application.

Check the load balancer by:

curl http://LBR.domain2/OA_HTML/AppsLogin -H 'Host: LBR.domain2'
<HTML><HEAD><TITLE>Redirect to http://LBR.domain2/OA_HTML/AppsLocalLogin.jsp</TITLE></HEAD><BODY>http://LBR.domain2/OA_HTML/AppsLocalLogin.jsp</BODY></HTML>

Regards,
Latifa

ErmanArslansOracleBlog

Nov 14, 2017; 2:48pm

Re: LoadBalancer

Administrator

5732 posts

Did you done all the necessary things documented in:

Using Load-Balancers with Oracle E-Business Suite Release 12.0 and 12.1
"Section : 2.1: Using Hardware Load Balancers with Single Web Entry Point."

I guess you did.. (including autoconfig on all nodes and restarting the apps services..)

Did you done all the necessary things in Section 2.1.4: Configuration Changes on the Load Balancer?

If yes, what error are you getting?
*Browser side, Oracle HTTP server and oacore side..

send me screenshots and the logs

ErmanArslansOracleBlog

Nov 14, 2017; 2:51pm

Re: LoadBalancer

Administrator

5732 posts

Also describe your environment.
what is that windows server?
what is the server1? Linux?
What kind of conf is that?
Can you do telnet to the LBR.domain2 port 80 from the apps nodes and from your own windows client?

latifa

Nov 14, 2017; 3:42pm

Re: LoadBalancer

403 posts

1. My environemnt is composed :
3 OAS (WebTier) VM Linux and 3 CM (Concurrent Manangers) VM Linux.
DB is : 2 nodes

So we have: Oracle 12C ASM, RAC and EBS 12.1.3, cluster

2. windows server? is windows client

ErmanArslansOracleBlog

Nov 14, 2017; 3:45pm

Re: LoadBalancer

Administrator

5732 posts

Please answer all of the questions and send me the logs and screenshots.

1)Can you do telnet to the LBR.domain2 port 80 from the apps nodes and from your own windows client?

2)Did you done all the necessary things documented in:

Using Load-Balancers with Oracle E-Business Suite Release 12.0 and 12.1
"Section : 2.1: Using Hardware Load Balancers with Single Web Entry Point."

I guess you did.. (including autoconfig on all nodes and restarting the apps services..)

3)Did you done all the necessary things in Section 2.1.4: Configuration Changes on the Load Balancer?

If yes, what error are you getting?
*Browser side, Oracle HTTP server and oacore side..

4)send me screenshots and the logs

latifa

Nov 14, 2017; 4:00pm

Re: LoadBalancer

403 posts

I configured only one server.

1) Yes telnet LBR.domain2 port 80 is ok from apps node and windows client side.

2) As I said before, I think I have all done : but I don't have https as indicated in the MOS.

I have modified these parameters:

s_external_url from http://server1.domain1 to http://LBR.domain2
s_webentryhost: from servers1 to LBR
s_webentrydomain : domain2
s_login_page : from http://server1.domain1/OA_HTML/AppsLogin to http://LBR.domain2/OA_HTML/AppsLogin.

and also:
s_webport no change : 10000
s_active_webport from 10000 to 80

But I have no DNS so I put
@IP LBR.domain2 in /etc/hosts of server1
@IP LBR.domain2 in the /etc/hosts of windows server

--> Followed by Autoconf of course and restart application Tier

3) I asked the guy who configured the loadbalancer and his answer on how was it done and it's as following schematically:

user -> LBR (port 80) -> serveur (port 10000)

4) which logs do you mean please ?

While connecting to the url I have a blanck screen !

Regards,
Latifa

ErmanArslansOracleBlog

Nov 14, 2017; 4:11pm

Re: LoadBalancer

Administrator

5732 posts

One server? ("I configured only one server.")
You have 3 webtiers but you configured only one of them with the Load Balancer?

What was your goal in configuring only one server? This load balancer, it cannot load balance with 1 server..
Why don't you do the autoconfig on all your apps servers and make them a part of this load balancing thing?

As for the logs, I mean the Oracle HTTP server and oacore logs.

latifa

Nov 14, 2017; 5:17pm

Re: LoadBalancer

403 posts

In reply to this post by ErmanArslansOracleBlog

I want just to test for one server in order to go back to the first configuration.
I know that load balancer is used to use distribute charge between servers but just for test configuration of the balancer can be OK with one server.

Here you are some logs

Thanks in advance for your help
Regards,
Latifa

Logs.7z

latifa

Nov 14, 2017; 6:08pm

Re: LoadBalancer

403 posts

Hi Erman,

I configured all the servers even CM servers with the LBR url and parameters s_active_webport to 80.
restarted the application on all webtiers and CM servers.

ISame problem. I checked the error.log in $LOG_HOME/ora/10.1.3/Apache and I found the following error message:

[Tue Nov 14 18:45:45 2017] [error] [client 10.114.251.122] [ecid: 1510681545:10.114.251.211:20357:0:3,0] File does not exist: /exec/products/UA11ZNCE/nce/OA/12.1/inst/apps/UA11ZNCE_ua11zas1/portal/OA_HTML/AppsLogin

I checked and this file doesn't exist even directory OA_HTML ?

How can this missing happen ...

Regards,
Latifa

ErmanArslansOracleBlog

Nov 14, 2017; 7:15pm

Re: LoadBalancer

Administrator

5732 posts

Check this:

Unable To Open The E-Business Suite Login HTTP-404 Error. Error_log Shows "File does not exist: $INST_TOP/portal/OA_HTML/AppsLogin" (Doc ID 1177264.1)

ErmanArslansOracleBlog

Nov 14, 2017; 7:17pm

Re: LoadBalancer

Administrator

5732 posts

Your oacore server also complain about it..

javax.servlet.ServletException: oracle.classloader.util.AnnotatedClassNotFoundException:

Missing class: _AppsLocalLogin

ErmanArslansOracleBlog

Nov 14, 2017; 7:19pm

Re: LoadBalancer

Administrator

5732 posts

Directly compile the jsps and retry..

$FND_TOP/patch/115/bin/ojspCompile.pl ojspCompile.conf --compile --flush -p 20

latifa

Nov 14, 2017; 8:25pm

Re: LoadBalancer

403 posts

Hi Erman,

I compiled directly the jsps. Here it is the log file.

However I didn't stop application before. May I do it now and recompile, autoconf and start ?

Regards,
Latifa

ojspc_error.log

latifa

Nov 14, 2017; 8:51pm

Re: LoadBalancer

403 posts

I stopped the application Tiers and the first webTier (only) showing error message in : adoacorectl.txt --> default_group~oacore~default_group~2.log :

17/11/14 18:45:19 WARNING: ApplicationLogManager is not installed, may result in loader leaks. Set -Djava.util.logging.manager=oracle.classloader.util.ApplicationLogManager

default_group~oacore~default_group~2.log

latifa

Nov 14, 2017; 9:54pm

Re: LoadBalancer

403 posts

Hi Erman,

It works :) compiling jsps --> stop all Tiers, autoconf even DB Tier as by note 1177264.1.

Restart --> I could access to the application.

Thank you very much.

However, I can't open Forms screens ... :(

Regards,
Latifa
Security_Settings.docx

latifa

Nov 14, 2017; 10:29pm

Re: LoadBalancer

403 posts

Hi Erman,

I solved the forms problem following work instructions in:

http://utopiaaan.blogspot.fr/2014/04/forms-issue-in-r12-application-blocked.html

and it Works :)

Thank you very much for your help Erman.

Regards,
Latifa

ErmanArslansOracleBlog

Nov 15, 2017; 8:40am

Re: LoadBalancer

Administrator

5732 posts

Cool Latifa :)
Thanks for sharing the info.