Database Administrator

1. Install CentOS 5.5 i386. All are installed by default. Disable SELinux and firewall. 2. Check the rpm package # Rpm-qa -- queryformat "% {NAME}-% {VERSION}-% {RELEASE} (% {ARCH}) \ n" | \ Egrep "binutils | compat-libstdc ++ | elfutils-libelf |

Solr in action Directory Part 1 first recognized SOLR 1 Solr Introduction 2. Getting familiar with Solr 3 Solr core concepts 4. Configure Solr 5. Create an index 6. Text Analysis Part 2 Solr core functions 7. Initiate query and processing results 8

PostgreSql Partition + Hibernate Insert, postgresqlinsert Unlike Oracle, PostgreSQL needs to manually control partition rule triggers. Step 1: Create a partition Create table table_partition_1 (CHECK partition_column criteria) INHENRITS (table)Step 2

Recently, we used tomcat and MySQL to build a Java Web server and deploy the game server logic on it.   Shortly after the game was launched, we found a large number of garbled characters in the database. This is a very serious problem and must be

The following error occurs during DG switching:   ORA-00274: illegal recovery option SEESION   Problem description: When I run the switch statement on the master database and then switch the slave database to the master database, this problem occurs:

OS & MySQL version and Configuration: MySQL Version: 5.6.19Linux Version: Linux boston.oracle.com 2.6.18-164. el5 #1 SMP Thu Sep 3 02:16:47 EDT 2009 i686 i686 i386 GNU/Linux   1. To DOWNLOAD the MySQL Installation Software, go to www.oracle.com to

List knowledge points about oprocd Oprocd is introduced by oracle in rac for fencing io In unix systems, if we do not use third-party cluster software other than oracle, The oprocd process will exist. In linux, The oprocd process is available only

Next, after the resolution of SCN problem, encountered ORA-600 [4194]/[4193] error.Fault symptom: An error is reported when you OPEN the database:ORA-00600: internal error code, arguments: [4194], [], [], [], [], [], [], [] 4193: indicates

In reports, duplicate data can be basically not displayed. How can we achieve the following in SQL? a10a20b30b40b50Shown: a1020b304050 The SQL statement is as follows: create table #a (part varchar(10),price int)goinsert into #a

1. Error description ORA-12801: error Signal issued in parallel query server P007 ORA-01722: Invalid Number 12801.00000-"error signaled in parallel query server % s" * Cause: A parallel query server reached an exception condition. * Action: Check

I mentioned hibernate integration when I learned about the database when I was learning Spring. However, I have almost no idea about hibernate technology, I only know that it is an orm object ing framework, so I will give a brief understanding of

12. You need to produce a report where each customer's credit limit has been incremented by $1000. InThe output, the customer's last name shoshould have the heading Name and the incremented credit limitShocould be labeled New Credit Limit. The

1. The current session is valid. Alter session set NLS_DATE_FORMAT = 'yyyy-MM-DD: HH24: MI: ss '; 2. Permanent Effect After the sys user logs in, execute the following command and restart the database to make it take effect. Alter system set NLS_

Preface supplement knowledge before classNumber (p, s)Number (p, s): Number type. p indicates the effective length of the Number (from the left 1st digits of the Number not 0Until the rightmost length. value range: 0 ~ 38 digits), and s indicates

Select count (*) from (select. * FROM (select cd. *, nvl (CV. SUM_CI_BALANCE, 0) as SUM_CI_BALANCE, nvl (CV. SUM_LN_BALANCE, 0) as SUM_LN_BALANCE FROM OCRM_F_CI_CUST_DESC CD left join (select cust_id, FR_ID, sum (CI_BALANCE) as sum_CI_BALANCE, sum

I recently used statspack on a 8i production database of the customer and found that alert has an error: Mon Jun 16 13:17:52 2014Errors in file/oracle/8.1.7/admin/prod/bdump/snp0_96626_prod.trc:ORA-12012: error on auto execute of job 304ORA-01631:

Possible causes and solutions for ORA-27302: failure occurred at: skgpspawn3 Symptom: Mon May 26 07:08:58 GMT + 08:00 2014 Process startup failed, error stack:Mon May 26 07:08:58 GMT + 08:00 2014 Errors in

No matter what materials you want to learn, or when you first get to know a system, what you want to learn is to understand the requirements. If the requirements are different, then your system will be completely invisible. Software Requirement

This error occurs because the host name and/etc/hosts file are inconsistent. You only need to write the host name and its IP address to the/etc/hosts file and then OK. Note that the name cannot contain underscores. In addition to modifying the

Although online index reconstruction (alter index index_name rebuild online) has extended the index reconstruction time, it has also given us the ability to recreate indexes online to improve data availability. If errors such as user termination or