Database Administrator

To install phpMyAdmin, record the following points: Install phpMyAdminDecompress the package to/var/www.Configure ApacheListen 8030.DocumentRoot/var/www/phpMyAdmin Cp config. sample. inc. php config. inc. phpVi config. inc. phpModify the following

(1) When the header file mysql. h cannot be found,Cd/usr/include/mysql/Cp */usr/include/ (2) When undefined reference to 'mysql _ init' occurs,It is best to use # gcc-o test. c 'mysql _ config -- cflags -- libs'Other compilation commands: # gcc-o

Environment Description: Operating System: CentOS 5x86Database: Oracle 10.2.0.1 non-RAC EnvironmentASM instance name: + ASM Refer to metalink node: 311350.1 1. Check the process of the ASM instance. Www.bkjia.com @ oracle [/home/oracle]> ps-ef |

Modify the database character set to ZHS16GBK.View server character setsSQL> select * from V $ NLS_PARAMETERS;Modify:$ Sqlplus/nologSQL> conn/as sysdbaIf the database server has been started, run SHUTDOWN IMMEDIATETo shut down the database server,

1. select d. id, d. outer_code from dict_depts_source d order by outer_code (view duplicate data) 2. select d. id, d. outer_code, row_number () over (partition by outer_code order by outer_code) row_flag from dict_depts_source d (identifies

DBWn: the Database Block Writer is responsible for the background process of writing dirty blocks to the disk. CKPT: The Checkpoint Process is only the header of the file for updating the data file to assist in creating the Checkpoint Process (DBWn )

1. update (select...) set column1 = column2; Update (select iy. company_name company_name1, cc. company_name_jc company_name2From income_year_item iy, city_company ccWhere iy. company_code = cc. code)Set company_name1 = company_name2; 2. Only one

Create a listening port (using Oracle Net Configuration Assistant and Oracle Net Manager to create and start using commands. Both methods have been tried ). Create a local service name and use tnsping. However, when creating a service name, the

OracleProblem description:The following error occurs when you connect to the oracle 10.2.0.1.0 database using jdbc today:Connection refused (DESCRIPTION = (TMP =) (VSNNUM = 153093120) (ERR = 12505) (ERROR_STACK = (ERROR = (CODE = 12505) (EMFI = 4 )))

Task: grant the select permission (or insert permission) of all userA tables (or views) to userB. Basic Idea: Log on With usera. select 'Grant insert on' | table_name | 'to userb;' from user_objects; to execute all generated SQL statements. Of

In the Execution Plan, the CARTESIAN cartesian Product sometimes appears. Simply put, What Is CARTESIAN? There are two sets. Any member of each set must be associated with any member of another set... below are some experiments on cartesian: SQL>

Oracle Database partitioning is an important means and method for optimizing the performance of Oracle databases. Before doing the project at hand, I only heard the name of an over-area, when I was talking about it at a seminar, I told myself that I

ORA-03111 error, causing system failure Symptom Description: The system reports a "java. SQL. SQLException: ORA-03111" error at runtime. Problem Analysis: Locate the fault code in metalink. Document No. [ID 1219453.1] is similar to the customer's

Use dbms_stats or analyze Since Oracle8.1.5 introduced the dbms_stats package, Oracle and experts have recommended dbms_stats to replace analyze. The reasons are as follows: 1. dbms_stats can be analyzed in parallel. 2. dbms_stats has the automatic

InOracleIf the modification operation is submitted incorrectly,Then you want to view and modify the original value.,In this case, you can use the query to flash back.(Query flashback ). You can query the flash back based on a time value or a

The Gentoo Linux operating system (pronounced/mongod zookeeper ntu kernel/) is a Linux meta release version based on the Portage package management system. This project and its products are named after the babaya penguin. The Gentoo package

MySQL always reports an error, saying that the sock file does not exist. There are several methods on the Internet to change the permissions and change the configuration file. The. sock file still cannot be generated normally. No way. Delete and

I recently learned about the MySQL cluster and found that there are many methods for MySQL clusters. The following describes the MySQL Master Slave configuration. The MySQL Master Slave is literally understood as a relationship between the Master

OracleTablespace (TableSpace), Segment (Segment), Disk Area (Extent), Block (Block).OracleThe allocation unit used to save database objects SegmentIt is a database object that consumes storage space, such as tables, indexes, and rollback segments.

Today, it is also a strange idea. MySQL verifies that varchar (15) will save 15 Chinese characters, and the first 15 will be automatically intercepted if the number exceeds 15. This concept may come from SQL server. In the varchar type, Chinese