NAV: SLTechnology News&Howtos > Database >

• 

  Elaborate on the ip address of oracle 11g rac

  At the beginning of oracle11g, set up SCAN ip, in addition to there is public ip,virtual ip,private ip, easy to make people dizzy. The following is explained one by one: public ip: oracle data similar to single instance

  2022-06-01 10:25:08 Views: 202
• 

  IO Multiplexing of Redis

  First, linux IO reuse function within the same thread, multiple descriptor IO operations can be executed concurrently and alternately. Epoll provides only three functions: int epoll_create (int size); # create epoll handle int e

  2022-06-01 10:25:08 Views: 221
• 

  Mysql mysqldum backup script

  This article is mainly about how to use shell to achieve full, incremental backup of mysql. Incremental backups copy mysql-bin.00000* to the specified directory at 3 a.m. from Monday to Saturday, while full backups use mysqldump to export all databases, weekly

  2022-06-01 10:25:08 Views: 224
• 

  Environment configuration of oracle-realize the up and down page flip of oracle sqlplus

  Install rlwrap-0.37.tar.gz tool-implement memory and page flip function in SQLPLUS in rpm10g32 path 1. Decompress [root@oracle3 ~] # cd / u01/rpm10g32 [roo

  2022-06-01 10:25:08 Views: 249
• 

  Install Zabbix3.2 in Centos7

  Official installation documentation: https://www.zabbix.com/documentation/3.2/manual/installation/install_from_packages/server_ins

  2022-06-01 10:25:07 Views: 221
• 

  DB2 performance optimization-how to optimize lock upgrade by adjusting lock parameters

  1. Concept description the so-called lock upgrade (lock escalation) is a mechanism of database. In order to save memory overhead, it will convert a large number of fine-grained locks that take up a lot of resources into a small number of coarse-grained locks with relatively few resources.

  2022-06-01 10:25:07 Views: 290
• 

  Key points of oracle 11g dg deployment rman

  1. Environment introduction iphostnamesiddb_namedb_unique_namenet service name192.168.56.118oraclepyunhaipyunhaipyunhaipyu

  2022-06-01 10:25:07 Views: 232
• 

  Modification of parameters using alter system set does not take effect

  Recently, when I was doing an experiment with Oracle RAC on a virtual machine, I saw that the background log kept reporting errors because the configured log_archive_dest_2 parameters were referred to node 2, and node 2 was not powered on, so there was always an error. So I thought this parameter was done before the experiment.

  2022-06-01 10:25:06 Views: 285
• 

  [reading notes] database audit

  Database version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 I. audit technology of audit type ORACLE, in addition to SYSDBA audit, there is also a database

  2022-06-01 10:25:06 Views: 277
• 

  Orabbix installation instructions for zabbix

  Zabbix uses orabbix to monitor oracleOrabbix is a Zabbix plug-in used to monitor Oracle database instances. Download address: http://www.smartmarmot.com/produ

  2022-06-01 10:25:06 Views: 202
• 

  Redis note collation (1): Redis installation configuration and data type operation

  About Redis [TOC] Redis is an open source (BSD licensed), in-memory data structure server that can be used as a database, cache, and message queue agent. It supports strings, hash tables, lists, collections, ordered collections, bitmaps, hyperloglog

  2022-06-01 10:25:06 Views: 290
• 

  Oracle decode function and sign function

  Introduction to the flow control function DECODEdecode () function: main functions: translate query results into other values (that is, expressed in other forms, the following examples are illustrated); usage: Select decode (columnname, value 1, translation value 1)

  2022-06-01 10:25:05 Views: 214
• 

  Database Monitoring system of centos7 Sky Rabbit (Lepus)

  First, the Lepus installation needs the Lamp environment, the installation of the Lamp environment is more difficult, the one-click deployment of the XAMPP LAMP environment is easy and labor-saving, the lepus official website manual also recommends the use of XAMPP installation, lepus is also on the XAMPP

  2022-06-01 10:24:56 Views: 298
• 

  EF database migration

  Open the codefirst migration command: Enable-Migrations-ContextTypeName BlogEntitiesBlogEntities (context, the class that inherits DbContext) to update the data

  2022-06-01 10:24:53 Views: 289
• 

  Mariadb Database xtrabackup backup tool

  XtraBackup backup tool three steps 1. Install the XtraBackup package. two。 Use XtraBackup to perform full and incremental backups. 3. Prepare the data recovery directory. Yum-y install perl-DBD-My is required

  2022-06-01 10:24:52 Views: 221
• 

  CentOS 7 installs cacti 1.1.x

  As the cacti 1.1.x series has changed a lot since it was released, it integrates a lot of plug-ins and has its own automatic discovery function, so recording it is more suitable for copying and pasting. Environment: CentOS 7.4installation premise a, install system patch yum update-yb, open

  2022-06-01 10:24:52 Views: 294
• 

  MySQL 5.6 highly available architecture for read-write separation through MMM

  In the previous blog post, we used keepalived+ master-slave synchronization to build a simple MySQL high availability architecture (see https://blog.51cto.com/jiangjianlong/1981994 for details), which we will share today through M.

  2022-06-01 10:24:41 Views: 234
• 

  ORA-6550;6510

  EXP-00008: if you encounter ORACLE error 6510, you must declare that the identifier 'SYS.DBMS_DEFER_IMPORT_INTERNAL'' is a loss of permission. Log in to grant exp_full with sysdba

  2022-06-01 10:24:40 Views: 208
• 

  MySQL Partition Summary

  MySQL supports horizontal partitions and does not support vertical partitions. Horizontal partitions, in behavioral units, are divided into different physical files; vertical partitions are divided for columns. MySQL partitions, in addition to InnoDB support, MyISAM also supports, so partitions are not engines

  2022-06-01 10:24:37 Views: 225
• 

  Installation Oracle11gR2 RAC--- automatically patches GI PSU (11.2.0.4.8)

  Oracle 11g RAC automatically patch GI PSU (11.2.0.4.8) and patch (11.2.0.4.8). You can refer to reamme in patch p21523375_112040_Linux-x86-64.zip.

  2022-06-01 10:24:37 Views: 221