NAV: SLTechnology News&Howtos > Database >

• 

  The solution of ORA-01102 error reporting

  The error of ORA-01102: cannot mount database in EXCLUSIVE mode is mainly caused by the lk file, which is located in the dbs directory under ORALCE_HOME. Solve the problem:

  2022-06-01 17:39:04 Views: 208
• 

  Management and Application of btrfs

  Btrfs file system (only available in centos 7. 0). Btrfs (usually pronounced Butter FS), a COW (copy-on-write) file system announced by Oracle in 2007 and in progress. The goal is to take

  2022-06-01 17:39:04 Views: 314
• 

  Installation of postgresql9.6.9 in centos 6.8

  Centos 6.8 install postgresql9.6.9 practice 1, prepare the system before installation: centos 6.8 server IP:192.168.1.211 modify SELINUX=disabledvi / etc/selinu

  2022-06-01 17:39:04 Views: 278
• 

  Oracle DBA reflects that virtual machines in ODA cannot allocate memory

  The final cause of the investigation is due to the parameter setting of the oracle database itself. 1. How to adjust memory and cpu:oakcli configure vm uat-ihub-oracle-db-prefnode 1-ma for a virtual machine

  2022-06-01 17:39:04 Views: 239
• 

  Things to consider when ORACLE RAC runs above 300 GB of memory

  With going to IOE, the hardware of PC server is much cheaper than that of IBM minicomputer, and many hosts are equipped with T memory. Here are some parameters that need to be considered in MOS when the memory is greater than 300g in RAC environment. Welcome to ORACLE Super Group: 1

  2022-06-01 17:38:58 Views: 302
• 

  Oracle linux 7 Open Port

  Selinux was enabledyou need to add the port 587 to http_port_tsemanage port-m-t http_port_t-p tcp

  2022-06-01 17:38:58 Views: 270
• 

  8623 error: The query processor ran out of internal resources and could not pro

  8623 error: The query processor ran out of internal resources and could not produce a query plan problem description: configured with S

  2022-06-01 17:38:49 Views: 219
• 

  Construction of ShowDoc

  In fact, the official document is also very clear. Mainly post the problems I encountered. Environment: LNMP (LAMP has not been tried, interested students can try it, and then send it) PHP5.3 version above, php-mbstring module, php-pdo module, mysq

  2022-06-01 17:38:46 Views: 263
• 

  Db2 full library integrity check and gadget record

  Db2 "SELECT substr (TABNAME,1,30) as TAB_NAME, STATUS, ACCESS_MODE, substr (CONST_CHECKED,1,1) as FK_C

  2022-06-01 17:38:45 Views: 273
• 

  Usage of delete delete sql statement in MySQL

  Mysql how to delete one or more rows, use the SQL statement delete keyword, fixed usage delete from table name. 1Dist delete delete a row of delete from student w

  2022-06-01 17:38:45 Views: 302
• 

  How to restore the root password when trove creates instance from backup

  When trove uses innobackupex, the line backup is carried out for the whole database. When the instance is created from the backup set, the data in the backup set can be restored. However, because it is a full database backup, root,os_admin (the account used by trove to manage the database, o

  2022-06-01 17:38:45 Views: 288
• 

  Must-see database usage specification

  Guide: with regard to the MySQL database specification, I believe you have seen some documents. This article classifies and summarizes the relevant database specifications in detail, from the database table naming design specification to the index design specification, and then gives some suggestions on the compilation of SQL. It is believed that these norms are applicable to most public companies.

  2022-06-01 17:38:45 Views: 248
• 

  Oracle unbound variable SQL query

  SqlplusSQL > set numw 30select FORCE_MATCHING_SIGNATURE, count (1) from v$sqlwhere FORCE_MATCHING_SIGNA

  2022-06-01 17:38:44 Views: 294
• 

  Index optimization series 14-when the performance of partitioned indexes is low

  Drop table part_tab purge;create table part_tab (id int,col2 int,col3 int) partition by range (id) (pa

  2022-06-01 17:38:44 Views: 233
• 

  The 12th theoretical basis of Mysql database-backup and restore

  1. It is the most popular open source SQL database management system developed by MySQL AB Company. Its main features are as follows: 1. It is a database management system. 2. It is an associated database management system. 3. It is an open source software, and there are a large number of shared MySQL software 4, M available.

  2022-06-01 17:38:38 Views: 208
• 

  Add Scott user

  C:\ Users\ Administrator > echo% ORACLE_HOME%C:\ app\ Administrator\ virtual\ product\ 12.2.0\ dbhome_2C:\ User

  2022-06-01 17:38:26 Views: 255
• 

  User who created the Mysql database

  Note: the SQL statement ends with ";" by default in the Mysql database. When entering commands, keywords can be uppercase or lowercase, but must be consistent, I prefer to use lowercase, personal habit. There are three main ways to create database users in Mysql: 1 by reporting to my

  2022-06-01 17:38:25 Views: 235
• 

  MySQL read-write Separation Architecture (KHPM)

  MySQL read-write Separation Architecture (KHPM) KeepalivedHAProxyProxySQLMySQLKeepalived+HAProxy Application Portal No single Point of failure ProxySQL Cluster ProxyS

  2022-06-01 17:38:22 Views: 209
• 

  50 suggestions for MongoDB developers Tip12

  This series of articles are translated from "50 Tips and Tricks for MongoDB Developers". I can't find the Chinese version for the time being. Anyway, I have been studying mongodb deeply recently, so I just want to translate it. On the one hand, strengthen yourself.

  2022-06-01 17:38:22 Views: 258
• 

  Application continuity in Oracle RAC Environment

  Most of the databases of traditional enterprises such as banking and telecommunications industry use the high-availability architecture of oracle rac+dataguard. In the implementation process of rac project, due to the stringent requirements of business continuity, high-availability implementation and testing work is particularly important. Oracle is in the new edition

  2022-06-01 17:38:21 Views: 215