Database Administrator

I. Installation of LINUX1. RedHat AS4 system installation:Disk Partition Note: SWAP space is twice the memory size.The basic network configuration is based on local network conditions.Host Name: linuxsvrBasic Firewall Configuration:⊙ No firewall⊙

MySQL transaction processing Learning Start transaction, COMMIT, and ROLLBACK syntaxStart transaction | BEGIN [WORK]COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE]ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE]Set autocommit = {0 | 1} The start

1. Remove the original MySQL database 2. restart the computer; 3 In windows:Open the command line window and stop MySQL service: Net stop mysqlStart MySQL, usually to the installation path of MySQL, find the mysqld-nt.exeRun: mysqld-nt --

1. After mysql is installed in Linux, the default value is: case-sensitive for table names, not case-sensitive for column names; 2. log on to the/etc/my. add lower_case_table_names = 1 after [mysqld] In cnf and restart the MYSQL service. The

I checked the shell script $ Oracle_HOME \ bin \ dbstart and found a bug. He thinks PFILE =$ {ORACLE_HOME}/dbs/init $ {ORACLE_SID }. ora, but after oracle9i is installed by default, the init $ ORACLE_SID.ora file is not in the $ ORACLE_HOME/dbs

Use the show status Command Meaning:Number of times the aborted_clients client has been disconnected illegallyAborted_connects connection failure countThe number of times the com_xxx xxx command is executed. There are manyNumber of connections from

Many people may have this experience: clearly all systems are set with UTF-8, but with phpMyAdmin to see the database, found that the text is still garbled. If this happens, because although mysql itself and the webpage are both UTF-8, xoops uses

Learn how to use RIA Framework Flex to create a MySQL management UI The emergence of PHPMyAdmin shocked the industry, and there is no doubt. It is of course the best PHP-based application, because it changes the MySQL management interface from the

1. Download the source code package Download To http://dev.mysql.com/downloads/mysql/6.0.html in mysql-6.0.0-alpha.tar.gz 2. Create a user group and user group for mysql Groupadd mysqlUseradd-g mysql 3. Compile and install mysql Cp mysql-6.0.0-alpha.

Any database may have certain security risks during its long-term use. For database administrators, a complete set of database backup and recovery mechanisms should not only be intended for the secure operation of computer operating systems. When

The following error occurs when you use dbms_output.put_line to output the statement: Begin user_priv (username => 'hr'); end; ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytesORA-06512: at "SYS. DBMS_OUTPUT", line 32ORA-06512: at "SYS.

Oracle 10G R2 can be installed in the following versions of Linux: Oracle Enterprise Linux 5 (OEL5) Oracle Enterprise Linux 4 (OEL4) Red Hat Enterprise Linux 5 (RHEL5) Red Hat Enterprise Linux 4 (RHEL4) Red Hat Enterprise Linux 3 (RHEL3) Novell SUSE

It is much easier to write a long script than to use other views. It is said that it can be used from Oracle 7.x to 11g. Sm $ ts_used & sm $ ts_free Idle> select * from sm $ ts_used; TABLESPACE_NAME

For DBAs, you often encounter database upgrades or apply patches, and sometimes need to run a large number of scripts. For these operations, we want to output files simultaneously on the screen for subsequent steps or errors that have been lost

Chapter 1: configure the experiment environment The experiment environment is implemented using virtual box virtual Machine Software. The steps for installing the operating system are ignored... 1.1 server operating system: 1.2. Oracle software

For rownum, it is the number of the row returned from the query that is sequentially allocated by the Oracle system. The first row is allocated 1, and the second row is 2, this pseudo field can be used to limit the total number of rows returned by

The database is locked in the test environment today, and the database cannot be shut down through shutdown immediate, so I used ps-fu Oracle | grep ecds | awk '{print $2}' | xargs kill-9 to forcibly Delete All oracle processes. Now, when I enter

About setting the table to read only in Oracle Alter table test3 read only; This feature should be added from 11 GB, because an error is reported when it is executed in 10 GB: ORA-01735: Invalid alter table Option After the value is set to read

A control file is a small binary file that is part of the Oracle database. It is used to record the database status and physical structure.Each database must have at least one control file, but it is strongly recommended that more than one control

An error with ORA-01157 and ORA-01110 reported at Oracle startup today SQL> startup mount; SQL> alter database open; RA-01157: unable to identify/lock data files 10-see DBWR trace files ORA-01110: Data Files 10: 'd: \ ORACLE \ ORADATA \ ORCL \ USERS0