NAV: SLTechnology News&Howtos > Database >

• 

  Installation of SQL sever encountered duplicate instance name and invalid credentials

  The school has set up a database course this semester, which requires us to install a SQL sever software to practice using. I found SQL sever 2008R2 resources in the official account, the software installation housekeeper. After downloading and decompressing the package, you will begin to follow the tutorial step

  2022-06-01 14:02:05 Views: 247
• 

  MySQL lesson 6 Primary key is a string case insensitive

  In the process of creating a table, specify a field of type varchar and specify a primary key. If there is already a record as aaaa, if an AAAA record is inserted into the database at this time, it will prompt: 1062-Duplicate entry 'AAAA'

  2022-06-01 14:02:05 Views: 301
• 

  Centos6.3 install mysql5.7

  1. View CentOS's own MySQL 5.1 components and uninstall rpm-qa | grep-I mysqlrpm-e-- nodeps mysql-libs-5.1.61-4.el6.x86_642, rpm

  2022-06-01 14:01:14 Views: 265
• 

  JDBC connects to the database

  The main steps for JDBC to connect to the database are as follows: 1. Load the JDBC driver Class.forName ("com.mysql.jdbc.Driver"); after loading successfully, the instance of the Driver class will be registered with DriverMan

  2022-06-01 14:01:13 Views: 215
• 

  Recognize regular expressions

  Regular expression re:pattern in Python: matching pattern, following regular expression syntax method: matching method, introduction to search/match/split/findall/finditer/sub/subnre module

  2022-06-01 14:01:13 Views: 273
• 

  The solution to the error of ORA-04031 reported by Oracle11G

  Problem: when migrating the customer's database to a new minicomputer, the customer encounters the following error when using Oracle: application that throws an exception: type of exception thrown by Hebcz.Platform.VM: DDTek.Oracle.OracleExcep

  2022-06-01 14:01:13 Views: 278
• 

  Redis 3.0 compilation and installation

  Official main site: http://www.redis.io/ download address: http://www.redis.cn/download.htmlCommand API: http://www.redis.cn/comm

  2022-06-01 14:01:12 Views: 282
• 

  Tomcat installation configuration

  Install Tomcat notes: software: jdk:jdk-8u5-linux-i586.gz download address: http://download.oracle.com/otn-pub/java/jdk/8u5-b13/jdk-

  2022-06-01 14:01:12 Views: 265
• 

  Production system RMAN backup failed ORA-00245

  First, environment description AIX 6.1Oracle 11.2.0.3 three-node RAC II, problem description 1. Full library backup error Starting Control File and SPFILE Autobackup at 04wi N

  2022-06-01 14:01:12 Views: 227
• 

  High availability scheme of database

  Plan 1: dual-computer high availability scheme 1. Database architecture figure 2. One machine An is used as the read-write library, the other B as the backup library, after the failure of the A library, the B library is used as the read-write library, and after the A library is restored, An is used as the backup library. 3. The development shows that in this case, the database IP address in the data source configuration can be virtual

  2022-06-01 14:00:54 Views: 288
• 

  Master-Slave replication Application of Relational Database

  1. Concepts related to MySQL simple replication: 1. Meaning of mysql replication: Mysql replication is a prerequisite for mysql to complete high-performance applications. 2. Mechanism of mysql replication: Slave thread: IO thread: request for binary logs from the main service

  2022-06-01 14:00:53 Views: 299
• 

  Installation of Oracle linux

  The first step is operating system installation, the second step is firewall setting, the third step is SELinux setting, the first step is operating system installation: nextthe differences between "Basic Storage Devicec" and "Sp"

  2022-06-01 14:00:35 Views: 250
• 

  Memcache cluster

  Four computers memcache:192.168.1.201 192.168.1.202magent: 192.168.1.100 192.168.1.101 experiment: 1. Install libevent software (four) [roo

  2022-06-01 14:00:34 Views: 233
• 

  MySQL MHA application practice (scheme actual combat)

  1. Environment and conditions already exist master-slave architecture environment hostname IP address master-slave role MHA role leo1192.168.3.2MasterMHA-nodeleo2192.168.3.3slaveMHA-nodeleo3192.168

  2022-06-01 14:00:34 Views: 242
• 

  Access Control of MongoDB Learning arrangement

  MongoDB learning access control 1. Restrict access to a specific IP address by adding the-- bind_ip parameter at startup and-- host/app/mongo/mongodb/bin/mongod-- d when the client connects

  2022-06-01 14:00:34 Views: 248
• 

  Oracle Series: (10) Summary

  Use the NVL (NVL b) general function to calculate the annual income of employees. NVL () acts on any type, that is, the (number/varchar2/date) general function: the parameter type can be number or varchar2 or date type using NVL2 (

  2022-06-01 14:00:33 Views: 287
• 

  Finance, another main battlefield of ZTE

  "Finance is currently the most important section of ZTE besides the telecommunications industry." Cui Liangjun, vice president of ZTE, called a spade a spade at the 2019 China International Finance Exhibition. At the same time, ZTE, which made its debut at the financial exhibition, comprehensively demonstrated a full range of end-to-end products and solutions in the financial sector. ZTE

  2022-06-01 14:00:24 Views: 243
• 

  Linux automatically backs up Oracle and deletes backups before a specified number of days

  This article is mainly about the use of shell scripts to achieve regular backup of Oracle database, and delete backup files before a specified number of days. Daniel who has mastered shell, please pass by decisively. If there are any similarities in this article, it is purely intentional. First introduce the test environment, and then explain the details.

  2022-06-01 14:00:24 Views: 285
• 

  Centos7 configuration samba

  After the basic installation of yum install samba is complete, go to the configuration file directory cd / etc/samba/vi / etc/smb.conf (remember to back up) about the contents of smb.conf, and do the following: # Global configuration

  2022-06-01 14:00:24 Views: 291
• 

  Configure JNDI data sources in Tomcat

  Enterprise web servers are used at work, such as weblogic, it is very convenient to configure JNDI data sources. If you have nothing to do at home, you want to use tomcat to configure JNDI, which is easy to build the system to use. It is found that there is no interface operation for versions above tomcat6.x. Remember

  2022-06-01 14:00:23 Views: 228