No package mysql-server available

By Ravi Karamsetty | October 26, 2016 |

Starting CentOS7 MySQL is replaced with MariaDB. You might encounter the following error “mysql -u root -p4Samsung4” when you try installing mysql using yum. [root@myhost~]# yum install mysql-server Loaded plugins: fastestmirror, langpacks Loading mirror speeds from cached hostfile * base: * extras: * updates: No package mysql-server available. Error: Nothing to do … Continue reading “No package mysql-server available”

Read More

ssh – failed login attempts on centOS

By Ravi Karamsetty | September 26, 2016 |

Though SSH is secured protocol, but opening the SSH Port without a firewall/VPN or whitelisting the allowed hosts can be cause security vulnerabilities and you will find hackers scanning or open ports, using Brute-force username and password and get into your network. A machine when ssh port is not secured, when login via SSH, upon … Continue reading “ssh – failed login attempts on centOS”

Read More

centos7 – mysql install fails due to conflict in

By Ravi Karamsetty | September 18, 2016 |

MySQL We recently built new linux server using CentOS Version 7.0. This release of CentOS comes with MariaDB and MySQL is not a standard offering. When I tried installing MySQL, MySQL install failed with the following error: –> Finished Dependency Resolution Error: Package: 2:postfix-2.10.1-6.el7.x86_64 (@base/$releasever) Requires: Removing: 1:mariadb-libs-5.5.50-1.el7_2.x86_64 (@updates) Obsoleted By: mysql-community-libs-5.7.15-1.el6.x86_64 (mysql57-community) … Continue reading “centos7 – mysql install fails due to conflict in”

Read More

Oracle Goldengate – unable to start integrated replicat – OGG-00446

By Ravi Karamsetty | September 4, 2016 |

For one of our projects, we upgraded Goldengate version to After upgrading to newer version, I am able to successfully add new replicats. But when I tried starting the replicat, I encountered the following error: 2016-09-04 11:50:58 ERROR OGG-00446 Supplemental checkpoint table does not exist. Create a supplemental checkpoint table with the UPGRADE CHECKPOINTTABLE … Continue reading “Oracle Goldengate – unable to start integrated replicat – OGG-00446”

Read More

Goldengate – Integrated Capture fails with OGG-02912

By Ravi Karamsetty | |

Here is one of my recent experiences running Oracle Goldegange against Oracle database. I was able to add Goldengate Extract Integrated process successfully without any issues. But when I tried starting the extract process, extract failed with the following error: 2016-09-04 23:49:30 ERROR OGG-02912 Patch 17030189 is required on your Oracle mining database … Continue reading “Goldengate – Integrated Capture fails with OGG-02912”

Read More

oracle impdp as sysdba and attach job

By Ravi Karamsetty | July 22, 2016 |

impdp allows Oracle DBA to exit out of the current process while the job continues to run in the background.  In the event you have to connect to the job and take some action, below is how that can be accomplished: In the following example job name is – “my_job”   impdp \”/as sysdba\” attach=my_job … Continue reading “oracle impdp as sysdba and attach job”

Read More

oracle – generate kill database sessions script

By Ravi Karamsetty | July 21, 2016 |

Here is the script that comes handy to Oracle DBAs for generating script to kill sessions based on user sessions. For example, this SQL script generates the script to kill all the sessions belong to user – SCOTT. Login to database as sys or system or sysdba or user with DBA role: SQL> select ‘alter … Continue reading “oracle – generate kill database sessions script”

Read More

Oracle dbms_job remove from another schema

By Ravi Karamsetty | June 10, 2016 |

In the following use case, as sysdba I am trying to remove the job that belongs to another user – ‘AMS2000’ that results in error – ORA-23421. As a sysdba, when you try removing job belonging to another user, you will get ORA-23421 SQL> BEGIN DBMS_JOB.remove(4002); 2 END; 3 / BEGIN DBMS_JOB.remove(4002); * ERROR at … Continue reading “Oracle dbms_job remove from another schema”

Read More

Enabling and Disabling – auto optimizer stats collection

By Ravi Karamsetty | May 20, 2016 |

Here is how you can query if the Auto Optimizer Stats Collection job is running in Oracle Database 11g: Login to database as SYSDBA: [sql] SELECT CLIENT_NAME, STATUS FROM DBA_AUTOTASK_CLIENT WHERE CLIENT_NAME = ‘auto optimizer stats collection’; [/sql] Below is how the job can be disabled: [sql htmlscript=”false”] EXEC DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => ‘auto optimizer stats collection’, … Continue reading “Enabling and Disabling – auto optimizer stats collection”

Read More

oracle standard edition one vs oracle standard edition 2

By Ravi Karamsetty | January 6, 2016 |

Starting Sept 2015, Oracle Standard Edition and Oracle Standard Edition One are no longer available from Oracle.  Oracle Standard Edition 2 is the new product offering under standard edition starting with Oracle 12 Release 1 ( . Below link from Oracle provides the difference between Oracle Standard Edition One (SE1) vs Oracle Standard Edition 2 vs … Continue reading “oracle standard edition one vs oracle standard edition 2”

Read More