Database Administrator

Oracle Database is one of the most complex databases so far. This complexity allows Oracle databases to meet various requirements of enterprises. However, most of the time, the database administrator has some skills to simplify database maintenance.

The Listener. ora and tnsnames. ora files are often difficult to use due to format issues. I have configured and kept a backup, and I will copy it and modify it later! Hey ~~~ Because Linux is usually used in many cases, sometimes you may encounter

Notes for installing Oracle 11G in Ubuntu 9.04:(1) Oracle does not support Ubuntu and is related to the Linux kernel version,(2) Pay attention to conflicts between Oracle and local JDk and Chinese garbled characters.Local parameters:(1) Ubuntu

At the recent Oracle OpenWorld 2009 Conference, Oracle released the latest server virtualization product Oracle VM 2.2, they also said that their users will be able to use this product to accelerate deployment and simplify the management of

The authoritative eWeek test shows that MySQL 4.0.1 is comparable to Oracle 9i. EWEEK Labs/PC Labs can be said to be the leader in Benchmark Testing. As early as October 1993, their sister Magazine PC Magazine did the same test. This cooperation

To install MySQL in Ubuntu, run the following command at a terminal prompt: Sudo apt-get install mysql-server Sudo apt-get install mysql-client Sudo apt-get install php5-mysql // The installation php5-mysql is to connect php to mysql Once the

1. MySQL compilation and installation in Linux:(1) ../depcomp: line 571: exec: g ++: not foundMake [1]: *** [my_new.o] Error 127Make [1]: Leaving directory '/home/justme/software/mysql-5.1.30/mysys'Make: *** [all-recursive] Error 1This problem

A strange problem occurred when importing a data from an Oracle database. Chinese characters are garbled. First, you can confirm that the data in the database exists in Chinese, and that the data is also in Chinese when you use Toad for connection

The business description is as follows: When inserting a table under Oracle, you must update the value of another field based on the value of one field. Of course, it can also be implemented through a program, but this field is only used for data

This article uses the migration method to migrate and upgrade the database from 10 Gb to 11 GB. Recommended reading: Clone an Oracle EBS Database User-managed database clone RMAN-based database cloning on the same machine RMAN duplicate Database I.

Install MySQL-server-5.6.13-1.el6.x86_64.rpm under RedHat 6.3 First, download the following three files: MySQL-client-5.6.13-1.el6.x86_64.rpmMySQL-devel-5.6.13-1.el6.x86_64.rpmMySQL-server-5.6.13-1.el6.x86_64.rpm Then use the root account to log in

When you want to access data in another database table across local Oracle databases, dblink of the remote database must be created in the local database, dblink allows you to access data in a remote database table just like a local database. The

Oracle's online help system is implemented through the ystem. help table, which stores SQL information in Oracle. First, use the system user to log on to sqlplus, oracle Training Run select count (1) from system. help; There are only over 900 things,

Mysql Cluster Overview The most significant advantage of MySql Cluster is high availability, high real-time performance, high redundancy, and high scalability. It allows you to deploy the Cluster of the "in memory" database in a non-shared system.

Environment: AIX 6.1, Oracle11g ASM After the ASM instance is installed and started properly, the ASM disk group can detect it. Oracle software is installed normally. Then, when creating a database in DBCA, select the ASM disk until the file storage

Today, when migrating the zabbix database, a shared tablespace cannot be released. because mysql uses the innodb Storage engine by default, when a large data volume is deleted, because of the Force interruption, the shared tablespace cannot be

The following problem occurs during spfile creation or nomount: SQL> create spfile from pfile;Create spfile from pfile*ERROR at line 1:ORA-01078: failure in processing system parametersLRM-00123: invalid character 158 found in the input file

For an Oracle database user, a table must be read/write controlled and can only be read and written, but cannot be deleted or modified. Developers start to want to implement it with user permissions. After some discussion, it is inappropriate to

Previously, the Department used the transform to implement row_number. I think it is more convenient to use it after UDF implementation, eliminating the hassle of the transform syntax. The test table used is: Hive> desc row_number_test;OKId1 intId2

I. Preparations before installation (1) Before installation, see to learn about the installation and configuration of the Postgresql database. (2) create a bandwidthd-pgsql account to log on to the Postgresql database Root @ Ubuntu :~ #