NAV: SLTechnology News&Howtos > Database >

• 

  ORA-00600 [kcratr_nab_less_than_odr] troubleshooting

  This type of error may occur when the server power supply suddenly fails (using backup control files for recovery) the error type: SQL > alter database open*ERROR at line 1:ORA-00600: internal er

  2022-06-01 11:58:20 Views: 225
• 

  Memcached (2) YUM installation and compilation installation

  YUM installation: it relies on libevent, but this is generally included with the system. In addition, I installed Memcached on a separate server here, but it is also deployed separately in the production environment. There is usually a memcached in the epel source. Let's take a look at it.

  2022-06-01 11:58:20 Views: 240
• 

  Xtrabackup series: binary installation

  First, extract the binary package tar-zxvf percona-xtrabackup-2.4.11-Linux-x86_ 64.libgcrypt145.tar.gz. Add the environment variable according to the path and use it.

  2022-06-01 11:58:20 Views: 257
• 

  Detailed explanation of haproxy monitoring page

  QueueCur: current queued requests / / current number of queue requests Max:max queued requests / / maximum number of queue requests Limit: / / queue limit Sessi

  2022-06-01 11:58:16 Views: 257
• 

  DB2 common commands

  Start database: start db2 service: db2start activate database instance: db2 activate database view activated database: db2 list active databases   shutdown database: failed database

  2022-06-01 11:58:16 Views: 227
• 

  Rman duplicate is more important than others.

  Rman duplicate database must be the same platform, but replication between 32bit\ 64bit is supported, and $ORACLE_HOME/rdbms/admin/utlirp.sql needs to be executed after the replication is completed.

  2022-06-01 11:58:16 Views: 287
• 

  Install mysql through yum warehouse under CentOS6.5

  Environment: Centos6.5 View centos version: [root@localhost ~] # cat / etc/redhat-release CentOS release 6.5 (Final) 1. Check to see if it is safe

  2022-06-01 11:58:16 Views: 221
• 

  The mechanism of oracle lock

  In modern multi-user and multi-task systems, it is inevitable that multiple users access a shared object at the same time, which may be a table, row, or memory structure. in order to solve the data security, integrity and consistency problems caused by multiple users' concurrent access, there must be a mechanism to solve these problems.

  2022-06-01 11:58:15 Views: 257
• 

  Differences between df and du commands

  1. Under normal circumstances, there is a gap between df and du output. The du-sh command obtains the total number of blocks used by the specified file system by adding up all directories, symbolic links, and the number of blocks used by the file system, while the df command obtains the total number of blocks by looking at the disk block allocation map of the file system.

  2022-06-01 11:58:15 Views: 278
• 

  Salt minion startup error

  The error message is as follows: The Salt Master has rejected this minion's public key! To repair this issue, delete the publi

  2022-06-01 11:58:15 Views: 301
• 

  About SQL image configuration error

  About the SQL image configuration error, it will often prompt the image error, the solution is as follows: the main reasons: 1. Firewall, the port is not available 2. The remote port does not open the 3.SQL service and the domain account is not used. Authentication cannot synchronize communication. If none of the above is true, there is a problem with backup and restore. Repeat.

  2022-06-01 11:58:06 Views: 265
• 

  Export method of sybase table structure

  Sybase ASE comes with a command line tool to export object structure: ddlgen more detailed usage, please refer to: use DDLGEN to extract object definition syntax from ASE database. If the object structure contains Chinese, use the parameter:-Jcp936 is more practical.

  2022-06-01 11:58:05 Views: 287
• 

  Sql_log_bin of MySQL Parameter Analysis

  There are many times when we want a SQL statement to be executed only on the Master database and not copied to the Slave database, at which point the sql_log_bin parameter is exactly what you need. For example, we want to import data only into the main library, but the Slave database guarantees

  2022-06-01 11:58:05 Views: 277
• 

  Detailed explanation of postgres database configuration file

  Allow_system_table_modsAllows modifications of the structure of system tables. Allows you to modify the structure of the system table. Application

  2022-06-01 11:58:05 Views: 299
• 

  Sql server 2008 2016 server view port

  This computer-- management-servers and applications-sql server configuration manager-- sql server network configuration

  2022-06-01 11:58:05 Views: 237
• 

  Oracle10g exports excel through sqlplus

  Oracle10g exports excel1 through sqlplus and creates scripts: cd / home/oracle/bristolvim a1.sqlset linesize 200set term off verify

  2022-06-01 11:58:04 Views: 255
• 

  The creation of mysql stored procedure

  Note: (1) what we need to pay attention to here are DELIMITER / / and DELIMITER; in two sentences, DELIMITER means a delimiter because MySQL defaults to ";". If we do not declare a delimiter, the compiler will treat the stored procedure as

  2022-06-01 11:58:04 Views: 232
• 

  Solution to password expiration of oracle account

  Oracle system account password expiration solution. System account password is valid for 180 days by default. When the password prompt has expired, you can use the following methods: 1 > enter sqlplus in the DOS window, prompt for account password 2 > enter s

  2022-06-01 11:58:04 Views: 265
• 

  Basic deployment and basic use of MySql (for personal learning and review)

  MySQL database introduces the most famous and widely used open source database software-originally owned by the Swedish company MySQL AB-in January 2008, MySQL AB was acquired by SUN. In April 2009, SUN was acquired by Oracle, a new open source branch M

  2022-06-01 11:58:04 Views: 226
• 

  Zabbix monitors the postgresql database through pg_monz templates

  Need to install the software package pg_monz-2.1.tar.gz zabbix-sender-3.0.5-1.el7.x86_64.rpm zabbix-agent-3.0.17-1.el7.

  2022-06-01 11:57:52 Views: 288