06-01-2016 11:29 AM
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
Solved! Go to Solution.
06-02-2016 12:28 AM
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"
06-02-2016 12:28 AM
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"
06-02-2016 03:35 AM
Thanks Nicolai for your comments.