RAC DB faq's

To Check status of RAC DB:
===========================
[oracle@slc00ypo ~]$ srvctl status database -d ORCL
Instance ORCL1 is running on node slc00ypo
Instance ORCL2 is running on node slc00ypp
[oracle@slc00ypo ~]$


[oracle@slc00ypo ~]$ srvctl status nodeapps
VIP slc00ypq is enabled
VIP slc00ypq is running on node: slc00ypo
VIP slc00ypr is enabled
VIP slc00ypr is running on node: slc00ypp
Network is enabled
Network is running on node: slc00ypo
Network is running on node: slc00ypp
GSD is disabled
GSD is not running on node: slc00ypo
GSD is not running on node: slc00ypp
ONS is enabled
ONS daemon is running on node: slc00ypo
ONS daemon is running on node: slc00ypp


[oracle@slc00ypo trace]$ crs_stat -t
Name           Type           Target    State     Host       
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    slc00ypo   
ora....ER.lsnr ora....er.type ONLINE    ONLINE    slc00ypo   
ora....N1.lsnr ora....er.type ONLINE    ONLINE    slc00ypo   
ora.asm        ora.asm.type   ONLINE    ONLINE    slc00ypo   
ora.cvu        ora.cvu.type   ONLINE    ONLINE    slc00ypo   
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE              
ora....network ora....rk.type ONLINE    ONLINE    slc00ypo   
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    slc00ypo   
ora.ons        ora.ons.type   ONLINE    ONLINE    slc00ypo   
ora.orcl.db    ora....se.type ONLINE    ONLINE    slc00ypo   
ora....ry.acfs ora....fs.type ONLINE    ONLINE    slc00ypo   
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    slc00ypo   
ora....SM1.asm application    ONLINE    ONLINE    slc00ypo   
ora....PO.lsnr application    ONLINE    ONLINE    slc00ypo   
ora....ypo.gsd application    OFFLINE   OFFLINE              
ora....ypo.ons application    ONLINE    ONLINE    slc00ypo   
ora....ypo.vip ora....t1.type ONLINE    ONLINE    slc00ypo   
ora....SM2.asm application    ONLINE    ONLINE    slc00ypp   
ora....PP.lsnr application    ONLINE    ONLINE    slc00ypp   
ora....ypp.gsd application    OFFLINE   OFFLINE              
ora....ypp.ons application    ONLINE    ONLINE    slc00ypp   
ora....ypp.vip ora....t1.type ONLINE    ONLINE    slc00ypp   
[oracle@slc00ypo trace]$


RAC DB Connection String:
==========================
I tried :

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=adc4120554.us.oracle.com) (PORT=1616))
(ADDRESS=(PROTOCOL=TCP)(HOST=adc4120555.us.oracle.com) (PORT=1616))
(CONNECT_DATA=(SERVICE_NAME=ORCL)))

http://programmersjournal.blogspot.com/2008/08/jdbc-connection-string-for-oracle-rac.html


Finding Log File location:
==========================
SQL> connect / as sysdba;
Connected.

SQL> show parameter backg;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/diag/rdbms/orc
                                                 l/ORCL1/trace
SQL> exit

Rsync - Copy from remote hosts

To copy files from remote servers

a) Mount the filesystem locally using NFS.

Run the below :

 rsync   -avtz      /net/host_name-mounted/faovm     /scratch/aime/faovm_local


/net/host_name-mounted/faovm is a NFS point which is mounted locally.

There is a difference in

/net/host_name-mounted/faovm and /net/host_name-mounted/faovm/

/net/host_name-mounted/faovm    :   will copy  faovm directory also.
/net/host_name-mounted/faovm/   : by giving trailing slash it will copy contents inside faovm dir.



-a  archive mode
-v  verbose
-t  preserve time
-z  transfering in a compressed mode , so that transfers are done quickly