Database Administrator

Directory Preface Chapter 1 hardware preparation Chapter 2 software preparation Chapter III installation in 11.5.10 For Linux Chapter 4 Maintenance and problem solving after installation Chapter 5 release of ebs Oracle EBS 11.5.10 Study Notes

I. Introduction I have been using Linux for a long time. I have never studied hard tasks and system learning. Recently, I have to use MySQL in Linux for my work. I thought that I had experience using SQL Server in Windows and thought it would be

Recently, I encountered a problem. After Oracle 10 Gb Database Export, the import in 9I was actually problematic, so After trying to install 9I and connect to 10 Gb, use the 9I EXP command to export the data. Who knows whether the exported data is

1. Install the required MySQL software package in Ubuntu Sudo apt-get install binutils cpp fetchmail flex gcc libarchive-zip-perl libc6-dev libcompress-zlib-perl libdb4.3-dev libpcre3 libpopt-dev lynx m4 make ncftp nmap perl-modules unzip zip zlib1g-

When I was writing SQL statements recently, I encountered two problems: 1) ORA-01795: maximum number of expressions in a list is 1000 Cause: the following SQL statement is written: SELECT PALLET_ID, BOX_ID, STATUS FROM SD_CURRENT_BOX WHERE

Install Sqlite in Linux.Linux: pecl install sqlite/Tmp/pear/SQLite-1.0.3/sqlite. c: 125: warning: initialization from incompatible pointer type/Tmp/pear/SQLite-1.0.3/sqlite. c: 126: warning: initialization from incompatible pointer typeMake: ***

"ContentType =" text/html; charset = gb2312 "%>String info = "";String traininfo [] = new String [20]; // stores the information of each recordInt index = 0;Connection con = null;PreparedStatement psm = null;Statement sm = null; Try{Class. forName ("

"The input value is not long enough in the date format" reported in Oracle for date conversion" Select (select j. jgmc from t_zzjg j where j. jtpd = t. jtpd) jgmc,T. jtpd,Sum (t. jcj) jcj,Sum (t. sa) sa,Sum (t. la) la,Sum (t. ajbl) ajbl,Sum (t.

1. What is the Oracle character set? The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. ORACLE supports the national language

The single-host multi-instance MySQL solution is to run multiple MySQL database instances on one physical server. Advantages of Single-host and multi-instance MySQL:1. save costs and reduce the number of servers, IP addresses, and cabinets. The

Outline I. MySQL Backup Type2. What are MySQL backups?Iii. MySQL backup toolsIv. MySQL backup policyV. Backup preparationVi. demo of backup policyNote: The system version CentOS6.4 X86_64 and MySQL version 5.5.32 Implementation of MySQL backup and

Outline 1. configuration file description My-small.cnf My-medium.cnf My-large.cnf My-huge.cnf My-innodb-heavy-4G.cnf 2. Detailed explanation my-innodb-heavy-4G.cnfIii. configuration file OptimizationNote: Environment Description, CentO5.

Xtrabackup ------ A required MySQL DBA Tool Note: 1) Documents Reference http://www.percona.com/docs/wiki/percona-xtrabackup:start 2) mysql version 5.1.50 or later. 1. Introduction and installation of Xtrabackup 1. Xtrabackup is an open-source

As a widely used database, Oracle runs stably on the AIX database and is widely used in some key departments and industries. As a special data storage medium, bare devices can directly operate data, saving the first level of the operating system and

Oracle 10 DBMS_MONITOR tracks and analyzes other session SQL statements 1. session information View the current session information statement Select sid, serial #, username, machineFrom v $ sessionWhere type! = 'Background'And username = 'sys '; --

I. Basic Environment requirementsSystem Environment:System Version: RHEL5U8 x86_64Oracle version: ORACLE 10.2.1IP addressOdb1 192.168.100.144192.168.101.144Odb2 192.168.100.143192.168.101.143Disable Selinux/iptables on the server Ii.

Oracle temporary table introduction: In addition to permanent tables, the ORACLE database can also create temporary tables. These temporary tables are used to save the data of a SESSION or the data required in a transaction. When the session exits

Long transaction impact OGG is a transaction-level real-time replication tool. That is to say, OGG only copies committed transactions. Before a transaction's commit or rollback occurs, it stores the operations of each transaction in a managed

Environment: OS: rhel63_64bit DB: Oracle10gR2 Master/Slave switchover sequence: first from the master database to the slave database, then from the slave database to the master databaseSwitchover:Lossless conversion is usually triggered manually or

An online query is simplified as follows:Selectdt, count (distinct c1), count (distinct case when c2> 0 and c1 = 0 then c1 end ), count (distinct case when c2> 0 and c1> 0 then c1 end) from t where dtbetween '000000' and '000000' group by dt;The