How to Mount NFS

Posted on October 24, 2012 by Ahmed Tawfik 
mount -t nfs -o options host:/remote/export /local/directory


Source: https://access.redhat.com/knowledge/docs/en-US/Red_Hat_Enterprise_Linux/6/html/Storage_Administration_Guide/s1-nfs-client-config.html
Posted in Linux | Tagged , | Leave a comment

How to change hostname in Redhat & Oracle Linux

Posted on October 24, 2012 by Ahmed Tawfik

As user “root”

“vi /etc/sysconfig/network”, change HOSTNAME value to the new hostname

“hostname NEW_HOST_NAME” to change it for the current sessions

“vi /etc/hosts”, change the old value to point to the new hostname

“service network restart” to restart the networking service and apply all the new changes

Posted in Linux | Tagged , , , , | 2 Comments

Get List of ASM Disks in an 11gR2 Database

Posted on October 23, 2012 by Ahmed Tawfik

select * from v$asm_disk

Posted in Oracle | Tagged , , , | Leave a comment

How to compile all Oracle DB 11gR2 Invalid Objects

Posted on September 19, 2012 by Ahmed Tawfik

Login to SQLPlus
Run the following statement: “@?/rdbms/admin/utlrp.sql”

Posted in Oracle | Tagged , , , , , , | Leave a comment

How to query Oracle DB 11g for user account status

Posted on September 4, 2012 by Ahmed Tawfik

select USERNAME,ACCOUNT_STATUS from dba_users where USERNAME=’PUT_YOUR_USER_NAME_HERE’;

Sample output:

USERNAME                                    ACCOUNT_STATUS
——————————           ——————————–
SADMIN                                           OPEN

Posted in Oracle | Tagged , , , | Leave a comment