Database Administrator

Detailed steps for creating the ipvs-XL Cluster Recently, the company's business needs to use ipvs-XL clusters. There is not much network information about this part of knowledge. After a period of query and various detours, the installation was

Oracle Linux 5.5 (64bit) Installation of Oracle 11g R2 RAC graphic tutorial 1. Preparations before installation:Operating System: Oracle Linux 5.5 64bitCluster software: GI 11.2.0.1Database: database rdbms 11.2.0.12. Resource preparation:Oracleasm-2.

Oracle 11g password expired lock reported ORA-28000 the account is locked, 11gora-28000 I. Reasons for triggering this error and Related Factors This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by

SQL Server data migration to PostgreSQL error explanation and solution, serverpostgresql Problem reproduction: 1. PG client: postgres=# create table text_test (id int,info text);CREATE TABLEpostgres=# insert into text_test values (1,E'\0x00');ERROR:

Chapter 2 User Authentication, Authorization, and Security (10): Create a database that contains, authenticationSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes.

(Han shunping) pl/SQL programming (2), shunping plI. pl/SQL advanced-control structurePl/SQL provides three conditional branch statements: if -- then, if -- then --- else, if --- then --- elsif --- else(1) simple condition judgment if-thenQuestion:

Install MySql in Ubuntu and connect to the Internet, while tumysql is on the Internet. Pure beginner tutorial. 1. Install mysql apt-get install mysql-server mysql-client libmysqlclient15-dev During the installation process, you will be

This article builds the mirror demonstration for the non-domain environment, for the domain environment establishment, can refer to above: http://blog.csdn.net/dba_huangzj/article/details/28904503Source:

This article describes how to install Oracle 11gR2 (11.2.0.3) in Oracle Linux 6.3 ). Since Oracle 11g, the official Oracle website does not provide a download link for its Patch. You need to use the Meatlink account to download the Patch. Do not

Mongodb advanced 3: mongodb management and mongodb advanced management Http://blog.csdn.net/stronglyh/article/details/46827141 Usually, there are many win development environments, but the production environment should be put on unix. I.

Address: http://www.itpub.net/thread-1801066-1-1.html I recently saw several posts in the forum discussing buffer busy waits. Here I will talk about my views.Let's first talk about how this wait came about.The origin of buffer busy waits.When n

Alertsid. log error message: Fri Sep 27 15:18:39 2013Started redo scanFri Sep 27 15:18:39 2013Errors in file/oracle/admin/lixora/udump/lixora_ora_23439.trc:ORA-00314: log 2 of thread 1, expected sequence #335 doesn't match 331ORA-00312: online log 2

Link: http://www.vpsee.com/2009/08/use-shell-script-to-access-mysql/ In the afternoon, I wrote a simple bash script to test the program and input a test case file, Output the test cases and results that fail the test and save the results to the

The reason is that the client character set is not set during the export, or the settings are incorrect. It's okay to change it to DB.Check the character set (select userenv ('language ') from dual ;)The exported character set is SIMPLIFIED

SQL % found, SQL % notfound, SQL % rowcountWhen executing the DML (insert, update, delete) statement, you can use the following three implicit cursors (the cursor is an area in the memory that maintains the query results, which is opened when DML is

PostgreSQL tutorial (10): Performance Improvement tips and postgresql Performance Improvement 1. Use EXPLAIN: PostgreSQL generates a query plan for each query, because selecting the correct query path has a critical impact on performance. PostgreSQL

Mysql data backup and recovery, mysql backup and recoveryBackup/recovery policies:1. Regular mysql backup and recovery time that the system can afford should be taken into consideration.2. Make sure that mysql opens log-bin. With binarylog, mysql

Summary of index, foreign key, and field syntax maintenance for mysql, SQL Server, and oracle databases, and SQL Server oracle Summary of index, foreign key, and field syntax maintenance for mysql, SQL Server, and oracle databases  1. MYSQL database

Newlisp tracks jobtracker status, newlispjobtracker The basic idea is to use newlisp to regularly download the jobtracker page, use regular expressions to parse the table elements in html, and then obtain the latest mapreduce status. Each time the

This article mainly introduces what is DB2 database partition and why database partition is used. The following uses Balanced Warehouse E7100 as an example to introduce the basic methods and application practices of database partition management. DB2