Dear Erman,
We are following Using Oracle 19c Oracle RAC Multitenant (Single PDB) with Oracle E-Business Suite Release 12.2 (Doc ID 2530665.1)
Since At this point of upgrade,we dont have any EBS related environment files from 19c home. Can we skip this step
After the Database Upgrade
Grant database privileges
Perform the steps in Document 2758993.1, Managing Database Privileges in Oracle E-Business Suite Release 12.2, to grant database privileges to the Oracle E-Business Suite schemas. Do not run any non-existent environment files.
Steps for AD and TXK Delta 12 or Earlier
If you are running Release Update Packs for AD and TXK Delta 12 or earlier, perform the following tasks to manage your database privileges:
If you have not already done so, copy the adgrants script from the application tier server to the database tier server using the appropriate command for your system.
UNIX:
$ cd $APPL_TOP/admin
$ scp adgrants.sql <USER_NAME>@<DB_SERVER>:<ORACLE_HOME>/appsutil/admin/adgrants.sql
Windows:
Use your preferred OS utility to copy %APPL_TOP%\admin\adgrants_nt.sql from the application server to the %ORACLE_HOME%\appsutil\admin directory on the database server.
On the database server, set the environment by following either the CDB or non-CDB instructions below.
CDB: If container database (CDB) and pluggable database (PDB) are used, then set the environment as follows:
UNIX:
$ source $ORACLE_HOME/<CDB_NAME>_<hostname>.env
$ export ORACLE_PDB_SID=<PDB_NAME>
Windows:
C:\> %ORACLE_HOME%\<PDB_NAME>_<hostname>.cmd
Non-CDB: If you are in a non-CDB environment, that is you are not using the database multitenant architecture, then set the environment as follows:
UNIX:
$ source $ORACLE_HOME/<SID>_<hostname>.env
Windows:
C:\> %ORACLE_HOME%\<SID>_<hostname>.cmd
Locked
