NAV: SLTechnology News&Howtos > Database >

• 

  JEESZ distributed Framework-- single sign-on Integration Scheme

  JEESZ distributed Framework single sign-on Integration solution Section 1: introduction to single sign-on step 1: understand the main characteristics of single sign-on SSO is that Web protocol (such as HTTPS) is used between SSO applications, and there is only one login entry. SSO system has the following three roles: 1)

  2022-06-01 11:29:44 Views: 207
• 

  Install Oracle 11g based on RHEL 6.5.detailed tutorial (3) & mdash;— install VMware Tools

  3 install VMware Tools1) as shown in the following figure, select virtual machine-client-install / upgrade VMware Tools. 2) Click OK as shown in the following figure. 3) Click OK as shown in the following figure. 4) as shown in the following figure, you can see VM

  2022-06-01 11:29:26 Views: 218
• 

  Statistical database data volume statement

  In general, when server permissions or database permissions are obtained through a vulnerability, in order to verify the severity of the vulnerability, in most cases, we need to count the amount of data in the database (not query specific data values). The following query statements share two databases, and you can query the database directly.

  2022-06-01 11:29:13 Views: 301
• 

  Oracle uses errorstack to track tomcat Times wrong ORA-00903 invalid table name what to do

  What the editor wants to share with you this time is how Oracle uses errorstack to track the wrong ORA-00903 invalid table name of the tomcat Times. The article is rich in content, and interested friends can learn about it. I hope you can get something after reading this article.

  2022-06-01 11:29:13 Views: 255
• 

  Replica sets Architecture replication set (2) detailed explanation

  Now that we have successfully built the log, here is a detailed interpretation of the log. We can view some basic information of the operation log, such as size, log startup time, and primar, by executing the "db.printCollectionStats ()" command.

  2022-06-01 11:29:13 Views: 210
• 

  The difference between Rowid and Rownum

  Rowid and Rownum are rarely used by database developers because batch data is mostly used in enterprise database development, but it is still used by other database staff. Both rowid and rownum are imaginary columns, but they have completely different meanings. Ro

  2022-06-01 11:29:13 Views: 221
• 

  ADF developer encountered an error: JBO-26030 could not lock the record, and another user held the lock

  While testing the deployed ADF program, the following error was encountered: "the record cannot be locked and another user holds the lock." After examining the code, it is found that two consecutive commit operations are performed on the same data in the method of the code. The reason for this design is that some words of the data are processed first in the method.

  2022-06-01 11:29:04 Views: 219
• 

  The database is not case-sensitive

  Lower_case_table_names=1 # means not to distinguish [mysqld] lower_case_table_names=0 to distinguish

  2022-06-01 11:28:49 Views: 298
• 

  Remote backup of binlog Log in mysql Database

  The binary log binlog of MySQL database records all the DDL and DML operations on the database, which plays an irreplaceable key role in the point to point disaster recovery of the database. Therefore, based on such considerations, it is necessary to generate binlo for the production environment

  2022-06-01 11:28:49 Views: 210
• 

  AB replication and GTID multithreaded replication configuration for MySQL5.7

  Mysql AB replication: three hosts: MASTER IP:172.25.35.21SLAVE1 IP:172.25.35.22SLAVE2 IP:172.25.35.19MYSQL version: mysql5.7 download

  2022-06-01 11:28:49 Views: 202
• 

  Zabbix monitors Oracle DataGuard through Orabbix

  Oracle uses DataGuard as a remote backup. You can add QueryList=archiv to the beginning QueryList by monitoring the difference between master and slave archive log sequences vim orabbix/conf/query.props

  2022-06-01 11:28:48 Views: 265
• 

  Linux environment installation oracle11G preparation environment (self-study note 1)

  The system chooses Red Hat Enterprise Edition 5.464 bit, database: oracle11G-R2oracle installation preparation environment: 1:yum server configuration: [root@station90 ~] # cat / etc/yum.repos.d/ba

  2022-06-01 11:28:45 Views: 297
• 

  Analysis of Oracle Table connection mode

  Oracle Table join mode analysis table join basics: 1. Which table will drive the query (that is, the first table accessed)? When will none of the tables be accessed according to the specified path query? What are the optional drive paths? 2. What Oracle connections may occur? Remember: in

  2022-06-01 11:28:42 Views: 278
• 

  Zabbix master-slave replication

  1. Export mysqldump-uroot-p-- single-transaction-R-- default-character-set=utf8-- tri except the appearance of the historical data table in the main zabbix database.

  2022-06-01 11:28:42 Views: 247
• 

  Problems with Excel tables and databases

  Sort out some of the most basic problems encountered in the previous two days of work because of the work requirements, import the Excel table into the database, then SQL statements for business logic operation, and finally export the result set to the table. When I heard about this task, I felt no difficulty at first, but as a result, my strength hit me in the face. Question 1:

  2022-06-01 11:28:30 Views: 230
• 

  Python deletes mongodb database and users, and views Python

  #! / usr/bin/env python#coding:utf-8from pymongo import MongoClientclient = MongoClient ('192.168.6.243)

  2022-06-01 11:28:29 Views: 215
• 

  Xtrabackup backup recovery

  1. Xtrabackup instructions and installation 1, Xtrabackup instructions and installation 2, Xtrabackup full backup and recovery 3, Xtrabackup full and incremental backup and recovery 4, Xtrabackup partial complete and incremental backup and recovery

  2022-06-01 11:28:29 Views: 295
• 

  Location and solution of memory problem

  Basic process of memory problem location: mainly used performance counter Page life expectancy (database counter: mainly displays unused pages, seconds to stay in the cache) Lazy writes/sec (database counter: lazy write

  2022-06-01 11:27:59 Views: 238
• 

  Simple and practical mysql database backup web page file backup

  Install percona-xtrabackup http://990487026.blog.51cto.com/10133282/1759237root@uat:/backup# cat xtrabackup

  2022-06-01 11:27:59 Views: 286
• 

  DB_FILE_MULTIBLOCK_READ_COUNT performance-related parameters

  First, environment Oracle 11g RAC II, test process SQL > show parameter db_fileNAME TYPE

  2022-06-01 11:27:58 Views: 282