Thursday, March 27, 2014

ORA-01090, ORA 03113 -

This was seen on the Database Administrator during the connection process, since a shutdown was already issued - this error popup was seen.
















Seen during the shutdown process. This was in the command prompt/

I had issued the shutdown and it did not seem to complete the process and I went to the services folder and shutdown the various services.

SQL> shutdown
ORA-03113: end-of-file on communication channel
SQL>

IBM and Hadoop - an article

https://w3-connections.ibm.com/blogs/7620ea40-0851-4b28-bce0-06c2315965b1?lang=en_us&lnk=w3news

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.











































ORA-12505 - Listener does not know of SID !





To fix this .


- Check which instances are currently known by the listener by executing: lsnrctl services <listener name>
- Check that the SID parameter in the connect descriptor specifies an instance known by the listener.



ORA - 12560 - TNS protocol adapter error

c:\Windows\System32>sqlplus sys as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Mar 26 16:25:03 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:


How to resolve this ?


 ========================================================

search for the service and start it
Run-> services.msc - search for WAREHOUS -> Start the service.





This did not help either !
=========================================================


=========================================================
One of the web sites said a ) set the oracle_sid and b) net start.

1.
I had to stop it first and restarted it - no luck !



c:\app\Administrator\product\12.1.0\client_1>set oracle_sid=WAREHOUS

c:\app\Administrator\product\12.1.0\client_1>net start oracleserviceWAREHOUS
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.


c:\app\Administrator\product\12.1.0\client_1>net stop oracleserviceWAREHOUS
The OracleServiceWAREHOUS service is stopping...........
The OracleServiceWAREHOUS service was stopped successfully.


c:\app\Administrator\product\12.1.0\client_1>sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Mar 26 16:51:21 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error



Tuesday, March 25, 2014

Test scenarios with Oracle 12c while creating the TDW.


SQL Developer and SQL Plus:

After installation and creating of the Oracle DB WAREHOUS, and configuring the ITM and launching the 64 bit SQL developer, follow this procedure to see the WAREHOUS on the left panel.
 
I had to manually create the connections in order to see the WAREHOUS db.

This is the link I followed.
http://docs.oracle.com/cd/E16655_01/appdev.121/e21814/tdddg_connecting.htm#TDDDG121

 

Essentially - click on Connections-> new Connection-> and enter as shown below.




Click on WAREHOUS and this is what was seen.

  




























How to remove this error :














For this 
Check that the ITM TEPS GUI is showing the PA panel and the tasks correctly - before proceeding.
  
a ) tnslsnr stop
b ) Remove the TNS_ADMIN in the Control Panel -> Advanced -> Environemntvars.
c ) Stop the SQL developer plus.
d ) Close the Command window.


e ) Open new command prompt.
f  ) Echo %TNS_ADMIN% - should show that this environment is not set
g )  tnsping  WAREHOUS

C:\Users\Administrator>tnsping WAREHOUS

TNS Ping Utility for 64-bit Windows: Version 12.1.0.1.0 - Production on 25-MAR-2
014 16:18:18

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
C:\app\Administrator\product\12.1.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = co911805
1168.in.ibm.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAM
E = WAREHOUS)))
OK (10 msec)  <============================================

 
i ) start the SQL developer plus
To be continued. )


=============================================================================



To fix this.

Installing Oracle 12c Client for ODBC connections.

This blog discusses how to resolve the ERROR shown on the TEP GUI console when the performance Analyzer is started.



Some background:
Performance Analyzer Agent is built as a 32 bit executable.

If one is attempting to run this on a windows 2012 platform which is a 64 bit, then this requires a 32bit Oracle ODBC drivers to be set up and it cannot use the default 64 bit ODBC connections.

In this context : one would download the 32 bit Oracle ODBC driver from this location below:


c:\IBM\ITM>kincinfo -t pa
************ Tuesday, March 25, 2014 3:04:14 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

PA  KPA(32-bit) CMA/Tivoli Performance Analyzer              WINNT  06.30.02.00 32251         20140319 1638

PC  APPLICATION SUPPORT DESC                                 PLAT   APP VER  BUILD         INSTALL DATE

PA  TEMS App Support/Tivoli Performance Analyzer             WICMS  06.30.02.00 32251         20140319 1638
PA  TEPS App Support/Tivoli Performance Analyzer             WICNS  06.30.02.00 32251         20140319 1638
PA  TEPB App Support/Tivoli Performance Analyzer             WIXEB  06.30.02.00 32251         20140319 1638
PA  TEPD App Support/Tivoli Performance Analyzer             WIXEW  06.30.02.00 32251         20140319 1638
P0  KP0(32-bit) CPA/Performance Analyzer Domain for DB2      WICPA  06.30.02.00 32252         20140320 1146
P3  KP3(32-bit) CPA/Performance Analyzer Domain for OS agen  WICPA  06.30.02.00 32252         20140320 1146
P4  KP4(32-bit) CPA/Performance Analyzer Domain for Oracle   WICPA  06.30.02.00 32252         20140320 1146
P6  KP6(32-bit) CPA/Performance Analyzer Domain for System   WICPA  06.30.02.00 32252         20140320 1146
PI  KPI(32-bit) CPA/Performance Analyzer Domain for ITCAM R  WICPA  06.30.02.00 32252         20140320 1146
PU  KPU(32-bit) CPA/Performance Analyzer Domain for VMware   WICPA  06.30.02.00 32252         20140320 1146


Check what the Kincinfo is showing

Is it WINNT or WIX64?  

If it's WINNT, then you need to create a 32-bit ODBC so it can talk to the Oracle TDW.  

While WPA requires 64-bit ODBC.  So we have to create 2 different ODBC when TEPS and WPA are installed on the same Window system.


Here are some snapshots of installing the 32bit Oracle ODBC driver.
( but before you install - click on c:\windows\sysWoW64\odbcad32.exe and click on DSN - and ensure
a) The ITM Warehouse is a 64 bit DSN and
b) Add -> does not have a " Oracle 12dbhome_1 "   - clearly indicating the DSN for 32 bit is not present.


Let's download the 32bit Oracle client :

http://www.oracle.com/technetwork/indexes/downloads/index.html








http://www.oracle.com/technetwork/topics/dotnet/downloads/net-downloads-160392.html










 
PA is a 32bit executable, itneeds the 32bit ODBC to talk to the Oracle TDW.First to install the 32bit ODBC so that it can talk to the Oracle TDW  
bring up the 32bit ODBC and validate that there is no DSN  
below, it is a 32bit ODBC -and THE DSN is actually 64 bit, but I need to install and create the 32 bit.  
 
Now install the 32bit oracle client.  
 
 
 
Click Next.  
 
 
 
 
 
Now, bring up the 32bit ODBC in the c:\windows\syswow64 folder.  
Click on Add.  
Search for the 32 bit Oracle ODBC driver.  
 
Configure and test the connection.  
If you got this.  
 
Check TNSNames.ora in the c:\app\Administrator\product\12.1.0\client_1\Network\Admin  



Troubleshooting tips:


The client installs a new folder as shown below in blue.



c:\app\Administrator\product\12.1.0>dir
 Volume in drive C has no label.
 Volume Serial Number is F635-DBE5

 Directory of c:\app\Administrator\product\12.1.0

03/25/2014  11:54 AM    <DIR>          .
03/25/2014  11:54 AM    <DIR>          ..
03/25/2014  12:03 PM    <DIR>          client_1
03/25/2014  12:26 PM    <DIR>          dbhome_1
               0 File(s)              0 bytes
               4 Dir(s)   9,499,811,840 bytes free




Go to "Control Panel -> Advanced ->  

Set the environment variable in the Advanced tab of the System Properties control panel.
Bring up a new command prompt window.

Check it is set:

echo %TNS_ADMIN%


Then run tnsping to check if your connect string can be resolved:


The tnsnames.ora looks like this.

ITM Warehouse =
   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co9118051168)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = WAREHOUS)
    )
  )

( to be continued )

The impact of this is the PA on the TEPS console does not show the ERROR it used to show earlier.





tnsping <connect string>