Database Administrator

Take a look at BIRT. I think of the previous company's use of Oracle BAM. At that time, I started to work on BAM by myself. from scratch, after learning something, I found that Oracle BAM was about to be used for application crash, almost tortured

After DB2 is started successfully, it stops automatically after about 10 minutes, and the disk space is insufficient. Problem description: After DB2 is started successfully, it stops automatically about 10 minutes later. Solution: 1. view the DB2

Today, I tried the latest version of mysql cluster7.2, which has major drawbacks when adding data nodes online. What are the disadvantages? A: First of all, the newly added nodes must restart all NODB data nodes and restart all SQL nodes according

After the 5.5 semi-synchronous replication, MySQL 5.6 has optimized and improved it. Two of them are important: 1. It should be a big pleasure for O & M personnel. After the master-slave switchover, in the traditional mode, you need to find the

Example: Remote Data Information: User name: interface Password: interface Ip: 10.7.237.17 Database: uidb Local database information: Username: jucks Password: jucks Database: gilbert 1. Check whether the user jucks has the dblink creation

Today, an Oracle 11.2.0.3 environment is installed. It is found that diskmon is always in the offline status: [Root @ osdbso ~] # Crs_stat-tName Type Target State Host------------------------------------------------------------Ora. DATA. dg ora...

Today, I was about to leave after work. As a result, the developers said that the data in a test table suddenly disappeared and that no one should delete the table, ask me if it is an Oracle Bug (this is a bit of a problem, I can think of it all,

The MySQL. user table in the mysql Cluster API node is the MyISAM engine. Therefore, you must configure the permission system for each API. MySQL has provided us with a shared permission script. This script is mainly used to replace the mysql. user

MySQL database itself provides the mysqldump command to back up data. Of course, we can also use other tools such as phpMysqlAdmin to back up the MySQL database. However, data corruption may occur when backing up a large amount of data. After all,

MySQL is a scarce resource for PHP programs. By default, the maximum number of connections for MySQL is 100, that is, a maximum of 100 MySQL clients can be connected. Therefore, PHP has made some optimizations when using MySQL connections. These

When executing the following command, you must first enter db2cmd in the running of the client to initialize or su to the db2 instance. I. Common sense commands 1. db2 connect to -- connect to the local database name Db2 connect to user using --

In RedHat 5, raw devices are managed through udev. Then, how does udev know the raw device through MAJOR and MINOR. If we only write: ACTION = "add", KERNEL = "sda", RUN + = "/bin/raw/dev/raw/raw1% N" Therefore, Udev cannot identify raw devices and

A two-node Oracle 11g rac with the host names rac1 and rac2 respectively. The instance names are db4qg_1 and db4qg_2. The effect required is that the rac1 node starts the instance db4qg_1 and the rac2 node starts db4qg_2, but in actual operation, it

Environment: 192.168.1.8 (DR, real server) 192.168.1.88 (real server) 192.168.1.188 (real server)1. DR installation Configuration:(1) install IPVSADMYum install ipvsadm(2) bind a VIP:Ifconfig eth0: 0 192.168.1.200 broadcast 192.168.1.200 netmask 255.

Alter databasebackup controfile to trace as '/bk/col. SQL '; Consistency database stop destroys log files and Control Files Start Database SQL> startup Oracle instancestarted.   Total SystemGlobal Area 314572800 bytes Fixed Size 1219136

I. What is Incremental backup? Incremental Backup backs up new data. If you have 10 Gb of data in a database, you can add 10 MB of data every day. The database must be backed up once every day. Do you need to back up so much data? We only need to

PostgreSQL has added some Window Function functions in Versions later than 8.4. The following is a brief introduction. A window function performs a calculation setting ss a set of table rows that are somehow related to the current row. this is

Mysql database read/write splittingI. Mysql database installation (skipped here)2. Mysql master-slave replication. The master server is A: 192.168.5.31, And the slave server is B: 192.168.5.32.1. Operations on master serverLog on to mysqlMysql-u

1. Set system parameters;The following Kernel Parameter settings are required for Oracle Database 10 GB.Generally, you can set the maximum shared memory to half the physical memory. If the physical memory is 2 GB, you can set the maximum shared

Prerequisites:Install the database software on the two machines, create databases respectively, and start the database; Description 1. Host functions:[Oracle @ Oracle11gOcp_catalog ~] $ Cat/etc/hosts# Do not remove the following line, or various