Database Administrator

Recently, the system was changed from SUSE10.3 to. It looks pretty much better. However, my display is 19-inch wide screen. It takes a lot of effort to set the resolution of 1440x900 in 11.2. After the driver is installed, set the screen width

I. Introduction to Xtrabackup and backup principles: Xtrabackup is an open-source software developed by percona. It can quickly back up and restore mysql Databases and supports online Hot Backup (data read/write is not affected during Backup ), this

After mysql is installed in Linux, mysql is generally added to the Automatic startup list: Add/usr/local/mysql/bin/mysqld_safe -- user = mysql & This usually brings a lot of convenience to users, but my Linux system suddenly gets stuck when the

### Run the following content in the System shell--- Run the following content in Sqlplus with this Annotation### 1. Environment for obtaining Oracle usersSu-oracleCd/oracleSource. cshrc### Display the running status of Oracle10gRAC/crsCrs_stat-t###

Cause: the NLS_LANG parameter of the client connection is inconsistent with the NLS_CHARACTERSET In the DB. view the server parameters: Select * from nls_database_parameters t where t. parameter = 'nls _ CHARACTERSET'OrSelect * from v $

1. Download MySQL installation-free/binary software (No compilation required) File Format: MYSQL-VERSION-OS.tar.gz 2. Create a MySQL group, create a MySQL user, and add the user to the mysql group. (In Unix of different versions, groupadd and

1. Summary of Character Set and Export Import Problems First, ensure that the Oracle database server is consistent with the client character set to ensure data encoding consistency. When the database server selects ZHS16GBK, when exporting and

Generally, imp exp is used to back up and import data to the database. However, in some cases, it is necessary to flexibly retrieve data from two databases. Here I use the dblink method of or1c. First, the listener tnsnames. ora file can be

1. Download the 11g Release 1 (11.1.06) Linux installation package, 11.1.07patch Ii. Install Oracle Database 11.1.06 The installation must be performed on a non-root user; otherwise, an error occurs. Decompress the installation

How does one install the MongoDB database in Linux? Follow these three steps to install MongoDB in Linux. Read more: Install and start MongoDB in LinuxStep 1: download an object For 32-bit linux $ Curl

1. DUMP DatafileBlock example There are three types of SCN in a data block of Oracle: The Block header SCN, the CSC (cleanout SCN) and the commit SCN recorded in ITL. If we want to view the content of a block or some blocks, we can dump these blocks

Read Blob data through JDBC to demonstrate code ImportJava. io. File; ImportJava. io. FileOutputStream; ImportJava. io. IOException; ImportJava. io. InputStream; ImportJava. io. OutputStream; ImportJava. SQL. Connection; ImportJava. SQL.

I wrote an Oracle Conversion Function and found that the data cannot be converted when the data is negative, because the data stored in the front-end of the service is 32 bits. When JAVA is converted to the INT type with a signed character, A

1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order. 2. Try to avoid null value determination on the field in the where clause. Otherwise, the engine will discard

In Ubuntu 10.10, Qt is used to connect to the Mysql database. The detailed steps are described first. Step 1: Install the qt Development Environment

Finally, CentOS 6 was downloaded and installed on the virtual machine using Mini Desktop. VMWare-Tools installed Start installing Oracle 11.2 1. download the latest Oracle 11.2 installation package from the Oracle website. Because CentOS6 is

  ReateOr Replace TriggerTr_insert_emp BeforeInsert OnEmpForEach row Begin Insert IntoAValues(: New. empno,: new. ename,: new. job,: new. mgr,: new. hiredate,: new. sal,: new. comm,: new. deptno ); End;

Problem: execute a piece of code to reverse a string, which is to execute multiple SQL statements. How to make it pass in Oracle. I want to think about dynamic SQL. execute immediate is a syntax for parsing and Executing standard SQL statements. You

Many Oracle EBS developers have encountered how to submit a concurrent request in Form or PLSQL?It is actually relatively simple. For more information, see PLSQL. DeclareV_req_id Number;BeginFnd_global.apps_initialize (4394,505 93, 660, 0 );

Today, we demonstrated the switching process between switchover and failover on the virtual machine. The customer is concerned with failover. We directly turn off the virtual storage switch to simulate array faults. Failover steps are as follows: 1.