Database Administrator

On the Internet, if sysv-rc-conf is used for configuration, or if S is changed to start with K, because 10.04 connects the MySql startup to/lib/init/upstart-job, and the latter calls/etc/init/mysql. the definition of boot in the conf file is a new

This article describes how to install and configure Oracle SOA Suite in Linux. The version of SOA Suite is 11.1.1.3.0, which is the latest version. Just like setting up an environment in the past two days, simply record the building process and

Oracle provides an interesting connect by clause, which can sort the branches with a family tree structure. It applies to the structure of organizations or companies, financial account code, and so on. To use query traversal, you need to store data

D jango's ORM has a very convenient function. It should also be said to be a very basic function. After you call save () to insert a model to the database, the created auto-increment id is synchronized to the current model. The default return value

Perform SQL tracking in Oracle. It is estimated that most of them will use autotrace in sqlplus or set 10046 tracking. However, if you are debugging an application system, especially the system that opens the connection pool, the above two methods

Oracle function (converts the entire string to uppercase) NLS_UPPER (x [, y]) [Function] returns a string and converts it to uppercase; [Parameter] x struct expression [Parameter] Nls_param (optional) specifies the sort method (nls_sort = ).

Keywords: Hongqi Asianux3 + Oracle 10g R2 for Linux x86-64 1. Receive a consulting phone number in the morning: Oracle cannot be started in Linux. We will try to solve the problem at the site in the afternoon. 2. After arriving at the site, learn

Oracle has five constraints. Primary key primary keys constraints, foreign key foreign constraints. Unique constraint, not null constraint, and check constraint. Remember: constraints are for a column. Check constraints: alter table temp add

1. hardware configuration instructions:The swap partition of Fedora 14 must have at least 2048 MB; otherwise, a warning is reported during Oracle installation.2. software requirements1) dependent software packages to be installed or upgraded.Make-3.8

1. Build the installation environment 1. Create an informix user group and user Log in as root, and then: Groupadd-g 3000 informix Useradd-u 3000-g 3000-d/home/informix-m informix 2. Modify Environment Variables # Su-informix # Cd # Ls- # Vi.

At work, we found that orcale time formatting is a little different from Java time formatting: For example, in Java, you can write a string in the format of time when the date is changed: SimpleDateFormat sdf = new SimpleDateFormat (); Sdf.

Environment: OS: rhel 6.3 _ 64bit DB: Oracle 10gR2 Level switching process: Master Database SQL> select protection_mode, protection_level from v $ database; PROTECTION_MODE PROTECTION_LEVEL----------------------------------------MAXIMUM

Oracle materialized view testMaterialized View is a special physical table. The Materialized view is relative to a common view. A common view is a virtual table, which has many application limitations. Any query of the view, Oracle, is actually

In the past, most of the company's projects were on version 5.5, and there was just a project (free trading platform) with a small amount of data. A single server ran stably online and rarely took over, in order to unify the version, I plan to

When using Oracle SQL * PLUS, SPOOL is really easy to use. How can we implement it in MySQL? The following is an experiment description. In MySQL, the tee parameter can be used in three methods: First, add the tee parameter to the my. cnf parameter

Take a look at the official description of slave_exec_mod. Command-Line Format --slave-exec-mode=mode Option-File Format slave_exec_mode System Variable Name slave_exec_mode Variable Scope Global

Flash back technology is usually used to quickly and easily recover logical errors such as misoperations in the database. The flash back method can be divided into database flash back, table flash back, and transaction flash back, based on the

1. Full backup database, and the Backup Type is specified as backupset RMAN> backup as backupset database; Starting backup at 13-FEB-14Using channel ORA_DISK_1..... 2. Back up the users tablespace again and specify the Backup Type as backupset. RMAN>

Fault symptom:Go to the slave server and run:Mysql> show slave status \ G.......Relay_Log_File: localhost-relay-bin.000535Relay_Log_Pos: 21795072Relay_Master_Log_File: localhost-bin.000094Slave_IO_Running: YesSlave_ SQL _Running:

1. OUI-10182 The valid tive user ID does not match the owner of the file .......... Solution: Use the root account to create the oraInst. loc file under/etc and write the following content: Inventory_loc =/u01/app/oraInventory (directory of