Database Administrator

Installation File mysql-gui-tools-5.0r11.tar.gzTo setup mysql-gui-tools:Get root right to do it!Shell> tar zxvf mysql-gui-tools-5.0r11.tar.gzShell> cd mysql-gui-commonShell>./configureShell> makeShell> make installShell> cd

Today, I learned from the official MySQL website that MySQL announced the closure of the Enterprise Server Source code, which is a heavy blow to open source enthusiasts. Although free users generally only use MySQL Community Server (open-source free

1. What is MySQL?MySQL (pronounced "My Ess Que Ell") is a multi-user, multi-thread SQL database Server developed by Tcx (http://www.tcx.se. MySQL aims to be fast, stable, and easy to use.MySQL can be obtained in this http://www.mysql.net.

I. IO sched is a method used by the operating system to determine the order of IO operations submitted on Block devices. There are two purposes: Improving IO throughput and reducing IO response time. However, IO throughput and IO response time are

1. OS and DB versions DB Version: 9.2.0.6 OS Version: HP-UXiasd5_pb B .11.23 U ia64 0515426764 unlimited-user license2. alert log Thu Oct11 18:14:17 2012 Errors infile/Oracle/product/9.2.0/rdbms/log/ingwdb_ora_17366.trc: ORA-07445: exception

In database security configuration, security reinforcement is required. To ensure database security, however, sometimes, after improper operations or database business account password modification, the configuration of database connection for the

After the active data guard is deployed, the read-only query can be handed over to the standby database for execution, and the routine database backup work can be performed on the standby database to relieve the pressure on the primary database,

The purpose of setting unused is to use the unused flag to delete the unused when the cpu, memory, and other resources are insufficient. After setting the unused column, the column data is not deleted immediately, but hidden physically. The recovery

1. Oracle cannot be started because of reduced memory Last login: Sun Nov 4 15:09:06 2012 from 192.168.5.222[Oracle @ h1 ~] $ Sqlplus "/as SYSDBA" SQL * Plus: Release 11.2.0.1.0 Production on Sun Nov 4 15:26:59 2012 Copyright (c) 1982,200 9, Oracle.

Backup is a top priority for DBAs. No matter how powerful your technology is and there is no backup, you are still helpless when something goes wrong. Here is just the BACKUP command summarized in the work. The scripts collected in the future will

Today, when sqlplus is used ========================================================== ======== ERROR:ORA-28002: the password will expire within 7 days ========================================================== ======== The system prompts that the

1. Use the create or replace view command to create a view Syntax format: Create or replace view name As select query clause Example: Create or replace view tb_user_view1 as select count (username) shuliang, username from tb_user group by username

Today, when installing Oracle 10g on Windows XP, there was no problem when installing Oracle software, but when DBCA database creation, there was a "ORA-12638: Credential retrieval failed" error. The reason is that Oracle cannot apply operating

Use filesperset to control the size of a backup set When the filesperset parameter is specified, rman compares filesperset with the automatically calculated value (for the number of files in each allocated channel) And take a smaller value to

Oracle Net trace is used to track or debug oracle connection failures, abnormal disconnection, connection timeout, and other situations. It generates detailed tracking information to analyze and diagnose Oracle Net-related faults. Network debugging

After installing the asm rpm package today, the last step of configure always fails when running/etc/init. d/Oracleasm configure: [Root @ localhost nick] #/etc/init. d/oracleasm configureProcessing the Oracle ASM library driver. This will configure

In this case, the root password of MySQL is lost. To restore it, let's talk about the environment first: Red Hat Enterprise Linux 6.3 x86_64 MySQL 5.5.28 According to your previous experience, modify my. cnf: Add skip-grant-tables in [mysqld],

Before Oracle 11g, we can create pfile from spfile or use pfile to create spfile. In Oracle 11g, spfile management is enhanced. You can use memory to create pfile and spfile. Syntax: Create pfile [= 'pfile _ name'] FROM {SPFILE [= 'spfile _ name']} |

Sometimes we have such an application. In SQL left join, we need to make a column with a NULL value not return NULL, but a specific value, such as 0. At this time, using is_null (field, 0) will not work, and an error will be reported. It can be

How Does Oracle query the complete definition statement of an object? Syntax: DBMS_METADATA.GET_DDL (Object_type IN VARCHAR2,Name IN VARCHAR2,Schema IN VARCHAR2 default null,Version IN VARCHAR2 DEFAULT 'compuble ',Model IN VARCHAR2 DEFAULT 'oracle ',