NAV: SLTechnology News&Howtos > Database >

• 

  # Xlib: connection to & quot;:0.0" refused by server Xlib: No protocol specified

  When running asmca on a redhat5 system, the following error is prompted: # Xlib: connection to ": 0.0" refused by serverXlib: No protocol specifie

  2022-06-01 10:15:37 Views: 277
• 

  MongoDB Visualization tool mongochef

  A powerful MongoDB visual management tool mongochef, download address: https://studio3t.com with a screenshot:

  2022-06-01 10:15:34 Views: 245
• 

  DG environment RMAN delete archive error RMAN-08137: archived log not deleted

  Oracle 12C DG environment, prepare library archive directory alarm, check crontab script, find delete operation, keep it for two days, and then execute it manually to check the cause of error; RMAN > delete noprompt expired arch

  2022-06-01 10:15:33 Views: 223
• 

  How to create an efficient index

  Guidelines for index creation: 1, frequently appear in where clauses 2, frequently appear in join associated fields 3, select highly selective keys 4, don't use B-tree indexes on keys with few different values. Such keys or expressions are often poorly selective, so they do not have performance.

  2022-06-01 10:15:33 Views: 257
• 

  Install mariadb5.5 in binary mode on centos6

  Prepare the mariadb-5.5.57-linux-x86_ 64.tar.gz binary package this package is compiled, which means we have to install it in a specific directory; step 1, prepare the mysql user mkdir / app/data# this directory

  2022-06-01 10:15:33 Views: 204
• 

  V$option & & dba_registry

  After we have installed the database, we need to check the database component to see if the status is available. When building the library manually, the components installed are incomplete, so we need to install the required components manually. Here is a way to view the components. -- View the components in the system SQL > sel

  2022-06-01 10:15:29 Views: 208
• 

  Manual exploitation of SQL inject vulnerabilities: get shell

  Idea: upload a "backdoor" and control the backdoor to get the shell, such as the sentence *. For example: / submit via request and execute shell

  2022-06-01 10:15:29 Views: 287
• 

  How Oracle makes dbf files move

  This article mainly shows you how Oracle makes dbf files mobile, the content is easy to understand, I hope you can learn, after learning there will be a harvest, the following let the editor to take a look at it. Background insufficient oracle space, found that the dbf file is not designed

  2022-06-01 10:15:20 Views: 236
• 

  How to install mysql5.7 with linux source code

  Linux source code how to install mysql5.7? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. 1. Download the mysql source installation package wget

  2022-06-01 10:15:20 Views: 221
• 

  Basic knowledge of MySQL database

  Day02 MySQL database basic knowledge 1, basic knowledge overview: the foundation determines the success or failure of your course! Only after learning these basic knowledge, can you really use it freely. In order to have a deeper understanding of the database, the road will go farther and farther. Second, basic knowledge: 1.

  2022-06-01 10:15:16 Views: 260
• 

  MHA Architecture of mysql

  Role Ip address hostname Server id type master192.168.1.131master11 master (write) Master (candicate) 192.168.1.132Master22 slave (read) Slave19

  2022-06-01 10:15:16 Views: 259
• 

  Set the environment variable of Oracle10g under Windows

  Set the Oracle10g environment variable Windows under Windows to install Oracle10g. Every time you start the em service, that is, enter emctl start dbconsole in the cmd command line window, you will always prompt "Environ"

  2022-06-01 10:14:58 Views: 231
• 

  Installation and use of typical NoSQL database-- MongoDB installation and use

  The installation method is carried out directly with the apt-get install mongodb command, and the source package installation can also be done with hadoop@dblab:/$ sudo apt-get updatehadoop@dblab:/$ sud.

  2022-06-01 10:14:55 Views: 204
• 

  On the synchronization delay of MongoDB

  When your users complain that the modified information does not change and the deleted data is still displayed, if you pinch and calculate, it is estimated that the database master is out of sync. Like other databases that provide data synchronization, MongoDB also encounters synchronization latency, in MongoDB's ReplicaOr

  2022-06-01 10:14:55 Views: 300
• 

  Oracle11G installation practice

  Oracle introduces Oracle Database, also known as Oracle RDBMS, or Oracle for short, a relational database management system of Oracle. It is a leading product in the field of database. We can say that Oracle data

  2022-06-01 10:14:48 Views: 272
• 

  Record a production Database & quot; accident & the experience of quot; restart

  Introduction in a sunny afternoon, the lower right corner of the computer came pieces of e-mail reminders, while accompanied by the vibration of Wechat nails, open a look, application errors, Heaven Rabbit alarm, database server memory burst red, Mysql database instance hung up. Check and explain the database version: mysq

  2022-06-01 10:14:43 Views: 264
• 

  3.1-MongoDB installation

  MongoDB installation * build yum source if you install the epel extension source, you can install the mongodb2.4 version, but this time we want to install version 3.0. the official source only supports 64-bit system vim / etc/yum.repos.d/mongo.

  2022-06-01 10:14:42 Views: 238
• 

  Commands commonly used in MEMCACHE

  Common commands of MEMCACHE: SET, GET,INCR,APPEND,DELETE,FLUSH_ALL,GETS,CASSET ZHANG 0 03 ZHANG KEY 0 FLAG 0 EXPI

  2022-06-01 10:14:42 Views: 250
• 

  Migration and Rescue of Database

  A day of wind and rain, when on duty at night, a business database space is not enough, call the police. Normal shutdown SQL > shutdown immediateDatabase closed.Database dismounted.ORACLE

  2022-06-01 10:14:42 Views: 278
• 

  Oracle cannot collect AWR error ORA-13516

  Today, when I looked at a SQL that the application responded that it could not be executed, I found that the AWR report in the database was not collected automatically. The most recent one remained on September 26th. The current time is October 20th. Now it is interesting. How could this happen? the default AWR is once an hour.

  2022-06-01 10:14:39 Views: 270