NAV: SLTechnology News&Howtos > Database >

• 

  Problems in Oracle operation

  Linux system Oracle11.2.0.3 version question: when sqlplus / as sysdba executes starup, an error is reported: answer: check whether this parameter is set in sqlnet.ora, SQLNET.AUTHENTIC

  2022-06-01 21:25:49 Views: 222
• 

  Comparison of MongoDB aggregation commands

  MongoDB aggregation commands compare the following table to provide a brief overview of the properties of the MongoDB aggregation command. The aggregatemapReducegroup description has been added in version 2.2. Designed to provide the performance and availability of aggregation tasks. Use the pipe path

  2022-06-01 21:25:49 Views: 232
• 

  Improvement and optimization of SQL

  A basic single table query 1. 1 query table structure desc table name SQL > desc empName Null? TypeEMPNO NOT NULL NUMBER (4) ENAME VARCHAR2 (10) JOB VARC

  2022-06-01 21:25:46 Views: 297
• 

  The usage of Oracle Random function

  To put it simply, most random numbers taken by Oracle are generated by calling dbms_random package. There are four ways to generate random numbers through dbms_random package: 1. Dbms_random.normal function takes no arguments and is used for

  2022-06-01 21:25:46 Views: 213
• 

  Mysqlzhimmm cluster

  Role ipHostnameid write read Master1192.168.1.128Master11192.168.1.100Master2 (backup) 192.168.1.131Master22192.168

  2022-06-01 21:25:46 Views: 218
• 

  Linux and CentOS package management

  (here take httpd-2.2.15-56.el6.centos.3.x86_64.rpm as an example) install: # rpm-ivh httpd-2.2.15-56.el6.centos.3.x86_64.rpm Select

  2022-06-01 21:25:45 Views: 240
• 

  Some pits encountered by elasticsearch according to configuration [Failed to load settings from [elasticsearch.yml]]

  I basically haven't changed the configuration file before, but I've changed it again in recent days. I've changed some configuration files and dealt with a lot of nonsense errors; here are some problems caused by spaces. The version is elasticsearch-2.3.0 or elasticsearch-r

  2022-06-01 21:25:33 Views: 264
• 

  LAMP building

  LAMP building instructions: simulate building LAMP on a linux host introduction: LAMP consists of four parts: Linux,Apache,MySQL,PHP. This set of architecture is built to realize the deployment of dynamic web page environment. This article will be on a centos

  2022-06-01 21:25:18 Views: 263
• 

  Hbase hive integration

  Due to the needs of the project, hbase is used to store data. Use hive to query the data. So here we need to integrate hbase and hive. Found the next information on the Internet, in fact, it is also quite simple, mainly in the configuration. Let me make a record of the steps of integration. 1. Environment: h

  2022-06-01 21:25:18 Views: 260
• 

  MySQL+MMM High availability Cluster deployment (1)

  First, the functional features of MMM MMM is the abbreviation of (Master-Master replication manager for MySQL), it is a set of script programs that support dual-master failover and dual-master daily management, while MMM uses Perl

  2022-06-01 21:25:06 Views: 225
• 

  Oracle installation stand-alone manual practice version

  Oracle 11g full installation manual Note: some computers may need to turn on cpu's support for virtualization, please set it up in bios. 1. Install the virtual machine software to extract the VMware10.rar and install the software. Specific steps (brief). 2, create a virtual machine

  2022-06-01 21:25:06 Views: 275
• 

  SQL Server Alwayson build five: Alwayson configuration

  Enable Alwayson in Sql Server Configuration Manager on SQL01 and SQL02 servers right-click SQL Server Service Select Properties in AlwaysOn Hi

  2022-06-01 21:24:36 Views: 260
• 

  The use of wildcards% and _ for Oralce rookie learning

  Initial: use of http://www.arppinging.com/wordpress/?p=104Oralce rookie wildcards% and _ 1,% in Oracle,% means match all, use likeS before using wildcards

  2022-06-01 21:24:35 Views: 250
• 

  Mongodb shard cannot horizontally expand write capabilities?!

  Some time ago, online dba was ready to go to Mongodb sharding. In order to test whether it could expand its writing ability, I wrote various scripts (multi-thread writing a mongos, multi-thread writing multiple mongos) to test and found that it had been written on a shard all the time.

  2022-06-01 21:24:35 Views: 206
• 

  The mysql-5.7.21 version keeps reporting an error ERROR 1067 (42000)!

  Many tutorials on the Internet are wrong, what configuration file should be changed? It's all wrong! Only this is the right way to share with you. If you find it useful, please like one and report an error in the picture above: second, modify the database configuration, restart the database, and restart to enter the database. Fourth, reinsert the data and see that it has been successfully inserted.

  2022-06-01 21:24:26 Views: 203
• 

  Mongodb indexes multiple columns through @ Indexes

  @ Indexes index annotations can be marked on a class so that a multi-column index @ Entity@Indexes (@ Index ("user,-date")) public class ChangeLog {Date d can be created.

  2022-06-01 21:24:26 Views: 275
• 

  Subscription exception broker message code 20598, personal summary

  Recently, a strange problem has been found in the subscription. The exception is: "subscription exception broker message code 20598. The row was not found at the subscriber when the replicated command was applied." There are all kinds of answers to this mistake on the Internet. Personally, I think that messing around will not solve the substantive question in the end.

  2022-06-01 21:24:25 Views: 254
• 

  Research on Oracle Tree query (start with connect by prior)

  The most important syntax structure of an oracle tree query is: select. Start with... Connect by... Prior, which allows you to display the relationships in the table as a tree. 1. Create test table and data:-- create test table CREA

  2022-06-01 21:24:25 Views: 243
• 

  One of the basic commands of SQL learning

  1. SQL syntax 1, database tables A database usually contains one or more tables. Each table is identified by a name and the table contains rows with data. 2. Case SQL is not sensitive to case. 3. Semicolon after SQL statement some databases require the use of a semicolon at the end of each SQL command

  2022-06-01 21:24:22 Views: 302
• 

  ORA-00845: MEMORY_TARGET not supported on this system

  Remember that ORACLE failed to start ORA-00845: MEMORY_TARGET not supported on this system uses the oracle user and starts [oracle@localhos] as usual

  2022-06-01 21:24:20 Views: 237