Error:Failure of server APACHE bridge:No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.

Error:
Failure of server APACHE bridge:

No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.
Build date/time: Apr 20 2009 15:29:34

Change Number: 1253617

Solution:
If its Linux server.

+ Stop the apache server

/usr/sbin/apachectl stop
 
+Check SELINUX parameter
 
[root@TZ-IBWB-PRD-01 ~]# getenforce
Enforcing
 
+set the value to Permissive as below
 
[root@TZ-IBWB-PRD-01 ~]# setenforce 0
[root@TZ-IBWB-PRD-01 ~]# getenforce
Permissive

+Start the apache

/usr/sbin/apachectl start

Check the URL.

+To make perment solution

Tuning BO report of FCUBS which is taking more than 30mins

Tuning BO report of FCUBS which is taking more than 30mins,

By using hash join you can change the response time to 2mins.

Below is the example of query run more than 30mins,the plan is taking nested loop.

SELECT

 ACVW_ALL_AC_ENTRIES.TRN_REF_NO,

 ACVW_ALL_AC_ENTRIES.TRN_CODE,

 ACVW_ALL_AC_ENTRIES.AC_NO,

 GLTMS_GLMASTER.GL_DESC,

 ACVW_ALL_AC_ENTRIES.CUST_GL,

 ACVW_ALL_AC_ENTRIES.MODULE,

 ACVW_ALL_AC_ENTRIES.AC_CCY,

 ACVW_ALL_AC_ENTRIES.DRCR_IND,

 ACVW_ALL_AC_ENTRIES.FCY_AMOUNT,

 ACVW_ALL_AC_ENTRIES.TRN_DT,

 ACVW_ALL_AC_ENTRIES.VALUE_DT,

 ACVW_ALL_AC_ENTRIES.LCY_AMOUNT,

 ACVW_ALL_AC_ENTRIES.AUTH_ID,

 ACVW_ALL_AC_ENTRIES.USER_ID

FROM

 FCUBSUSER.ACVW_ALL_AC_ENTRIES,

 FCUBSUSER.GLTMS_GLMASTER

….

…

…

UNION

SELECT

 ACVW_ALL_AC_ENTRIES.TRN_REF_NO,

 ACVW_ALL_AC_ENTRIES.TRN_CODE,

 ACVW_ALL_AC_ENTRIES.AC_NO,

 STTMS_CUST_ACCOUNT.AC_DESC,

 ACVW_ALL_AC_ENTRIES.CUST_GL,

 ACVW_ALL_AC_ENTRIES.MODULE,

 ACVW_ALL_AC_ENTRIES.AC_CCY,

 ACVW_ALL_AC_ENTRIES.DRCR_IND,

 ACVW_ALL_AC_ENTRIES.FCY_AMOUNT,

 ACVW_ALL_AC_ENTRIES.TRN_DT,

 ACVW_ALL_AC_ENTRIES.VALUE_DT,

 ACVW_ALL_AC_ENTRIES.LCY_AMOUNT,

 ACVW_ALL_AC_ENTRIES.AUTH_ID,

 ACVW_ALL_AC_ENTRIES.USER_ID

FROM

 FCUBSUSER.ACVW_ALL_AC_ENTRIES,

 FCUBSUSER.STTMS_CUST_ACCOUNT

WHERE

….

….

…

FCUBS Blank page after login

After cloning FCUBS from PROD,When you try to launch the url of application then login,You may get blank page as like.

 

++ We have to change the Weblogic data source to IP address of database.
++ Check the /etc/hosts file entry for ip address.Some time you may ping back  127.0.0.1  

#ping HOSTNAME
PING HOSTNAME (127.0.0.1) 56(84) bytes of data.
64 bytes from HOSTNAME (127.0.0.1): icmp_seq=1 ttl=64 time=0.034 ms

# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               HOSTNAME localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
10.106.180.12   HOSTNAME

========
Change the above host entry as like

# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
::1             localhost6.localdomain6 localhost6
10.106.180.12   HOSTNAME
Then restart the weblogic and try to login

Weblogic Installation for FCUBS

Weblogic installation for application like FCUBS env

++ Create user

Create users and groups

groupadd –g 600 wlsgroup

useradd  -g wlsgroup -s /usr/bin/bash oracle

++ Installation dir

Installation Path=/oradata/Weblogic/Middleware/

Domain Path=/oradata/Weblogic/logs/

Log path=/oradata/Weblogic/domains/

++ Change the kernel parameters

Ulimit entries:

1) /etc/security/limits.conf

oracle soft nofile 131072

oracle hard nofile 131072

oracle soft nproc 131072

oracle hard nproc 131072

oracle soft core unlimited

oracle hard core unlimited

oracle soft memlock 3500000

oracle hard memlock 3500000

2) /etc/profile

ulimit -S -c 0 > /dev/null 2>&1

Change it to the following:

ulimit -S -c unlimited > /dev/null 2>&1

And add the below entry at the last above unset

---

if [ $USER = "oracle" ]; then

umask 022

ulimit -i 1024

ulimit -l 128

ulimit -n 65536

fi

unset i

unset pathmunge

Login as oracle user

Export the display to xmanager or take the console from the serer

And execute the installer

./ wls1032_linux32.bin