Solaris 11 - NFS - Trouble Shooting

Log File
/var/svc/log/network-nfs-server:default.log
# fmadm faulty -a

# nfsstat

Oracle: Patch RAC

If you don't specify -local, opatch is going to patch all nodes. As a DBA, you should test on one node first, then roll out the patch on all other nodes.

If you have multiple Grid Infrastructure Home or Oracle Home, you can specify which one to patch:
$ opatch apply -local -oh /oracle/apps/grid/11.2.0.3



If only one of them and you are using specified opatch for each home, you can run opatch as below:
$ opatch apply -local

Then roll out the patch on individual node.



$ opatch apply -remote_nodes db02


 Roll back specified patch

$  opatch rollback -id 15983996

Display Oracle RAC Information

# Run as grid user

echo "======================================/etc/hosts======================================================"
# Display /etc/hosts
cat /etc/hosts

echo "=====================================Nodes in Cluster================================================="
# List all nodes
olsnodes

echo "=======================================Cluster Name==================================================="
# Display Cluster Name
olsnodes -c

echo "=================================the Public and VIP Node Name========================================="
# Display the Public and VIP Node Name
olsnodes -n -i

echo "====================================the Private IP Details============================================"
# Display the Private IP Details
olsnodes -n -i -l -p

echo "======================================Subnet Info====================================================="
# Display Subnet Info in Oracle Clusterware
oifcfg getif

exit

Oracle Database: Switch UNDO Tablespace online

CREATE UNDO TABLESPACE UNDOTBSNEW DATAFILE '/DATAFILES/UNDOTBSNEW.DBF'  AUTOEXTEND ON NEXT 100M  SIZE 4096M;


ALTER SYSTEM SET UNDO_TABLESPACE= UNDOTBSNEW;

DROP TABLESPACE UNDOTBSOLD INCLUDING CONTENTS AND DATAFILES;