Skip to main content

Posts

Showing posts with the label Oracle 19c

adgrants issue with 19c PDB database

 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 a d.plsql.ad_zd_sys.GIVE_PRIVILEGE 

19c ORACLE HOME Cloning -Linux/Solaris

  Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If you are performing multiple Oracle Database installations, then you may want to use cloning to create each Oracle home, because copying files from an existing Oracle Database installation takes less time than creating a new version of them. This method is also useful if the Oracle home that you are cloning has had patches applied to it. When you clone the Oracle home, the new Oracle home has the patch updates which is already applied on oracle home. Steps to clone an Oracle home step 1 : Stop Services Stop all processes related to the Oracle home. Step 2 : Create a ZIP or TAR file with the Oracle home (/u01/app/oracle/product/19.0.0/dbhome_1)    Use ROOT user for ZIP and UNZIP  # zip -r dbhome_1.zip /u01/app/oracle/product/19.0.0/dbhome_1 TAR option: # tar -cvf dbhome_1.tar /u01/app/oracle/product/19.0.0/dbhome_1 Step 3: s cp zip/tar to target s...