Here I will write about the "Installation of Oracle 12c on Windows 2012 *64 bit OS)", and configuring it for IBM Tivoli Monitoring ITM 6.3.0
Read the Best Practices before installing the Oracle for Tivoli Monitoring.
Some snapshots are enclosed which focus on the Oracle installation and configuration.
these are my steps and officially not documented this way anywhere., but has worked for me - so documenting it.
Run the setup.exe
Enter an email address to start off with the installation. ( and unchecked the next push button )
Next, I selected "I want to remain uninformed of Critical security patches" and the rest of the panel got grayed out - as I was behind a firewall and this did not matter.
Step 2: Selected "Skip Software Updates"
Step 3: Create and configure a database.
Step 4: "Desktop Class"
Step 5: "Use Windows Built-In account"
Step 6: in the below snapshot ,I unchecked the "Create as container database" , and changed the default from ORCL to WAREHOUS.
This below is if you have created a default of ORCL and want to create another database called WAREHOUS ( not recommended - but putting the snapshot in case you need it )
Something about "Save Response File" I clicked "Continue"
Click on Install, Finish
-
Do not Delete the Browsing history, or Cache at this point during the startup of the portal ( see below )
At this point -do not close the above window where it says Password management - You will need it in case, the login prompt wont let you in.
Then click on the Password management - reset the password for sys and login back again.
Click on "Security tab" above. -> Users -> Create user.
Create the user 'ITMUser" and password "itmpswd1"
Something about Table spaces - I am accepting the defaults.
2. Create Roles
Security-> Roles -> Create Role -> Create role as ITM_DW
Enter ITM_DW
Next - assign some capabilities to the role.
-
-
__ Assign Role ITM_DW to User ( ITMuser )
Register the Oracle driver with the Windows ODBC data source.
Start -> Administrative tools -> Data Sources. ( 64 bit )
Or open a command line, go to c:\windows\sysWoW64\odbcad32.exe
Next up, we will need to register the Oracle driver under Windows Server's ODBC Data Source Administrator.
Go to the Start Menu, navigate to Administrative Tools, then select Data Sources (ODBC) 64 bit.
Select the System DSN tab. If your Oracle driver is not listed, which should be the case, select Add, scroll down to where your Oracle driver is listed.
In my case it says Oracle 12c ( see snap below ) —then select Next.
The next window is going to need you to input information regarding the ODBC connection you are going to create.
For Data Source Name enter ITM Warehouse, for TNS Service Name enter WAREHOUS, then for User ID enter ITMUser. .
If the above is slow to reach, that means the tnsnames.ora and listener.ora needs to be tweaked and it is a little complex ( in my opinion ) to configure it .
That will be covered in another blog.
Now, create the "TNS Service Name"
Open the "Net Configuration Assistant."
Select Add. In the Service Name field, enter WAREHOUS.
For the network protocol, select TCP.
Next, enter the host name and port number of the computer on which the Database resides.
The default port number is 1521.
Perform the connection test to verify you can actually connect to it.
You should then be prompted to configure another net service name, select No. Once back at the original screen, click Finish to exit.
If this fails, Hit Cancel
Click on "Test"
Click "Next" on warehous and
If this fails - then Change Login - and try again.
Or Click Cancel and try testing again. with the different credentials . (in my case it was ITMUser/itmpswd1 )
Configure the Summarization and Pruning Agent, Warehouse Agent and other components thar need the Oracle as the TDW.
===============================================
The tnsnames.ora after configuration shows up as :
tnsnames.ora Network Configuration File: C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
WAREHOUS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051206.in.ibm.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WAREHOUS)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051206.in.ibm.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.in.ibm.com)
)
)
=====================================================
Listener.ora
# listener.ora Network Configuration File: C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051206.in.ibm.com)(PORT = 1521))
)
)
============================================================
sqlnet.ora
# sqlnet.ora Network Configuration File: C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
===
Install ITM,
My test environment is to set up the ITM using TEPS to Embedded, and Performance Analyzer to Oracle as a TDW.
So TEPS -> Embedded
ITM ( PA, SPA, and WPA ) to Oracle 12c as my TDW.
In my case I installed ITM 6.3.0,and one of the first few steps is that the ITM tries to configure the Warehouse Proxy Agent.
If the below snapshot does not succeed -then go to the 64 bit ODBC and check if the DSN is there or not. After successfully configuring and test connection succeeds - then come back to ITM and continue with the installation.
Next, it configures the TEPS - this takes a little long.
Trouble shooting tips
If the ODBC configuration window during the test is slow, then I found that entering the hostname ,instead of "localhost" for the tnsnames.ora
e.g:
WAREHOUS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051168.in.ibm.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WAREHOUS)
)
)
and the listener.ora to have this.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051168.in.ibm.com)(PORT = 1521))
)
)
Steps to do it right: ( except the database connection issue )
a) tnsnames.ora and listener.ora to have the hostname instead of the localhost
b ) stop pa
c) stop tnslsnr ( in the c:\app\Administrator\product\12.1.0\dbhome_1\BIN folder )
d ) remove the PA clear Offline entries.
e ) tnslsnr start
f ) open the 64 bit odbcad32.exe and test conection .
g) This is unrelated to the configuration of Oracle and ITM - but found this helpful during my install sessions - hence putting it here.
To fix the above - I had to manually delete the c:\users\Administrator\AppData\local\temp\2 folder command line
Stop PA, WPA, SPA .
This is not helping ! There are some Oracle processes being help up.
So I have to stop the WAREHOUS table.
Bring up the Oracle Admin GUI. ( Remember to stop the PA, WPA, and SPA )
Right Click and stop Service and Restart Service.
If the above does not help, stop all the Oracle related processes in the services window.
Restart all : I was unable to start a few !
-
Another troubleshooting tip.
How to resolve the Unable to set the tasks being configured successfully.
This can happen when you open the configuration panel and make changes and try to save the tasks.
-Stop PA ,and bring up the GUI, andtry to alter and save.-Start PA, bring up the PA config panel and try to alter and save the tasks.
In one of my experiments - I was to start the PA agent and then save, it worked.
but it failed at one point since ( maybe) the agent was down ! to be tested again.
--
How to configure the SPA :
Sometimes you will get to see the "localhost"- I changed it to the hostname by making this changes in the configuration.
Stop and restart the agent - to see the host name in the TEPS Panel.
------------
My experiments with setting the hostname as a Fully Qualified domain name on Summarization and Pruning agent.
After configuration - you should see this in the TEPS panel.
===============
How do you resolve this below ?
Failed to connect to Teps
2014-03-24 15:06:55: TImpMainTask: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-24 15:06:55: TImpMainTask: CANDLEHOME is C:\IBM\ITM
2014-03-24 15:06:55: TImpMainTask: config dir C:\IBM\ITM\TMAITM6\Config
2014-03-24 15:06:55: TImpMainTask: root dir C:\IBM\ITM\TMAITM6\
2014-03-24 15:06:55: TImpMainTask: todeploy dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-24 15:06:55: TImpMainTask: deployed dir C:\IBM\ITM\TMAITM6\Config/deployed
2014-03-24 15:06:55: TImpMainTask: No sql files found in dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-24 15:06:55: TImpMainTask: processFiles failed.
2014-03-24 15:06:55: DONT_TRIM_MSNS=
2014-03-24 15:06:55: MSN trimming is enabled
2014-03-24 15:06:55: Using jvm classpath C:\IBM\ITM\TMAITM6\kpaxjdbc.jar;C:\Downloads\ojdbc5.jar
2014-03-24 15:06:55: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-24 15:06:55: Using jvm from C:\IBM\ITM\java\java70\jre\bin\classic\jvm
2014-03-24 15:06:55: Cannot find JNI_CreateJavaVM function in loaded jvm !
2014-03-24 15:06:55: JNI_CreateJavaVM returns 0
2014-03-24 15:06:55: Error loading VM
2014-03-24 15:06:55: Adding Task <ConfigParser>
2014-03-24 15:06:55: Adding Task <GarbageCollectorTask>
2014-03-24 15:06:55: OUTPUT_KEEPER_DUMP is ''
2014-03-24 15:06:55: Entering task controller execution loop
2014-03-24 15:06:55: Checking config parser task: <ConfigParser>
2014-03-24 15:06:55: JDBCConnection::Connect: jdbc:oracle:thin:@co9118051168.in.ibm.com:1521:WAREHOUS
2014-03-24 15:06:55: jdbc:oracle:thin:@co9118051168.in.ibm.com:1521:WAREHOUS connected
2014-03-24 15:06:55: Failed to connect to TEPS database <=========
2014-03-24 15:06:55: Checking if there is any user task going to be run
==============================================================
Another screen capture - but without the debug flag turned on.
This is from the kpacma.log in the c:\ibm\itm\tmaitm6\logs folder.
2014-03-26 02:33:02: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-26 02:33:02: Using jvm from C:\IBM\ITM\java\java70\jre\bin\classic\jvm
2014-03-26 02:33:03: Cannot find JNI_CreateJavaVM function in loaded jvm !
2014-03-26 02:33:03: JNI_CreateJavaVM returns 02014-03-26 02:33:03: Error loading VM
2014-03-26 02:33:03: OUTPUT_KEEPER_DUMP is ''
2014-03-26 02:33:03: Entering task controller execution loop
2014-03-26 02:33:03: Failed to connect to TEPS database
2014-03-26 02:33:03: Evaluation total time 0 s
================================================================
A typical ITM installation on a windows 2012 64 bit server, shows the various components:
PA is 32 bit, Summarization and Pruning is 64 bit. ( this is during the test phases )- validating if this works or not.
************* Monday, March 24, 2014 4:01:30 PM *************
User : Administrator Group : NA
Host Name : CO9118051168 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 20140319 1638
CJ TEPD App Support/Tivoli Enterprise Portal Desktop Clien WIX64 06.30.02.00 d3248a 20140319 1638
CQ KCQ(64-bit) CMA/Tivoli Enterprise Portal Server Agent WIX64 06.30.02.00 d3248a 20140319 1638
CQ TEPS App Support/Tivoli Enterprise Portal Server WIX64 06.30.02.00 d3248a 20140319 1638
CW TEPB App Support/Tivoli Enterprise Portal Browser Clien WINNT 06.30.02.00 d3248a 20140319 1638
GL KGL(64-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WIX64 06.30.02.00 d3248a 20140319 1638
GL KGL(32-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WINNT 06.30.02.00 d3248a 20140319 1638
HD KHD(64-bit) CMA/Warehouse Proxy Agent WIX64 06.30.02.00 d3248a 20140319 1638
KF KKF(32-bit) IEH/IBM Eclipse Help Server WINNT 06.30.02.00 d3221a 20140319 1638
MS TEMS App Support/Tivoli Enterprise Monitoring Server WIX64 06.30.02.00 d3248a 20140319 1638
NT KNT(32-bit) CMA/Monitoring Agent for Windows OS WINNT 06.30.02.00 32191 20140320 1359
PA KPA(32-bit) CMA/Tivoli Performance Analyzer WINNT 06.30.02.00 32251 20140319 1638
SY KSY(64-bit) CMA/Summarization and Pruning Agent WIX64 06.30.02.00 d3221a 20140319 1638
UE KUE(32-bit) CMA/Tivoli Enterprise Services User Interfa WINNT 06.30.02.00 d3248a 20140319 1638
A server in the customer 's environment showed this instead -notice the 32bit installation of the Summarization and Pruning agent. Notice that the PA is 32bit, but the SPA is 32bit as well.
AC KAC(64-bit) CMA/32/64 Bit Agent Compatibility Package WIX64 06.30.02.00 201308240836 20131118 1314
CJ TEPD App Support/Tivoli Enterprise Portal Desktop Clien WIX64 06.30.02.00 d3248a 20131118 1314
CQ KCQ(64-bit) CMA/Tivoli Enterprise Portal Server Agent WIX64 06.30.02.00 d3248a 20131118 1314
CQ TEPS App Support/Tivoli Enterprise Portal Server WIX64 06.30.02.00 d3248a 20131118 1314
CW TEPB App Support/Tivoli Enterprise Portal Browser Clien WINNT 06.30.02.00 d3248a 20131118 1314
GL KGL(64-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WIX64 06.30.02.00 d3248a 20131118 1314
GL KGL(32-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WINNT 06.30.02.00 d3248a 20131118 1314
HD KHD(64-bit) CMA/Warehouse Proxy Agent WIX64 06.30.02.00 d3248a 20131118 1314
KF KKF(32-bit) IEH/IBM Eclipse Help Server WINNT 06.30.02.00 d3221a 20131118 1314
MS TEMS App Support/Tivoli Enterprise Monitoring Server WIX64 06.30.02.00 d3248a 20131118 1314
NT KNT(64-bit) CMA/Monitoring Agent for Windows OS WIX64 06.30.02.00 32191 20140227 1412
PA KPA(32-bit) CMA/Tivoli Performance Analyzer WINNT 06.30.02.00 32251 20131118 1314
SY KSY(32-bit) CMA/Summarization and Pruning Agent WINNT 06.30.02.00 d3221a 20131118 2033
UE KUE(32-bit) CMA/Tivoli Enterprise Services User Interfa WINNT 06.30.02.00 d3248a 20131118 1314
Please look at the 32bit Oracle ODBC driver installation and install.
Read the Best Practices before installing the Oracle for Tivoli Monitoring.
Some snapshots are enclosed which focus on the Oracle installation and configuration.
these are my steps and officially not documented this way anywhere., but has worked for me - so documenting it.
Run the setup.exe
Enter an email address to start off with the installation. ( and unchecked the next push button )
Next, I selected "I want to remain uninformed of Critical security patches" and the rest of the panel got grayed out - as I was behind a firewall and this did not matter.
Step 2: Selected "Skip Software Updates"
Step 3: Create and configure a database.
Step 4: "Desktop Class"
Step 5: "Use Windows Built-In account"
Step 6: in the below snapshot ,I unchecked the "Create as container database" , and changed the default from ORCL to WAREHOUS.
This below is if you have created a default of ORCL and want to create another database called WAREHOUS ( not recommended - but putting the snapshot in case you need it )
Something about "Save Response File" I clicked "Continue"
Click on Install, Finish
-
Do not Delete the Browsing history, or Cache at this point during the startup of the portal ( see below )
At this point -do not close the above window where it says Password management - You will need it in case, the login prompt wont let you in.
Then click on the Password management - reset the password for sys and login back again.
Click on "Security tab" above. -> Users -> Create user.
Create the user 'ITMUser" and password "itmpswd1"
Something about Table spaces - I am accepting the defaults.
2. Create Roles
Security-> Roles -> Create Role -> Create role as ITM_DW
Enter ITM_DW
Next - assign some capabilities to the role.
-
-
__ Assign Role ITM_DW to User ( ITMuser )
Register the Oracle driver with the Windows ODBC data source.
Start -> Administrative tools -> Data Sources. ( 64 bit )
Or open a command line, go to c:\windows\sysWoW64\odbcad32.exe
Next up, we will need to register the Oracle driver under Windows Server's ODBC Data Source Administrator.
Go to the Start Menu, navigate to Administrative Tools, then select Data Sources (ODBC) 64 bit.
Select the System DSN tab. If your Oracle driver is not listed, which should be the case, select Add, scroll down to where your Oracle driver is listed.
In my case it says Oracle 12c ( see snap below ) —then select Next.
The next window is going to need you to input information regarding the ODBC connection you are going to create.
For Data Source Name enter ITM Warehouse, for TNS Service Name enter WAREHOUS, then for User ID enter ITMUser. .
If the above is slow to reach, that means the tnsnames.ora and listener.ora needs to be tweaked and it is a little complex ( in my opinion ) to configure it .
That will be covered in another blog.
Now, create the "TNS Service Name"
Open the "Net Configuration Assistant."
Select Add. In the Service Name field, enter WAREHOUS.
For the network protocol, select TCP.
Next, enter the host name and port number of the computer on which the Database resides.
The default port number is 1521.
Perform the connection test to verify you can actually connect to it.
You should then be prompted to configure another net service name, select No. Once back at the original screen, click Finish to exit.
If this fails, Hit Cancel
Click on "Test"
Click "Next" on warehous and
If this fails - then Change Login - and try again.
Or Click Cancel and try testing again. with the different credentials . (in my case it was ITMUser/itmpswd1 )
Configure the Summarization and Pruning Agent, Warehouse Agent and other components thar need the Oracle as the TDW.
===============================================
The tnsnames.ora after configuration shows up as :
tnsnames.ora Network Configuration File: C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
WAREHOUS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051206.in.ibm.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WAREHOUS)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051206.in.ibm.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.in.ibm.com)
)
)
=====================================================
Listener.ora
# listener.ora Network Configuration File: C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\Administrator\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051206.in.ibm.com)(PORT = 1521))
)
)
============================================================
sqlnet.ora
# sqlnet.ora Network Configuration File: C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
===
Install ITM,
My test environment is to set up the ITM using TEPS to Embedded, and Performance Analyzer to Oracle as a TDW.
So TEPS -> Embedded
ITM ( PA, SPA, and WPA ) to Oracle 12c as my TDW.
In my case I installed ITM 6.3.0,and one of the first few steps is that the ITM tries to configure the Warehouse Proxy Agent.
If the below snapshot does not succeed -then go to the 64 bit ODBC and check if the DSN is there or not. After successfully configuring and test connection succeeds - then come back to ITM and continue with the installation.
Next, it configures the TEPS - this takes a little long.
Trouble shooting tips
If the ODBC configuration window during the test is slow, then I found that entering the hostname ,instead of "localhost" for the tnsnames.ora
e.g:
WAREHOUS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051168.in.ibm.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = WAREHOUS)
)
)
and the listener.ora to have this.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = co9118051168.in.ibm.com)(PORT = 1521))
)
)
Steps to do it right: ( except the database connection issue )
a) tnsnames.ora and listener.ora to have the hostname instead of the localhost
b ) stop pa
c) stop tnslsnr ( in the c:\app\Administrator\product\12.1.0\dbhome_1\BIN folder )
d ) remove the PA clear Offline entries.
e ) tnslsnr start
f ) open the 64 bit odbcad32.exe and test conection .
g) This is unrelated to the configuration of Oracle and ITM - but found this helpful during my install sessions - hence putting it here.
To fix the above - I had to manually delete the c:\users\Administrator\AppData\local\temp\2 folder command line
This is not helping ! There are some Oracle processes being help up.
So I have to stop the WAREHOUS table.
Bring up the Oracle Admin GUI. ( Remember to stop the PA, WPA, and SPA )
Right Click and stop Service and Restart Service.
If the above does not help, stop all the Oracle related processes in the services window.
Restart all : I was unable to start a few !
-
Another troubleshooting tip.
How to resolve the Unable to set the tasks being configured successfully.
This can happen when you open the configuration panel and make changes and try to save the tasks.
-Stop PA ,and bring up the GUI, andtry to alter and save.-Start PA, bring up the PA config panel and try to alter and save the tasks.
In one of my experiments - I was to start the PA agent and then save, it worked.
but it failed at one point since ( maybe) the agent was down ! to be tested again.
--
How to configure the SPA :
Sometimes you will get to see the "localhost"- I changed it to the hostname by making this changes in the configuration.
Stop and restart the agent - to see the host name in the TEPS Panel.
------------
My experiments with setting the hostname as a Fully Qualified domain name on Summarization and Pruning agent.
After configuration - you should see this in the TEPS panel.
===============
How do you resolve this below ?
Failed to connect to Teps
2014-03-24 15:06:55: TImpMainTask: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-24 15:06:55: TImpMainTask: CANDLEHOME is C:\IBM\ITM
2014-03-24 15:06:55: TImpMainTask: config dir C:\IBM\ITM\TMAITM6\Config
2014-03-24 15:06:55: TImpMainTask: root dir C:\IBM\ITM\TMAITM6\
2014-03-24 15:06:55: TImpMainTask: todeploy dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-24 15:06:55: TImpMainTask: deployed dir C:\IBM\ITM\TMAITM6\Config/deployed
2014-03-24 15:06:55: TImpMainTask: No sql files found in dir C:\IBM\ITM\TMAITM6\Config/todeploy
2014-03-24 15:06:55: TImpMainTask: processFiles failed.
2014-03-24 15:06:55: DONT_TRIM_MSNS=
2014-03-24 15:06:55: MSN trimming is enabled
2014-03-24 15:06:55: Using jvm classpath C:\IBM\ITM\TMAITM6\kpaxjdbc.jar;C:\Downloads\ojdbc5.jar
2014-03-24 15:06:55: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-24 15:06:55: Using jvm from C:\IBM\ITM\java\java70\jre\bin\classic\jvm
2014-03-24 15:06:55: Cannot find JNI_CreateJavaVM function in loaded jvm !
2014-03-24 15:06:55: JNI_CreateJavaVM returns 0
2014-03-24 15:06:55: Error loading VM
2014-03-24 15:06:55: Adding Task <ConfigParser>
2014-03-24 15:06:55: Adding Task <GarbageCollectorTask>
2014-03-24 15:06:55: OUTPUT_KEEPER_DUMP is ''
2014-03-24 15:06:55: Entering task controller execution loop
2014-03-24 15:06:55: Checking config parser task: <ConfigParser>
2014-03-24 15:06:55: JDBCConnection::Connect: jdbc:oracle:thin:@co9118051168.in.ibm.com:1521:WAREHOUS
2014-03-24 15:06:55: jdbc:oracle:thin:@co9118051168.in.ibm.com:1521:WAREHOUS connected
2014-03-24 15:06:55: Failed to connect to TEPS database <=========
2014-03-24 15:06:55: Checking if there is any user task going to be run
==============================================================
Another screen capture - but without the debug flag turned on.
This is from the kpacma.log in the c:\ibm\itm\tmaitm6\logs folder.
2014-03-26 02:33:02: KPA_JAVA_HOME is C:\IBM\ITM\java\java70
2014-03-26 02:33:02: Using jvm from C:\IBM\ITM\java\java70\jre\bin\classic\jvm
2014-03-26 02:33:03: Cannot find JNI_CreateJavaVM function in loaded jvm !
2014-03-26 02:33:03: JNI_CreateJavaVM returns 02014-03-26 02:33:03: Error loading VM
2014-03-26 02:33:03: OUTPUT_KEEPER_DUMP is ''
2014-03-26 02:33:03: Entering task controller execution loop
2014-03-26 02:33:03: Failed to connect to TEPS database
2014-03-26 02:33:03: Evaluation total time 0 s
================================================================
A typical ITM installation on a windows 2012 64 bit server, shows the various components:
PA is 32 bit, Summarization and Pruning is 64 bit. ( this is during the test phases )- validating if this works or not.
************* Monday, March 24, 2014 4:01:30 PM *************
User : Administrator Group : NA
Host Name : CO9118051168 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 20140319 1638
CJ TEPD App Support/Tivoli Enterprise Portal Desktop Clien WIX64 06.30.02.00 d3248a 20140319 1638
CQ KCQ(64-bit) CMA/Tivoli Enterprise Portal Server Agent WIX64 06.30.02.00 d3248a 20140319 1638
CQ TEPS App Support/Tivoli Enterprise Portal Server WIX64 06.30.02.00 d3248a 20140319 1638
CW TEPB App Support/Tivoli Enterprise Portal Browser Clien WINNT 06.30.02.00 d3248a 20140319 1638
GL KGL(64-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WIX64 06.30.02.00 d3248a 20140319 1638
GL KGL(32-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WINNT 06.30.02.00 d3248a 20140319 1638
HD KHD(64-bit) CMA/Warehouse Proxy Agent WIX64 06.30.02.00 d3248a 20140319 1638
KF KKF(32-bit) IEH/IBM Eclipse Help Server WINNT 06.30.02.00 d3221a 20140319 1638
MS TEMS App Support/Tivoli Enterprise Monitoring Server WIX64 06.30.02.00 d3248a 20140319 1638
NT KNT(32-bit) CMA/Monitoring Agent for Windows OS WINNT 06.30.02.00 32191 20140320 1359
PA KPA(32-bit) CMA/Tivoli Performance Analyzer WINNT 06.30.02.00 32251 20140319 1638
SY KSY(64-bit) CMA/Summarization and Pruning Agent WIX64 06.30.02.00 d3221a 20140319 1638
UE KUE(32-bit) CMA/Tivoli Enterprise Services User Interfa WINNT 06.30.02.00 d3248a 20140319 1638
A server in the customer 's environment showed this instead -notice the 32bit installation of the Summarization and Pruning agent. Notice that the PA is 32bit, but the SPA is 32bit as well.
AC KAC(64-bit) CMA/32/64 Bit Agent Compatibility Package WIX64 06.30.02.00 201308240836 20131118 1314
CJ TEPD App Support/Tivoli Enterprise Portal Desktop Clien WIX64 06.30.02.00 d3248a 20131118 1314
CQ KCQ(64-bit) CMA/Tivoli Enterprise Portal Server Agent WIX64 06.30.02.00 d3248a 20131118 1314
CQ TEPS App Support/Tivoli Enterprise Portal Server WIX64 06.30.02.00 d3248a 20131118 1314
CW TEPB App Support/Tivoli Enterprise Portal Browser Clien WINNT 06.30.02.00 d3248a 20131118 1314
GL KGL(64-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WIX64 06.30.02.00 d3248a 20131118 1314
GL KGL(32-bit) CMA/Tivoli Enterprise Monitoring Agent Fram WINNT 06.30.02.00 d3248a 20131118 1314
HD KHD(64-bit) CMA/Warehouse Proxy Agent WIX64 06.30.02.00 d3248a 20131118 1314
KF KKF(32-bit) IEH/IBM Eclipse Help Server WINNT 06.30.02.00 d3221a 20131118 1314
MS TEMS App Support/Tivoli Enterprise Monitoring Server WIX64 06.30.02.00 d3248a 20131118 1314
NT KNT(64-bit) CMA/Monitoring Agent for Windows OS WIX64 06.30.02.00 32191 20140227 1412
PA KPA(32-bit) CMA/Tivoli Performance Analyzer WINNT 06.30.02.00 32251 20131118 1314
SY KSY(32-bit) CMA/Summarization and Pruning Agent WINNT 06.30.02.00 d3221a 20131118 2033
UE KUE(32-bit) CMA/Tivoli Enterprise Services User Interfa WINNT 06.30.02.00 d3248a 20131118 1314
Please look at the 32bit Oracle ODBC driver installation and install.
No comments:
Post a Comment