Database Administrator

DBAs do not have to back up files. Eygle is called the DBA's nightmare. So far! Although many people think that backup of parameter files is not important, you often suffer! Parameter file. For windows, spfile and pfile of Oracle are in the E: \

In MySQL, the default Character Set utf8 is used. The sorting order of Chinese characters by Pinyin is messy, not the result we want. The solution is as follows: 1. If you do not want to change the table definition and default encoding, convert

All these operations are performed in Linux and the root permission is required. Installation start: Shell> groupadd mysql Shell> useradd-g mysql Shell> gunzip | mysql-VERSION.tar.gz | tar-xvf- Shell> cd mysql-VERSION Shell>./configure -- prefix

Note:EXP-00091: Suspicious exit statistics.EXP-00091: Exporting questionable statistics. Generation:This error occurs when the database table is exported (dump) when the database server and client character set are different. This error does not

After MySql is installed, there is only one ROOT user with super management permissions, and ROOT restrictions can only be used on the local database. What if we want to remotely manage MySql? In fact, we need to add a Super User with super

The MySql4.1.7 password algorithm is different. You can make the following options: 1) Use PHP5 and php_mysqli.dll instead of the previous php_mysql.dll. 2) Change the MySql password to the original algorithm (this article introduces) I have been

There is an internal limit on the size of Oracle data files, which is: Each data file can contain a maximum of 2 ^ 22-1 data blocks. This limit directly results in the maximum allowed size of each data file. Under 2 K Block_size, the maximum data

First use one as read/write, and one as read-only Mysql-proxy -- proxy-address = 192.168.210.20.: 3306 -- proxy-read-only-backend-addresses = 192.168.210.132: 3306 -- proxy-backend-addresses = 192.168.210.131: 3306 -- proxy-lua-script

Today, when I create a table in MySQL, I first create it in MySQL Query Browser, but I always report an error. Later I thought it was just a client software that is easy to operate. I guess it won't work. Later, I created a table under the MySQL

When using mysql for database restoration, The following Error occurs due to The large data size: The MySQL Server returned this Error: MySQL Error Nr. MySQL server has gone away. This error occurs when I restore a 30 mb backup. The solution is to

To import and export a MySQL file, follow these steps: 1. MySQL Command Line Mode settings: Desktop> my computer> Properties> environment variables> New> PATH = "; path \ mysql \ bin;", where path is the installation PATH of MySQL. 2. A brief

In Oracle, the CHAR field value is automatically filled with spaces. Therefore, when it is used as a condition, you may not be able to find the desired data.If you cannot change the database design, use RTRIM. Example:DB: Code highlighting produced

The following error occurs when connecting to MySQL in Linux C: After the compilation is successful, run the program./connect: error while loading shared libraries: libmysqlclient. so.15: cannot open shared object file: No such file or

Today's optimization has been transformed to optimization wait (waits). In reality, the most fundamental appearance of performance optimization is also concentrated on IO, which is the most important aspect that affects performance, waiting in the

Environment: CentOS 6.2 + Oracle 11.2.0.3 (non-rac) Problem description: database every day around error ora-07445, after a few days is two to three times a day this error occurs, checked on the MOS, is the patch number 13901133 bug, the patch was

To add a user to mysql, follow these steps: 1. Log On with the root user Mysql-u root-p 2. Select mysql database Use mysql 3. Add a user Insert into user (Host, User, Password) values ("localhost", "your username", password ("your Password "));

Clustering factor is one of the parameters used to calculate cost in the CBO optimizer mode in Oracle statistics. It determines whether the current SQL statement is indexed, or full table scan and nested External table connection. In this case, what

For the sake of database data security, the exp command is no stranger to most Oracle users (especially database administrators). This exp command can complete various backup of database data, for example, full database, specific user, and specific

By default, only the date is displayed on the RMAN backup and recovery interface, but there is no specific time. Sometimes you need to view the specific time, for example, to view multiple Incarnation events of the current day. To solve this problem,

I used SUSE10 SP3 to install Oracle 11g R2, but when I logged on to EM, I found that the buttons such as "cancel" were all small boxes, and google found a solution later, the EM garbled code is caused by java, and the EM button is a graph generated