Oracle RAC, ASM, Exadata, Cloud, and More..
ORA-28362 -Wallet key not found
›
Once TDE is created, it is very important component of the database and never delete or move out of the wallet location. If the old wallet ...
Remote Oracle Net connections hang -Doc ID 1302367.1
›
Symptoms: Something may occur where there is a connectivity problem between clients or servers and a remote database such as standby or DR...
Insert statements cause table contention
›
Insert contention usually is caused by block level contention such as other session and sequential reads along with the indexes Troubl...
Latch Free Wait contention issue
›
Latch Free Wait contention issue To troubleshoot this issue, following the following steps: 1. run AWR reports on each node RAC 2. r...
Remote Diagnostic Agent - RDA
›
Remote Diagnostic Agent - RDA RDA is a command-line diagnostic tool that is designed to reduce the number of support requests for addit...
Materialized view is not doing a fast refresh
›
1) For fast refresh, the mlog$ is required ensure that you create mlog$ on tables that involve in the materialized view. 2) Get capability ...
ipmitool
›
ipmitool - utility for controlling IPMI-enabled devices power supply, voltage, power sensor To display sensor status ipmito...
Exadata Software Executables And Software Locations
›
Compute Server software’s Locations and Executables /u01 – GI and RDBMS binaries /opt/oracle.cellos - cell OS configuration, execu...
Backup Exadata Storage and Compute Servers
›
Backup Storage Servers: Oracle does not support installation of any software of any type. You’re not required to backup your storage serve...
Infiniband verification
›
Verify IB cards are present # lspci | grep Infi Should be 1 card per system. Verify IB ports are UP # ibstatus | grep phys ...
List Flash Storage on Exadata Servers
›
You can query SCSI flash device information using lsscsi or list your PCI flash module using flash_dom to understand how flash storage is c...
Flash Storage
›
You can query SCSI flash device using lsscsi, list your PCI flash modedule using flash_dom lsscsi -v | grep MARVEL (to ...
Display physical disk, Megaraid device information, mdadm software RAID configuration
›
lsscsi can show both physical SAS drives and flash devices. There are 12 SAS devices and lsscsi -v | grep MARVEL [8:0:0:0] ...
Display Storage and Compute Server architecture
›
You’re assigned to manage the Exadata Machine. You want to display overall architecture, storage configuration, network, and OS. uname –...
›
Home
View web version