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 FEBRUARY 24, 2022
Applies to:EBS on Oracle Cloud: Provisioning and Administration - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Oracle Applications DBA - Version 12.1.3 to 12.2 [Release 12.1 to 12.2Cloud]
Information in this document applies to any platform.
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:
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'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document