NAV: SLTechnology News&Howtos > Database >

• 

  Grid Infrastructure Single Client Access Name (SCAN) Explained (document ID 887522.1)

  Grid Infrastructure Single Client Access Name (SCAN) Explained (document ID 887522.1) APPLIES TO:Oracle Dat

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

  ORACLE RAC installation-performance and high availability testing

  Since 11G, the installation of RAC has become a physical task, but after the installation of RAC, how to ensure the stable operation of the system and how to get the performance of the system has a great impact on the stable operation of the online system in the later stage. The following is a summary of some experience in the implementation of the project in the past year or so. #

  2022-06-01 12:16:18 Views: 268
• 

  Partition table of MySql

  MySql partition sub-table sub-table concept sub-table: a large table is divided into several physical tables with independent storage space according to certain rules, each table corresponds to three files, MYD data file, .MYI index file, .frm table structure file. These tables can be distributed on the same disk

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

  MySQL+Amoeba+MySQLMMM High availability Cluster

  1. MySQL-MMM (Master-Master MySQL) MMM Overview dual master failover and daily management script consisting of multiple mysql master servers and multiple mysql slave servers. Although it is called dual master replication, it is only allowed in business at a time.

  2022-06-01 12:16:10 Views: 255
• 

  Centos6.6 installation AliSQL personal testing

  AliSQL is a branch of Alibaba based on the official version of MySQL, which is used in Alibaba Group business and Ali Cloud database service. It is currently maintained by Ali Cloud Database team. The AliSQL version has undergone a great test in terms of strength and breadth. The latest AliS

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

  Oracle installation executes. / runInstaller prompt SEVERE: [FATAL] web01: web01

  As soon as the installation of oracle 11g$./runInstaller on RHEL 6.4starts, an error of SEVERE: [FATAL] web01: web01 is reported. Click OK and exit the installation. [@ more@] error

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

  Difference between call and exec for executing stored procedures in Oracle

  Both methods can be used in sqlplus: exec pro_name (parameter 1.); call pro_name (parameter 1.); difference: 1. But exec is a sqlplus command and can only be used in sqlplus; c

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

  Introduction to common functions of MySQL

  MySQL database provides a wealth of functions, such as our commonly used aggregate functions, date and string processing functions and so on. These functions can be used by SELECT statements and their conditional expressions, which can help users deal with the data in the table more easily and make MySQL data more convenient.

  2022-06-01 12:16:00 Views: 226
• 

  Oracle dbms_random

  Oracle dbms_random introduces several commonly used functions to generate 0-1 decimal (default) SQL > select dbms_random.valuefrom dual;VALUE-.932351

  2022-06-01 12:15:54 Views: 283
• 

  Ten methods of speeding up ASP.NET MVC Application

  [editor's note] the author is the most valuable blogger (MVB) Jonathan Danylko in the DZone community, and mainly introduces ten ways to speed up ASP.NET MVC applications. Compiled by domestic ITOM management platform OneAPM

  2022-06-01 12:15:54 Views: 235
• 

  Install oracle 11g using the VNC remote Desktop Centos 7 system

  It's the first time to use Centos 7 Oracle 11g. VNC has used it before but the configuration is not very successful. I came here today and had a good time. The first step is to configure Centos 71.1.Centos 7 to download DVD ISO image directly on the official website.

  2022-06-01 12:15:54 Views: 270
• 

  Use the percona monitoring plug-in to monitor MySQL in zabbix

  Download and install the percona source. You can use wget-N-- no-check-certificate rpm-ivh percona-rele later with percona toolkit or innobackup.

  2022-06-01 12:15:52 Views: 253
• 

  Deployment of Oracle RAC in VMware vsphere platform (II, NTP configuration and SSH trust)

  NTP configuration two nodes check whether to install ntprpm-Q ntp/// install yum-y install ntp if not install / systemctl enable ntpd systemctl enab

  2022-06-01 12:15:44 Views: 261
• 

  The problem of database collation

  The collation of the database is good enough to be installed by default. For example, in simplified Chinese environment, when installing SQL Server, the default is Chinese_PRC_CI_AS, while in English environment, it is SQL_Latin1_General_CP1.

  2022-06-01 12:15:39 Views: 257
• 

  Effective rules of multi-column index

  Myisam,innodb in mysql uses Btree index by default. As for the data structure of btree, it doesn't matter. You just need to know the result. Since it is an index, the data structure is sorted at last. Just like Xinhua Dictionary, its directory is based on afort b.

  2022-06-01 12:15:37 Views: 274
• 

  MySQL error writing file error

  Some time ago, when archiving and collating historical data in MySQL, I found that a lot of SQL could not be executed. At first, I thought there was something wrong with the SQL statement I wrote. When I took out all the SQL that was being executed, I found that the syntax was not wrong, but when I executed the INSERT statement, I made a mistake: put IN

  2022-06-01 12:15:35 Views: 237
• 

  When pl/sql connects to the oracle database under win10, it can only be connected by running as an administrator.

  This reason is inexplicable. I have completely controlled the permissions of tnsname.ora files. I don't know if there are any other files that need to change permissions!

  2022-06-01 12:15:33 Views: 297
• 

  View the configuration and running status of HARD

  Check the configuration and running status of HARD HADR connection status: when the HADR of the standby database starts, it first enters the local synchronous update state. The log files in the local system are retrieved and replayed according to the configuration parameters of the local log path and the settings of the log archiving method. When the local log file is replayed

  2022-06-01 12:15:33 Views: 228
• 

  Oracle RAC modifies private IB Nic protocol to RDS protocol

  Follow the oraclesupport network steps and further refine the steps. The environment is rhel6.2-64 oracle11.2.0.31. First install the IB network card and driver, and use the command to view the installed network card: [root@nari65 b]

  2022-06-01 12:15:30 Views: 281
• 

  Oracle12C creates user learning

  In Oracle 12C, there are two kinds of accounts, one is public account, the other is local account (which can also be understood as private account). A joint account refers to an account created under CDB and valid in all PDB, and the other is an account created in PDB. Tests for these two accounts, such as

  2022-06-01 12:15:30 Views: 303