Database Administrator

I. Oracle Enterprise Linux 5.0: Required component installation:GNOME Desktop EnvironmentEditorsGraphical InternetText-based InternetDevelopment LibrariesDevelopment ToolsServer Configuration ToolsAdministration ToolsBaseSystem ToolsX Window System 2

The default selinux configuration of RHEL5.1 only allows the MySQL Server to listen on port 3306. To enable MySQL to listen on other ports, you need to use the semanage command to set the listening permission for the MySQL Server. The following

In addition to the well-known Chinese characters, mysql instances on Linux may encounter the following problems: You use mysql5x and configure the database to use the UTF-8 character set, you use the linux Standard jdk environment, you use a high

This morning, the production sybase Database suddenly went down. I used [root @ d1 install] #./startserver-f RUN_mcsdb to disable other startup tasks. The following error is also reported. [Root @ d1 install] # Incorrectly built binary which

MySQL5.0 version of the installation of graphic tutorial is FOR beginners to learn, first download MySQL-5.0.22 (source package) FOR Linux address: Ghost (Installation Package) can go to the official website http://dev.mysql.com/downloads/ The

MySql was sold to Sun for $1 billion a few months ago. As the boss of Mysql, the former CEO of MySql and the current senior vice president of Sun's database, Marten Mickos, recently seems in a bad mood. Why? Marten Mickos was questioned at the Linux

1. Create password file commandOrapwd file = <> password = <> entries = maximum numberThe file naming rules are in orapw in unix/linux and pwd. ora in windows.For more information, see the description below (this is a summary of pub's netizens)1.

My mysqllistener is mysql-cluster-gpl-6.2.15-linux-i686-glibc23.tar.gz. In actual work, if you do not start mysqld service on the data node in the cluster settings, data and tables created on the MySQL node server cannot be transparently displayed

1. test environment: > Master: physical machine, Debian (testing) + mysql5.0 + ip: 192.168.40.223 > Slave: Virtual Machine, CentOS (4.0) + mysql5.0 + ip: 192.168.40.225 2. Modify the Master (192.168.40.223) 1). Modify/etc/mysql/my. cnf Make the

After installing Oracle10g, I want to enable SQL * plus for learning, and then follow the steps in the book to connect to the database with scott user. After the installation, an error is prompted several times. Error: the account is locked Then I

The preceding method uses the combination of Red Flag DC Server 5.0 and iASP to connect to an independent ms SQL Server 2000 using ASP. The advantage of this method is that you do not need to modify the user's database environment. However, the

(I) What is it? Records detailed information about MySQL Server startup and shutdown, and severe warnings and errors during running. Mysql> show variables like 'Log _ error ';+ --------------- + --------------------------------- +| Variable_name |

I. Description There are two types of RMAN backups: Catalog and Nocatalog. For Nocatalog, Oracle uses a control file to save some RMAN backup records. In fact, most of them also use Nocatalog for backup. It is easier to use Nocatalog. However, when

Original database version: Oracle 10.2.0.4.0 Target database version: Oracle 11.2.0.1.0 Use expdp to export data from the original database: Expdp system/xxxxxx schemas = test1201 directory = easbak dumpfile = test1201.dmp logfile =

Hang has recently been used to export schema-level data and has to stop the current export job. If you have similar problems, please continue to read it.1. Problem DescriptionThe database is hang when the entire schema is exported, as shown

For the Oracle RAC cluster database, it has never been clear about how to achieve load balancing in terms of high JOB. I have tested it over the past few days and come to the following conclusions. At what level can a JOB be customized. If a job is

SQL Tuing Advisor (STA) is part of the automation Tuning Optimizer. In the previous article, I used SQL tuning advisor (STA) to automatically optimize SQL statements to describe the background of SQL Tuing Advisor (STA) and provide examples. This

I started the Oracle database course. Textbooks and teachers both use 10 Gb of lectures. However, Oracle 11g has been released for a long time, and its functions tend to be stable. It also provides complete online materials, therefore, we plan to

1. Insert Buffer-It brings performance to the InnoDB Storage EngineLike Data Pages, insert buffering is an integral part of a physical page.(1) The primary key is the unique identifier of the row. In the application, the row records are inserted in

To save the trouble in the future, we can modify the mysql garbled characters in the configuration file under RHEL6.3. My mysql configuration file is/etc/my. cnf 1. First find [mysqld] in the configuration file and add the following