NAV: SLTechnology News&Howtos > Database >

• 

  Linux study notes April 9 task

  11.1 introduction to LAMP architecture 11.2 MySQL, introduction to MariaDB 11.3 user=mysql 11.5 MySQL installation. / scripts/mysql_install_db-- user=mysql-- dat

  2022-06-01 16:05:23 Views: 242
• 

  HADOOP/HBASE/SPARK modifies PID file location

  When the PID file location of HADOOP/HBASE/SPARK is not modified, the PID file will be generated to the / tmp directory by default, but the / tmp directory will be deleted after a period of time, so later when we stop HADOOP/HBASE/SPARK

  2022-06-01 16:05:23 Views: 221
• 

  ORACLE JET Basic Table Scrolling

  Example of Basic Table: Basic Table

  2022-06-01 16:05:17 Views: 263
• 

  Using DBLink to realize remote data Export by data pump

  Using DBLink to realize the remote data export of data pump and the simple realization of using data pump to export the data in database An on database B server. The premise is that the versions of the two data are the same. 1. The user SQL > create us used to create the export on database B (as administrator)

  2022-06-01 16:05:16 Views: 232
• 

  Oracle Command History tool (rlwrap)

  Download address: https://github.com/hanslub42/rlwrap/releases1. Install dependency package [root@node3 ~] # yum install readline-devel*

  2022-06-01 16:05:12 Views: 247
• 

  Zabbix practice: deployment-& gt; Monitoring-- & gt; alarm

  There is an important saying in operation and maintenance: unmonitored services are not allowed to go online. Zabbix is a third-party open source software that provides distributed system monitoring and network monitoring based on web interface. It is mainly composed of two parts: zabbix-server and zabbix-agent.

  2022-06-01 16:05:12 Views: 243
• 

  MongoDB replica set election principle management

  MongoDB replication sets Overview replication sets are additional data replicas, the process of synchronizing data across multiple servers, replication sets provide redundancy and add data availability, and the advantages of restoring replication sets to services interrupted by hardware failures through a replication set are as follows: make the data more secure. High data available

  2022-06-01 16:04:51 Views: 262
• 

  Backup-based duplicate (RAC-RAC)

  Environment production RAC (target): ORACLE_SID=prodb Test RAC (auxiliary) ORACLE_SID=testdboracle version: 11.2.0.1.01, RAC node1 in production environment

  2022-06-01 16:04:40 Views: 235
• 

  Using Powershell to realize automatic Operation and maintenance of Database

  Using Powershell to realize database automation operation and maintenance there are only a few good original books and many translated books in the market for SQLServer, but they are limited to the development, management and business intelligence of SQLServer database itself. But for P

  2022-06-01 16:04:40 Views: 236
• 

  Oracle12.2 ORA-03113

  1. Database startup error SQL > startupORACLE instance started.Total System Global Area 2030043136 bytesFixed Size 879

  2022-06-01 16:04:18 Views: 215
• 

  Oracle time conversion, comparison

  Sometimes the sysdate of oracle is compared with the time field in the database, so you need to use to_char and to_date,select h.resourceid, to_char (to_date (h.close_t)

  2022-06-01 16:04:18 Views: 295
• 

  How to install Redis in CentOS

  Preface redis is a key-value storage system. Similar to Memcached, it supports relatively more value types for storage, including string (string), list (linked list), set (collection), and zset (sorted se)

  2022-06-01 16:04:18 Views: 236
• 

  The difference between Latch and Lock

  Latch is a lightweight lock resource provided by Oracle. It is used to lock resources quickly and for a short time to prevent multiple concurrent processes from modifying and accessing a shared resource at the same time. He only works in memory. We can not say exactly that the lock of resources in memory is called latch, database object (table).

  2022-06-01 16:04:17 Views: 291
• 

  Change the DB2 port number under Linux

  When testing with sqoop, I found that the port number 50000 was occupied, so I changed the port number of DB2. The first step is to log in to the instance user of DB2 database. Here is db2inst1db2 get dbm cfg | grep SVCENAME

  2022-06-01 16:04:05 Views: 239
• 

  Rman backup, crontab scheduled task did not generate backup files

  Using the combination of crontab execution plan and RMAN to realize the automatic backup of the database: using the scheduled task to perform the backup, only the directory is generated, but no backup file is generated 1: manually execute the backup script, no problem 2:crontab scheduling task, can generate

  2022-06-01 16:04:05 Views: 264
• 

  Redis error "max number of clients reached""

  When you check redis monitoring, you can see that the graph of redis is abnormal. The screenshot is as follows: as shown in the screenshot above, you can see that the number of client connections in redis rises abruptly to 10K and then drops to 0. The reason for the surveillance itself is excluded, and it is very clear.

  2022-06-01 16:03:59 Views: 268
• 

  Centos 7 deployment oracle 12c rac is served

  Oracle 12c has been released for a long time. Although several sets of single instance oracle 12c have been deployed recently, there has been no opportunity to implement 12c rac in the production environment. Of course, it is impossible to replace the existing 11g rac with 12c rac.

  2022-06-01 16:03:29 Views: 290
• 

  Oracle GoldenGate 12.2.0.1 installation,

  View Inventory File3, OGG upgrade stop old version related process ps-ef to view and install new version [oracle@ggtest1 tmp] $cd fbo_ggs_Linux_x64_shiphome/

  2022-06-01 16:03:29 Views: 259
• 

  Mongodb shell script

  1. Set replica set #! / bin/bash#mongodb to enter client and use admincd / usr/mongodb/binMongoDB='./mongo 192.168.1.7purl 37017'

  2022-06-01 16:03:14 Views: 267
• 

  Check out the summary of MySQL database version methods!

  When you take over a mysql database management, you first need to check the maintained version of the mysql database, or when the developer asks you about the version of the mysql database, and you happen to forget it, then you also need to check the version of the mysql database. These are myself.

  2022-06-01 16:03:14 Views: 210