NAV: SLTechnology News&Howtos > Database >

• 

  Use DBMS_FILE_TRANSFER to migrate database from AIX to Linux

  Environment description source-side target operating system AIX 6100-03-10-1119RHEL6.5 x64 cluster Oracle RAC+ASMOracle RAC+ASM database version 11.2.0.3.011.2.0.4.01,

  2022-06-01 13:17:24 Views: 252
• 

  Mongodb Master-Slave replication and deployment of replica sets

  1. Introduction to Mongodb configuration parameters: [root@host11 tmp] # cat / etc/mongod.conf# runs fork=true# as a daemon to set the path dbpath=/usr/local of db

  2022-06-01 13:17:24 Views: 246
• 

  LocalContainerEntityManagerFactoryBean spring

  Org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jpaMappingCo

  2022-06-01 13:17:24 Views: 299
• 

  Basic operation of database 2

  Mysql-day03 I, mysql storage engine 1.1.Storage engine introduction: it is the function program of mysql database software. The function and data storage mode of each storage engine are also different. The storage engine handles the table processor 1.2 to view the storage supported by database service.

  2022-06-01 13:17:23 Views: 276
• 

  Install Linux CentOS 6.5 on USB disk and encounter trouble 64-bit operating system and disable ipv6, CentOS7 uninstall OpenJDK and install Oracle JDK

  Methods 1:windows platform: 1. Use UltraISO to open iso (e.g. CentOS-6.5-x86_64-bin-DVD1.iso) 2. Then click "start"-> "write hard disk image". The hard drive is your U disk, and the image file is installed.

  2022-06-01 13:16:53 Views: 233
• 

  Suddenly I can't connect to phxsql.

  The business said that in recent days, the phxsql could not be connected for some time in the evening, but after a while it was fine and could be connected again. I think since it can be connected, it should not be the problem of the authorization form mysql.user. If there is a problem with the authorization, it will always be unable to connect, and usually no one will go.

  2022-06-01 13:16:53 Views: 241
• 

  Patch 21 Oracle11.2.0.4 windows32+64bit path 11.2.0.4.160419 p22064588 p22839608

  Latest patch on June 3, 2016-Oracle11.2.0.4 for windows32+64bit,p22064588 patch21.2.0.4.21,p22839608 11.2.0.4.16041

  2022-06-01 13:16:53 Views: 249
• 

  Solving the problem of too many connections in MySQL

  Today, my MySQL encountered a not-so-strange mistake, "Too many connections". When I usually encounter this problem, I basically modify the max_connections parameter of / etc/my.cnf and then restart the database. But

  2022-06-01 13:16:52 Views: 271
• 

  Talking about the objects of Oracle Database

  Oracle database-the most basic objects are tables and views, as well as constraints, indexes, sequences, functions, stored procedures, and even creating synonyms. The operation on the database can basically be summed up as the operation on the data object. Therefore, on the basis of the basic operation described in the previous blog post, this article

  2022-06-01 13:16:22 Views: 250
• 

  Install zabbix3.0 in centos7 LAMP environment

  Zabbix3.0 required PHP, database, Apache/Nginx version reference: zabbix3.0 requirements for PHP, database, nginx/apache version reference: https://www.zabbix.com/do

  2022-06-01 13:16:22 Views: 298
• 

  Analytical function of oracle function

  1. The analysis function has four over row_number dense_rank rank and four cannot use 2.select empno, sal, deptno,sum (sal) over (order b) alone.

  2022-06-01 13:16:16 Views: 298
• 

  Oracle 11g configuration DG

  One: modify the main library parameter file: * .DB _ UNIQUE_NAME=PHUB*.LOG_ARCHIVE_CONFIG='DG_CONFIG= (MECBS,PHUB)'* .LOG _ ARCHIVE_DEST_2='S

  2022-06-01 13:16:15 Views: 291
• 

  The difference between Oracle rman backup retention Policy Redundancy and recovery window

  RMAN > CONFIGURE RETENTION POLICY TO REDUNDANCY 7th rman > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW

  2022-06-01 13:16:11 Views: 240
• 

  Basic Operation of Mysql based on linux operating system (1)

  Basic operation of Mysql based on linux operating system (1) background introduction: establishment of mysql soft connection, ln-s / usr/local/mysql/bin/mysql / usr/bin1. Log in locally, command: # mysql-

  2022-06-01 13:16:11 Views: 203
• 

  Sqlite3 common commands and how django operates sqlite3 database

  First, how to enter sqlite3 interactive mode for command operation? 1. Confirm whether sqlite3 has been installed on the python command line, and execute > import sqlite3 > No error is reported, indicating that sqlite3 has been successfully installed. 2.

  2022-06-01 13:16:10 Views: 302
• 

  How does the database view the utilization of tablespaces

  Enter the following code into the oracle database to select total.tablespace_name,round (total.MB, 2) as Total_MB,round (total.MB-fr)

  2022-06-01 13:16:02 Views: 257
• 

  Real-time migration of Redis heterogeneous cluster data

  Background due to historical reasons, the company's cache scheme uses Codis, and most of them share a cluster. We plan to abandon Codis and use Redis's native cluster architecture. Why should we abandon Codis? there are two main reasons: 1. Codis has been official for a long time.

  2022-06-01 13:16:02 Views: 282
• 

  CentOS7 silently installs the database oralce11gR2

  System version operating system: CentOS Linux release 7.3.1611 (Core) II. Oracle software version oracle version: linux.x64_11gR2linux.x64_11gR2_

  2022-06-01 13:16:01 Views: 245
• 

  Common functions of calculating time difference in Oracle

  Oracle calculates the time difference commonly used in two Date type fields: START_DATE,END_DATE, to calculate the time difference between the two dates (in days, hours, minutes, seconds, milliseconds, respectively): day: ROUND (TO_NUMBER (END_DAT)

  2022-06-01 13:16:01 Views: 285
• 

  Get the implementation plan method II-explain plan

  1 install the $ORACLE_HOME/rdbms/admin/utlxplan.sql (UNIX) script to generate a table. This program creates a table called plan_table and runs explain PLAN [SE]

  2022-06-01 13:15:46 Views: 225