Database Administrator

Due to work needs, I set Oracle Intermedia on HP UX And sortium to implement full-text search. It is currently in use. There are many problems and experiences in the setup process. This article is based on Oracle 8.1.6 and 8.1.7, and cannot be

When I was managing a technical consulting company, I heard some reasons for not using MySQL. Although many reasons are due to misunderstanding, there are indeed some reasons for not using MySQL. Of course, the actual situation may vary depending on

Oracle clients often need to be installed during program creation. If there are many client terminals, this will be a very troublesome task. On the one hand, we need to arrange our applications, on the other hand, it is difficult to install the

1. Download the MySQL Installation File The following two files are required to install MySQL: [Root @ test1 local] # rpm-ivh MySQL-server-5.0.26-0.i386.rpm is: unzip Hat Enterprise Linux 3 RPM (x86) downloads, find the Server and Client programs

In actual Oracle applications, many people may encounter such problems. For performance or other considerations, you need to change the tablespace of a table or all tables of a user. The common practice is to first Delete the table and then

After several days of hard work, I finally installed Oracle11G FOR Linux. I started to install RS4.0 and downloaded several versions of Oracle10g, or Oracle and Linux were incompatible, either the inventory directory cannot be found, or the net

Oracle Database startup and shutdown Methods I. Several startup methods: 1. startup nomount is not installed and started. In this mode, execute the following commands: re-build the control file and re-build the database. Start the instance, that is,

// Title: MySQL character set (my summary) // By dx_andy // Time: 2007.8.27 evening // Test environment: win32 MySQL 5.0.45 // Cause: Garbled MySQL Since the launch of MySQL 4.1, the garbled code problem for Chinese people has also aroused the risk

MySQL supports unidirectional and asynchronous replication. During the replication process, a Linux server acts as the master server, and one or more other servers act as slave servers. The master server writes updates to the binary log file and

Environment: Ubuntu LinuxThe following methods have been tested by myself and can solve the problem of garbled characters in Ubuntu PHP inserting MySQL database. 1. Use utf8 for database storage as much as possible (modify/etc/my. cnf and add

The descriptions below have no theoretical basis and are purely personal experiences. MySQL uses version 4.1 or later, and uses the default for whatever character set it is. You do not need to set MySQL. Then an example of using GB2312 and UTF-8

OS: Oracle-Enterprise-R5-U2-Server-i386Oracle: linux_x86_11gR1_database ERROR:Sqlplus: error while loading shared libraries:/u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied I. Simple

Because of the pre-research needs of the project, I want to find a solution that can meet the requirements of the internal and external Network Database Synchronization. I first tested the Advanced Replication function of Oracle, but did not succeed.

MySQL has built the Replication function since version 3.23. We can configure it to master-slave mode or master-master mode. The method is very simple. Here we will record the configuration of the master-master. Here I test mysql 5.1.31. One is

System: LINUX 5.6-64Database Version: 11.2.0.2The following error occurs during Automatic SQL tuning of Oracle:Thu Jan 10 22:00:02 2013Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_ SQL _TUNING_TASK"Thu Jan 10 22:02:39 2013

Oracle online logs and Oracle archive logs record the complete change information of the entire database. Is an important part of Oracle architecture. Therefore, online log planning is also very important. However, as the business grows or the

Take scott. emp as an example. Based on the position (MGR) number, find all information about the position number.Create TYPE first: equivalent to the TYPE of each row of record, which can be understood as scott. emp % rowtype1.CREATE or replace

Test environment: DB: 11.2.0.3, 10.2.0.4 OS: RHEL 4.8 Migrate the stored outline data in Oracle 10 Gb to 11 GB 1. Export the data in the test table [Oracle10g @ rhel4 SQL] $ expdp scott/oracle tables = test1directory = testdumpfile = test1.dmp;

MongoDB replica Set Primary-Secondary switchover Experiment 1. Create a directory for the replica Section [Root @ bakdbserver ~] # Mkdir-p/var/lib/mongo/dbs/node1 [Root @ bakdbserver ~] # Mkdir-p/var/lib/mongo/dbs/node2 [Root @ bakdbserver ~] #

In an SQL statement, several subqueries are union. It is okay to execute each subquery separately, but the statement is executed after union, and an error is reported.ORA-00904: "xxx": invalid identifierEach subquery of union must have the same