• (+1) 508 834 8245
  • contact@srinivasmaddali.com
logo
  • Home
  • RDBMS
    • Oracle
    • SQL Server
    • MySQL
    • PostgreSQL
  • Big Data
    • Mongo
    • CouchBase
    • cassandra
  • Tutorials
    • RMAN Tutorials123
    • Oracle Tutorials
  • OS
  • Contact Us
Transpo
  • Home
  • RDBMS
    • Oracle
    • SQL Server
    • MySQL
    • PostgreSQL
  • Big Data
    • Mongo
    • CouchBase
    • cassandra
  • Tutorials
    • RMAN Tutorials123
    • Oracle Tutorials
  • OS
  • Contact Us

  • Home

Download PDF

  • Oracle 12c New Features 09 – Database Testing & Patch Querying
  • Oracle 12c New Features 10 – Security
  • Oracle 12c New Features 10 – Security-2
  • Oracle 12c New Features 10 – Security-3
  • Oracle 12C new features and an understanding
  • Oracle 12C New Features
  • oracle 12c OS requirements Solaris 5.10
  • Oracle 11g Features
  • Oracle 11g PDF Documents
  • An Analogy on the Architectures of Oracle and Animated Living Being
  • Oracle 12c New Features 06 – AQ Enhancements
  • Archived Log Files
  • How to Turn Archiving ON and OFF
  • Tell me how many background processes help Oracle Instance to run?
  • Catlog Creation
  • Control Files
  • Control Structures
  • Create Data Base
  • CSScan
  • Data Files
  • Database Creation
  • Oracle 12C Database Authentication Methods for the administrators
  • Database Testing and Patch Querying
  • DBNEWID
  • How Oracle Works
  • How to remove streams
  • How to split a single partition into multiple partitions in 12c‏
  • Installation Of Oracle Database
  • Installing Oracle 11.2.0.4 on x86 64 bit Linux RHEL - requirements‏ (from and by Oracle)
  • Loading Data into Oracle Tables
  • Links
  • Logical Structures
  • Maintenance Mode
  • Manage Temporary Files for the database
  • Metadata Views
  • Multitenant architecture and Multi-process and multi-threaded
  • MV log
  • ORA-04030 and ORA-04031
  • ORA-04045
  • Installing Oracle 11.2.0.4 on x86 64 bit Linux RHEL - requirements - Oracle Doc
  • Oracle Architecture
  • Oracle Edition and Options Buy-able
  • Oracle Trinity
  • Oracle Wait Interface
  • ORADIM
  • ORAPWD
  • Ordba Wizard
  • OverView
  • PGA
  • PID For Oradebug
  • Recover_database
  • Recovery Catlog
  • Redo Log Files
  • Redo Records
  • Regenerate Dropped Table
  • Requirements
  • Restricted Session
  • SAN
  • Security
  • Segments II - Rollback Segments
  • Segments IV - Partitioned Tables
  • Segments Part I
  • Segments Part V - Index Organized Tables
  • Segments Part VII Temporary Segments
  • Set Default Tablespace and Temporary Tablespace for the database
  • Single Partition into Multiple partition
  • Some easy to use tools
  • Some One Said
  • 7 easy steps to configure HugePages for your Oracle Database Server
  • Architecture of the central processing unit (CPU)
  • C File Extension
  • Causes and Solutions for DGMGRL ORA-16664 Data Guard Broker Doc ID 2494260.1
  • CentOS package repository
  • cert_insider_trading
  • Changes in Oracle Database Security 18c
  • Configuration Services Issues (CS or BCS) on APPS DB PRODUCTS Schema
  • configure_streams
  • configure_streams_1
  • Creating Duplicate Database from RMAN Using the Backups done at OS level Doc ID 419144.1
  • Data Warehousing
  • Database and Datapump Enhancements
  • DataGuardObserverFSFO
  • DBCA Silent Mode New features in Database 19C Doc ID 2477805.1
  • dgmgrl_observer
  • Diagonalizability, Performance and Security in 19c
  • encrypted_data_OB_02262020
  • ExecutiveSummary 4.3 - CHD Data Storage (003) MS
  • Global Data Privacy
  • Goldengate Classic and Integrated modes and switching from one mode to another
  • Guided SR: ORA 600 [KSSRMP1] (Doc ID 2422621.1)
  • How To Install/Uninstall Expression Filter Feature or EXFSYS schema along with Rules Manager (Doc ID 258618.1)
  • Solaris 10: how to install logrotate package
  • HOW TO REVERSE ENGINEER FROM ORACLE SCRIPT
  • How To Upgrade From Goldengate Classic Extract To Integrated Extract Doc ID 1484313.1
  • Install Oracle Database 19c with Automatic root Scripts Execution
  • Installing Oracle
  • Is it supported to do a Transport Tablespace (TTS) Import with Data Pump on a tablespace with binary XML objects? Doc ID 1908140.1
  • Linux downloads PostgreSQL Installation
  • new_param_12.2.0
  • ORA-00600: internal error code, arguments: [kjbrchkin:wgl] (Doc ID 2420500.1)
  • Oracle - managing the corruption
  • Oracle Data Guard Observer Installation
  • Oracle Goldengate Upgrade
  • Required Steps to Recreate a Capture Process. Doc ID 471695.1
  • REST, Social sign-in, SQL*Net, Data Guard, Automated Indexes, Distinct on LISTAGG (Analytical Function), restore points propagation to standby, fine grained supplemental logging and Observer changes
  • RMAN and EMC DD Issue With An Archive Log When Running A Restore on 1 of 3 servers (Doc ID 2116741.1)
  • SRDC_MOS
  • syslog.doc

Create check of Outbound Oracle Profiles for Auditors

 

  • 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


Awesome Image

Srinivas Maddali. is a Leading Software Solution Development and Information Technology Consulting Company which provides Services to many Businesses around the United States led by certified professionals with expertise in Research, Design, Development and Delivery of high-end Technology Solutions.

Useful Links

  • Home
  • About Us
  • Services
  • Contact Us

Contact Us

  • Srinivas Maddali
    945 Concord St, Framingham, MA-01701
  • + 508 834 8245
  • contact@srinivasmaddali.com
Copyright © 2002-2020 Srinivas Maddali,
All rights reserved.