Hello everyone! This will be my first blog for the year 2016 and I hope that this will be helpful when you experience this kind of issue during an installation of a Maximo 7.5 fix pack. The title of this blog speaks for its content and this is can be a very specific issue. This issue happens when you are trying to install Maximo 7.5.0.x fix pack in an environment that has Oracle database.   For a brief background of the environment, this is an environment where you have a separate Maximo Administrative Workstation and a separate Oracle... [More]

Tags:  issue upgrade troubleshooting 7.5 tpaeupgrade connection oracle maximo

Hello Oracle users!   Have you ever looked at the view v$session to see how many Maximo sessions are open for your application?  And then wonder why they all display as INACTIVE?   (You will need DBA privilege or read privilege on the view v$session to select the results.)   This SQL statement can be run to view the open sessions for the MAXIMO schema.   select sid, status, machine, program, username, logon_time, last_call_et from... [More]

Tags:  maximo connections oracle supmax

Hello Oracle DBAs!   This is a heads up.  I have noticed that there are still many customers running Oracle 11.2.0.3 or earlier and may be planning to move to Oracle 11.2.0.4 in the near future.   Quite a few Maximo customers encountered an Oracle bug which impacts Maximo and the usage of text indexes.  The error can occur in various areas within Maximo but if you see an ORA-00604 it is likely this problem.   You will see an error similar to this error: java.sql.SQLException: ORA-00604: error occurred at recursive SQL... [More]

Tags:  maximo supmax oracle

On Oracle database, the default optimizer_mode is ALL_ROWS.  This optimizer_mode is inefficient for Maximo SQL queries, especially users screen response.   Here is an explanation of Oracle optimizer_mode from oracle documentation -- http://docs.oracle.com/database/121/TGSQL/tgsql_influence.htm Relevant information extracted from the above link Best throughput (default) When you set the OPTIMIZER_MODE value to ALL_ROWS , the database uses the least amount of resources necessary to process all rows that the statement accessed. For batch... [More]

Tags:  performance maximo optimizer_mode oracle

We encountered an issue in MAXIMO 7.5 with the Oracle 11 database, where system allowed user to store 5 digit years into database. Such invalid date values in the database with the year over 9999 caused errors when reading data or interfacing them to other systems. We found similar issue already reported, but no permanent solution was available. http://www-01.ibm.com/support/docview.wss?uid=swg1IV36705 IV36705: MAXIMO DATE FIELDS (ALLOW > 4 LENGTH YEAR ENTRY)   There are several ways to reproduce this issue in the system:... [More]

Tags:  invalid oracle year date maximo

Hello Everyone, For those who are using Spatial and are also using Oracle, this is a very important update for you! An Oracle Critical Patch Update(CPU) was recently released on October 14th, 2014. If this is installed on your Oracle Database, connections to Oracle DB can crash ArcGIS. This issue only affects Oracle users. All versions of ArcGIS are impacted by this CPU. · If you have not yet installed the patch listed above, do not install it , per Esri's recommendation. · If you have installed the patch listed above, Esri recommends that... [More]

Tags:  update esri patch maximo ibm-blog arcgis cpu oracle spatial

Once in a while I'll get questions about performance problems.  Specific scenarios can be resolved by applying Interim Fixes or adding indexes.  Those critical and urgent problems often happen throughout the entire system.   Here is a collection of performance related recordings and technotes that might help: Install Performance Monitor... [More]

Tags:  donotrun websphere eam service-management servicemanagement management tpaeperformance tivoli maximo #supmax performance server oracle asset ism crontask sql database tuning asset-management

There's some intermediate resource required by Oracle database to execute sql statements. One among them is Oracle Temporary Table Space when pure-in-memory operations could not be performed due to resource limitation or specific execution plan. As Oracle doc says:"A temporary tablespace contains transient data that persists only for the duration of the session".  So likely, if you have many things produced in the middle of query, you will probably need a temporary space to put such intermediate stuff in.   Before we start to discuss... [More]

Tags:  oracle temp maximo