Create check of Outbound Oracle Profiles for Auditors Tuesday, October 22, 2019 You want to create a listing of all outbound Oracle users and associated profiles for PCI auditors. - Go to server p1tk-db01 and login to the "oracle" OS account - Navigate to directory /export/oracle/Push_Infra - execute script ./exec_get_instance_user_info_against_all_instances.sh - output will be placed in file get_instance_user_info.out in the same directory Example execution and feedback (truncated)... ============================================= NEW FILE PUSH INFRA [p1tk-db01] [oracle] [08:45:37] [~/Push_Infra] >./exec_get_instance_user_info_against_all_instances.sh This is a wrapper for get_instance_user_info.sh Results will be in get_instance_user_info.out... Run command against pt235 at den-oltp-vip.vrli.net... ssh -q den-oltp-vip.vrli.net /pt235/u01/app/oracle/scripts/sh/get_instance_user_info.sh pt235 Run command against pch02 at den-ch-vip.vrli.net... ssh -q den-ch-vip.vrli.net /pch02/u01/app/oracle/scripts/sh/get_instance_user_info.sh pch02 Run command against prman02 at den-rmanprd-vip.vrli.net... ssh -q den-rmanprd-vip.vrli.net /prman02/u01/app/rmanprd/scripts/sh/get_instance_user_info.sh prman02
Create check of Outbound Oracle Profiles for Auditors
Tuesday, October 22, 2019
You want to create a listing of all outbound Oracle users and associated profiles for PCI auditors.
- Go to server p1tk-db01 and login to the "oracle" OS account
- Navigate to directory /export/oracle/Push_Infra
- execute script ./exec_get_instance_user_info_against_all_instances.sh
- output will be placed in file get_instance_user_info.out in the same directory
Example execution and feedback (truncated)...
=============================================
NEW FILE PUSH INFRA [p1tk-db01] [oracle] [08:45:37] [~/Push_Infra]
>./exec_get_instance_user_info_against_all_instances.sh
This is a wrapper for get_instance_user_info.sh
Results will be in get_instance_user_info.out...
Run command against pt235 at den-oltp-vip.vrli.net...
ssh -q den-oltp-vip.vrli.net /pt235/u01/app/oracle/scripts/sh/get_instance_user_info.sh pt235
Run command against pch02 at den-ch-vip.vrli.net...
ssh -q den-ch-vip.vrli.net /pch02/u01/app/oracle/scripts/sh/get_instance_user_info.sh pch02
Run command against prman02 at den-rmanprd-vip.vrli.net...
ssh -q den-rmanprd-vip.vrli.net /prman02/u01/app/rmanprd/scripts/sh/get_instance_user_info.sh prman02