Database Administrator

The Helper sorted out the following knowledge about Oracle databases in Linux for your reference! Installing Rose for Linux Oracle Install oracle 9.2.0.04 [Oracle @ whdata1 install] # cd Disk1 [Oracle @ whdata1 Disk1] #./runInstaller 1. The

Steps for installing a MySQL database in Ubuntu: 1.download mysql-6.0.4-alpha.tar.gz2. tar-zxvf mysql-6.0.4-alpha.tar.gz3. cd mysql-6.0.4-alpha4../configure -- prefix =/usr/local/mysql5. make6. sudo make install7. sudo cp

"Client does not support authentication protocol requested by server "? "Client does not support authentication protocol requested by server" is displayed when you install MySQL or a later version ". Mysql 4.1 and later versions use the new

Because the supervisor requires a script on the central management server to automatically check the running status of all mysql servers of the company at the specified time every day, and then send it to the specified mailbox. All mysql server

1. test environment: > Master: physical machine, Debian (testing) + mysql5.0 + ip: 192.168.40.223 > Slave: Virtual Machine, CentOS (4.0) + mysql5.0 + ip: 192.168.40.225 2. Modify the Master (192.168.40.223) 1). Modify/etc/mysql/my. cnf Make the

1. Create an Informix group and an Informix userUse the root user to pass the Informix Installation File to LinuxUse the root user to install Informix in the/bank/informi directory 2. Use Informix to configure the installation.Modify

PhpMyAdmin is a PHP-based MySQL database management tool based on the Web-Base architecture on the website host.You can manage the entire MySQL Server (requires a Super User) or a single database. To implement the latter, You need to properly set

If you are using Oracle 8i or a later version, it is simple. execute immediate SQL _str is used in the process. SQL _str is a patchwork SQL statement, but this dynamic statement contains parameters, or when the Select result is into the variable,

Confusion between space and empty string query in MySQL In MySQL, if the value of an Element in a string-type field is a null string or space, a problem may occur during query. Execute Java code Select * from table where Element = ''or Java code

Recent UAT database migration, because multiple databases need to be migrated to the same machine, after part of the completion, start the subsequent database encountered a ORA-27102 error, prompting that the memory exceeds, view the system

This document describes how to install and create an Oracle database in silent mode. The User Creation, user group, and environment settings are the same as those for graphical installation. For specific settings, see the blog :. Silent Installation

Generally, mysql requires backup. There are many backup methods. The following is an automatic backup of a remote database that I used in concert with a scheduled task. I. Confirm the backup solution: Backup Machine: ip192.168.8.51 Database Server:

One or several autonomous transactions can be defined in a transaction (outer transaction. An autonomous transaction can be committed independently without affecting the outer transaction. Similarly, the rollback of the outer transaction does not

Database performance is an eternal topic, that is, how to use less resources to achieve more efficient performance. The Oracle system parameter RESOURCE_LIMIT is a parameter used to control the user's usage of database resources. It is enabled when

1. Configuration Planning Name IP Listeners End Port SID Db_name Db_unique_name Service name   Host 127.0.0.1 Listener1 1521 Test1 Test1 Test1 Test1   Slave 127.0.0.1

If you know how to learn embedded technology, you must understand the database. The embedded tutorials on the books you read are all in use. It seems that I cannot learn it, the following is a simple record of how to install and use SQLite on Ubuntu

• Compile SELECT statements, use equijoin and non-equijoin to access data in multiple tables • use a self-join to connect the table to itself • use an OUTER join to view data that typically does not meet the join conditions • generate two or more

Description of the new and enhanced RMAN functions in Oracle Database 11g• Configure an archiving log deletion policy • Use the Oracle network to copy active databases (No backups) • backing up large files in multiple parts • Creating archive

A friend asked me to back up the database with exp at every night to a specified directory and automatically delete the data backed up one week ago, record and share the process only. For the case of Oracle automatic backup on Linux (using RMAN),

Prerequisites:   Two linux machines with Oracle installed. This is CentOS3_x86. Oracle service is installed on the master database and an instance named ora10g is added. The slave database only installs the oracle service For convenience, the