ORA -00600 while gather statistics
Error ===== BEGIN * ERROR at line 1: ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: at “SYS.DBMS_STATS”,…
Read MoreFind the datafile used and free space
COL 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 MoreDeploying apex in tomcat
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 MoreUpgrade database 19c registry components invalid
The 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 MoreScript to get metadata for schema creation and grants
select ‘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 & Schemas on Different SCN in Replicat OGG process
How 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 MoreDecommission of pluggable databases
Steps 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 MoreOracle GoldenGate upgrade 19c
A. 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 MoreTo check trace file of concurrent request
SELECT ‘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 MoreSending Email From Oracle using Amazon Simple Email Service (SES)
Use the below Link to create the Cerfiticate using Amazon SMTP address. https://whatsmychaincert.com/?email-smtp.us-east-1.amazonaws.com Creating Oracle Wallet : mkdir -p /u01/app/oracle/wallet/TEST orapki wallet create -wallet /u01/app/oracle/wallet/TEST orapki wallet add -wallet /u01/app/oracle/wallet/TEST…
Read More