Database Administrator

Oracle, as a large database, is widely used in financial, post and telecommunications, power, civil aviation, and other important sectors with a large data throughput and a wide spread of computer networks. For system administrators, it is

7. Change the MySQL directoryThe default data file storage directory of MySQL is/var/lib/mysql. To move the directory to/home/data, perform the following steps:1. Create a data directory under the home DirectoryCd/homeMkdir data2. Stop the MySQL

1. Install the cross compiler on a PC with a Linux operating system. I use Moxa tool chain for DA66x (the same is true for other embedded Linux systems ), you can download it from the Moxa Website:2. Download the ACE package to a Linux PC and

A friend called me a few days ago and asked me to help test their servers. After scanning, I found that SQL Server SA was empty and decided to use this vulnerability for penetration testing. After testing, we found that the Stored Procedure

I haven't written anything for a long time. On these days of work, I got some methods to install Mysql. This method can install multiple Mysql on a Linux service at the same time. The source code of mysql. the serial number is mysql-5.0.20a.tar.gz.

How to run Oracle commands in SUSE Linux:Suid/guid:Non-Oracle users are required to run oracle commands such as sqlplus. Solution:If you want to set s u I d, set the one before the corresponding permission bit to 4; if you want to set g u I d, set

Installation environment: Ubuntu 7.10 and Oracle 10.2.0 Enterprise I. Check hardware requirements and memory hard disk requirements.Memory 512 M, swap partition 500 M 2. Install the required packageSudo apt-get install gcc make binutils lesstif2

In Windows, the ui programs of the Oracle client include toad and pl/SQL developer. in Ubuntu Linux, all of them are lost. Fortunately, oracle officially has SQL developer, which supports multiple system platforms at the same time and supports mysql,

Oracle plans to release 41 security patches on Tuesday as part of the quarterly severe Patch Update (CPU. These patches fix dozens of severe vulnerabilities in its products. In Oracle's patch release notice, the CPU includes ten new security

Debian 6 sets Oracle 11g R2 to automatically start upon startup Log On with the root account. Step 1: Modify/etc/oratab Orcl:/home/oracle/product/11.2.0/db_1: Y Where Orcl: sid /Home/oracle/product/11.2.0/db_1: db_home Y: Start Y (yes) or N (no).

RedHat 5.8 install Oracle 11gR2_Grid Cluster 1. Install the corresponding software package through rpm: Rpm-ivh binutils-2 *. i386.rpm Rpm-ivh binutils-2 *. x86_64.rpm Rpm-ivh compat-libstdc ++-33-* I * Rpm-ivh compat-libstdc ++-33-x * Rpm-ivh

Some users asked this question: How do I escape the @ symbol in the password during the export operation?Because the default Oracle will parse the strings after the @ symbol as the service name, it will not work without processing.Some enterprises

Using shell scripts to monitor and manage Oracle databases will greatly simplify DBA workload, such as common instance monitoring, monitoring, and alarm log monitoring, and database backup, AWR report automatic mail, etc. This article describes how

Oracle uses Incomplete Database-level recovery to solve the logical errors caused by data loss or human error before 10 Gb. After 10 Gb, RMAN introduces a new feature called "tablespace point-in-time recovery", TSPITR for short, which can actually

Today, at, I ran to CICC to check the data and found that the archive of the Library (11gR2 RAC, 4 nodes under AIX6.1) was full recently. I ran to ask the middleware buddy who had arrived in advance, no exception was found ...... It's just a bit

Instance recovery is used to recover failed instances or failed instances in the parallel server environment, therefore, instance recovery can refer to both crash recovery and instance recovery in the parallel server environment (one or more failed

Oracle Stored Procedure refresh materialized view SQL: Create or replace package body REFRESH_MVIEW IS -- Author: 241433-- Created: 4:25:04-- Purpose: This PKG is for REFRESH MVIEW -- Public type declarationsCONS_BCR_LIST VARCHAR2 (40): =

My system is Ubuntu 12.10 First, add the key: Apt-key adv -- keyserver keyserver.ubuntu.com -- recv 7F0CEB10 An error occurs as soon as it comes up: Executing: gpg -- ignore-time-conflict -- no-options -- no-default-keyring -- secret-keyring/tmp. PJ6

Simple setup of master-slave MySQL 192.168.190.128 "====" 192.168.190.129Master ---- slaveSlave ---- master 1. Configure the my. cnf file on the master 128 and add the following parameters:Server-id = 1Log-bin = mysql-binLog-salve-updatesSync_binlog

The username and password used for installing Oracle are not remembered. Don't worry. Open sqlplus. Follow these steps to create a login user: Step 1: Use sys to log on to sys/password as sysdba. Any character of the password can be logged