Database Administrator

Because Red Hat enterprise linux 5 comes with a mysql, When you install a new mysql, an error is prompted, such:Error: Failed dependencies: MySQL conflicts with mysql-server-5.0.77-4.el5_4.2.i386 Rpm-qa | grep mysql can see the installed mysql.

Oracle functions (search character positions in strings (full-width Calculation of 1 character )) INSTR (C1, C2 [, I [, J]) [Function] searches for a specified character in a string and returns the location where the specified character is found;

The installation documents for a single Oracle instance are everywhere on the Internet, and there are also some good articles. In fact, the best installation documentation for oracle is the online manual, but the installation steps of the manual are

After MySQL is compiled and installed, it cannot be started properly. Example: Prompt 'can't connect to local MySQL server through socket '/tmp/MySQL. sock' I have read that this file does not exist, but if MySQL is started properly, it should be

The installation of python-mysqldb in CentOS took three hours. The strange problem was that python setup. py build had a lot of garbled characters. If you see a friend on the Internet who has encountered the same problem, post it and share it with

The syntax of the SELECT... for update statement is as follows:SELECT... for update [OF column_list] [WAIT n | NOWAIT] [skip locked];Where:The OF clause is used to specify the columns to be updated, that is, to lock specific columns on the row.The

By default, Oracle sqlplus cannot start the execution of analysis plans and statistics execution efficiency. To start the following functions, you only need to take a few steps: 1. log on to the system using the sysdba role of the sys user. 2:

Required packages: Php5-mysql # php can contact the database after installation Php5-common Php5-cli # Need to execute php script Mysql-server Start installation: Download the latest mysar package Tar zxvf mysar-2.0.6.tar.gz-C/usr/local #

I. Preparations Note: because it is installed on a server that already exists and has been used by multiple parties, you must first confirm whether Mysql has been installed on this Linux server. 1. When groupadd mysql, the system prompts that mysql

Error message: Starting MySQL. Manager of pid-file quit without updating file. [FAILED]Vim install_mysql.shCHOST = "x86_64-pc-linux-gnu"CFLAGS = "-march = nocona-O2-pipe"CXXFLAGS = "$ {CFLAGS }"./Configure \"-- Prefix =/usr/local/mysql "\"--

Execute the following method immediately, and pass the current variable in with USING. EXECUTE IMMEDIATE'Begin'Work_Order_Req_Line_Util_API.Create_Po_Allowed (: requisition _,: line_no _,: release_no _);END ;'USING requisition_no _, line_no _,

This example is created based on ASMLib or a bare device. 1. Install the support packages required by asmA. Download the support package from the Oracle Website: hereB. Download the corresponding asm installation package based on the Linux

Since Oracle9i, Oracle is no longer simply a relational database management system. It adds a series of object-oriented features based on the relational database model. Oracle9i is known as object-oriented database. Oracle's object system complies

If the data is too large, we cannot directly assign values to the clob variable. In this case, we can use the dbms_lob.read and dbms_lob.write methods to read and write clob variables in stages. However, we should set up a cache for the clob

I. Oracle PL/SQL usage1. User ManagementDatabase System permission (DataBaseSystem Privilege) Database Object permission (DataBaseSystem Privilege) Oracle internal users Sys and System Create user: create user user_test identified by

Host OS: Win7 Virtual Machine: Virtual Box 4.3.6 Virtual Machine OS: Oracle Linux 5.1 _ x86_64 Database software: Oracle 10G 10.2.0.1 _ x86_64 Cluster software: 10201_clusterware_linux_x86_64.cpio.gz Database Upgrade Patch Set: 10.2.0.5.0 Linux x86-6

Configure Oracle lsnrctl and auto start 1. Set Host Name [Root @ www ~] # Cat/etc/sysconfig/networkNETWORKING = yesHOSTNAME = www.bkjia.com 2. Set the Host Name and IP address [Root @ www ~] # Cat/etc/hosts127.0.0.1 localhost. localdomain localhost4

The undo segment is in the manual management mode because the undo segment management mode is modified during the experiment. 1. view the undo segment statusSQL> col segment_name for a20SQL> col owner for a10SQL> col tablespace_name for a20SQL> col

When you look at the histogram of a field, you cannot see the values of high and low values. You need to convert the values as follows. SQL> SELECT column_name,Num_distinct n_d,Low_value o_low_value,Display_raw (low_value, data_type)

After establishing RAC on a virtual machine a few days ago, I tried to test the two functions of Oracle TAF (transparent application failover) and Server Load balancer. 1. Server Load balancer First, edit the tnsnames. ora file on the server and