Database Administrator

The 21st century is the century of information, and the competition of comprehensive national strength is, to a large extent, the competition of information utilization. In recent years, with the proposal and implementation of the "digital earth"

This article describes how to use PHP4 to connect Oracle8i in a Linux environment. 1. Download and install Oracle 8i for linux. Complete installation. Do not only install the client. 2. Download The PHP3 or PHP4 source code. 3. Configure PHP

When I was managing a technical consulting company, I heard some reasons for not using MySQL. Although many reasons are due to misunderstanding, there are indeed some reasons for not using MySQL. Of course, the actual situation may vary depending on

Password Complexity is an important aspect for IT auditors to check whether a system is secure.IT policies often point out that the password should have a minimum length and contain a mix of uppercase letters, lowercase letters, numbers, and special

Check the Rman backup log in the early morning and find an error. The error is as follows:RMAN-00571: ========================================================RMAN-00569: ========= error message stack follows ============RMAN-00571: ==================

Some work needs to be done after installing msyql using the mysql binary installation package1. Set the password/usr/local/mysql/bin/mysqladmin-uroot-p password newpassword2. Copy the startup script/usr/local/mysqlsupport-files/mysql. server

PhpMyAdmin is a MySQL management tool. Through this program, you can directly manage MySQL from the web without running it on the system. Installation steps: 1. Obtain the archive ftp://ohaha.ks.edu.tw/pub/source/php/phpmyadmin_2.0.5.tar.gzor Ftp: //

Environment: S/390 or zSeries; Linux for S/390Problem: when installing DB2 for Linux/390, you need to add three user groups: db2iadm1, db2fadm1, and db2asgrp, and add db2inst1, db2fenc1, and db2as respectively. In this case, you may encounter

(1) Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.(2) Start-> Program-> Oracle-OraHome81-> Oracle Installation Products-> Universal InstallerUninstall all Oracle Products(3) Run regedit, select

I have installed Ubuntu7.10 Server Edition and desktop edition. The server version directly configures the LAMP server and the desktop version. I use the new software Manager-edit-to use the Task Group tag software package. Select LAMP for

A Linux server needs to start multiple data instances, such as DB1 and DB2. Method:Export Oracle_SID = DB1Sqlplus '/as sysdba' Exit! Export ORACLE_SID = DB2Sqlplus '/as sysdba' Exit! For different listening ports, the method for starting the

DBLINK details 1. Create dblink Syntax: CREATE [PUBLIC] database link link Connect to username identified by password USING 'string string' Note: 1) permission: The account used to CREATE a database link must have the system permission of create

Consistent reads are generated when SQL statements are executed. What is logical read? The process in which the cpu reads these blocks in the memory is called the consistent get. The IO generated during the reading process is the logical IO. cpu

This morning, the middleware service was congested in the production service, and the query results of a history table were found to be very slow. Further, the hash partition index of the table was invalid, it is in the "UNUSABLE" status and the

1. view the current File System[Root @ hp173/] # bdfFilesystem kbytes used avail % used Mounted on/Dev/vg00/lvol3 204800 154080 50384 75%//Dev/vg00/lvol1 298928 83696 185336 31%/stand/Dev/vg00/lvol8 2613248 1010056 1592040 39%/var/Dev/vg00/lvol7 2359

Management of ASM (Management of Shared disks)1. Manage the ASM in instance mode. Before starting the database, you must first start the ASM instance. After the ASM instance is started, the ASM disk is mounted.--------- Install the ASM management

Not long ago, because the developer truncate an important table, he found us and made an exception recovery to restore the table.The following is an experiment I did on the vm afterwards. It is completely replicated. Of course, you can also set the

Script file:Backup. shRq = 'date' + % Y % m % d % H % m''Su-Oracle-c "exp zjhk/zjhk_123 owner = zjhk file =/home/oracle/zjhk _ $ rq. dmp" Cron is a linux scheduled execution tool that can run jobs without human intervention. Since Cron is a built-in

In the execution of related SQL statements, the process in mysql is prone to some words similar to file temp, which tells us that our host SQL adopts file Sorting and other operations, this may greatly affect the efficiency of the result set to be

The Oracle Database software provides the following two scripts to configure automatic Database startup and shutdown with the server:[Oracle @ prod bin] $ pwd/U01/app/oracle/product/11.2.0/db_1/bin[Oracle @ prod bin] $ ls-l dbs *-Rwxr-x --- 1 oracle