Database Administrator

When multiple MySQL servers need to be run on a machine, mysqld_multi is a great tool. It can be started, shut down, and reported by using simple commands. The configuration file below is very concise, just for testing purposes, so make a backup of

MySQL uses the default Character Set of latin1. That is to say, the Chinese character fields are stored directly using the GBK internal code encoding, if you want to sort the fields with Chinese characters in pinyin (especially those with names),

1. An error is reported when ORACLE software is installed to 86%. The figure is missing. The log is as follows: /Oracle/u01/app/oracle/product/11.2.0/INFO: db_1/lib/sysliblist '-R/opt/SUNWcluster/lib-R/export/home/oracle/u01/app/oracle/product/11.2.0

The name looks terrible: Web Scale. It is actually based on the Community version of Oracle MySQL 5.6, and some tools and patches are added. Let's take a look at this

Recently, I was working on a graduation design. It was a small system developed with powerbuilder. This system is similar to vb I learned two years ago, but it is not the same. I started to do it when I was familiar with the environment, now the

I used VB6 Enterprise Edition to encapsulate a DLL, which has four VB forms: form1, form2, form3, form4, in VBE of excel 2003, class modules and standard modules in DLL are successfully called with VBA code, but VB forms cannot be called or

Let's take a big picture first:  SQL statement used: BYS @ ocm1> select dbms_rowid.rowid_relative_fno (rowid) file #, dbms_rowid.rowid_block_number (rowid) block #, deptno from bys. test; FILE # BLOCK # DEPTNO ------------------------------ 4 391 10

CTE statement structure and CTE recursive query in SQL SERVER CTE statement Structure A common table expression (CTE) can be considered as a temporary result set defined within the execution range of a single SELECT, INSERT, UPDATE, DELETE, or

Various objects (including tables, columns, and indexes) in Oracle databases are case-insensitive by default. All objects in the data dictionary are in uppercase. If you enclose the column name or table name in double quotation marks when creating a

The temporary table of Oracle only exists in a session or transaction lifecycle. The data in the temporary table is only visible to the current session. When the session exits or the user commits a commit or rollback transaction, the data in the

Routine upgrades and patching are common tasks for system O & M personnel. In many cases, upgrading the database and patching are the ultimate policy to solve Oracle bugs. Before Oracle 11gR2, Oracle generally adopted an incremental patch upgrade

Today is. after a busy day, I finally have time to write something. Some time ago I wrote about how to recover from the existence of a backup in RAc ocr. Today I wrote about how to reconstruct ocr and olr without a backup? The biggest tragedy is

For how recovery works, see the first blog on the Restoration topic:Http://fly1116.blog.51cto.com/8301004/1337681For a brief introduction to the fly. sh script used in the restoration process and other scripts, see the second blog on the Restoration

When I first started using mysql, I first wanted to differentiate the case sensitivity of column names. I found many methods on the Internet, so 1. After mysql is installed in linux, the default value is: case-sensitive for table names, not

3 hardware and software requirements 3.1 Hardware requirements As follows: Device Description CPU More than 2 Memory 1 GB or above Hard Disk More than two, with better arrays. 40 Gb or above per Disk

Ii. Encrypted Database Password You can use GoldenGate to encrypt some database passwords. There are roughly three types of database passwords that can be encrypted. The password used to log on to the database by GoldenGate Extract, Replicat, and

Please note that Oracle explicitly does not Support running Oracle database with VMWare on the official Support website.But what should I do in a virtual environment? My suggestions:If you are an enterprise user and all the infrastructure uses

1. Connect to Mysql Command: mysql-u -p 1. Connect to MYSQL on the local machine. First, open the DOS window, enter the mysql \ bin directory, and then enter the mysql-u User Name)-p password). Press enter and you will be prompted to enter the

1. Mysql Installation Method Mysql is a platform-independent open-source relational database. you can install and deploy the Mysql database in rpm mode, which is also the simplest. However, for the rpm version, the functions of the Mysql database

This article mainly organizes Forum content. Forum address: http://bbs.et8.net/bbs/showthread.php? T = 1026112) Many people have encountered that RAID5 is suspended on the server. After a disk is dropped, the second disk is immediately