Month: June 2020

Exadata X8M New features

Oracle has released its latest version of world’s most powerful database machine ( Exadata ) , in the Oracle Open World 2019 . So , whats new with this release, and how it is different […]

 593 total views,  2 views today

Where does Exadata cell software reside before and after Exadata X7.

Oracle in its Exadata X7 model release , moved all the Exadata cell software partition to two M.2 disks for the Linux OS . Prior to X7 , the operating system partitions or cell software […]

 349 total views,  1 views today

Free up memory/cache on Linux system using /proc/sys/vm/drop_caches

To speed up operations and reduce disk I/O, the kernel usually does as much caching as it has memory. This sometime could led to extremely low free space, for new operation and we need to […]

 323 total views,  2 views today

How to change scan listener port in RAC.

The following example will change the existing scan listener port from 61521 to 1571. 173 2019-09-20.12:21:27 . oraenv 174 2019-09-20.12:21:36 srvctl modify scan_listener -p “TCP:61521/TCP:1571” 175 2019-09-20.12:21:56 srvctl stop scan_listener 176 2019-09-20.12:22:05 srvctl start scan_listener […]

 819 total views,  6 views today

Remove PDB From Restricted Mode in Oracle

Connected to: Oracle Database 18c EE Extreme Perf Release 18.0.0.0.0 – Production Version 18.10.0.0.0 SQL> sho pdbs ;     CON_ID CON_NAME          OPEN MODE  RESTRICTED ———- —————————— ———- ———-          2 PDB$SEED                       READ ONLY  NO          3 […]

 2,467 total views,  10 views today

ORA-16573: attempt to change or access configuration file for an enabled broker,ORA-02097: parameter cannot be modified because specified value is invalid

The dg_broker_config_file file was accidentally created on the the local file system , and we needed to move those config file to ASM NAME TYPE VALUE dg_broker_config_file1 string /u02/app/oracle/product/18.0.0 .0/dbhome_2/dbs/dr1dbname.dat But when doing that , […]

 514 total views,  1 views today

Command to check all the running db with their respective homes in Oracle db 12c

To verify exactly which db and asm is using which home , please match the process id of homes provided in the first half , with the db running in the second half of the […]

 321 total views,  4 views today

Create oracle 18c database from ExaCC console

This post covers, step by step 18c database creation on Exadata cloud at customer machine using ExaCC console or UI. Please enter the required information for creating the database such as db name and your […]

 771 total views,  2 views today

ORA-28354,ORA-28417: Encryption wallet, auto login wallet, or HSM is already open

Today, I faced a unique issue , where Oracle 12c tde encryption the wallet was neither getting opened , not it was closing after issuing close command . When , I was querying the wallet […]

 2,699 total views,  7 views today