Database Administrator

Click Ubuntu system => System Management => New Software Package Manager Search for the jdk mysql keyword and select the software source to be installed from the search list. I. Configuration ~ /. Bashrc FileDefault JDK installation path/usr/lib/jvm/

Recently, MySql was installed and run on the server. Due to the aging of the computer's keyboard, I always press the wrong key. The error message is not interrupted, so it is annoying. No way, I disabled it. Open the installation directory of MySql.

After Oracle Releases PL/SQL and Java application programming interfaces (APIS), the click tool or builder that can use the newly released APIs will be launched on the market, this is generally the best practice. With this practice, developers can

The RedHat system can be found on the Internet. There is no article about the MySQL cluster of the Ubuntu system. I am writing the Ubuntu MySQL cluster method. Don't scold me for being a newbie. Introduction to the network environment: Test

Database: SC _source and SC _dest Requirement: Copy all objects under the product user in SC _source to SC _dest. I. preparations: 1.1 place the SC _source and SC _dest databases in the archive Mode 1.2 if some tables do not have a primary key,

When multiple MySQL servers need to be run on a machine, mysqld_multi is a great tool. It can be started, shut down, and reported by using simple commands. The configuration file below is very concise, just for testing purposes, so make a backup of

When you encounter an error "cocould not start the service MySQL error: 0" when installing or reinstalling mysql, you can try the following two methods. I. method 1 When installing MySQL, the error "cocould not start the service mysql error: 0" is

Environment: Virtual Machine OS: Linux 5 Oracle version before Upgrade: 10.2.0.0.1 First shut down the database and listen And then kill all oracle processes. Ps-ef | grep oracle | grep-v grep | grep-v ef Kill-9 process no. Decompress the

When you create a unique constraint before creating a primary key constraint, if you use a common method to delete the primary key constraint, the unique constraint index will not be deleted, which is a PROBLEM of Oracle 10 Gb. This article uses an

Postgres 9.3 is currently under intensive development. A new feature worth noting in this version is the JSON data type. After reading the new functions for data generation article, let's take a look at the description of the new JSON feature in the

Abstract: when using the sybase database, we often use excel to read the content in excel and insert it into the sybase database table, in this process, there are often line breaks in excel (line breaks are not visible). After being imported to a

Environment: OEL + Oracle 11.2.0.1 ORACLE_SID = orcl2 Create the following directory: [Root @ DBA2/] $ mkdir/backup[Root @ DBA2/] $ mkdir/backup/0[Root @ DBA2/] $ mkdir/backup/1[Root @ DBA2/] $ mkdir/backup/2[Root @ DBA2/] $ mkdir/backup/3[Root @

The Web Cache Configuration Assistant check failed when installing Oracle 10.2.0.1 grid control in Configuration Assistants (Configuration Detection), prompting a OUI-25031 error, the solution is as follows: The following error is reported: Then,

Oracle Bug 6136074 encountered at work, a bug of 10203, is the first time this problem was encountered. On 10.2.0.3, a bug may cause compilation or view failure. The failure may not only result in unavailability of the current view or process, but

Connection character: |Value assignment: ": ="For example, l_name: = 'sky ';Determine whether the values are equal: "="For example, if 1 = 1 then...Variable binding :":"For example, if: P_NAME = 'sky' then... ExistsNot exists does not exist % Type

When cleaning up unnecessary users after installing MySQL today, I accidentally deleted root @ localhost and added it again. Then I want to add a user to connect to the remote machine, as a result, the user cannot be added. Mysql> select user ();+ --

Operating System: Oracle linux 6.3 x86_64 Oracle version: Oracle 11.2.0.3 Go to the grid user, cd $ ORACLE_HOM/deinstallE directory [Grid @ xyy1 deinstall] $./deinstallChecking for required files and bootstrapping...Please wait...Location of

Xtrabackup is an open-source project of percona. It supports hot backup of innodb, XtraDB, and MyISAM (locks the table)The MyISAM storage engine locks tables and is also very depressing because Innodb and MyISAM storage engines are used online,

Distributed transactions The Innodb Storage engine supports XA transactions and distributed transactions. Distributed Transactions allow multiple independent transaction resources to participate in a global transaction. Transaction resources are

Most people will first check whether the disk space in the archive directory is full and determine whether the archive space is full based on the free space of the archive directory, however, I think this method does not necessarily represent the