Change Exadata Passwords

To change all password inside a Exadata is a lot of manual work. So i wrote a small script! You can find it here. The script should run on the first db node and change all password to the one read from the std in. Continue reading “Change Exadata Passwords”

Advertisements

OraTcpTest

In MOSC I read about OraTcpTest and had a short look at MOS note 2064368.1 . The scope of the tool is to measure network performance for Dataguard environments.
In the past I used iperf – a default Unix tool – but it has to be installed and it’s hard to set the options exactly matching the database. Often the results were not the same as the database ones. OraTcpTest should do it better. Continue reading “OraTcpTest”

Exadata storage reconfiguration with empty DGs

Changing the size of your disk groups (DG) is quite easy if the disk groups are empty. if the total amount of space used in all DGs is less then the smallest DG it’s possible to change the size. it’s like playing towers of Hanoi, you must move your data several times. This is not described here. Here you find instructions to change the size with empty DGs. Continue reading “Exadata storage reconfiguration with empty DGs”

long running script without nohup

You started a long running script and didn’t used nohup? No Problem!
To protect the script against a break caused by i.e. network errors, I usually use nohup. You have the output available in nohup.out. If you already started the script, it’s to late for nohup, but you can disown the job from your shell: Continue reading “long running script without nohup”

orachk

orachk is nothing new and was former known as raccheck, long time ago and the functionality increased a lot! It checks your environment for possible wrong configurations and best practices from oracle. The number of checks increase with each version. here you can see all the checks. You can check an existing installation or improve your standard configuration with the recommendations. I like to use it, after a cluster setup or upgrade or operating system upgrade. It’s not limited to Database, Clusterware or Operating System, but in this blog it is. Main MOS Note and Doku. Exachk is an own tool, but belongs to the same family. Continue reading “orachk”

SCAN-Listener and NAT

Network Address Translation (NAT) and SCAN listener are not working out of the box, because the scan redirect to the local_listener value, usually a IP and not a DNS name. failed Continue reading “SCAN-Listener and NAT”

ORA-600 in ASM Instance

I don’t encounter a ORA-600 so often in an ASM instance and even more rarely on an engineered system..
I tried to add a failed disk back to the diskgroup after the replacement and ended up with an ORA-600: Continue reading “ORA-600 in ASM Instance”