Wednesday, March 26, 2014

Installing ITM 6.3.0 and Oracle 12c as a TDW for PA, SPA and WPA.

Run the setup.exe and let it install all the components on the HUB Tems.
Below is some of the snapshots of my installation on a windows server

 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
How to fix this ?  
 
Rebuild TEPS DB.  

Right click -> Advanced ->Utilities -> Build TEPS DB ( ~ )
 
 
Install the ITM Agent ( in my case - I installed the 6.3.0 Agent )  
Install the Performance Analyzer Agent at last.  




Notice the WINNT (32bit executable ) and the WIX64 ( 64 bit executable )

*********** Wednesday, March 26, 2014 4:57:47 AM ************
User       : Administrator         Group     : NA            
Host Name  : CO9118051206          Installer : Ver: 063002000
CandleHome : C:\IBM\ITM            
Installitm : C:\IBM\ITM\InstallITM
*************************************************************
...Product Inventory


PC  PRODUCT DESC                                             PLAT   VER          BUILD         INSTALL DATE  

AC  KAC(64-bit) CMA/32/64 Bit Agent Compatibility Package    WIX64  06.30.02.00  201308240836  20140321 0635
CJ  TEPD App Support/Tivoli Enterprise Portal Desktop Clien  WIX64  06.30.02.00  d3248a        20140321 0635
CQ  KCQ(64-bit) CMA/Tivoli Enterprise Portal Server Agent    WIX64  06.30.02.00  d3248a        20140321 0635
CQ  TEPS App Support/Tivoli Enterprise Portal Server         WIX64  06.30.02.00  d3248a        20140321 0635
CW  TEPB App Support/Tivoli Enterprise Portal Browser Clien  WINNT  06.30.02.00  d3248a        20140321 0635
GL  KGL(64-bit) CMA/Tivoli Enterprise Monitoring Agent Fram  WIX64  06.30.02.00  d3248a        20140321 0635
GL  KGL(32-bit) CMA/Tivoli Enterprise Monitoring Agent Fram  WINNT  06.30.02.00  d3248a        20140321 0635
HD  KHD(64-bit) CMA/Warehouse Proxy Agent                    WIX64  06.30.02.00  d3248a        20140321 0635  <============ 64
KF  KKF(32-bit) IEH/IBM Eclipse Help Server                  WINNT  06.30.02.00  d3221a        20140321 0635
MS  TEMS App Support/Tivoli Enterprise Monitoring Server     WIX64  06.30.02.00  d3248a        20140321 0635
NT  KNT(32-bit) CMA/Monitoring Agent for Windows OS          WINNT  06.30.02.00  32191         20140326 0314
PA  KPA(32-bit) CMA/Tivoli Performance Analyzer              WINNT  06.30.02.00  32251         20140321 0635   <================ 32
SY  KSY(64-bit) CMA/Summarization and Pruning Agent          WIX64  06.30.02.00  d3221a        20140321 0635    <============== 64
UE  KUE(32-bit) CMA/Tivoli Enterprise Services User Interfa  WINNT  06.30.02.00  d3248a        20140321 0635

PC  APPLICATION SUPPORT DESC                                 PLAT   APP VER      BUILD         INSTALL DATE  

IN  Install INS/Windows Install Component                    WINNT  06.30.02.00  201308240836  20140321 0635
IN  TEPD INS/TEP Desktop Windows Install Component           WINNT  06.30.02.00  201308240836  20140321 0635
IN  TEMS INS/TEMS Windows Install Component                  WINNT  06.30.02.00  201308240836  20140321 0635
IN  TEPS INS/TEP Server Windows Install Component            WINNT  06.30.02.00  201308240836  20140321 0635
IN  TEMA(32-bit) INS/ITM 6.x Agent Install Component         WINNT  06.30.02.00  201308240836  20140321 0635
IN  TEMA(64-bit) INS/ITM 6.x Agent Install Component Extens  WINNT  06.30.02.00  201308240836  20140321 0635
A4  TEMS App Support/Monitoring Agent for i5/OS              WICMS  06.30.02.00  32481         20140321 0635
A4  TEPS App Support/Monitoring Agent for i5/OS              WICNS  06.30.02.00  32481         20140321 0635
A4  TEPB App Support/Monitoring Agent for i5/OS              WIXEB  06.30.02.00  32481         20140321 0635
A4  TEPD App Support/Monitoring Agent for i5/OS              WIXEW  06.30.02.00  32481         20140321 0635
AS  KAS(64-bit) CAS/Tivoli Enterprise Monitoring Automation  WIX64  06.30.02.00  d3248a        20140321 0635
GS  KGS(64-bit) GSK/IBM GSKit Security Interface             WIX64  08.00.50.05  d3221a        20140321 0635
GS  KGS(32-bit) GSK/IBM GSKit Security Interface             WINNT  08.00.50.05  d3221a        20140321 0635
HD  TEMS App Support/Warehouse Proxy                         WICMS  06.30.02.00  d3248a        20140321 0635
HD  TEPS App Support/Warehouse Proxy                         WICNS  06.30.02.00  d3248a        20140321 0635
HD  TEPB App Support/Warehouse Proxy                         WIXEB  06.30.02.00  d3248a        20140321 0635
HD  TEPD App Support/Warehouse Proxy                         WIXEW  06.30.02.00  d3248a        20140321 0635
II  TEPS App Support/IBM Installation Manager                WICNS  01.06.03.01  d3221a        20140321 0635
IT  TEPS App Support/TEC GUI Integration                     WICNS  06.30.02.00  d3221a        20140321 0635
IT  TEPB App Support/TEC GUI Integration                     WIXEB  06.30.02.00  d3221a        20140321 0635
IT  TEPD App Support/TEC GUI Integration                     WIXEW  06.30.02.00  d3221a        20140321 0635
IU  TEPS App Support/IBM HTTP Server                         WICNS  08.00.06.00  d3221a        20140321 0635
IW  TEPS App Support/Tivoli Enterprise Portal Server Extens  WICNS  08.00.06.00  d3221a        20140321 0635
JM  KJM(64-bit) JVM/Embedded JVM                             WIX64  07.04.02.00  201308061911  20140321 0635
JM  KJM(32-bit) JVM/Embedded JVM                             WINNT  07.04.02.00  201308061911  20140321 0635
JM  TEPB App Support/Embedded JVM - TEP Browser Client       WIXEB  07.05.00.00  201307121313  20140321 0635
LZ  TEMS App Support/Monitoring Agent for Linux OS           WICMS  06.30.02.00  32341         20140321 0635
LZ  TEPS App Support/Monitoring Agent for Linux OS           WICNS  06.30.02.00  32341         20140321 0635
LZ  TEPB App Support/Monitoring Agent for Linux OS           WIXEB  06.30.02.00  32341         20140321 0635
LZ  TEPD App Support/Monitoring Agent for Linux OS           WIXEW  06.30.02.00  32341         20140321 0635
NT  TEMS App Support/Monitoring Agent for Windows OS         WICMS  06.30.02.00  32191         20140321 0635
NT  TEPS App Support/Monitoring Agent for Windows OS         WICNS  06.30.02.00  32191         20140321 0635
NT  TEPB App Support/Monitoring Agent for Windows OS         WIXEB  06.30.02.00  32191         20140321 0635
NT  TEPD App Support/Monitoring Agent for Windows OS         WIXEW  06.30.02.00  32191         20140321 0635
P0  KP0(32-bit) CPA/Performance Analyzer Domain for DB2      WINNT  06.30.02.00  32252         20140326 0353
P3  TEMS App Support/Performance Analyzer Domain for OS age  WICMS  06.30.02.00  32252         20140326 0353
P3  TEPS App Support/Performance Analyzer Domain for OS age  WICNS  06.30.02.00  32252         20140326 0353
P3  KP3(32-bit) CPA/Performance Analyzer Domain for OS agen  WINNT  06.30.02.00  32252         20140326 0353
P3  TEPB App Support/Performance Analyzer Domain for OS age  WIXEB  06.30.02.00  32252         20140326 0353
P3  TEPD App Support/Performance Analyzer Domain for OS age  WIXEW  06.30.02.00  32252         20140326 0353
P4  KP4(32-bit) CPA/Performance Analyzer Domain for Oracle   WINNT  06.30.02.00  32252         20140326 0353
P6  KP6(32-bit) CPA/Performance Analyzer Domain for System   WINNT  06.30.02.00  32252         20140326 0353
PA  TEMS App Support/Tivoli Performance Analyzer             WICMS  06.30.02.00  32251         20140321 0635
PA  TEPS App Support/Tivoli Performance Analyzer             WICNS  06.30.02.00  32251         20140321 0635
PA  TEPB App Support/Tivoli Performance Analyzer             WIXEB  06.30.02.00  32251         20140321 0635
PA  TEPD App Support/Tivoli Performance Analyzer             WIXEW  06.30.02.00  32251         20140321 0635
PI  KPI(32-bit) CPA/Performance Analyzer Domain for ITCAM R  WINNT  06.30.02.00  32252         20140326 0353
PU  KPU(32-bit) CPA/Performance Analyzer Domain for VMware   WINNT  06.30.02.00  32252         20140326 0353
R2  TEMS App Support/Agentless Monitoring for Windows Opera  WICMS  06.30.02.00  201308010129  20140321 0635
R2  TEPS App Support/Agentless Monitoring for Windows Opera  WICNS  06.30.02.00  201308010129  20140321 0635
R2  TEPB App Support/Agentless Monitoring for Windows Opera  WIXEB  06.30.02.00  201308010129  20140321 0635
R2  TEPD App Support/Agentless Monitoring for Windows Opera  WIXEW  06.30.02.00  201308010129  20140321 0635
R3  TEMS App Support/Agentless Monitoring for AIX Operating  WICMS  06.30.02.00  201308010131  20140321 0635
R3  TEPS App Support/Agentless Monitoring for AIX Operating  WICNS  06.30.02.00  201308010131  20140321 0635
R3  TEPB App Support/Agentless Monitoring for AIX Operating  WIXEB  06.30.02.00  201308010131  20140321 0635
R3  TEPD App Support/Agentless Monitoring for AIX Operating  WIXEW  06.30.02.00  201308010131  20140321 0635
R4  TEMS App Support/Agentless Monitoring for Linux Operati  WICMS  06.30.02.00  201308010134  20140321 0635
R4  TEPS App Support/Agentless Monitoring for Linux Operati  WICNS  06.30.02.00  201308010134  20140321 0635
R4  TEPB App Support/Agentless Monitoring for Linux Operati  WIXEB  06.30.02.00  201308010134  20140321 0635
R4  TEPD App Support/Agentless Monitoring for Linux Operati  WIXEW  06.30.02.00  201308010134  20140321 0635
R5  TEMS App Support/Agentless Monitoring for HP-UX Operati  WICMS  06.30.02.00  201308010136  20140321 0635
R5  TEPS App Support/Agentless Monitoring for HP-UX Operati  WICNS  06.30.02.00  201308010136  20140321 0635
R5  TEPB App Support/Agentless Monitoring for HP-UX Operati  WIXEB  06.30.02.00  201308010136  20140321 0635
R5  TEPD App Support/Agentless Monitoring for HP-UX Operati  WIXEW  06.30.02.00  201308010136  20140321 0635
R6  TEMS App Support/Agentless Monitoring for Solaris Opera  WICMS  06.30.02.00  201308010138  20140321 0635
R6  TEPS App Support/Agentless Monitoring for Solaris Opera  WICNS  06.30.02.00  201308010138  20140321 0635
R6  TEPB App Support/Agentless Monitoring for Solaris Opera  WIXEB  06.30.02.00  201308010138  20140321 0635
R6  TEPD App Support/Agentless Monitoring for Solaris Opera  WIXEW  06.30.02.00  201308010138  20140321 0635
SY  TEMS App Support/Summarization and Pruning Agent         WICMS  06.30.02.00  d3221a        20140321 0635
SY  TEPS App Support/Summarization and Pruning Agent         WICNS  06.30.02.00  d3221a        20140321 0635
SY  TEPB App Support/Summarization and Pruning Agent         WIXEB  06.30.02.00  d3221a        20140321 0635
SY  TEPD App Support/Summarization and Pruning Agent         WIXEW  06.30.02.00  d3221a        20140321 0635
T1  TEMS App Support/Tivoli Enterprise Monitoring Server TR  WICMS  07.30.63.00  d3248a        20140321 0635
TM  TEMS App Support/IBM Tivoli Monitoring 5.x Endpoint Sup  WICMS  06.23.03.00  d3039a        20140321 0635
TM  TEPS App Support/IBM Tivoli Monitoring 5.x Endpoint Sup  WICNS  06.23.03.00  d3039a        20140321 0635
UI  KUI(32-bit) CLI/Tivoli Enterprise Services User Interfa  WINNT  06.30.02.00  201308240836  20140321 0635
UL  TEMS App Support/Monitoring Agent for UNIX Logs          WICMS  06.23.03.00  30981         20140321 0635
UL  TEPS App Support/Monitoring Agent for UNIX Logs          WICNS  06.23.03.00  30981         20140321 0635
UL  TEPB App Support/Monitoring Agent for UNIX Logs          WIXEB  06.23.03.00  30981         20140321 0635
UL  TEPD App Support/Monitoring Agent for UNIX Logs          WIXEW  06.23.03.00  30981         20140321 0635
UM  TEMS App Support/Universal Agent                         WICMS  06.23.03.00  d3021a        20140321 0635
UM  TEPS App Support/Universal Agent                         WICNS  06.23.03.00  d3021a        20140321 0635
UM  TEPB App Support/Universal Agent                         WIXEB  06.23.03.00  d3021a        20140321 0635
UM  TEPD App Support/Universal Agent                         WIXEW  06.23.03.00  d3021a        20140321 0635
UX  TEMS App Support/Monitoring Agent for UNIX OS            WICMS  06.30.02.00  32411         20140321 0635
UX  TEPS App Support/Monitoring Agent for UNIX OS            WICNS  06.30.02.00  32411         20140321 0635
UX  TEPB App Support/Monitoring Agent for UNIX OS            WIXEB  06.30.02.00  32411         20140321 0635
UX  TEPD App Support/Monitoring Agent for UNIX OS            WIXEW  06.30.02.00  32411         20140321 0635








At this point - you will notice that there is an error in the kpacma.log stating it cant open the JNI_CreateJava () something.



This leads to the "DB Connection Failure" when you open the PA panel.

To fix this.


This is because the PA is a 32 bit exe, and it needs a 32 bit ODBC driver.

Below you will see that there is no 32 bit Oracle DSN driver.

If there was one - you would have seen the OracleHomeClient_something in the Add"

Notice the missing DSN line for Oracle 32bit Client. it has to be installed.

Please follow the Installation of the Oracle Client blog page to install the Oracle 32bit driver.

 


Install the 32bit Oracle ODBC driver.

Do not hit the "Test Connection" as it will fail. Only installation seems to have fixed the problem of the DB Failure error in the PA config panel.

This should remedy the Database error seen in the TEPS GUI.

At this time - I started the 32bit ODBC connections by setting the TNS_ADMIN to the new location where the Oracle 32bit ODBC client was installed.

set  TNS_ADMIN=c:\app\Administrator\product\12.1.0\client_1\network\admin
echo %TNS_ADMIN%

cd c:\windows\sysWoW64\
odbcad32.exe



 At this time - I added and did not "Test Connection", as it would fail in the ODBC 32 window.


Reconfigured the PA again, and reinit the PA tables to catch up with the 32bit ODBC driver ( I think the PA automatically detects the 32bit ODBC driver and uses it - not sure on the concept behind this )



Restart the Performance Analyzer, and the TEPS GUI panel should list the connection as "OK" instead of the ERROR, 
and also the bottom TEPS PA panel will list the various tasks.



If this does not work:
stop all the processes,   Rebuild the TEPS Embedded database, Reconfigure the TEPS, Reconfigure the PA and select the "Initialize" the PA tables. and start the PA.



Bring up the SQL developer,

Create a new connection call it WAREHOUS ( ONLY if it is not there ) - ( choose the service name as WAREHOUS ) and click on Tables.











Click on Test, it happens in a second and does not display a success of a failure - but just a flicker of the screen ( on both Windows 2012 and Windows 2008 )

Click on Connect.
 Now the WAREHOUS will appear in the left navigational panel.
This below clearly indicates that the PA is configured, but the historical configuration is not .


















Another view if the Historical collections were configured.











































No comments:

Post a Comment