Usefull tools

Do you want to monitor running processes?

You can use :

http://technet.microsoft.com/en-us/sysinternals/bb896645

VS build commands

Today I needed to copy output from one solution into another.

command to do this is as follows:

copy $(TargetDir) "$(SolutionDir)\PROJECT-NAME\bin"

ERROR ORA-12154 TNS: installing ODAC 11.2

Solution as its progresses

Step 1:

Source of solution 1

SYMPTOM
Receive the error message, "ORA-12154 TNS: could not resolve the connect identifier specified."

Error while installing ODAC 11.2 Release 4 and Oracle Developer Tools for Visual Studio (11.2.0.3.0) in Microsoft Transaction Server

Error:

Value = NumberOfInstalls

INFO: Query Returned: 1

INFO: Setting variable 'n_numInstalls' to '1'. Received the value from a code block.

INFO: Calling Query w32RegQueries10.2.0.1.0  RegGetStringValue

Key = HKEY_LOCAL_MACHINE

SubKey = software\oracle\OracleMTSRecoveryService\Setup\All Versions\1

Value = Home

INFO:

Query Exception: GetValueKeyNotFoundException

Query Exception Class: class oracle.sysman.oii.oiil.OiilQueryException

INFO: *** Cancel Dialog: Specified key not found ***

INFO: User Selected: Stop installation of all products.

 

Solution:

You will need to update registry. Follow steps below

 

Setting up keys in registry:

1, Key = HKEY_LOCAL_MACHINE

SubKey = software\oracle\OracleMTSRecoveryService\Setup\All Versions\1

Value = Home

value: C:\oracle\product\10.2.0\client_1\

select new > String value

2, Key = HKEY_LOCAL_MACHINE

SubKey = software\oracle\OracleMTSRecoveryService\Setup\Current Version\

value: C:\oracle\product\10.2.0\client_1\

this value will get overwritten with installer value, but the key has to be present.

Oracle cheat sheet

Display existing tables in oracle db

Code:

SELECT owner, table_name
  FROM dba_tables

if you need only user tables:  

SELECT table_name
  FROM user_tables

NLog config targets -Database, Text File, EventLog

Example of NLog Targets



<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">




  <variable name="applicationName" value="Application" />
 
 
  <!-- do not change -->
  <variable name="eventLogTaget" value="ProjectName" />
 
  <targets>
    <!-- NLogViewer logger -->
    <!-- Text file logger -->
   
    <target name="logFile" xsi:type="File"
            layout="${longdate} ${level} ${message}"
            fileName="${basedir}/${shortdate}.log" />


   
   
    <target name="log" xsi:type="EventLog"
            layout="${logger}: ${message} ${exception:format=ToString}"
            log="${eventLogTaget}" source="${applicationName}" />


    <target name="logdb" type="Database">
      <dbprovider>mssql</dbprovider>
      <dbhost>SERVER2</dbhost>
      <dbdatabase>NLogDatabase</dbdatabase>
      <dbusername>temp</dbusername>
      <dbpassword>temp</dbpassword>


      <commandText>
        INSERT INTO dbo.LogTable([level]
        ,[logger]
        ,[message]
        ,[exception])
        VALUES( @level, @logger, @message, @exception);
      </commandText>
     
      <parameter name="@level" layout="${level}" />
      <parameter name="@logger" layout="${logger}" />
      <parameter name="@message" layout="${message}" />
      <parameter name="@exception" layout=" ${exception:format=ToString}" />
    </target>
   
  </targets>
  <rules>
    <!--<logger name="*" levels="Trace, Info, Debug, Warn, Error, Fatal" writeTo="eventlog"/>-->
    <logger name="*" levels="Trace, Info, Debug, Warn, Error, Fatal" writeTo="log, logdb, logFile"/>
  </rules>
</nlog>