Home
Search results “Oracle asm zabbix”
Monitorando bancos de dados Oracle via ODBC no Zabbix
 
18:16
Nesse vídeo demonstro como instalar e configurar no servidor zabbix o cliente oracle e o ODBC, assim como usar um template para monitoramento de banco oracle no Zabbix. Gostou? Deixe Seus Comentários, Curtidas, Compartilhe, Assine o meu canal↓↓↓ Acesse o meu site: www.leandromoreirati.com.br Curta minha Fanpage: https://www.facebook.com/leandromoreiraEnsinoeTreinamento/ Cadastre-se no meu grupo do facebook: https://www.facebook.com/groups/leandromoreiraensinoetreinamento/ Assine minha lista de email: news.leandromoreirati.com.br Gostou do vídeo, curta, compartilhe deixe seus comentários!!! [ERRATA] NO VÍDEO INFORMEI QUE A VERSÃO DO BANCO ORACLE USADA PARA TESTE ERA A 10.2.0.4 E O CORRETO É A VERSÃO 11.2.0.4 1) Link para download do client Oracle) http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html 2) Variáveis de ambiente Oracle # VARIAVEIS ORACLE export ORACLE_HOME=/usr/lib/oracle/11.2/client64/lib export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME export TNS_ADMIN=/etc/oracle 3) Configuração do Driver Oracle (/etc/odbcinst.ini) [oracle] Description=ODBC for Oracle Driver=/usr/lib/oracle/11.2/client64/lib/libsqora.so FileUsage=1 Driver Logging=7 4) Configuração do ODBC [MODELO] (/etc/odbc.ini) [moreira] Driver = oracle DSN = moreira ServerName = moreira UserID = zabbix Password = monitora 5) Configuração TNSNAMES.ORA (/etc/oracle/tnsnames.ora) [MODELO] MOREIRA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.84)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = moreira) ) ) 6) Link para donwload template oracle ODBC https://github.com/den-is/zbx_oracle_odbc 7) Macro para configuração do host {$DSN} - DataSource Configurado no odbc.ini {$ORA_USER} - usuário de consulta no banco de dados {$ORA_PASS} - senha do usuário de consulta
Views: 6432 Leandro Moreira
ZABBIX Server v3.0 installation on CentOS7 Step-By-Step manual
 
23:09
1. OS a. Linux CentOS 7 b. Update it c. Prerequisites d. Database e. Secure it 2. Zabbix 3.0 using MySQL database, MariaDB a. install Zabbix b. connect to database c. configure front-end d. secure server e. finish configuration # Install basic server and configure it CentOS Download - https://www.centos.org/download/ http://isoredirect.centos.org/centos/7/isos/x86_64/CentOS-7-x86_64-Minimal-1511.iso # Set IP and activate adapters if required nmtui #connect using SSH/Telnet # Change time zone if not done jet mv /etc/localtime /etc/localtime.bak ln -s /usr/share/zoneinfo/Europe/Riga /etc/localtime #Check swap file free -m #Create swap file dd if=/dev/zero of=/swapfile1 bs=1024 count=524288 chown root:root /swapfile1 chmod 0600 /swapfile1 mkswap /swapfile1 swapon /swapfile1 free -m # To activate /swapfile1 after Linux system reboot vi /etc/fstab #Append the following line: /swapfile1 none swap sw 0 0 # Update CentOS - take some ~5-10 minutes.. yum update -y # Install some useful packages yum install vim -y #Install MySQL fork Mariadb yum install mariadb-server -y # Edit MySQL config file and add innodb_file_per_table under [mysqld] section vim /etc/my.cnf innodb_file_per_table #Start MySQL and secure it (by default database root has no password) systemctl start mariadb mysql_secure_installation #create zabbix database and user mysql -p CREATE DATABASE zabbix CHARACTER SET utf8 COLLATE utf8_bin; GRANT ALL PRIVILEGES ON zabbix.* TO [email protected] IDENTIFIED BY 'PasswordHere'; flush privileges; exit #Installation of Firewall yum install firewalld -y systemctl unmask firewalld systemctl enable firewalld systemctl start firewalld # allow connections to ports 10051 (Zabbix server), 10050 (Zabix agent), 80 (HTTP) 443 (HTTPS) in firewalld firewall-cmd --permanent --zone=public --add-port=10051/tcp firewall-cmd --permanent --zone=public --add-port=10050/tcp firewall-cmd --permanent --zone=public --add-port=80/tcp firewall-cmd --permanent --zone=public --add-port=443/tcp firewall-cmd --reload ========================================== # Install Zabbix packages on CentOS/RHEL 7 # Download Zabbix 3.0 configuration package rpm -ivh http://repo.zabbix.com/zabbix/3.0/rhel/7/x86_64/zabbix-release-3.0-1.el7.noarch.rpm # Install Zabbix packages yum install zabbix-server-mysql zabbix-web-mysql zabbix-agent zabbix-get zabbix-sender zabbix-java-gateway -y # Import initial DB schema and data (Zabbix version can be different, so check folder name) cd /usr/share/doc/zabbix-server-mysql-3.0.3 zcat create.sql.gz | mysql -uroot -p zabbix # Edit database configuration in zabbix_server.conf vim /etc/zabbix/zabbix_server.conf DBHost=localhost (better change to IP) DBName=zabbix DBUser=zabbix DBPassword=your password for DB user "zabbix" # Edit PHP timezone vim /etc/httpd/conf.d/zabbix.conf php_value max_execution_time 300 php_value memory_limit 128M php_value post_max_size 16M php_value upload_max_filesize 2M php_value max_input_time 300 php_value always_populate_raw_post_data -1 php_value date.timezone Europe/Riga # It's necessary to uncomment the “date.timezone” setting and set the right timezone for you. # After changing the configuration file restart the apache web server. systemctl start httpd # Start Zabbix server process systemctl start zabbix-server #check the status systemctl status zabbix-server -l # Start Zabbix agent process. systemctl start zabbix-agent # Set SELinux settings - recommended, but can make trouble if not configured)) getenforce setsebool -P httpd_can_network_connect=1 setsebool -P httpd_can_connect_zabbix=1 setsebool -P zabbix_can_network=1 getsebool -a | grep zabbix getsebool -a | grep httpd_can_network_connect # Add all Zabbix services to server startup systemctl list-unit-files systemctl enable zabbix-server.service systemctl enable zabbix-agent.service systemctl enable zabbix-java-gateway.service systemctl enable httpd.service systemctl enable mariadb #Ready to go to http://ipaddress/zabbix to finish setup Server name: name of Zabbix server instance (will see it in the right up corner, under logout) Example: zbx_prod01, zbx_test01, zbx3.0.centos7 etc. Default user: Admin password: zabbix /etc/zabbix/web/zabbix.conf.php Thank's for watching! Please, subscribe! Your Zabbix team
Views: 416 Zabbix Tutorials
New DBA tool "DBGuard for Oracle" !
 
02:18
DBGuard for Oracle. Programmed by DBA Consultant Serhad Erdem. email: [email protected]
Views: 265 serhad erdem
Oracle VM Server - Creating a VM from a template
 
07:18
Downloading, registering templates and creating a VM from a template.
Views: 13782 DellTechCenter
Tutorial de Instalação (parte 2): Configurando o Oracle Linux para o Oracle Database 12c
 
01:02:40
Confiram o artigo completo por esse endereço: http://certificacaobd.com.br/2014/03/04/linuxoracle-tutorial-de-instalacao-parte-2-configurando-o-oracle-linux-para-o-oracle-database-12c/
Views: 6709 Certificação BD
How to setup multiple agents for monitoring using the advance mode
 
05:36
http://software.dell.com/products/foglight-for-sql-server/
Views: 694 DellTechCenter
VMware Fix - Failed to lock the file Cannot open the disk 'xxxx.vmdk'
 
03:37
Failed to lock the file Cannot open the disk 'xxxx.vmdk' or one of the snapshot disks it depends on.
Views: 85434 ProgrammingKnowledge2
19.7 ipcs and ipcrm command
 
05:19
UDEMY LINUX SYSTEM ADMINISTRATION FOR BEGINNERS TUTORIAL-19_-_Networking 1_-_Introduction_to_SuSe_Linux 2_-_Working_with_Files_and_Directories 3_-_vi_Text_Editor 4_-_Environment 5_-_Introduction_to_Shell_Scripting 6_-_software_administration 7_-_Redirection_and_Pipes 8_-_Working_with_Processes 9_-_Super_User_concept 10_-_Filter_commands 11_-_Find_command_examples 12_-_Creat_user_with_YaasT_command 13_-_User_Administration 14_-_Configuring_System_Performance_and_Capacity_Administration 15_-_Job_and_Cron & at_administration 16_-_File_Systems 17_-_Archives 18_-_System_log 19_-_Networking 20_-_Conclusion
Views: 143 Debyum
CentOS 5.6 Disponible
 
00:47
32 Bits : http://mirrors.ecvps.com/centos/5.6/isos/i386/CentOS-5.6-i386-bin-DVD.iso 64 Bits : http://mirror.cogentco.com/pub/linux/centos/5.6/isos/x86_64/CentOS-5.6-x86_64-bin-DVD-1of2.iso
Install PostgreSQL 9.4 on CentOS 7 - Part 2 of 2
 
05:30
PART 2 of 2. Detailed walk through of installing CentOS 7 (on a VM) followed by installing PostgreSQL 9.4. VMware ESXi 6. No Ads. (English - Canadian Accent) Table of Contents: 1) Planning 2) Create VM 3) Download ISO, check SHA256 with Quick Hash v2.6.3 4) Install Operating System - CentOS 7 5) Postinstallation Tasks 6) Install PostgreSQL 9.4 7) Starting and Stopping with systemd 8) Open port 5432 (firewalld) 9) Conclusion
Views: 1512 Phany Langille
Tutorial Instalacion Oracle 10g Version 2
 
06:32
Sergio Bascuñán - Seccion 222 Tutorial instalacion Oracle 10g
Views: 474 TDB222Inacap
سهر ابو الشروف الاغنيه التي لم تنشر
 
05:23
سهر ابو الشروف الاغنيه التي لو تنشر ولم تعرض
Views: 52694 hasan fdawi