Database Administrator

When executing the sudo apt-get install mysql-server5.1 installation command in Ubuntu, I was not prompted to enter the mysql password and other information, however, after installation, mysql can be directly entered in the terminal. Although mysql

The server Load balancer of the Oracle RAC server distributes new connection requests to the node with the smallest load based on the number of connection loads of each node in the RAC. When the database is running, the PMON process of each node in

A friend configures the DG of the master database and the physical slave database. After the configuration is complete, he finds that there is a slave database which cannot receive the archive logs of the master database. Logs cannot be transmitted

Due to the rapid growth of data in the Oracle database, the disk space of the data file is insufficient. To clean up the space, I disabled oracle, then, the data files, control files, and redo log groups are moved directly to another disk, but this

Background_dump log: [Oracle @ HBCADB001 trace] $ tail-f/u01/sys_software/oracle/product/11.2.0/grid/log/hbcadb001/alerthbcadb001.log The warning Log File alert_sid.log stores routine information and error information. Its path is BDUMP. SQL> show

Oracle 9i is really a headache, ORA-00600 has become a signboard error, although 10g also has similar errors, but it is already very different from 9i.At the beginning of DBA, on the ORA-00600 began to understand, when learning that this is "oracle

MySQL uses connector C/C + To Read Binary fields: Use getString Vector vec; While (pResultSet-> next ()) { String str = pResultSet-> getString ("data "); Vec. insert (vec. end (), str. begin (), str. end ()); } Use getBlob Vector vecALL;

The following error is reported when you use the Oracle 11g EXP command to back up the database: EXP-00003: no storage definition found for segment (11,307) "EXP-00003: no storage definition found for segment ...... "Error, which is related to a

In the Oracle data guard environment, the alert. the error message "ORA-12514: TNS: listener does not currently know of service requested in connect descriptor" appears in the log file, causing the logs on the master database to fail to be

Move the MySQL database directory on Linux today The configuration is as follows: /Etc/my. cnf [Mysqld]Datadir =/home/mysqlSocket =/var/lib/mysql. sock The following problems occur when the configuration file is changed and MYSQL is restarted: 110222

MySQL database backup tool has its own mysqldump, which is an official mysql backup tool. However, mydumper, a third-party backup tool, is advantageous for more people. Next we will test and verify the backup efficiency between them. 1. Install the

I. Environment Description Mysql version: mysql-installer-community-5.5.27.1 32-bit Mysql for Windows 7 32-bit: I installed the mysql database on my own Windows 7 laptop, the advantage is that it reduces the overhead and space used by the master

Redis is a high-performance key-value database. Its key has a wide range of data structures: string, hash, list set, and sorted set. Compared with memcache, NOSQL not only has a rich key data structure, but also has persistence functions. It also

1. modify a data table It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need to log on to the computer of localhost. After logging on to MySQL, change the "Host" item in the "user" table

Use show parameter xx in sqlplus to view the Oracle-defined parameters, which are obtained by querying v $ parameter. In addition, some implicit parameters in Oracle cannot be directly queried through the show parameter method. Let's check the

In the evening, I continued to follow the tutorial and completed the connection to MongoDB. There were some slight bumps in the middle. 1. Follow this tutorial to: http://docs.cloudfoundry.com/services/mongodb/nodejs-mongodb.html 2. Download and

Trigger execution sequence Combined trigger Enable and disable triggers Trigger execution sequence Oracle allows more than one trigger to establish the same time point, but it never guarantees their execution order. The Oracle 11g trigger syntax now

The results returned by the recent SQL query cause a ORA-06502 error to the PL/SQL variable. The error description is ORA-06502: PL/SQL: numeric or value error: character string buffer too small. obviously, the length of the character variable

Limitations when using Oracle sequence currval and nextval Create a sequence Create sequence test_seq Minvalue 1 Max value 10000000 Start with 1 Increment by 1 Cache 20; Sequence values cannot be used in the delete, select, and update

Download the p8202632_10205_linux.zip patch to metalinkand upload it to the server. Perform the following upgrades:   1. Stop RAC [Oracle @ b87 ~] $ Srvctl stop database-d racdb [Oracle @ b87 ~] $ Srvctl stop asm-n b87 [Oracle @ b87 ~] $ Srvctl stop