Tuesday, April 7, 2020

Oracle Cloud Compartments


Compartments: 

It is a Logical Collection of OCI resource (Compute Machines, Subnets, object Storage etc). 

You can apply the IAM to each compartment. It provides a logical division so that access can be provided accordingly

Below are its characteristics:
-        - Each resource can go to single compartment
      -Compartments can be nested (Six level deep)
-        -Resources can interact with other resources in different compartments
-        -Resources and compartments can be added and deleted anytime
-        -Resource can be moved from one compartment to other
-        -You can give access to group of users for a compartment

Monday, April 6, 2020

Node Eviction in RAC

The node eviction/reboot for I/O fencing to ensure that writes from I/O capable clients can be cleared avoiding potential corruption scenarios in the event of a network split, node hang, or some other fatal event in clustered environment.                                                                        
 Evictions occur when CSS detects a heartbeat problem that must be dealt with

Why it occur?
-  Lost network communication(30 sec) with another node(s) or lost disk heartbeat (200 sec) information from another node(s)
 
Diagnosis:
OS log messages (/var/log/messages) If you notice  "kernel: SysRq : Resetting". This shows this node is evicted by some other node from cluster.
CSSD logs  <ORA_CRS_HOME>/log/<hostname>/cssd
 /etc/oracle/oprocd/<hostname>. oprocd.log 
This file exists in <CRS_HOME>/log/<hostname>/cssd/oclsomon dir for errors

Friday, September 1, 2017

Moving table into a different Replicat Thread



      Move Table A from replicat thread Rep1 to new replicat Rep2

1. Edit the parameter file Rep1 and exclude the table from the parameter file
MAPEXLUDE A

ggsci> stop replicat rep1
3. Check the Replicat position in the trial files
4. Start the replicat rep1
6,  Alter the newly created replicat rep2 to the position recording in positon 3
7. Start the replicat rep2
ggsci> start the Replicat

2. Stop the Replicat

Ggsci> info replicat rep1
Record : trail file number and sequence number

ggsci> Start replicat rep1
5. Add the new replicat
add replicat rep2, exttrial <> ,checkpointtable <>
Add the required table Table A to the replicat parameter file

ggsci> alter replicat rep1,extseqno <> , extrba <>