NAV: SLTechnology News&Howtos > Database >

• 

  ORACLE log management framework quest error manager

  The Quest Error Manager (QEM) is a framework that will help you standardize the management of errors

  2022-06-01 15:37:18 Views: 264
• 

  JDBC series: (2.5) create JDBCUtils tool classes

  1. Create the db.properties file url=jdbc:mysql://localhost:3306/testdbuser=rootpassword=rootdriverClass=com.mysql

  2022-06-01 15:37:18 Views: 286
• 

  Install oracle client to support oracle remote backup and PL/SQL configuration

  1. Oracle_client installation (brief) download address: 12g: https://www.oracle.com/technetwork/database/enterprise-edition/download

  2022-06-01 15:37:12 Views: 241
• 

  3_Oracle_Admin_SPFILE

  SPFILE is stored on the server side and cannot be modified by itself (thus overcoming some security risks of PFILE). If you use a text editor to view SPFILE, you will find that it is a binary file. You need to use the SQL command and be managed by Oracle Server to make

  2022-06-01 15:36:45 Views: 294
• 

  Solve the problem of garbled codes in springmvc+mybatis+mysql [transfer]

  This article mainly introduces the relevant information to solve the problem of Chinese garbled code in springmvc+mybatis+mysql in java. Friends who need it can refer to the recent use of ajax to request springmvc background query mysql database, the page is displayed in Chinese.

  2022-06-01 15:36:44 Views: 248
• 

  Remote execution of SaltStack practice-Returners

  Remote execution of SaltStack practice-Returners Learning remote execution of SaltStackSaltStack practice-Returners1. Returners listing 2. Introduce the usage of mysql returner

  2022-06-01 15:36:44 Views: 262
• 

  The usage of SQL CASE

  -- simple case function case sexwhen'1' then 'male' when'2' then 'female' else 'other' end--case search function case when sex ='1' then

  2022-06-01 15:36:43 Views: 244
• 

  Oracle 10g process of generating awr report

  SQL > exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Product

  2022-06-01 15:36:20 Views: 284
• 

  Oracle11G_ archive and log files

  Operation mode: Oracle database can be run in archive mode, non-archive mode, and can be switched between each other; log file classification: online log file, archive log file; online redo log: record changes to data, which can be used for data recovery and log analysis; also known as online log file; LG

  2022-06-01 15:36:20 Views: 276
• 

  Easily master the way of database management-- the eighth (performance) of operation and maintenance inspection

  In the preface, daily inspection is an important step in database management and maintenance, and it is necessary to register the date and result of each inspection, and a patrol report may be needed at the same time. The purpose of this series is to solve some common problems: do not know what to patrol, do not know how to facilitate the physical examination machine, there are too many physical examination troubles.

  2022-06-01 15:36:20 Views: 243
• 

  The method of operating SqlServer2012 in cmd Command Line window

  Be careful to install SqlServer2012 before doing the following. 1. Open the cmd command line window and enter the sql-s service name. You can directly open the database server (no password is set). Note that this is logging in to the local database server, and displaying 1 > indicates even

  2022-06-01 15:36:14 Views: 302
• 

  Database startup error: ORA-00600 [kcratr_nab_less_than_odr]

  Recently, due to the power outage in the computer room, the database host was shut down abnormally. After the host returned to normal, the database was started with an error: ORA-00600: internal error code, arguments: [kcratr_nab_less_t

  2022-06-01 15:35:58 Views: 222
• 

  Ubuntu apt-get install Mongodb

  Recently, we are going to do a project with mongodb, and the environment is Ubuntu. Switch to the apt-get update update source for root users, which uses Aliyun's source, which feels fast and easy to use. Apt-get mongodb to see if the process starts mong

  2022-06-01 15:35:58 Views: 238
• 

  Mysql 8.0.11 innodb cluster High availability Cluster Manual Series-introduction to Cluster

  MySQL 8.0.12 innodb cluster high availability cluster deployment operation and maintenance management manual-innodb cluster principle introduction author Fang Lianchao Innodb cluster principle introduction Innodb clust

  2022-06-01 15:35:53 Views: 250
• 

  ORACLE 100 cases trial 4

  Oracle series "four": database design and analysis 1. The use of sequences in many database systems there is a column that grows automatically. If you want to achieve the function of automatic growth in Oracle, you can only rely on the sequence. 1. You must have the permission to create a sequence create seq

  2022-06-01 15:35:53 Views: 268
• 

  Common solutions for mysql backup and architecture

  Mysql backup tool: xtrabackup can build mysql dual master high availability architecture mysql cluster architecture MHAMMM framework mysql high availability cluster through keepalived

  2022-06-01 15:35:52 Views: 233
• 

  Mysql-5.6.35 binary installation

  Chown-R mysql:mysql / mysql/mysql/scripts/mysql_install_db-user=mysql-basedir=/mysql/-datadir=

  2022-06-01 15:35:52 Views: 290
• 

  How to solve the concurrency problem of redis

  How to solve the concurrency problem of redis? In response to this problem, the editor summed up this article today, hoping to help more friends who want to solve this problem to find a more simple and feasible way. Concurrency issues in redis have been cached by redis for a long time, and redis is single forward.

  2022-06-01 15:35:40 Views: 207
• 

  Formatting of SQL Plus output (linesize, pagesize)

  Description: SQL Plus can perform some database operations, just like using other database tools, but one drawback of SQL Plus is that the output is not formatted satisfactorily. Let's get down to business. Press the Win+ r key, enter sqlplus or

  2022-06-01 15:35:40 Views: 206
• 

  Recover data block bad block

  July 22, 2014 studies the recovery of bad blocks in databases: Oracle calls standard C system functions to read and write data blocks. Therefore, bad blocks may be caused by the following reasons: hardware I Universe errors, operating system I Unix O errors or buffering problems, memory or paging problems.

  2022-06-01 15:35:40 Views: 259