NAV: SLTechnology News&Howtos > Database >

• 

  Oracle DG-- Building Physical Standby

  Oracle DG-- build Physical Standby system environment: operating system: RedHat EL4Oracle: Oracle 10.2.0.1.0 as shown in the above figure: the main library is bj (db_unique_

  2022-06-01 12:12:22 Views: 218
• 

  8 of mysql series-separation of read and write

  Preface: the basic principle of read-write separation of mysql is: let master (master database) respond to transactional operations, let slave (slave database) respond to select non-transactional operations, and then use master-slave replication to transfer the

  2022-06-01 12:12:22 Views: 249
• 

  How to use mysqldump/xtrabackup backup

  Mariadb backup this article mainly explains in detail how Mariadb uses mysqldump and Xtrabackup to back up mysql database mysqldump to achieve the following functions: 1. Restore hellod after adding or deleting hellodb database

  2022-06-01 12:12:22 Views: 230
• 

  Easy implementation of SQL Server Database capacity Monitoring with PowerShell:30 Line Code

  This article introduces how to use PowerShell script to achieve SQL Server database capacity monitoring gossip, go straight to topic one, build a table for each server to record the capacity of each database of the server, with the server name as the table name. CREATE TA

  2022-06-01 12:12:19 Views: 263
• 

  Centos7 installs Mongodb's C++ driver

  According to the official website (https://github.com/mongodb/mongo-cxx-driver/wiki/Quickstart-Guide-(New-Driver))), C++ driver

  2022-06-01 12:11:48 Views: 275
• 

  Oracle dg library switchover master / slave switch

  Switchover switching: switching between master database and standby database under normal conditions, mainly used for master / slave maintenance, switching drills, etc.; failover switching: forced switching between master and standby database when the data is not synchronized, mainly used for switching in case of downtime or failure of the main database; 1. Swit

  2022-06-01 12:11:48 Views: 210
• 

  MySQL time function

  A. timestampdiff () passes three parameters, the first time type such as year, month, day, the second start time, the third end time select test_name, timestampdiff (YEAR,create_ti)

  2022-06-01 12:11:48 Views: 274
• 

  User authorization control, database remote maintenance, comprehensive application cases

  Case 1: authorized database user case 2: view and revoke authorization case 3: reset database management password case 4: remote maintenance database case 5: enterprise OA system deployment case 6: enterprise OA system migration case 1: authorized database user 1.1 this example requires mastery of Maria

  2022-06-01 12:11:48 Views: 205
• 

  Resolve oracle user expiration problem

  Recently, the staff of the testing department found a problem, saying that the password prompt for oracle users is about to expire. Ask me what's going on. After investigation found that the creation of oracle user passwords are only valid for 180 days, communicate with the relevant responsible person, decided to change the user password will never expire. Solution: the first method:

  2022-06-01 12:11:47 Views: 303
• 

  Detailed steps for Oracle11g installation

  For detailed steps of Oracle11g installation, please see attachment ↓↓ attachment: http://down.51cto.com/data/2366007

  2022-06-01 12:11:47 Views: 275
• 

  Unable to read C:/Program Files/Oracle/Inventory/ContentsXML/comps.xml

  Unable to read C:/Program Files/Oracle/Inventory/ContentsXML/comps.xml Today a colleague asked me a question. I couldn't install oracle all the time. Check the installation date.

  2022-06-01 12:11:47 Views: 207
• 

  Explanation and practice of MySQL query sentence select

  Select statement execution process: START- > 1.From-> 2.WHERE (select, appropriate row)-> 3.GROUP BY (grouping)-> 4.HAVING (filtering the grouping)

  2022-06-01 12:11:47 Views: 287
• 

  CentOS 7 install MariaDB 10.3 configure yum source

  This is the custom MariaDB YUM repository entry for CentOS. Copy it and paste it into the file under / etc/yum.repos.d/ (our suggested file is named MariaDB.repo or something like that). # MariaDB 1

  2022-06-01 12:11:47 Views: 253
• 

  Garela cluster

  If you need to turn off the firewall completely and selinux time must be synchronized, you can prepare time server # vim / etc/ntp.confserver 127.127.1.0fudge 127.127.1.0 stratum 10#sy

  2022-06-01 12:11:46 Views: 216
• 

  Django configure mysql database

  View all software installed by ubuntu: dpkg-l dpkg-l | grep mysql to view the installation path of the software dpkg-L | grep mysql to view the software started on boot, additional plug-ins are required: sudo a

  2022-06-01 12:11:46 Views: 287
• 

  Strong release of RDIFramework.NET ━ .NET Rapid Informatization system Development Framework Juxian V3.0

  Following the launch of the last version "RDIFramework.NET V2.9", it has been recognized and selected by many customers. V2.9 is a very successful and stable version. Thank you for your recognition and long-term attention and support. The base of V3.0 on V2.9

  2022-06-01 12:11:16 Views: 223
• 

  How to install PLSQL DEVELOPER 11 and Oracle 11g x64 Client in 64-bit Windows 7

  PLSQL Developer 11.06Chinese Green Registration Edition (Oracle11g-free client) download link: http://pan.baidu.com/s/1qYapNNe password: the context of the momh problem is on Win

  2022-06-01 12:11:12 Views: 279
• 

  PLS-00920: parameter plsql_native_library_dir is not set

  Today, when compiling a database object, plsql reported an error: PLS-00920: parameter plsql_native_library_dir is not set. Later, it was found that it was the plsql compilation mode and setting problem, to solve the problem.

  2022-06-01 12:11:07 Views: 254
• 

  Build LAMP by Centos7.2

  1. Close firewall: (for specific documents, please contact this blogger, there is a blogger's mailbox on the home page) 2. Install iptables firewall vi / etc/sysconfig/iptables # and edit firewall configuration file 3. Restart service 4. Close SELI

  2022-06-01 12:11:06 Views: 257
• 

  Install Apache Thrift Gateway to CentOS 2

  1. Generate thrift module thrift-- gen py / src/main/resources/org/apache/hadoop/hbase/thrift/Hbase.thrift for python

  2022-06-01 12:11:06 Views: 222