Error ======= Errors IN EBS POST INSTALL:RW 50015 : HTTP SERVER NOT RESPONDING 19/09/22 22:21:26 Start process ————————— /u01/oracle/VIS/inst/apps/VIS_ebs/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd /u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot…
Read MoreError ===== BEGIN * ERROR at line 1: ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: at “SYS.DBMS_STATS”,…
Read MoreCOL TABLESPACE_NAME FOR A30 COL FILE_NAME FOR A70 COL SIZE_GB FOR 99999 COL USED_GB FOR 99999 COL FREE_GB FOR 99999 COL %_Used FOR A15 SELECT Substr(df.tablespace_name,1,25) “Tablespace_Name”, Substr(df.file_name,1,70) “File_Name”, Round(df.bytes/1024/1024/1024,2)…
Read MoreApex 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 MoreSELECT ‘Request id: ‘||request_id , ‘Trace id: ‘||oracle_Process_id, ‘Trace Flag: ‘||req.enable_trace, ‘Trace Name: ‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’, ‘Prog. Name: ‘||prog.user_concurrent_program_name, ‘File Name: ‘||execname.execution_file_name|| execname.subroutine_name , ‘Status : ‘||decode(phase_code,’R’,’Running’) ||’-‘||decode(status_code,’R’,’Normal’), ‘SID Serial: ‘||ses.sid||’,’|| ses.serial#,…
Read More