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 […]
891 total views
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 […]
597 total views
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 […]
642 total views
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 […]
1,152 total views
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,998 total views
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 , […]
968 total views
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 […]
624 total views
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 […]
1,078 total views
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 […]
3,208 total views