by S-Square | Apr 9, 2019 | Blogs
Introduction: Oracle Segment Shrink Space feature was introduced from Oracle database version 10g. It is used for reclaiming unused/fragmented space from database objects like table, index-organized table (IOT), index, partition, sub-partition, materialized view or...
by S-Square | Mar 29, 2019 | Blogs
Introduction: The In-Memory Column Store (IM column store) allows users to store Oracle Database objects like columns, tables, partitions and materialized views in memory in a columnar format, rather than the typical row format. It is mainly used for analytic queries...
by S-Square | Feb 28, 2019 | Blogs
1) Error No: INS-30131 Initial Setup for Oracle 12C in Windows 10 While performing setup of DB, we may face above error-INS-30131, please find the below screenshot for the same. Solution: Go to Start, Type CMD Get the exact path where the setup.exe present and run the...
by S-Square | Sep 18, 2018 | Blogs
Issue: txkRunSSHSetup.pl script failing while doing enable ssh between primary and secondary nodes Error: perl $AD_TOP/patch/115/bin/txkRunSSHSetup.pl enablessh -contextfile=<CONTEXT_FILE> -hosts=h1,h2,h3$ ****************** hostname{600}$ perl...
by S-Square | Jul 18, 2018 | Blogs
Issue: While applying AD/TXK Delta 10 patches, patch fails on app2 or db1(secondary) node while running Autoconfig with mentioned below error ERROR: [ VERSION CONFLICTS INFORMATION] Template shipped by oracle is having a version different than the template lying in...