adgrant - system.fnd_oracle_userid ORA-06550: line 1094, column 17
SP2-0625: Error printing variable "result_set"
adgrants issue with 19c PDB database
Connect to a multitenant 19c database and follow below steps to resolve ORA error
1- source the cdb env file
2-set the ORACLE_PDB_SID=<PDB_NAME>
3- connect as sqlplus / as sysdba
4- go to location of adgrant and execute
cd /u01/app/oracle/product/19.0.0/dbhome_1/appsutil/sql
SQL> @adgrants.sql APPS
Note: ignore warnings during adgrant session ad.plsql.ad_zd_sys.GIVE_PRIVILEGE
Comments
Post a Comment