- Configure sshd service on Windows host
- Install the Microsoft SQL Server OMS plugin
- Download the Windows Agent
- Install Windows Agent
- Add the Target
prerequisite
- OEM installation
- Microsoft SQL server installation: To simplify the test, I made some configuration change:
- Turn off firewall
- Edit host file so it contains the linux host name to contain the linux host. %SystemRoot%\system32\drivers\etc\hosts
- Disable local security policy
- Create the local admin account with the same login name on the linux ( oracle).
Configure sshd service on Windows host
Please refer here.
Install the Microsoft SQL Server OMS Plugin
Setup –> Extensibility –> Self Update
Click Plugin
Click the Microsoft SQL Server plugin , If the plugin is not downloaded ( status: Available), click the download first . Once it is download, click the Apply
Select the Management Servers
Download the Windows Agent
- From the 12c, the agent can not be download separately from OTN. We have to download through the 12c either through the online or offline mode.
- The easier way to get the agent download is setup the online mode.
Setup –> Extensibility –> Self Update
Click Agent software
Select Microsoft windows and click download
Click the Apply
Install Windows Agent
- The Windows agent must be deploy on the Windows platform. The Agent use WMI to monitor the Windows, if the agent is on the Linux host, we would get the WMI error. “_OS_Type_Agent_DynamicProperty;Process invocation failure: java.io.IOException: Cannot run program "/u01/app/oracle/agent12cr2/core/12.1.0.2.0/bin/nmefwmi” . The nmwfwmi is the wmi monitor executable.
Setup –> Extensibility –> Self Update
Fill in the target host name
Fill in the host information. If the directory does not exist, it would be created
- Installation Base Directory: C:\OEM
- Instance Directory: C:\OEM\agent_inst
Provide the host credential
Then, click deploy agent
After the agent is deploy, we can verify the agent status
C:\OEM\agent_inst\bin\emctl.bat status agent
Add the Target
Setup –> Add Target –> add Targets Manually
Select the agent on the windows
Click add manually
Fill in the information
Database Role: sysadmin
This is OEM bugs, test connection would always fail with below error: SKIP the test and add the target.
Test Connection failed: [_WinAuthDLLToLoadDynamicProp;DB Credentials are found missing. DB Credentials are required for SQL based connections, MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _Wbem_Remote_Determination_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _MSSQL_Instance_TestMetric_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _OS_Type_TargetHost_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile)]
In the example above, I use the sql authentication. If I use windows authentication, I would get the “'C:\OEM\plugins\oracle.em.smss.agent.plugin_12.1.0.2.0\scripts\emx\microsoft_sqlserver_database..\..\..\..\dependencies\oracle.em.smss\jdbcdriver\sqljdbc_auth.dll' is found missing ” . We have to create the directory and download the sqljdbc_auth.dll from MSFT website then copy to that directory. However, I still get the test connection fail error.
After the target installed. check the host agent status
emctl config agent listtargets
Target –> All Target –> Click the host pandawin
Target –> All Target –> Click the MSSQL
we can also see the instance information
Reference
- http://gavinsoorma.com/2012/06/installing-the-12c-cloud-control-plug-in-for-microsoft-sql-server-database/
- http://gavinsoorma.com/2012/06/deploying-the-12c-management-agent-on-windows-using-the-12c-cloud-control-self-update-feature/
- https://forums.oracle.com/forums/thread.jspa?messageID=10745368
- https://forums.oracle.com/forums/thread.jspa?messageID=10784916
- http://docs.oracle.com/cd/E17559_01/em.111/e10314/emptg.htm
Its really a nice post, the content of this blog is really awesome and extraordinary.And also please Read link bvba Woodstone which provide information server monitoring & monitoring tools
ReplyDeleteyou can connect your security camera system to your computer via the Internet and have eyes on your property whenever you want Top Portable Monitors
ReplyDelete
ReplyDeleteAs an insurance, it merits checking whether your other programming is refreshed to be perfect with Windows 8.1.solar deals
Thanks for sharing this interesting blog with us.My pleasure to being here on your blog..I wanna come beck here for new post from your site. 4kcomputermonitor.com
ReplyDeleteIn the present worldwide setting firms need to realize what technologies would competitors be able to gag effectively, and might endeavor.https://www.techpally.com/learn-to-repair-ac/
ReplyDeleteIf you're like most households and own a computer or a laptop-then there's a good chance that you also have a LCD computer screen. 4k vs 144hz: What's the best
ReplyDeleteMight be likewise a reasonably wonderful short article that we all most certainly most popular assessing. Might be no day-after-day in which watch the possibility to look through unit. gecey.com/24-inch-tv
ReplyDeleteHello! I just wish to give an enormous thumbs up for the nice info you've got right here on this post. I will probably be coming back to your weblog for more soon! Best 4k 144hz monitor 2019
ReplyDeleteI gotta favorite this website it seems very helpful . Read reviews
ReplyDeleteWe are truly thankful for your blog entry. You will discover a great deal of methodologies in the wake of going to your post. I was precisely scanning for. A debt of gratitude is in order for such post and please keep it up. OEM
ReplyDeleteRegular visits listed here are the easiest method to appreciate your energy, which is why why I am going to the website everyday, searching for new, interesting info. Many, thank you https://serverbrowse.com/
ReplyDeleteHelpful article! Which you have given such good and informative knowledge on microsoft. It's useful for me but also good for others who are searching for this information. Thanks for giving me information like this. Oracle integration cloud service Certification
ReplyDeleteGaming monitor reviews: Every company offers exclusive facilities and advantages for selling their gaming monitors. You should read different reviews online to know more about their features and advantages. gaming monitor 144hz
ReplyDeleteIt likewise gives me to future coming highlights games which can without much of a stretch be open on this HTC Vive. Mad Heroes Mod APK
ReplyDelete