HP Network Automation

Network Automation

HP Network Automation (HPNA)

What is HP Network Automation? A solution that delivers real-time visibility, automation, and control for your network. HP Network Automation (HPNA) software tracks, regulates, and automates configuration and software changes across globally distributed, multivendor networks.  It automates the complete operational lifecycle of network devices from provisioning to policy-based change management, compliance,...

Read More
No package mysql-server

TECHNOLOGY TIPS

No package mysql-server available

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: mirror.es.its.nyu.edu * extras: mirrors.rit.edu * updates: mirrors.advancedhosters.com No package...

Read More
Mysql install fails

MYSQL INSTALL FAILS

centos7 – mysql install fails due to conflict in libmysqlclient.so

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: libmysqlclient.so.18()(64bit) Removing: 1:mariadb-libs-5.5.50-1.el7_2.x86_64...

Read More
Oracle Goldengate

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

For one of our projects, we upgraded Goldengate version to 12.2.0.1. 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...

Read More
Goldengate

ORACLE GOLDENGATE

Goldengate – Integrated Capture fails with OGG-02912

Here is one of my recent experiences running Oracle Goldegange 12.2.0.1 against Oracle 11.2.0.4 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...

Read More
Oracle Dba

ORACLE DBA

oracle impdp as sysdba and attach job

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 –...

Read More
Oracle Database

ORACLE DATABASE

Enabling and Disabling – auto optimizer stats collection

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...

Read More