Hi,

As you probably know, in SCOM 2012, there is no RMS role anymore. For keeping backward compatibility with some management packs that required the RMS role, Microsoft created the RMS Emulator role.

By default this role is hosted on the first management server that you installed.

As you can see, SCOM2012.vnext.be server is hosting the RMS Emulator role. This is confirmed by the following PowerShell command : GET-SCOMRMSEmulator command-let.

Now, if you want to move this role to another, simply execute the command : Get-SCOMManagementServer -Name "NewServerThatWillHostRMSEmulatorRole" | Set-SCOMRMSEmulator

You could confirm the move of the RMS Emulator role by retyping the command : GET-SCOMRMSEmulator

Or by looking on in the SCOM Console :

Cheers
Christopher KEYAERT
http://twitter.com/keyaertc

name · operations manager · opsmgr · Scom · server

Hi,

For one of my customer, I had to retrieve some information from an Oracle DB with System Center Opalis. The DB Query object included in Opalis supports MS SQL, Oracle, Odbc connection ….

For querying an Oracle DB with Opalis, there is some requirements, that I will explain step by step below :

1. Install the Oracle client on your Opalis server. Opalis requires the x86 release of the Oracle Client even if the Opalis server is in x64.

2. Oracle client is available at the following page : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

3. Download this version : Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit).

win32_11gR2_client.zip (684,581,290 bytes)

4. When downloaded, and uncompressed, just execute the setup.exe file.

5. During the installation process, select Runtime as installation type, and continue the next /next setup.

6. Once the setup finished, we need new to edit the tnsnames.ora configuration file.

7. Go to InstallationFolder\product\11.2.0\client_1\network\admin\ and edit the tnsnames.ora file.

8. ARSDVL is the name of the Oracle DB on which we want to connect, this name is used at two places in the file. line 4  as service name and also in the Connect_Data field. Host contqins is the name of the Oracle DB server.

9. Once the file edited and saved, for testing the connection, open a CMD prompt and type : 
SQLPLUS LOGIN@TNSNAME

10. If the SQL> prompt appears, we now than everything is ok and we could go back to our Opalis policy.

11. Here, a simple Opalis policy which will query the Oracle DB and return the result in an event.

12. Query Database object - Connection configuration : Add the name used in the tnsnames.ora file in the Service Name field, set the connection credentials.

13. Query Database object – Query : Here a simple Select query (Tips : Don’t add the ‘;’ at the end of the query or you will get an error message).

14. Send Platform Event – Configuration :

15. Run the policy.

16. Check the result

Christopher KEYAERT

client · Install · InstallationFolderproduct · name · zip