My Oracle Support Banner

E-Business 12.1.3 Adgrants.sql failing while Upgrading The Database From 12c To 19c. with ORA-01917: user or role 'APPS' does not exist (Doc ID 3038216.1)

Last updated on JULY 31, 2024

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

While following:

Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (Doc ID 2580629.1)
2.4 After the Database Upgrade

   2. Run adgrants.sql

       Copy $APPL_TOP/admin/adgrants.sql (adgrants_nt.sql for Windows) from the administration server node to the database server node. Use SQL*Plus to connect to the database as SYSDBA and run the script using the following command:
       $ export ORACLE_SID=<source SID>. <---------Incorrectly performed here and used CDB and not source
       $ sqlplus "/ as sysdba" @adgrants.sql (or adgrants_nt.sql) <apps user>E-Business 12.1.3 Adgrants.sql failing while Upgrading The Database From 12c To 19c. with

The following error is seen:

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


also the following is seen as a symptom:

select USERNAME, ACCOUNT_STATUS , LOCK_DATE from dba_users where username ='APPS';

no rows selected

 

Changes

 Upgrade database to 19c for E-Business Suite 12.1.3

Cause

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
Symptoms
Changes
Cause
Solution
References


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