Tuesday, 21 April 2020

Oracle : RMAN-04014: startup failed: ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [kdt.c], [9576

Error was encountered while duplicating database using backup from source.
RMAN-04014: startup failed: ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [kdt.c], [9576], [11.2.0.2.0]
Solution:
_compression_compatibility='11.2.0.0.0'


Monday, 20 April 2020

Windows10 : Apps missing after reinstall or reset

Tries a ton of thing. Following worked to get store back:

Click xbox->setting or fix option the first screen. click all check boxes



Above bring back store.

Wednesday, 8 April 2020

Oracle: TNS for Primary and Standby Failover & basic tns

TNS for Primary and Standby:: (failover)

PRDmydb =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (FAILOVER=ON)(LOAD_BALANCE=ON)(CONNECT_TIMEOUT=10)(RETRY_COUNT=3)
    (ADDRESS=(PROTOCOL=TCP)(HOST=mydbwldbprd001.int.bellmts.ca)(PORT=6123))
    (ADDRESS=(PROTOCOL=TCP)(HOST=mydbwldbprd002.int.bellmts.ca)(PORT=6123))
   )
    (CONNECT_DATA =(SERVICE_NAME  = prdmydb)(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC))
   )
)


Basic TNS:
dbalias=
(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = uimwldbprd001.int.bellmts.ca)(PORT = 1521))
         (LOAD_BALANCE = on)(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = dbservice)))