Connect to MariaDB from Oracle and perform DML on remote MariaDB table

Background: In enterprises most cases their database infrastructures or applications are built on different databases, sometimes data needs to be transferred or synced from one database to another heterogenous database. Oracle supports heterogenous connectivity to popular databases like MySQL, SQL Server, MariaDB, DB2, Sybase and more on the list. Here we will try to establish…

ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_****

Error: Errors in file /u01/app/oracle/diag/rdbms/bpay/bpay/trace/bpay_j000_24499.trc: ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_586″ ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at “SYS.DBMS_STATS”, line 47207 ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 882 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 20059 ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 22201 ORA-06512: at “SYS.DBMS_STATS”, line 47197 Cause: It’s a known bug, the advisory…

Oracle table partitioning: why, when and how

Why partitioning: Enhances the performance, manageability, and availability. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces. When to partition a table: Tables larger than 2gb size. Historical data Contents must be stored in different storage Avoid index maintenance when data is removed Index maintenance on parts of data like rebuilding…

Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background: After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up. OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured Workaround: From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when…