how install oracle

Install Oracle 11G Release 2 (11.2) on Centos Linux 7

Posted on July 13, 2014

This article presents how to install Oracle 11G on Centos Linux 7.

Read following article how to install Centos Linux 7: Install Centos Linux 7 (for comfort set 2G memory for your virtual machine before proceeding with Oracle software installation).

Installation software is available on OTN, edelivery version 11.2.0.1 or Oracle support(old metalink) 11.2.0.4. In this installation I’m presenting installation for 11.2.0.4 but for previous version 11.2.0.X it shouldn’t be different.

• Oracle support
• OTN: Oracle Database 11G Release 2 Software (64-bit).
• edelivery: Oracle Database 11G Release 2 Software (64-bit)

Create SSL haproxy

openssl genrsa -out eproc.iconpln.co.id.key 2048
openssl req -new -x509 -key eproc.iconpln.co.id.key -out eproc.iconpln.co.id.cert -days 36500
openssl req -new -key eproc.iconpln.co.id.key -out eproc.iconpln.co.id.csr

ubuntu 17 tdak bsa paket

http://wimantis.ninja/fixing-ubuntu-17-04-apt-get-update-release-file-not-found/


The solution is pretty simple, just replace us.archive.ubuntu.com and security.ubuntu.com in /etc/apt/sources.list with old-releases.ubuntu.com and then you'll be able to finish updating.

alter table zabbix database

sumber : https://support.zabbix.com/browse/ZBX-13789

Hi,

I have done some tunning on the database by adding few indexes :

ALTER TABLE `zabbix`.`problem` DROP INDEX `Test`, ADD INDEX `Test` (`source`,`object`, `r_eventid`) USING BTREE;

ALTER TABLE `zabbix`.`rights` DROP INDEX `Test`, ADD INDEX `Test` (`id`,`groupid`) USING BTREE;

Yum Repo Error

sumber : https://www.linuxquestions.org/questions/centos-111/yumrepo-error-centos-5-9-a-4175604669/
sumber : https://www.joeferguson.me/installing-php-5-6-x-on-centos-5-11/

Masalah

root@server1 $  yum --enablerepo=base info bash
Loaded plugins: fastestmirror, security
Loading mirror speeds from cached hostfile
YumRepo Error: All mirror URLs are not using ftp, http[s] or file.
 Eg. Invalid release/
removing mirrorlist with no valid mirrors: /var/cache/yum/extras/mirrorlist.txt

command routing linux add / delete

sumber : http://www.softpanorama.org/Net/Netutils/route_in_linux.shtml

apabila disk database zabbix penuh

truncate table history;