R12 E-Business Suite On Oracle Cloud Administration Error "ORA-20000: ORA-01917: user or role 'APPS' does not exist"When Running Adgrants.sql Against A Cloud Multi Tenant Database (Doc ID 2447786.1)

Last updated on JULY 25, 2023

Applies to:

Goal

E-Business Suite R12 On Oracle Cloud, Provisioning and Administration related issues

Provide steps to run adgrants.sql on a Cloud Multitenant Database.

For example when performing an Export/Import of EBS 12.0 or 12.1 with RDBMS 12c per <Note 1585256.1>, users are instructed to run adgrants as follows:

'Run adgrants.sql

Copy $APPL_TOP/admin/adgrants.sql (adgrants_nt.sql for Windows) from the administration server node to the working directory in the database server node. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:

$ sqlplus "/ as sysdba" @adgrants.sql (or adgrants_nt.sql) \[APPS schema name]

Note: Verify the usage of adgrants.sql in the adgrants.sql script. Older versions of adgrants.sql require the APPLSYS schema name parameter to be passed instead of APPS.'

However, the script fails when running as '/ as sysdba' since the script does not recognize/see APPS even though it exists.

'ORA-20000: ORA-01917: user or role 'APPS' does not exist

Error in ad_grants.Give_grants ORA-06512: at line 864'

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.