NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 12C OEM installation

  IP database OEM operating system database version 192.168.3.3 stand-alone service (12.1.0.5) Linux6.911.2.0.4 Note: OEM management RAC database needs to add hosts first, cluster highly available services (can also be added directly

  2022-06-01 16:12:56 Views: 251
• 

  Build master-slave replication based on gtid MySQL 5.7via mysqldump

  Install Master / Slave MySQL5.7 # Master MySQL5.7useradd mysql / sbin/nologincd / usr/localtar-xvf mysql-5.7.23-linux-glibc2

  2022-06-01 16:12:46 Views: 231
• 

  [MongoDB Learning Notes 9] in-depth MongoDB update (update) operation: modifier $inc

  OngoDB documents are updated by the update method after they are stored in the database. The update method has two parameters. For example, update (args1,args2) args1 refers to the condition of querying the document, and args2 refers to what kind of modification is made to the queried document.

  2022-06-01 16:12:46 Views: 277
• 

  [SQL] Export all Oracle table structures, everything except data

  Tools: PLSQL step: log in to plsql, open table, then click tools-> Export user object, select the exported content to specify the export location, and then ok

  2022-06-01 16:12:46 Views: 217
• 

  SQLServer database

  FAQs during installation 1) Server configuration-account configuration-invalid credentials provided https://jingyan.baidu.com/article/8cdccae9452b3c315513cd52.html2) sa login http

  2022-06-01 16:12:16 Views: 202
• 

  PHP connects to MSSQL database case. Multiple PHP versions of PHPWAMP connect to SQL Server database.

  Popularization of pre-class knowledge: MSSQL and SQL Server are the same software, but they are called differently. The full name of MSSQL is Microsoft SQL Server,MSSQL, which is abbreviated. Some people like to call it SQL Server directly. I will compare it.

  2022-06-01 16:12:16 Views: 278
• 

  Installation and Application of MySQL platform

  Mysql database installation application 1:MySQL is a multi-user, multi-threaded service. Advantages: high performance, high reliability, easy to use by default using TCP port 3306 matching file for / etc/my.cnf2:MySQL compilation and installation process: using rpm

  2022-06-01 16:12:02 Views: 222
• 

  PL/SQL Developer accesses remote database (native does not include oracle client)

  First, download the PL/SQL DeveloperPL/SQL Developer download page, you can choose to download 32-bit or 64-bit; if you need a Chinese interface, you can also download the language pack. Second, download Instant Client, which contains access data

  2022-06-01 16:12:01 Views: 278
• 

  Database management

  {* database *} 1. Installation: yum install mariadb-server.x86_64-y installation service systemctl start mariadb enable service systemctl stop fir

  2022-06-01 16:11:50 Views: 297
• 

  Lower the high water mark

  1. Establish initialization data to demonstrate the change of high water level in the data table (1), establish users and tables SYS@odb > create user test8 identified by test8;SYS@odb > grant connect

  2022-06-01 16:11:46 Views: 228
• 

  Oracle Study-- Oracle wait event (5)

  Oracle Study-- Oracle wait event (5) Db file single write this wait event usually occurs in only one case, that is, when Oracle updates the header information of the data file (such as when Checkpoint occurs

  2022-06-01 16:11:46 Views: 283
• 

  Plsql Chinese garbled code

  First, query the oracle server-side code through select userenv ('language') from dual;SIMPLIFIED CHINESE_CHINA.WE8MSWIN1252, such as:

  2022-06-01 16:11:46 Views: 222
• 

  Description of MongoDB backup and restore command

  1. Full library backup and restore # mongodump-d my_mongodb-o my_mongodb_dump#mongorestore-d my_mongodb my_mongodb_dump/* II, JS

  2022-06-01 16:11:46 Views: 299
• 

  PostgreSQL PostGIS geospatial plug-in

  1) Source code compilation PostGIS has many installation packages. If you try to compile separately, you can download the source code and then compile http://www.postgis.net/source/2) the following components are available for matching: postgresql-11.5-1-wi

  2022-06-01 16:11:45 Views: 256
• 

  The problem of ORACLE 11G RAC rebuilding EM

  Some time ago, there was a problem, that is, when rebooting a RAC node, I suddenly reported the problem of insufficient size of the recovery area. I checked that there should be no problem, it should have been modified to 500G, and there should be more than 200g of remaining space. How to disappear at once, and delete a lot of files inside, and use R

  2022-06-01 16:11:37 Views: 247
• 

  Deployment of Redis cluster sharding environment

  Principle cluster technology is the main technology for building highly concurrent websites. The greatest pressure to visit a website is to query the database when you need to visit a page and correspond to it. Redis has supported the cluster function since version 3.0.There must be at least three master nodes for the cluster to work properly. The Redis cluster is

  2022-06-01 16:11:37 Views: 261
• 

  Weblogic 12c silent installation

  Silent installation means that you do not need vnc to connect to the image interface. Follow these steps to successfully prepare the jdk environment vim / etc/profile to add export JAVA_HOME=/usr/java/jdkexport.

  2022-06-01 16:11:37 Views: 241
• 

  About mongodb rollover MySQL

  In the near future, it is necessary to transfer some data from Mongodb to MySQL. Previously, there were only packets from BSON. The original idea, directly using PHP's extended bson_decode, found that there are two thorny problems, one is the memory footprint, if a bson super

  2022-06-01 16:11:33 Views: 207
• 

  MySQL High availability Architecture: mysql+keepalived implementation

  System environment and architecture # hostname system version mysql version ip address mysqlMaster centos7.4 mysql5.7

  2022-06-01 16:11:33 Views: 246
• 

  The script detects a specific word in the file and makes the next action, down restart.

  # by flayber newly installed zabbix often hangs up automatically after 1: 00 p. M. and reports to Zabbix database is down. You need service mysqld restart to do it. We haven't found out exactly what caused it.

  2022-06-01 16:11:33 Views: 288