NAV: SLTechnology News&Howtos > Database >

• 

  Oracle database migration method 1: impdp+dblink

  Experimental environment: source database: 192.168.2.200 SID=testdb target library: 192.168.2.100 SID=testdb Experimental purpose: to use impdp+dblink to transfer 192.168.2.200 data

  2022-06-01 13:55:48 Views: 284
• 

  Parsing MySQL binlog-- (2) FORMAT_DESCRIPTION_EVENT

  This format describes events introduced in binlog version 4 to replace previous versions of START_EVENT_3 events. Is the first event in a binlog file and appears only once in a binlog file. Specific definition: binlog

  2022-06-01 13:55:48 Views: 237
• 

  Overview and principle Analysis of PXC / Galera Cluster Cluster

  Mariadb's galera cluster cluster copies percona's PXC database cluster, so the principle is the same # Galera Cluster/ PXC cluster works: client sends dml to server

  2022-06-01 13:55:45 Views: 295
• 

  OpenStack basic Learning and keystone Service configuration

  Openstack basic Learning OpenStack is a free software and open source project developed and initiated by NASA (National Aeronautics and Space Administration) and Rackspace under the Apache license. OpenStack is a

  2022-06-01 13:55:44 Views: 301
• 

  Data cannot be changed in MYSQL view

  The view comes from the base table. If the view uses some functions, such as sum,avg,count, etc., the combined data, and the data that does not exist in the base table, if you change the view, there will be an error to create the view to calculate the average create view huthon_.

  2022-06-01 13:55:44 Views: 280
• 

  Character function of Oracle one-line function

  This paper mainly summarizes the function and usage of the following character functions: the function states that ASCII returns the decimal value of the corresponding character CHR gives the decimal return character CONCAT to concatenate two strings, and the same INITCAT changes the first letter of the string to uppercase IN.

  2022-06-01 13:55:44 Views: 302
• 

  The use of xtarback backup tool

  One: what is xtrabackupXtraBackup is a tool for backing up MySQL. Only full backup is supported for mysql's MYISAM engine, and not only full backup but also incremental backup for innodb. It is a fully automatic tool.

  2022-06-01 13:55:44 Views: 269
• 

  What if I forget my MySQL password? MySQL reset root password method

  1. Solution to loss of Mysql password for single instance # ps-ef | grep 3306 # View the PID# kill PID# kill PID# my of 3306 instance

  2022-06-01 13:55:43 Views: 205
• 

  Table lock query appeared in Oracle and solved quickly

  When we share a database, we often encounter the problem of locking the table. 1. The stored procedure cannot be executed. 2. The query table data appears slowly. 3. The front end is jammed. The data of the locked table is queried through sql: SELECT dob.OBJECT_NAME Tab.

  2022-06-01 13:55:43 Views: 222
• 

  Overview of PL/SQL

  PL/SQL fully supports SQL data operations, fully supports SQL data types, and reduces the operation of converting data between applications and databases. The basic unit that makes up a PL/SQL program is the program block. PL/SQL blocks do not have to transmit SQ over the network one by one during execution

  2022-06-01 13:55:36 Views: 268
• 

  Ora-00327,ora-00312

  Do log switch, database handle live, cancel command execution, power off and close the database. Then log in to the database again, start the database, and the data crashes. Check alert log, report ORA-00327 and ORA-00312 failure prompt log2 log physical size 2

  2022-06-01 13:55:36 Views: 257
• 

  Installation of OracleLinux6

  The linux system installed for Oracle database 1. First of all, there must be an oracle linux mirror link: https://pan.baidu.com/s/1S3xYr4YNGtU-351bVaS1-Q extraction code: A55

  2022-06-01 13:55:06 Views: 267
• 

  Oracle CRS-0184 cannot talk to the crs daemon

  Oracle 11g rac crs process restart Times error 1 when creating a rac cluster, the above error occurred deleting the / etc/oracle/scls_scr/rac1/oracle/cssfatal file on the node1 machine and running / u

  2022-06-01 13:55:05 Views: 233
• 

  1. LAMP architecture introduction MySQL installation

  [toc] LAMP Architecture introduction MySQL installation 1. LAMP Architecture introduction 1.Linux+Apache (httpd) + MySQL+PHPAppache is the most commonly used web service software, while MYSQL is a relatively small database software

  2022-06-01 13:55:04 Views: 282
• 

  Using DBExportDoc V1.0 For MySQL to automatically generate database table structure documents

  For DBA or developers, how to standardize your database table structure documents is a very important thing. But when your library and your watch are overwhelming, you will have a headache. Recommend a tool DBExportDoc V1.0 For MySQL (M

  2022-06-01 13:54:34 Views: 249
• 

  Use zabbix to monitor MongoDB

  Now several game projects of the company mainly use MongoDB to store game data, so the monitoring of MongoDB is very important. For more information on other monitoring methods of MongoDB, please see the following articles: MongoDB Monitoring one MongoDB Monitoring two mongoto

  2022-06-01 13:54:24 Views: 269
• 

  Oracle Study-AIX6.1 Construction Oracle 10gR2 RAC (3)

  Oracle Study-AIX6.1 Construction Oracle 10gR2 RAC (3) 1. Configure shared storage [oracle@aix203 ~] $lsdev-c diskhdisk0 Available 1s-

  2022-06-01 13:54:15 Views: 219
• 

  Sqlserver: a method for querying database size

  / * * method for querying database size by 9.sqlserver * * /-- headquarters requires that the growth size of ERP database be obtained once a month. Source: http://www.jb51.net/article/30993.htmSE

  2022-06-01 13:54:14 Views: 294
• 

  The Scheme of data consistency in redis

  Background: now redis is widely used in interconnection, and its use varies from business to business, but there are generally problems with the consistency of data storage and caching. Here are some more mature and practical solutions. I hope it will be helpful to you, if you have good plans and suggestions.

  2022-06-01 13:54:14 Views: 259
• 

  Database-oracle

  Why use the database? File storage: 1, not easy to manage and analyze (entering ls commands under the Linux operating system will jam) 2, not easy to share 3, the file content is increasing, it is not easy to store the database: the number of DB:Database in the warehouse that uses the data structure to manage and store data

  2022-06-01 13:54:13 Views: 244