Monday, April 24, 2017

what are the different ways to check the alert log locations in oracle database?

 alert log checking methods

1)adrci> show alert (11g onwards)
2)select name,value from v$diag_info;(11g onwards)
3)show parameter back and navigate the alert log locations
4)navigate thru OEM

Tuesday, April 4, 2017

what are the pre-request for PRDB plug in oralce 12c

pre-request for PDB plug in 12c.

1.both source & target  DB should be on have same patch-set.
2.both source & target  server should be same endian format
3.both source & target  DB should be same character set
4.you can check using dbms_check_plug_incompatibaility