NAV: SLTechnology News&Howtos > Database >

• 

  Install and deploy LAMP environment under CentOS7

  (1) configuration summary: 1. 172.16.100.31 host runs httpd+php service (php is module working mode) to configure two virtual hosts: wordpress personal blog system, PHPmyadmin remote control mysql2, 172

  2022-06-01 16:19:16 Views: 246
• 

  How to start and shut down OEM in Oracle10g

  On the server side, you can start the EM tools console with the following command: first switch to the oracle user to execute: [root@oracledb ~] # su-oracle [oracle@oracledb ~] $emctl s

  2022-06-01 16:19:15 Views: 216
• 

  Oracle 12C RAC data migration

  Source side: 12C RAC primay backup file destination side: 12C single instance part summary: 1 pfile modification 2 disable redo thread N3 drop logfile group N4

  2022-06-01 16:19:15 Views: 268
• 

  Parameters to be adjusted for oracle 11g and 12c initial installation database

  First, the parameters that need to be adjusted for the initial installation of the 11g version of the database: the parameter setting standard is at risk by default. The maximum number of files allowed in the db_files1000200 database is 200. the initial value is 200. if the number is too small, the data file processes1500 data cannot be added.

  2022-06-01 16:19:15 Views: 204
• 

  MySQL multi-instance configuration file and startup file

  -mysql multi-instance configuration file [root@db01/] # cat / data/3307/ my.cnf [client] port = 3307 # < = port number, you can modify socket = /

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

  Oracle function-one-line function-number, date, date processing function

  Function classification one-line function: one input corresponds to one output,input and there is an one-to-one correspondence between output and lower group function: multiple input, but only one output. For example, sum () =

  2022-06-01 16:19:12 Views: 214
• 

  Statistics of tables in mongodb batch query Library

  In mongodb, it is generally used to view the statistical information of a table: db.t.stats () the main information is: "ns": "gqtest.t", "count": 40001, # rows "size": 21

  2022-06-01 16:19:11 Views: 260
• 

  DotConnect for Oracle getting started Guide (5): retrieving and modifying data

  [download the latest version of dotConnect for Oracle] dotConnect for Oracle (formerly known as OraDirect.NET) is based on ADO.NET technology and provides services for applications based on Oracle databases

  2022-06-01 16:19:11 Views: 253
• 

  Frequently asked questions about Linux installation of oracle11g

  Problem: emctl start dbconsole cannot start 1, Lsnrctl listener starts normally 2, emca-config dbcontrol db-repos recreate rebuilds the database as reported below

  2022-06-01 16:19:06 Views: 266
• 

  Summary of HBase-1.0.1 study notes

  Lu Chunli's work notes, who said that programmers should not have literary style? HBase-1.0.1 Learning Notes (1) Building http://luchunli.blog.51cto.com/2368057/1682049HBase-1.0.1 in Cluster

  2022-06-01 16:19:05 Views: 236
• 

  Enable / disable guest users of SQL database

  -- enable guest user "grant connection" USE [Fly2017] GOgrant connect to guest;-- disable guest user "deny connection" USE [Fly2017] GOdeny connec

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

  SQL Server logged-in users can only see libraries with their own permissions

  Http://www.cnblogs.com/huangtailang/p/4209180.htmlGRANT VIEW ANY DATABASE TO Public

  2022-06-01 16:19:05 Views: 250
• 

  Database security check monitoring is the key. Set the listening password.

  The security management of Oracle database snooping is easy to ignore. Do a test to disable the local authentication function of snooping, set the snooping password, database version 11.2.0.41, default configuration listener.oraLISTENER = (DES)

  2022-06-01 16:19:04 Views: 233
• 

  Oracle11G_l temporary tablespace

  Temporary tablespace: temporary data used to store users, which can be overwritten when needed, and temporary data hours after database relationships; use: sorting operations for large amounts of data

  2022-06-01 16:19:04 Views: 294
• 

  On the Life cycle of GTID-GTID

  1. A GTID will be obtained when the transaction commits, and the GTID will be recorded in the binary log in front of the transaction. If the transaction is not logged in the binary log, it will not get the GTID. two。 The GTID of the transaction will be recorded as Gtid_log_event

  2022-06-01 16:19:04 Views: 299
• 

  INS-20802 PRVF-9802 PRVF-5184 PRVF-5186 After Successful Upgradeto 11gR2 Grid Infrastructure

  INS-20802 PRVF-9802 PRVF-5184 PRVF-5186 After Successful Upgradeto 11gR2 Grid Infrastructure (document ID

  2022-06-01 16:19:03 Views: 288
• 

  Record summary, comparison of several data types of time field in MySQL

  In the preface, I always thought that I would use int to store it all the time. Recently, I saw datetime type frequently during project development, which caused some debate about which type of time field in MySQL database should be chosen. So I did some simple research and read some

  2022-06-01 16:19:03 Views: 284
• 

  How to use Redis in .NET

  How to use Redis in .NET? I believe that many novice rookies have not yet learned this skill. Through the summary of this article, I hope you can learn this skill. The following materials are the steps for implementation. Redis is a widely used memory database of Key/Value, Sina Weibo.

  2022-06-01 16:18:38 Views: 279
• 

  The use of sql group by

  Group by is generally used with aggregate functions such as count,sum,avg after select, such as: select * from test where (conditional) group by (conditional) if in the return set field

  2022-06-01 16:18:18 Views: 241
• 

  RHEL 6.5 install oracle11gR2

  RHEL6.5 install oracle11gR21, prepare OS installation before installation, install RHEL6.5 by default, close iptables, close selinux, modify local hosts file ~] # service iptables

  2022-06-01 16:18:18 Views: 230