Apex Location ============= /PROD/PROD2020/apex Linux version ============= [oracle@ip-172-31-25-66 ~]$ cat /etc/system-release Amazon Linux 2 cd /PROD/PROD2020/apex @apex_rest_config.sql --password Pass#123 Unlock Accounts =============== ALTER USER APEX_LISTENER IDENTIFIED BY Pass#123 ACCOUNT UNLOCK;…
Read MoreThe below CATJAVA and JAVAVM components are invalid during 19c database upgrade. The below steps are needs to run to fix the corrupted database components. Steps :- 1) Check DBA_REGISTRY_COMPONENTS…
Read Moreselect ‘create user ‘ ||username|| ‘ identified by values ”’ ||password|| ”’ default tablespace ‘ ||default_tablespace|| ‘ temporary tablespace ‘ ||temporary_tablespace|| ‘ profile ‘ ||profile||’;’ as sample from dba_users where…
Read MoreHow to Resync Tables and Schemas to re-instantiate OGG replicat process :- Stop the Replicat process in the target environment if it is running by using the following command: GGSCI>…
Read MoreSteps to decommission of PDBs : Connect to container database : oracle $ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Mon Mar 23 08:19:41 2020 Copyright (c) 1982,…
Read MoreA. Pre-Upgrade Tasks 1. Download the latest OGG software from support.oracle.com. In our demo we have downloaded Oracle_GoldenGate_19.1.0.0.4.zip for Linux 64 bit. 2. Copy the OGG software to the source…
Read MoreIn these trying times of coronavirus pandemic, Doyensys is leaving no stone unturned to ensure the safety of our employees. We are committed to our responsibility towards society and consider…
Read MoreAfter cloning EBS R12 successfully, when I am going to login EBS clone it did not show anything on the page. Login page is totally blank. I have restarted all…
Read MoreDECLARE v_session_id INTEGER := userenv(‘sessionid’); v_user_name VARCHAR2(30) := upper(‘&Enter_User_Name’); BEGIN fnd_user_pkg.createuser(x_user_name => v_user_name ,x_owner => ” ,x_unencrypted_password => ‘oracle’ ,x_session_number => v_session_id ,x_start_date => SYSDATE – 10 ,x_end_date => SYSDATE…
Read MoreSELECT a2.application_name, a1.user_concurrent_program_name, DECODE (running_type, ‘P’, ‘Program’, ‘S’, ‘Request set’, ‘UNKNOWN’ ) “Type”, b2.application_name “Incompatible App”, b1.user_concurrent_program_name “Incompatible_Prog”, DECODE (to_run_type, ‘P’, ‘Program’, ‘S’, ‘Request set’, ‘UNKNOWN’ ) incompatible_type FROM apps.fnd_concurrent_program_serial…
Read More