Database Blog

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.confwhere $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

Read More

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. 

Read More

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.

Read More

Oracle Big Data SQL

Oracle Big Data SQL supports queries against vast amounts of big data stored in multiple data sources, including Apache Hive, HDFS, Oracle NoSQL Database, and Apache HBase. You can view…

Read More

Software Component Overview for Oracle Big Data

The major software components perform three basic tasks: Acquire Organize Analyze and visualize The best tool for each task depends on the density of the information and the degree of…

Read More

Software for Oracle Big Data

The Oracle Linux operating system and Cloudera’s Distribution including Apache Hadoop (CDH) underlie all other software components installed on Oracle Big Data Appliance. CDH is an integrated stack of components that have been tested and…

Read More

The Oracle Big Data Solution

Oracle Big Data Appliance is an engineered system comprising both hardware and software components. The hardware is optimized to run the enhanced big data software components. Oracle Big Data Appliance…

Read More

Creating Multiple Indexes on the Same Set of Columns

You can create multiple indexes on the same set of columns when the indexes are different in some way. To create multiple indexes on the same set of columns, the…

Read More

Creating an Invisible Index

An invisible index is an index that is ignored by the optimizer unless you explicitly set the OPTIMIZER_USE_INVISIBLE_INDEXES initialization parameter to TRUE at the session or system level. To create an invisible index:  Use…

Read More

Creating an Unusable Index

When you create an index in the UNUSABLE state, it is ignored by the optimizer and is not maintained by DML. An unusable index must be rebuilt, or dropped and re-created, before…

Read More