6 comments

  1. Great Job!
    Thanks for sharing it.

    Best regards.

    Berni

    Berni

  2. Hi Michel,

    why does i have to install “2. Install the ORACLE ODBC driver and client tools (connectivity) on the oracle servers.” on the Oracle Servers? Did you mean the MOM Management-Servers?

    regards
    Mario

    Mario

  3. Mario,

    The Scripts will run on the Agent (so the oracle servers) and it uses an Oracle ODBC connection to query. So you must have installed this step 2. By default ODBC drivers will be installed but the client tools are’nt. You can check it by making a new ODBC connection with the windows ODBC tool in your control pannel local on your oracle server. If the ‘test’ is succesfull its ok.

    Michel

    michelk

  4. Hi Michel,

    I’m getting this error in Event Viewer of the servers with Oracle.

    Event ID: 9100
    An error occurred on line 119 while executing script ‘[MITS] Oracle v$ prefcounter collection ‘
    Source: Microsoft OLE DB Provider for ODBC Drivers
    Description: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener

    Have any idea what causes this error?

    Thanks,
    Miguel

    Miguel

  5. Michel,

    I forget to say that i have installed your oracle management pack 🙂
    And the error above is from one of the scripts of the management pack.

    Regards,
    Miguel

    Miguel

  6. Miguel,

    This has something to do with the TSN connection string. It seems that your Oracle service name has a different Listner name. Complex story but I have the fix but not right now. BTW. In a couple of weeks I wil post a revision of the Oracle Management pack for SCOM2007.

    Michel

    michelk

Comments are closed.