DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, August 2, 2016

REP-56055 exceeded max connections allowed Oracle Reports Erro

ERROR:

REP-56055 exceeded max connections allowed Oracle Reports Error


SOLUTION:

1. Find the file $DOMAIN_HOME/reports/conf/repservername.conf

where $DOMAIN_HOME is your applications (not infrastructure) home, and repservername is your reports server name, i.e. rep_markr.
2. Find the line <connection maxConnect="20" idleTimeOut="15">
3. Change the maxConnect value to something like "100"
4. Restart your reports server, i.e.

nohup $DOMAIN_HOME/bin/startManagedWebLogic.sh WLS_REPORTS

Oracle Reports taking more time to load when huge number of users are using at a time

ERROR:

Oracle Reports taking more time to load when huge number of users are using at a time

Error in log file
2016-07-22T14:50:04.163+05:30] [WLS_REPORTS] [INCIDENT_ERROR] [REP-56048] [oracle.reports.servlet] [tid: 108] [userId: <anonymous>] [ecid: 0000LOHts1mFw0G6yzFg6G1N^U5j00001h,0:1] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-56048 : Engine rwEng-0 crashed., job Id: 15710 [[ 
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0 
at oracle.reports.RWExceptionHelper.read(RWExceptionHelper.java:67)  

SOLUTION:

1. Take a backup and edit the rwserver.conf file from: DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration 


2. Change 

<property name="cacheSize" value="50"/> 

To 

<property name="cacheSize" value=999"/> 

3. Change 

" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30"> 

To 

" initEngine="2" maxEngine="4" minEngine="2" engLife="5" maxIdle="30" callbackTimeOut="180000" jvmOptions="-Xmx1024M -Xms128M -Xss512k"> 


4. <connection maxConnect="200" idleTimeOut="120"> 

Save, restart WLS_FORMS and WLS_REPORTS and test again. 

ora-28040 no matching authentication protocol in 12C

ERROR:
--------------------------------
ora-28040 no matching authentication protocol in 12C

SOLUTION:
-------------------------------

1. Edit the sqlnet.ora file of the 12c database.
2. Remove or comment the following entry.
SQLNET.ALLOWED_LOGON_VERSION
3. Add the following two new Oracle Net Services parameters:
SQLNET.ALLOWED_LOGON_VERSION_SERVER
SQLNET.ALLOWED_LOGON_VERSION_CLIENT
4. Bounce the database.
5. Bounce the application server.