NAV: SLTechnology News&Howtos > Database >

• 

  ORACLE database vault

  Oracle Database VaultTOC\ o "1-3"\ h\ z\ u Oracle Database Vault PAGEREF _ Toc518292867\ h 11. Refer to.

  2022-06-01 06:24:49 Views: 254
• 

  The solution to the incorrect time of Mysql5.7 error log

  The error log time of MySQL 5.7is inconsistent with the system time, which seems to be laborious. Referring to the official documents, we know that starting from MySQL 5.7.2, a new log_timestamps parameter has been added, which mainly controls error log and genera.

  2022-06-01 06:24:49 Views: 266
• 

  Hbase0.98.8 source code compilation (based on hadoop2.4.1)

  The previous article introduced the compilation process of hadoop2.4.1, as well as the compilation of hive and spark, this time briefly introduced the compilation process of hbase. Hbase0.98.8 is compiled using hadoop2.2.0 by default, and the author's hadoop environment is 2.

  2022-06-01 06:24:49 Views: 207
• 

  Automatic JOB cannot be called due to Resource Manager shutdown

  This article describes in detail that a large amount of CPU was consumed at the customer site because of the resmgr:cpu quantum waiting event. After confirming the cause and shutting down the Resource Manager explorer feature that will cause the CPU to rise, the subsequent result will be

  2022-06-01 06:24:49 Views: 281
• 

  Oracle 11g data guard maintenance

  Main library 1.1 check error view v$ ARCHIVE_DESTcol dest_name for a30set line 220col error for a30select dest_name,statu

  2022-06-01 06:24:44 Views: 227
• 

  Oracle 12c sysaux table space insufficient handling-AUDSYS.CLI_SWP$def5007c$1 $1

  Oracle 12c sysaux table space insufficient processing-AUDSYS.CLI_SWP$def5007c$1 $1 alarm log content: ORA-1688: unable to extend table AUDSYS.

  2022-06-01 06:24:44 Views: 292
• 

  Note-taking of Redis (2): use of Java API and construction of Redis distributed cluster environment

  [TOC] Redis Java API uses (1): the stand-alone version of Redis API uses Redis's Java API to operate through Jedis, so the third-party library of Jedis is needed first, because it uses the Maven project, so

  2022-06-01 06:24:43 Views: 230
• 

  How to start archiving with oracle and how to deal with full archiving space

  1. Check whether the archiving mode is enabled [oracle@db ~] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 17

  2022-06-01 06:24:43 Views: 240
• 

  Specific attention should be paid to the use of IN-PLACE to upgrade from MySQL5.6 to version 5.7.

  1. Before SQL changes the behavior of the GET_LOCK () function MySQL 5.7.5, GET_LOCK () will release the previously acquired locks before the second execution. After this version, multiple locks can be acquired at the same time, such as mysql > select vers.

  2022-06-01 06:24:43 Views: 252
• 

  Summary of problems occurred during MGR testing

  The problems in MGR can be summarized as follows: 1. When committing a transaction, try to control the amount of data of a single transaction as much as possible to reduce the check time of big things in other nodes and the cluster replication delay caused by blocking subsequent operations, such as the greater impact of transaction rollback; deployment of 2.MGR cluster environment to

  2022-06-01 06:24:43 Views: 290
• 

  Size of online in-place modified fields in what's new in mysql 5.7

  The size of the VARCHAR field can be modified by ALTER TABLE, command, and in-place, for example: ALTER TABLE T1 ALGORITHM=INPLACE, CHANGE COLUM

  2022-06-01 06:24:43 Views: 207
• 

  MySQL service startup, shutdown and login-2

  Second, to log in remotely to a mysql instance, you need to change the corresponding host of the login user to% or the hostname or IP of the remote client (similar to whitelist). MySQL > update mysql.user set host='%' w

  2022-06-01 06:24:42 Views: 261
• 

  Oracle tablespace recovery

  If you delete a test data file test.dbf in the tablespace by mistake, and then the next time you restart the database, the database cannot be opened (open), and the error is always reported: SQL > alter database open;alter dat

  2022-06-01 06:24:42 Views: 289
• 

  Change the online redo log file prompt ORA-01511 ORA-01141

  Recently, a database is being migrated, using a full physical copy to the new environment, but the datafile directory needs to be changed. The previous environment preparation and physical copy went smoothly, but when the database was opened to read only mode, it was prompted that a st could not be read.

  2022-06-01 06:24:42 Views: 232
• 

  Oracle 11gR2 uses RMAN duplicate from active database to replicate databases

  Under Oracle 10g, we can use the RMAN duplicate command to create a replication library with different DBID. When it comes to Oracle 11gR2, there are two ways to implement RMAN's duplicate: 1. Ac

  2022-06-01 06:24:42 Views: 303
• 

  Docker, let the database deployment be completed in a flash

  Guo Xurui, an expert in Warhol Technology products, container technology is not the innovation of Docker, and some basic technologies that container technology depends on, such as namespace, cgroup, chroot and so on, are not the first of Docker. The reason why Docker is popular to a large extent

  2022-06-01 06:24:41 Views: 258
• 

  Show engine innodb status interpretation

  Show engine innodb status interpretation Note: the following is based on the personal understanding of the innodb status section of "High performance mysql third Edition" and "mysql Technology Insider innodb Storage engine". If there is any error,

  2022-06-01 06:24:41 Views: 229
• 

  How to check whether a user has certain permissions defined on a permission object

  For example, the role created in the ABAP development studi below is to implement the permission control of CDS view DEMO_CDS_AUTH_LIT_PFCG, which uses the permission object S_CARRID. Suppose now I

  2022-06-01 06:24:41 Views: 265
• 

  Install mysql in centos7

  1. Create a new group or user [root@ticent admin] # groupadd mysql [root@ticent admin] # useradd-m-g mysql mysql [root@tic

  2022-06-01 06:24:36 Views: 220
• 

  Apache MySQL-based authentication (transfer)

  Apache authentication based on MySQL [@ more@] this paper introduces the method of realizing user authentication in Apache, discusses how to save authentication information in MySQL database, and then implements authentication through mod_auth_mysql module.

  2022-06-01 06:24:35 Views: 202