title: sqlplus for Oracle Directory Managers link: https://onemoretech.wordpress.com/2007/11/30/sqlplus-for-oracle-directory-managers/ author: lembobro description: post_id: 598 created: 2007/11/30 18:36:54 created_gmt: 2007/11/30 18:36:54 comment_status: open post_name: sqlplus-for-oracle-directory-managers status: publish post_type: post

sqlplus for Oracle Directory Managers

Just a few random sqlplus commands that anyone having to manage an Oracle Internet Directory might want to know.

To find out the name of the database you’re logged on to:

SQL> select * from GLOBAL_NAME;

or

SQL> select NAME from V$DATABASE;

Check database version:

SQL> select * from V$VERSION;

Getting version of Enterprise Business Suite (EBS) installed:

SQL> select release_name from fnd_product_groups;

List patches applied to an EBS system:

SQL> spool /tmp/patchlist.txt; SQL> select * from ad_applied_patches;

List bugs covered by all applied patches on an EBS system:

SQL> spool /tmp/patchlist.txt; SQL> select * from ad_bugs;

You will have to play around with the formatting the output to get some of these to be usable for reporting purposes.

Copyright 2004-2019 Phil Lembo