2 Replies Latest reply on Jun 27, 2014 1:58 PM by Misty Truong

    Oracle Database Credential for Oracle Database Discovery

      Share This:

      I have a question regarding the discovery of Oracle 11g databases.  All of the Oracle databases are running on Unix servers.  We have not setup a credential for the Oracle database discovery.  However, we have a Unix account that can log into Unix servers and its seems to pull the Oracle database server SI that contains the Oracle database info and Oracle Net Services (TNS) Listener as shown below:

      OracleSoftwarInstance.png

       

      OracleListener.png

      But when I go to Discovery | Credentials | Databases and it  showed the Oracle RDBMS with 789 failures and 0 Successes as shown below

      OracleRBMSFailed.png

      Do I need to setup a credential for Oracle database discovery? 

        • 1. Re: Oracle Database Credential for Oracle Database Discovery

          If you look at Oracle pattern (e.g. OracleRDBMS), you see that the Oracle database can be discovered by browsing through Oracle configuration files or looking at the oracle processes running in the host.   This will not require Database credential.  The database credential is needed if you want to enable sql queries for extended database discovery. 

          You have the option to disable/enable the sql queries for extended database discovery in the pattern.  If you enabled it, but you don't have any database credential defined, then you will see the failures (as shown in your above screen shot).

           

          Thanks,

          Carolina

          • 2. Re: Oracle Database Credential for Oracle Database Discovery

            It seems the sql queries for extended data is enabled by default.  Our Oracle DBA will setup an account  in the Oracle databases with READ permission  for ADDM to run sql queries for extended database,  but do not know  what level  (SIDs, schema, table etc..) in database requires the credential for sql queries?