Forum Discussion

Peaches_K's avatar
Peaches_K
Level 3
9 years ago

Password in Instance registration for OIP

When we register an instance for oracle, we add OS credentials for instance and Oracle RMAN recovery catalog credentials.

My Account team is asking where in Netbackup are these passwords/credentials stored.

I searched in Oracle admin guide - 7.6, could not find it. Can you Please help me in this

 

 

  • Credentials are store in the EMM database, encrypted.

    This is from the EMM database 

    create view "DARS_MAIN"."DARS_OC_InstanceGroupRepository"
      as select "DARS_OC_InstanceGroup"."InstanceGroupName",
        "DARS_OC_InstanceGroup"."OCInstanceGroupKey",
        "DARS_OC_InstanceGroup"."OCCredSetKey",
        "DARS_OC_InstanceGroup"."CreatedDateTime",
        "DARS_OC_InstanceGRoup"."LastModifiedDateTime",
        "DARS_OC_InstanceGroup"."UpdateVerifier",
        "Unix"."Username" as "UnixUser",
        "Unix"."Password" as "UnixPass",
        "Win"."Username" as "WinUser",
        "Win"."Password" as "WinPass",
        "Win"."Domain" as "WinDomain",
        "Ora"."Username" as "OraUser",
        "Ora"."Password" as "OraPass",
        "Ora"."Aux" as "OraTns",
        "Rman"."Username" as "RmanUser",
        "Rman"."Password" as "RmanPass",
        "Rman"."Aux" as "RmanTns"
        from "DARS_MAIN"."DARS_OC_InstanceGroup"
          left outer join "DARS_MAIN"."DARS_OC_CredSet" on "DARS_MAIN"."DARS_OC_InstanceGroup"."OCCredSetKey" = "DARS_MAIN"."DARS_OC_CredSet"."OCCredSetKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Unix" on "DARS_MAIN"."DARS_OC_CredSet"."UnixCredentialKey" = "Unix"."OCCredentialKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Win" on "DARS_MAIN"."DARS_OC_CredSet"."WindowsCredentialKey" = "Win"."OCCredentialKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Ora" on "DARS_MAIN"."DARS_OC_CredSet"."OracleCredentialKey" = "Ora"."OCCredentialKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Rman" on "DARS_MAIN"."DARS_OC_CredSet"."RMANCredentialKey" = "Rman"."OCCredentialKey"

     

  • Credentials are store in the EMM database, encrypted.

    This is from the EMM database 

    create view "DARS_MAIN"."DARS_OC_InstanceGroupRepository"
      as select "DARS_OC_InstanceGroup"."InstanceGroupName",
        "DARS_OC_InstanceGroup"."OCInstanceGroupKey",
        "DARS_OC_InstanceGroup"."OCCredSetKey",
        "DARS_OC_InstanceGroup"."CreatedDateTime",
        "DARS_OC_InstanceGRoup"."LastModifiedDateTime",
        "DARS_OC_InstanceGroup"."UpdateVerifier",
        "Unix"."Username" as "UnixUser",
        "Unix"."Password" as "UnixPass",
        "Win"."Username" as "WinUser",
        "Win"."Password" as "WinPass",
        "Win"."Domain" as "WinDomain",
        "Ora"."Username" as "OraUser",
        "Ora"."Password" as "OraPass",
        "Ora"."Aux" as "OraTns",
        "Rman"."Username" as "RmanUser",
        "Rman"."Password" as "RmanPass",
        "Rman"."Aux" as "RmanTns"
        from "DARS_MAIN"."DARS_OC_InstanceGroup"
          left outer join "DARS_MAIN"."DARS_OC_CredSet" on "DARS_MAIN"."DARS_OC_InstanceGroup"."OCCredSetKey" = "DARS_MAIN"."DARS_OC_CredSet"."OCCredSetKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Unix" on "DARS_MAIN"."DARS_OC_CredSet"."UnixCredentialKey" = "Unix"."OCCredentialKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Win" on "DARS_MAIN"."DARS_OC_CredSet"."WindowsCredentialKey" = "Win"."OCCredentialKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Ora" on "DARS_MAIN"."DARS_OC_CredSet"."OracleCredentialKey" = "Ora"."OCCredentialKey"
          left outer join "DARS_MAIN"."DARS_OC_Credential" as "Rman" on "DARS_MAIN"."DARS_OC_CredSet"."RMANCredentialKey" = "Rman"."OCCredentialKey"