Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Script to query multiple Oracle servers & instances

713479May 16 2013 — edited May 16 2013

Hi

If I have a list of either database servers, or database instances, is there any way I can create and run a single script-query that would give me a list of all users in all databases? Are there any tools that would do this? Perhaps an OEM based enhancement?

Ideally I'd like to just point the script-query at a tnsnames file, with the appropriate username/password and let it run from there. We have Oracle v10.2 environment in AIX and Linux & windows.The database are not Oracle GRID managed.
I'm thinking on the line of shell script or powershell.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2013

Added on May 16 2013

#general-database-discussions

7 comments

2,726 views