Database Administrator

1. Install jdk in Linux)We recommend that you download the binfile from the sun homepage. After running the file, you can create a java directory in/usr /. Commands in Linux Bin # Chmod + x j2sdk-1_4_2_04-Linux-i586-rpm.bin #./J2sdk-1_4_2_04-Linux-i5

Huang.bin.cn@live.cn original, reproduced please indicate the source. For more information about the installation process, refer to many articles on the Internet.--------------------------------------------------------HOST: ThinkPad T400Memory: 1024

The developers of the MySQL project team announced a new software version release model, which aims to create a more dynamic, accessible, open, and understandable development model. This means that the existing development mode will not be used in

Linux As4 single-instance Oracle system startup/shutdown script 1. Script namingScript Name: oracle. sh deployment Directory:/etc/rc. d/init. d Service list: RedHat service operation User: rootStart oracle command:/etc/init. d/oracle start close

Oracle performance has been optimized over the past few days and some information has been found online. Sometimes you need to export all the table, view, sequence, trigger and other information of a user. The following SQL statement can select the

Connect to Oracle today error: ORA-18008: can not find the OUTLN solution, the day before yesterday also used well, now no matter query any SQL statement or click list view will pop up the error prompt, busy for a while, finally, the solution is

Recent UAT database migration, because multiple databases need to be migrated to the same machine, after part of the completion, start the subsequent database encountered a ORA-27102 error, prompting that the memory exceeds, view the system

One of the important features of cmake is that it is independent from the out-of-source compilation function. That is, the compilation can be performed in another specified directory rather than the source directory, this ensures that the source

I. Glossary: 1: Server_uuid: Server ID. When Mysql is started for the first time, a server_uuid is automatically generated and written to the auto. cnf file in the data directory. It is not recommended to be modified. [Root @ mysql5_6 data] #

Practical Environment Introduction: Server Name IP System MySQL Odd.example.com 192.168.1.116 Rhel-5.8 5.5.16 Even.example.com 192.168.1.115 Rhel-5.8 5.5.16 Assume that the database to be

Generally, mysql requires backup. There are many backup methods. The following is an automatic backup of a remote database that I used in concert with a scheduled task. I. Confirm the backup solution: Backup Machine: ip192.168.8.51 Database Server:

Understanding of Oracle architecture ------- preliminary understanding First of all, the Oracle architecture has a system diagram, which I also understand. In fact, the architecture is the figure. To understand the architecture, you must understand

To test how to store video files in mysql DATA, we do not recommend that you store them directly, because migration is troublesome and prone to problems. The following is only a test function, importing jpg, png, and other images is similar. Create

1. Configuration Planning Name IP Listeners End Port SID Db_name Db_unique_name Service name   Host 127.0.0.1 Listener1 1521 Test1 Test1 Test1 Test1   Slave 127.0.0.1

(I) any query is annoying. As long as the query and MySQL are annoying, the fastest way to execute the query is not to execute Cache is king, such as Redis or memcache (Ii) Minimum query result set Try to query based on the primary key or

Installing Oralce on Linux is cumbersome. The preparations before installation are as follows: Read more: Install Oracle 10g R2 in CentOS 6.3 (x32) 1. Check whether the rpm software package has been installed. Binutils-2.17.50.0.6-6.el5Compat-db-4.2.

The Installation Method of MySQL 5.5 is slightly different from that of MySQL 5.1. The main difference lies in the configuration environment. For the installation method of MySQL 5.1, refer to build the LAMP environment (source code method ). This

A friend asked me to back up the database with exp at every night to a specified directory and automatically delete the data backed up one week ago, record and share the process only. For the case of Oracle automatic backup on Linux (using RMAN),

The process of using rman duplicate to create a slave database is much simpler. You do not need to manually create a slave Database Control File. Master database SPFILE *. Log_archive_format = '% T % S % r. arc'*. DB_UNIQUE_NAME = 'primary'*.

Backup and recovery are required for any database, which is of much importance and everyone understands. Mongodbalso describes the functions of tracing and restoration, which are the mongdump.exeand mongorestore.exe files downloaded by