by infra xpertzz | Feb 28, 2022 | Oracle
During Oracle 19c upgrade you may have to resolve the below required actions before upgrading the database Complete any pending DST update operation before starting the database upgrade. There is an unfinished DST update operation in the database. It’s current...
by infra xpertzz | Jan 12, 2022 | Oracle
1. What init.ora parameters does a user need to configure for ASM instances? Oracle ASM offers these initialization parameters. The main parameters for ASM include asm_diskgroups, asm_diskstring, asm_power_limit and asm_preferred_read_failure_groups. ...
by infra xpertzz | Dec 28, 2021 | Oracle
For more exciting blogs on Oracle, please click the LINK 1. EXCLUDING TABLE PARTITIONS JOB_NAME=INFRA_EXPORT DIRECTORY=DUMP_DIR DUMPFILE=Schema_%U.dmp LOGFILE=Schema.log SCHEMAS=INFRA EXCLUDE=table_data:”IN...
by infra xpertzz | Dec 28, 2021 | Oracle
For more exciting blogs on Oracle, please click the LINK 1. Crosscheck and delete expired archive logs RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; 2. Delete archive logs keeping just a days...
by infra xpertzz | Dec 28, 2021 | Oracle
For more exciting blogs on Oracle, please click the LINK 1. Checking tablespace size col “Tablespace” for a22 col “Used MB” for 99,999,999 col “Free MB” for 99,999,999 col “Total MB” for 99,999,999 select...
by infra xpertzz | Dec 10, 2021 | Oracle
For more exciting blogs on Oracle, please click the LINK 1. Kill Multiple Inactive sessions in Oracle BEGIN FOR r IN (select sid,serial# from v$session where username=’user’ and status’INACTIVE’) LOOP EXECUTE IMMEDIATE ‘alter system kill...
