locked
Not gathering any oracle info RRS feed

  • Question

  • MAP 6.0 with oracle 11.2 client installed on Map server.  SSH finds the Linux oracle servers and obtains Linux info but nothing about oracle is captured.  MAP documentation says the required credential for Oracle is 'Administrator' credentials.  Would 'Administrator' be the linux user owning the oracle install or root or a database login?

    Any other info on how MAP collects oracle info would be helpful. 

    Thanks

    Friday, October 14, 2011 9:11 PM

Answers

  • MAP should be able to discover SID/instance information at a minimum. Have you tried using root? There are multiple rounds of data collection that occur, the first is when MAP attempts to collect hardware and service information from every machine (Oracle SID/instance information is part of this). Then, based on what information gets returned, it will queue up machines for additional scans, such as directly connecting to the Oracle database engine to gather more info, like schema info for Oracle. This additional scan requires the Oracle client to be installed on the MAP machine.

     

    To answer your question on credentials, the scan of Linux is done with SSH and therefore need admin or root credentials for Linux. For the in depth Oracle scan, you will need admin credentials for the database engine so that queries can be run for schema info.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Rick-PNM Wednesday, October 19, 2011 7:23 PM
    Wednesday, October 19, 2011 5:58 PM

All replies

  • MAP should be able to discover SID/instance information at a minimum. Have you tried using root? There are multiple rounds of data collection that occur, the first is when MAP attempts to collect hardware and service information from every machine (Oracle SID/instance information is part of this). Then, based on what information gets returned, it will queue up machines for additional scans, such as directly connecting to the Oracle database engine to gather more info, like schema info for Oracle. This additional scan requires the Oracle client to be installed on the MAP machine.

     

    To answer your question on credentials, the scan of Linux is done with SSH and therefore need admin or root credentials for Linux. For the in depth Oracle scan, you will need admin credentials for the database engine so that queries can be run for schema info.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by Rick-PNM Wednesday, October 19, 2011 7:23 PM
    Wednesday, October 19, 2011 5:58 PM
  • Hi Michael,

     

    Actually I'm facing similar issue here, we run oracle on windows and I can return the following info:

    server name  instance name  version number

    but I still need to get more info like the Oracle Edition like standard, enterprise....for lisence purposes.

    Does MAP have the ability to gather this info? do I need to install the oracle client and provide admin credentials?

     

    Really appreciate your help in advance.

     

    Thanks,

    Russul

    Thursday, January 12, 2012 3:54 AM
  • Yes, MAP has this capability, but it does require the Oracle client to be installed on the same machine that has MAP installed. Once you have that, select Oracle from the inventory scenarios page of the inventory wizard and provide to proper credentials and you should see all of that informaton. As of 6.5, MAP can also discover Oracle on HP-UX.
    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, January 12, 2012 9:30 PM
  • Hi Russul,

    Did you manage to resolve this? I am having a similar issue.

    Thanks

    Tuesday, April 8, 2014 2:04 AM