cancel
Showing results for 
Search instead for 
Did you mean: 

Password in Instance registration for OIP

Peaches_K
Level 3

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Nicolai
Moderator
Moderator
Partner    VIP   

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"

 

View solution in original post

2 REPLIES 2

Nicolai
Moderator
Moderator
Partner    VIP   

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"

 

Peaches_K
Level 3

Thanks Nicolai for your comments.