Database Administrator

Tutorial on installing Oracle 10 Gb database on Linux Oracle Database software can run on almost all Windows/Unix operating systems. It is recommended that you learn to use it because of the ease of access and open source of linux systems. (RedHat 5.

After several years of research, I finally learned how to install the mysql Binary source code package in Linux, and finally solved ERROR 1045 (28000 ): access denied for user 'root' @ 'localhost, okay. Let's take a look at my installation

Basic MySQL Data Table operation 3: A comprehensive example of basic mysql operations 1. Create a database mysql> create database company;mysql> use company; Ii. Create a table 1. Create an offices table mysql> create table offices -> ( ->

NBU reconfiguration leads to unsuccessful recovery-link, NBU-Oracle of oracle and nbu[Root @ SsevendbS01 rman] # su-oracle [oracle @ SsevendbS01 ~] $ Rman target/Recovery Manager: Release 11.2.0.3.0-Production on Fri Sep 19 09:47:47 2014Copyright (c)

[Mongo] install and use PyMongo, mongopymongoInstall and use PyMongo Here is a simple installation and usage record. First, you must have an available mongo environment, either win or linux environment. Suppose you have some knowledge about mongo

A big and comprehensive choice between SQL and functions: Who is a more effective SQL ?, More effective SQL Reprinted please indicate the source: jiq •'s technical Blog Note that the Oracle11g database is discussed here. It is not applicable to SQL

Second, understanding database three paradigm, understanding database paradigm Understanding the database paradigm is of great help to design a rational database. Based on my understanding of the database paradigm and specific examples, this article

Explanation of a piece of Oracle GoldenGate (OGG) Transfer Process log (. rpt file), goldengate. rpt This article is original. For more information, see the source. Note: /U02/ggs/dirdat/sb is the name of the trail file formed by the source

An error occurred while installing MySQL in Linux: [Root@www.bkjia.com pub] # yum install MySQL-server-community-5.1.58-1.rhel5.i386.rpm Loaded plugins: product-id, refresh-packagekit, submodules-manager Updating Red Hat repositories. Setting

Atitit. java queue System and custom database-Based queue summary o7t and atitito7t Atitit. java queue System and custom database-Based queue summary o7t 1. Blocking queue and non-blocking queue 1 2. java. util. Queue interface, 1 3.

Next to Oracle Fusion Middleware I: database and RCU (SEE), this article describes the installation of Weblogic, UCM (WebCenter Centent), and WebCenter Portal. 1. Weblogic selects 10.3.6.0 and can be installed using the Installation File of

XML query in SQL SERVER: FOR XML specifies PATHPreface In SQL SERVER, you can specify RAW, AUTO, EXPLICIT, and PATH for XML queries. This article uses some examples to introduce the XML query of the specified PATH in SQL SERVER. PATH Parameter PATH

NoSQL (non-relational database)In short, a relational model refers to a two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and their relationships. The most common interpretation of NoSQL

Local name configuration: The local name can access the required database or server information with a simple name, and the information is saved to tnsnames. ora. LOCALNAME: local nameADDRESS: server ADDRESSPROTOCOL: PROTOCOL usedHOST: IP

The concept of SCAN (Single Client Access Name) is introduced in the Oracle 11g RAC cluster, that is, the Single Client Access Name of the cluster. SCAN provides a single host name for the client to access the Oracle database running in the cluster.

After an old DB2 database on the test machine stops the database normally, the sql1_2c error is reported when the database is started. The details are as follows: # Su-db2inst1   $ Db2start 2013-04-23 13:23:08 0 0 sql1_2c An unexpected system error

Part 1 Operating System -------- LINUX 1. redhat linux server 7.2 Installation1. Use the first REDHAT installation disk to boot from the CDROM Installation Guide2. Use the default installation language ENGLISH and add Simplified Chinese as the

The entire porting process is divided into three steps. 1. Copy the ORACLE and HMIS folders: If the original ORANT and HMIS folders are in the C: disk, the new system will be copied to the C: disk; the original files will be in the D: disk, and the

With the SQL Server event probe tool, you can use a captured trace to collect important information about the Server. With the Index Tuning Wizard, ITW, Index OPTIMIZATION Wizard, and correct general Index information, this trail can help you debug

First, place the file to be restored in the DATA file in ms SQL, and enter the ms SQL master database server. 1. We use the default method to create a database for recovery (such as MHDYF2005 ). It can be created in SQL Server. 2. Stop the database