Database Administrator

I am writing a small website job today. I can use jsp to insert data to MySQL in Ubuntu 8.10. Both English and numbers can be inserted, but Chinese characters won't work. I used all the jsp Chinese characters. I tried to use mysql query browser (a

Installation package required for CentOS * GNOME Desktop Environment * Editors * Graphical Internet * Text-based Internet * Development Libraries * Development Tools * Legacy Software Development * Server Configuration Tools * Administration Tools *

Recently, due to project requirements, mysql Data Synchronization has been set on Linux servers. Fortunately, there are a lot of network resources, and google has all of them, but the actual operation is troublesome and many problems are encountered,

Operating System: Linux Fedora 11Development Environment: Eclipse, CDT, and MySQL5.1.32 (the header file uses MySQL5.1.35)Preparations:1. Run the following command to view the MySQL version installed in Linux:$ Rpm-qa mysql2. Check whether

There are two ways to restrict the IP address used to log on to Oracle 1. Edit $ ORACLE_HOME/network/admin/sqlnet. ora and addTcp. validnode_checking = yes# Tcp. invited_nodes = () # list of IP addresses that can be accessed, separated by commasTcp.

In the development and testing environments of Oracle databases, the log mode and automatic archiving mode of databases are generally not set, which is conducive to the adjustment of system applications, the generation of a large number of archive

1. maintain_mode Parameter Golbal or transportable tablepsaces is recommended. When this parameter is set to global, streams is used for full-database replication; otherwise, streams is used for table space replication, you must specify one or more

Oracle and SQL server both follow SQL-92 standards: see here, but there are also some differences, the difference is as follows: In Oracle, the table name, field name, stored procedure name, and variable name cannot exceed 30 string lengths. The

In essence, a view is only an SQL statement, but MySQL does not store the SQL statement.Instead, we save the view definition in the form of a file like a table, and use. frm to exist.The SQL statement displayed with show create view is

PHP is recommended to operate Oracle databases by using the OCI8 extension. The method for enabling PHP OCI8 extension on the internet is roughly as follows: (1) Remove the comments of extension = php_oci8.dll in php. ini (first use phpinfo to check

I. Logical Standby preparation 1. Check whether the operation objects and statements are supported by logical Standby. Because logical Standby maintains synchronization with the Primary database through SQL applications. There is a big difference

One reason for triggering ora-01200 errors [Oracle @ oracle ~] $ Oerr ora 1, 0120001200,000 00, "actual file size of % s is smaller than correct size of % s blocks"// * Cause: The size of the file as returned by the operating system is smaller//

In projects, tasks that need to be completed regularly, such as regularly updating data and defining statistical data to generate reports, can be completed using Oracle jobs. The following section describes how to automatically create a table in an

1. You can download the Oracle software and installation documents for free on the oracle official website. If you install the software on a linux system in a virtual machine, you can use FileZilla Client to send the software to the

1. Mysql Database Installation Introduction: Mysql is a platform-independent open-source database that can be built on Windows, Linux, Unix, and other platforms. This article mainly explains how to install Mysql databases on the Linux platform,

Recently, Oracle released several new features in the latest MySQL 5.7.2 version. Most of the improvements are in terms of database performance and replication-related features. This new version will bring us incredible results. In this article, I

When you use imp/exp to import/export the 8I data to 10 Gb, it is found that all the comments of the imported data are garbled. The reason is that the client character set is not set during the export, or the settings are incorrect. It's okay to

When using mysqldump for backup, if the storage engine is MyISAM, you can only implement warm backup, and you need to use the option -- lock-all-tables to lock all tables. If the storage engine is InnoDB, The -- single-transaction option can be

I. Syntax:TRANSLATE (string, from_str, to_str)Ii. PurposeReplace each character in from_str with a string after the corresponding character in to_str. TRANSLATE Is a superset of the functions provided by REPLACE. If from_str is longer than to_str,

Data Guard Master/Slave switchover1. view the status Master database: SQL> SELECT SWITCHOVER_STATUS FROM V $ DATABASE; SWITCHOVER_STATUS------------------------------------------------------------To standby // can be converted TO a slave