Oracle E-Business Suite Database Configuration Report $AD_TOP/sql/adutconf.sql

Make sure sqlplus is in your path and you have sourced your R12 environment variables.
With a VIS test instance I do the environment sourcing as follows:

. /d01/oracle/VIS/EBSapps.env run

This script does a lot – including setting up your PATH, LD_LIBRARY_PATH, and Oracle Home for sqlplus, if set correctly the following command will show where you are running sqlplus from:

 which sqlplus
/d01/oracle/VIS/fs1/EBSapps/10.1.2/bin/sqlplus

Now generate the report by running a sqlplus script.  It’s output is ASCII text, and it is generated in the current directory you run it from.

cd $AD_TOP/sql
sqlplus apps/apps @adutconf.sql

The file adutconf.list will be produced.

-rw-r–r– 1 applmgr oinstall 154557 May 14 10:47 adutconf.lst
[applmgr@oel66-79 sql]$ head adutconf.lst
Oracle E-Business Suite Database Configuration Report
All dates are shown in DD-MM-YYYY format
Report Date : 14-05-2017 10:47:07
Database name: VIS

Leave a Comment

Scroll to Top