Database Administrator

Install MySQL Sudo apt-get install mysql-server This should be very simple, and I don't think there is much problem with the installation, so I will not talk about it much. Let's talk about the configuration below. Configure MySQL Note: In Ubuntu,

Connect to ORacleError:ORA-09817: Write to audit file failed.   [Oracle @ qs-dmm-rh1 dave] $ sqlplus sys/oracle as sysdba; SQL * Plus: Release 10.2.0.4.0-Production on Thu Mar 17 16:35:02 2011 Copyright (c) 1982,200 7, Oracle.All Rights

I. Oracle Database default tablespace settings DBAs often encounter such a headache: they do not know who created a user in Oracle and did not specify the default tablespace for this user, therefore, this user will use the default tablespace-system

Oracle join usage Join) T1 {[INNER] | {LEFT | RIGHT | FULL} [OUTER]} JOIN T2 ON boolean_experssion {[INNER] | {LEFT | RIGHT | FULL} [OUTER]} JOIN T3 ON boolean_experssion ..... T1 {[INNER] | {LEFT | RIGHT | FULL} [OUTER]} JOIN T2 USING (join colunn

The main content of this article is as follows: 6.1 Introduction 6.2 create a function 6.3 stored procedures 6.3.1 creation process 6.3.2 call a stored procedure 6.3.3 AUTHID 6.3.4 PRAGMA AUTONOMOUS_TRANSACTION 6.3.5 procedure 6.3.6 deletion process

************* ************* I. Role of master and slave: 1. It can be used as a backup method. 2. read/write splitting to relieve the pressure on a database II. Environment: OS CentOS5.5 DB MySQL5.5.3-m3 To install CentOS5.5, see Install

If you want to restore a database on a colleague's machine to your own machine, the DMP file provided by the colleague cannot be used. I suddenly thought of Oracle 10 Gb, and I was still in the Oracle 9I stage. Back up again with your own 9I client,

Overview To install Oracle 10.2.0.5, you must first install 10.2.0.1. The installation sequence is 10.2.0.1-> 10.2.0.5-> EM patch-> Create an instance-> fix EM Chinese garbled characters-> Create auto-start 1. Install the rpm package Nano/v. sh Copy

I. Check the memory and swap spaceOracle claims that the installation of Oracle10g Database in Linux requires at least MB of memory and at least 1 GB or two times of memory swap space. For servers with a system memory larger than 2 GB, the swap

Recently I want to review oci programming. In the past, Oracle client was required to build an oci development environment in the development environment. Very troublesome. Since instant client is recommended for oracle, try it. Last night. Record

There are three main types of data changes in the database: insert data (Insert), Modify data (Update), Delete data (Delete). These operations are commonly used by developers. This chapter briefly introduces these operations. The main contents of

1. When installing Oracle, the installation path and Source Path must both be in English. 2. When Oracle JDBC is used in the example, the following conclusions are drawn after the solution is met: Classes12.jar-for Java 1.2 and 1.3Ojdbc14.jar-for

Recently, I joined two project teams, FALABELLA and FM, to support Oracle DB. Because the project is in the development stage, there are always some database replication work. I compared several methods, it seems that the use of EXPDP/IMPDP is not

To Test Database Synchronization on the goldengate heterogeneous platform, you need to test data synchronization between MYSQL and Oracle. Therefore, this article introduces the process of installing MYSQL with source code. The installation process

Flashback is a feature provided by Oracle since 9i. In 9i, we use oracle to query data that has been operated in a table for a certain period of time, this feature is also called Flashback Query. In 10 Gb, Flashback has been greatly enhanced. Using

The following error is reported during database Logon:ERROR: ORA-28002: the password will expire within 7 daysThe default profile of Oracle before 11g has no restrictions on password expiration. in Oracle 11g, the default profile enables the

Introduction Hash table is one of the core structures of redis. In redis source code, dict. c and dict. h defines the hash structure used by redis. In this article, we will. c and dict. h. Because dict. the implementation of the separate chaining

# By default Redis does not run as a daemon. Use 'yes' if you need it.# Note that Redis will write a pid file in/var/run/redis. pid when daemonized.# Redis does not run as a daemon by default. You can modify this configuration item and use yes to

1. Applicable versionThe operation method is valid in Oracle GoldenGate-Version: 10.4.0.46 or later versions on any platform. 2. ObjectivesAdd a new table for data replication to the online Oracle GoldenGate environment. 3. MethodOracle GoldenGate

Install Oracle 11.1.0.6.0 in RedHat enterprise linux 6.1 Error prompted: OUI-18001: the operating system 'linux Version redhat-6.1 'is not support You need to change the change method. edit the file/etc/redhat-release and change Red Hat Enterprise