Database Administrator

Due to work needs, I set Oracle Intermedia on HP UX And sortium to implement full-text search. It is currently in use. There are many problems and experiences in the setup process. This article is based on Oracle 8.1.6 and 8.1.7, and cannot be

1. Download the MySQL Installation File The following two files are required to install MySQL: [Root @ test1 local] # rpm-ivh MySQL-server-5.0.26-0.i386.rpm is: unzip Hat Enterprise Linux 3 RPM (x86) downloads, find the Server and Client programs

After several days of hard work, I finally installed Oracle11G FOR Linux. I started to install RS4.0 and downloaded several versions of Oracle10g, or Oracle and Linux were incompatible, either the inventory directory cannot be found, or the net

Oracle Database startup and shutdown Methods I. Several startup methods: 1. startup nomount is not installed and started. In this mode, execute the following commands: re-build the control file and re-build the database. Start the instance, that is,

The first upgrade is actually a bank production database, which is under heavy pressure and hard to work and has been prepared for a week. on that day, the Bank gave me five hours of time, which is really insufficient. no way, just stick your head

Environment: Ubuntu LinuxThe following methods have been tested by myself and can solve the problem of garbled characters in Ubuntu PHP inserting MySQL database. 1. Use utf8 for database storage as much as possible (modify/etc/my. cnf and add

The simplest solution to the MySQL Chinese encoding problem is: Modify the mysql configuration file/etc/mysql/my. cnf (in CentOS, It is/etc/my. cnf), add the following command under [client: Default-character-set = utf8 [Mysqld] Add the following

We need to debug the PL/SQL process to view the variable content. You can use the following method. Assume that the variable we want to view is output and the type is varchar2. 1. The most basic DBMS_OUTPUT.PUT_LINE () method.You can use DBMS_OUTPUT.

Oracle SQL Developer was often used for simple database operations on Windows PC. This is a JAVA application, and it should obviously be able to run on the newly installed Ubuntu 8.04. It was only installed today that it still takes some effort to

Common Oracle Installation errors in Linux: /Tmp/OraInstall2007-12-30_02-16-11PM/jre/1.4.2/lib/i386/libawt. so: libXp. so.6: cannot open shared object file: No such file or directory occurred .. The reason is: the graphical dynamic link library

The backup script should be redirected to the Log and saved so as to find useful information in case of an error. Optimization related to RMAN backup To back up data, follow these steps: 1. read data from the disk 2. process data blocks in memory 3.

Generally, you can determine whether a database is designed with a comparative specification from two aspects. First, check whether there are a large number of narrow tables, and second, whether the number of wide tables is small enough. If the two

Install, deploy, and start MongoDB in CentOS. 1. Download the installation package 32-bit Wget http://fastdl.mongodb.org/linux/mongodb-linux-i686-2.2.3.tgz 64-bit Wget http://fastdl.mongodb.org/linux/mongodb-linux-x86_64-2.2.3.tgz Decompress the

Apsaradb for MongoDB Preface I have always wanted to get started with the development of large data volumes. Recently I found NoSQL databases have significant advantages in relational databases, especially for processing massive data volumes. There

Data files in the UNDO tablespace are directly deleted from the OS, and the database has not been shutduwn, and UNDO needs to be restored. 1. The database is running normally; 2. rm-fundotbs02.dbf: the database runs without knowing it until there is

For DBAs, it is common to create table. Although this method is simple, negligence can easily lead to unexpected problems. I encountered such a problem a while ago. Because the original TABLE is cloned and the data is stored in different tablespaces,

Use PL/SQL to connect to Oracle without installing the Oracle client 1. Download a software named Instant Client Package from the Oracle website. This software does not need to be installed and can be used as long as it is decompressed. : Http://www.

It is not a labor-saving task. If your MySQL version is 5.1.7 and earlier than 5.1.23, you can use the following simple method:RENAME {DATABASE | SCHEMA} db_name TO new_db_name; However, this method is not reliable and may cause data loss. It is not

The syntax is as follows:# Mysqlslap [options] Common Parameters [options: -- Auto-generate-SQL,-a automatically generates test tables and data, indicating that the SQL script generated by mysqlslap is used to test the concurrency pressure.--

SQL> CLEAR SCREEN;# Create a database tableSQL> start e: \ SQL. SQL;18;The table has been created.SQL> select table_name, tablespace_name from user_tables;TABLE_NAME