Monday, November 27, 2017

Solaris 11 - NFS - Trouble Shooting


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

# nfsstat

Friday, November 24, 2017

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

Tuesday, November 21, 2017

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

Monday, November 13, 2017

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;