NAV: SLTechnology News&Howtos > Database >

• 

  ORACLE cross-version upgrade

  Cross-version upgrade (10.2.0.5 to 11.2.0.3) 10.2.0.5 version: ORACLE_BASE: / oracle/u01/app/oracleORACLE_HOME: / oracle/u01/app

  2022-06-01 13:22:22 Views: 208
• 

  Tell me about Keepalived's brain fissure.

  1. Work scenario Keepalived provides the functions of Loadbalancing and High-Availability. This article refers to scenario 2. 2 which provides HA function for 2 Mycat nodes. The key configuration is as follows, which is the active and standby non-preemptive mode.

  2022-06-01 13:22:19 Views: 288
• 

  Concatenation of various database strings

  1. SQLite:SELECT 'AA' | |' BB' | | 'CC';2, MySQL:SELECT CONCAT (' AA', 'BB',' CC'); 3. SQL Server & Access:S

  2022-06-01 13:22:18 Views: 243
• 

  Backing up the MySQL database using XtraBackup

  This test uses XtraBackup to back up the MySQL database version: XtraBackup2.4.5+MySQL5.7.16 download address: https://www.percona.com/downloads/XtraB

  2022-06-01 13:22:18 Views: 291
• 

  Rpm package specifies the installation path

  Rpm packages generally have a default installation path, how do you want to change the default path, is there any way? Of course there is. Let's look at the following example. Such as installing JDK (Java Development Kit) or JRE (Java Runtime En)

  2022-06-01 13:22:18 Views: 254
• 

  Considerations for what's New in Oracle11g

  After upgrading from oracle10g to oracle11g, you need to understand the new features of oracle11g, which may have an impact on application and performance and need to be adjusted. 1. Default in Oracle11g password expiration policy oracle11g

  2022-06-01 13:22:17 Views: 295
• 

  DDL Operation of mysql-- Database

  SQL is a very important programming language for operating relational databases. Since structure query language is a language that can be programmed naturally, the classification of SQL can be divided into DDL,DML,DCL according to different operating objects. We operate the database, such as creating, adding

  2022-06-01 13:22:04 Views: 271
• 

  Detailed procedure of SQL server 2005 database mirroring

  SQL server 2005 database mirroring detailed process 1. Add a complete domain name suffix to restart the system right computer = > Properties = > change settings (computer name) = > change = > hq.com2.SQL service startup account creation

  2022-06-01 13:22:02 Views: 214
• 

  Does mysql really need to restart the service when it forgets its password?

  Let's start with a question: how to reset the root password without restarting mysqld and without permission to modify user accounts and permissions? It doesn't matter if I don't know. I didn't know how to do it before. Let's take a look at the following ways to reset your root password. 1 、 skip-

  2022-06-01 13:22:02 Views: 253
• 

  Summary of Oracle operation users and tablespaces

  1. The operation flow of Oracle database. First of all, we need to understand the whole operation flow of Oracle database, as shown in the following figure. The next introduction to the tablespace and the operation of the user needs to be based on the following three steps: step 1: use the cmd command to open the DOS window

  2022-06-01 13:22:02 Views: 250
• 

  PostgreSQL-- semaphore and shmall and shmmax related settings

  The relationship between shared_buffers and shmmax,shmall,max_connections 1.1.The relationship between shared_buffers and max_connections shared_buffers

  2022-06-01 13:21:56 Views: 276
• 

  Delete duplicate records in MySQL

  In our work, we often have the need to delete some duplicate data. Duplicate data may be caused by the program bug. Let's take a look at the idea of how to delete these duplicated data. Here's the thing. Check to see if the result grouped according to this duplicate field is greater than 1.

  2022-06-01 13:21:44 Views: 288
• 

  What is Redis suitable for?

  Redis has a variety of data structures, which are suitable for many different application scenarios. 1. Using Redis as the data structure of caching Redis string and hash table is suitable to store a large number of key-value pairs of information, so as to achieve cache. two。 Use Redis as queue Redis

  2022-06-01 13:21:43 Views: 201
• 

  The ORACLE EM web page cannot be accessed

  View status emctl status dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0Copyrigh

  2022-06-01 13:21:20 Views: 258
• 

  The usage and result Analysis of explain in the usage of MySQL

  In this article, we will take a look at the usage and result analysis of explain in MySQL usage. There is a certain reference value, friends in need can refer to, hope to help you. 1. Introduction to EXPLAIN use the EXPLAIN keyword to simulate the optimizer implementation

  2022-06-01 13:21:20 Views: 281
• 

  Sqlmap in-depth learning

  2022-06-01 13:21:18 Views: 283
• 

  ORA-01102: cannot mount database in EXCLUSIVE mode

  There is a database in the test environment, because the disk burst, a new hard disk was added, and the database collapsed SQL > startup mountORACLE instance started.Total System Global Ar when starting.

  2022-06-01 13:21:18 Views: 302
• 

  Ora-01113: file 2 requires media recovery

  File corruption or missing date file: operation flow 1, shutdown immediate;2, startup mount;3, recover datafile'd:\'; 4, alter database open

  2022-06-01 13:20:48 Views: 201
• 

  T-SQL query statement part 1

  T-SQL query sentence the first part of the security code: painstaking human heaven, hard work, three thousand Yue A can swallow Wu case 1: table as shown below experimental requirements: 1. Query the products table for fruit information with a factory date later than April 2014. 2. In the products table

  2022-06-01 13:20:48 Views: 262
• 

  Multiplexing controlfile files

  -- SQL > alter system set control_files='/u01/app/oracle/oradata/PROD4/PROD4/control01.ctl' when the database is open

  2022-06-01 13:20:45 Views: 294