NAV: SLTechnology News&Howtos > Database >

• 

  The opening method of ORACLE 12C PDBORCL

  In ORACLE 12C database, if the PDBORCL service is not enabled, the initialization or shutdown in progress of the PDB service will be reported when WEBLOGIC is enabled, so you need to use sys

  2022-06-01 10:09:59 Views: 217
• 

  Upload and upload error

  Erp downloads update wms_jxddhz set wmflg='N' where wmflg in ('Efeijimachi T') and rq >' 2017-08-01'update wms_pf_djhz

  2022-06-01 10:09:58 Views: 213
• 

  Invisible field

  In Oracle 11g R1, Oracle introduced some nice enhancements in the form of invisible indexes and virtual fields. Inheriting the former and carrying forward, the idea of invisible fields is introduced in Oracle 12c R1. In previous versions, to hide

  2022-06-01 10:09:52 Views: 283
• 

  Principle and configuration of MySQL GTID Master-Slave replication

  GTID is a global transaction ID that has been successfully executed based on the original mysql server, which is composed of server ID and transaction ID. This global transaction ID is unique not only on the original server, but also on all mysql servers that have master-slave relationships.

  2022-06-01 10:09:52 Views: 233
• 

  Install and test xtrabackup8.0

  Install and test xtrabackup8.0Xtrabackup 2.4. Backup and recovery of MySQL 8.0 is no longer supported, the following error will be reported when using it! Error: MySQL 8.0 and Percona Server 8.

  2022-06-01 10:09:52 Views: 250
• 

  MongoDB MMS deployment document (win agent)

  Copy and paste an official deployment document directly. If you have successfully installed (win agent), you need to install python. Due to the network speed problem, the python-2.7.3.amd64.msi I downloaded directly from the 51cto download station also needs to download pymon by myself.

  2022-06-01 10:09:49 Views: 252
• 

  Mariadb Columnstore when pm1 down occurs, the database will block.

  For example, the Mariadb Columnstore version is Server version: 10.1.21-MariaDB Columnstore 1.0.7-1#cat / etc/hosts192.168.

  2022-06-01 10:09:48 Views: 222
• 

  Tcpdump grab mysql sql statement

  #! / bin/bash#this script used montor mysql network traffic.echo sqltcpdump-I bond0-s 0-l-w-dst

  2022-06-01 10:09:48 Views: 300
• 

  Oracle 12cR2 RAC+ASM installation

  1. Preparatory work 1. Some changes about Oracle Gird Infrastructure began with Oracle Grid Infrastructure 12c version 2 (12.2), Oracle Grid Infr

  2022-06-01 10:09:48 Views: 236
• 

  The query of mysql table fragments is collected by itself.

  In MySQL, we often use variable-length text data types such as VARCHAR, TEXT, BLOB, and so on. However, when we use these data types, we have to do some extra work-- MySQL data table defragmentation. Every time MySQL gets from you

  2022-06-01 10:09:48 Views: 263
• 

  Oracle heap_sort

  CREATE OR REPLACE PACKAGE heap_sort_pkgASTYPE num_arr_tt IS TABLE OF PLS_INTEGER INDEX BY PLS_INTEGE

  2022-06-01 10:09:47 Views: 240
• 

  Construction of MYSQL master-slave environment

  Server: 192.168.11.131 master192.168.11.132 slave Server system # cat / etc/redhat-releaseCentOS Linux release 7.2.

  2022-06-01 10:09:47 Views: 286
• 

  Set up after new installation of sql server database

  To install the database, set the domain administrator as the database owner. Click the sql server configuration Manager and enable TCP/IP and Named Pipes in the SQL Native Clinet 10.0 configuration (32-bit)\ client protocol. In S

  2022-06-01 10:09:47 Views: 268
• 

  Source code installation mysql

  Create mysql group: groupadd mysql creates mysql users and assigns them to this mysq group without creating a home directory and allowing users to log in. (login is not allowed because the mysql you just created is a virtual user) useradd mysql

  2022-06-01 10:09:47 Views: 220
• 

  RMAN of Oracle Learning (14) recovery in actual combat-- based on point-in-time recovery

  1. Let's start with a complete RMAN > backup database; Starting backup at 2015-07-09 13:40:47allocated channel: ORA_DISK_

  2022-06-01 10:09:47 Views: 300
• 

  Oracle11g rac configuration

  Openfile:192.168.10.40DNS+NTP:192.168.10.411.rpm installation system package: rpm-Uvh binutils-*rpm-ivh compat-libcap1-1.1

  2022-06-01 10:09:38 Views: 217
• 

  13.django getting started 01 (django getting started View, templates, routing)

  First, the basic use process of django. Pip install django # install django to create a project:django-admin startproject mysite---mysite

  2022-06-01 10:09:38 Views: 204
• 

  Programming experience and Optimization measures of Oracle stored procedure

  1. If developers use Table or View of other libraries, be sure to establish View in the current library to achieve cross-library operation. It is best not to use "databsevv.dbo.table_name" directly, because sp_depends cannot display the S

  2022-06-01 10:09:38 Views: 211
• 

  Fedora25 install Oracle JDK

  When configuring the Oracle JDK development environment, many web tutorials recommend adding environment variables to / etc/profile. However, the virtual terminal gnome-terminal under Fedora does not log in to Shell by default (which can be found in the configuration

  2022-06-01 10:09:37 Views: 247
• 

  The pit stepped on the sql+workbench

  When you install mysql, you can install all the necessary accessories, especially mysql for excel, which is extremely convenient to import data from Excel to the database at a later stage. Workbench is a good auxiliary software, and the default connection is installed by default. Wor

  2022-06-01 10:09:37 Views: 224