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

Scenario: The customer said that the OEM was suddenly unavailable. Because the application is linked to some OEM pages, it must be restored immediately. Symptom: Log on to the client server and execute the emctl status dbconsole. An error is

The comparison between the round () function and trunc () function in Oracle is very practical. Round (x [, y]) [Function] returns the rounded value. [Parameter] x, y, numeric expression. If y is not an integer, the y integer is truncated. If y

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;

This error occurs ORA-01861: literal does not match format string Statement is Between 'time1' and 'time2' The query result is: ORA-01861: Text and format strings do not match Solution To_date ('time1', 'yyyy-mm-dd hh24: mi: ss ') Or You can

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

Profile usually refers to the configuration file. crs_profile is the configuration file for managing the cluster. In systlele RAC, all CRS resources are stored on the OCR disk. OCR is more similar to Windows registry. We know that the Windows

This is the case: Due to my carelessness, I helped other departments to update some data in batches on October 13, July 30. Who knows that the global update is complete, and I was notified of this problem only on October 10, September 26. They

System Environment: Database: Oracle 11.2.0.3 (64-bit linux) ArcSDE: ArcSDE9.3.1 sp2 (Build 4000) First, use dbca to create an oracle database instance (AA) Then, use ArcSDE9.3.1 sp2 post oracle 11.2.0.3 to create and configure sde user

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

Cause: zabbix may monitor the running status of the mysql service, but cannot monitor whether the master-slave replication of mysql is normal: Sometimes the synchronization has stopped, but the Administrator does not know. Start: log on to the mysql

CentOS 6.2 is already installed with mysql 5.1. However, CentOS 5.1 does not support the utf8mb4 character set (For details, refer to:). You can only upgrade Mysql to 5.5. This is indeed a painful upgrade process. Complete steps: 1. First, back up

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

ORA-19870 and ORA-19573 errors, such: RMAN> restore database; Starting restore at 11-DEC-12Using channel ORA_DISK_1 Channel ORA_DISK_1: starting datafile backupset restoreChannel ORA_DISK_1: specifying datafile (s) to restore from backup

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

Next we will talk about the migration of SQLite on micro. Steps: 1. compile a database suitable for arm 1. Download The SQLite source code package. URL: http://www.sqlite.org/ 2. decompress the source code package. [Root @ localhost SQL] # tar-zxvf

MySQL version: 5.5.28 System Platform: RHEL 5.8 32-bit (1) usage of Foreign keys: The foreign key has two main functions:One is to allow the database to ensure data integrity and consistency through foreign keys.One is to increase the readability of

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

Recently, a telecom company has implemented a project to migrate the original Oracle database to the PPAS of EnterpriseDB. It is very busy to get back the dump file of oracle and write down the installation and migration process. First, list the

Problem: In Oracle, how does one combine two tables with different rows into one table? SQL: Select s. stagename sname, Sum (nworkhours) nworkhours, Sum (OVERHOURS) OVERHOURS, Sum (nworkhours + OVERHOURS) From T_WorkDetails w, T_stage s Where w.