Database Administrator

ORA-01157 in Oracle Database: unable to identify/lock data files Environment: SLES 11 sp1 + RAC 11.2.0.3.7 I am about to take a vacation. I checked the database and found that node 2 of the billable billingdb database has the following error:Fri Apr

How to locate and kill bad MySQL queries? Sometimes, the complexity of relational database systems will confuse you, but fortunately, using MySQL tools to manage queries can avoid these complexities. In this tutorial, I will show you how to find and

Solution to Oracle TNS-12535: TNS: Operation timeout System Environment: OEL6.5 _ x86 Database Version: Oracle 11g 11.2.0.3.0 Client environment: Windows 7 flagship edition x86_64 I. [fault symptom] After the "Oracle Client" is installed on the

View MongoDB replica set again Because MongoDB uses memory ing files, the 64-bit version is required. Official: http://www.mongodb.org/downloads Mongodb version used in the lab environment is mongodb-linux-x86_64-2.6.0 Built on three virtual

ORA-12514 error troubleshooting when connecting to Oracle Recently, Oracle 11 GB in windows has been used for testing. ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor I searched the internet

Besides, table_id in MySQL Background]Recently, a master-slave data inconsistency occurred in an online instance, that is, data loss from the slave database. Root Cause: "Because table_list-> table_id is uint and m_table_id is ulong, the table map

MySQL 5.6-innodb import Improvement Before MySQL 5.6, the idb file for importing a single innodb table must be aligned with the tablespace id. If the tablespace id is inconsistent, you need to increase the tablespace id by creating a new table in

Database paradigm explanation The design paradigm of databases is the specifications that need to be met by database design. databases that meet these specifications are concise and have clear structures. At the same time, there will be no insert or

Use Java Sources in Oracle The MD5 encryption usage in Oracle is not clear. The encryption results are different from the results in the program, so we have to move the methods in Java. STEP 1:Create or replace and compile java source named

What is the difference between decode and case when?Decode can only be equivalent, case when can be used for range, range can be used for condition differentiation, decode can do, and case when can also do; in terms of efficiency, I personally think

Oracle tablespace growth exception solution: Another example Description: The temporary tablespace of a database in the customer environment increases abnormally (with a random date). It may be caused by the scheduled jobs of the following two

An example of troubleshooting ORA-04030 errors The customer said that an error was found in the database background as follows: Errors in file/Oracle/bkjia/saptrace/diag/rdbms/bkjia/incident/incdir_183218/bkjia_j003_8103_i183218.trc:ORA-04030: out

Why does the SQL run very slowly when the COST is very small due to the misunderstanding of the execution plan ?, Execution Plan cost Reprinted please indicate the source: http://blog.csdn.net/guoyjoe/article/details/38321477   PM on March 31, My

One command one-click collection of oracle inspection information (including dbhc, awr reports), dbhcawr   The preliminary steps are as follows:   SQL> @ nb ------ Oracle Database health Check STRAT------ Starting Collect Data Information! ------

Transplantation of sqlcipher and sqlcipher I. Download Code Sqlcipher depends on the openssl library. First download openssl: [fulinux@ubuntu ~]$ git clone https://github.com/openssl/openssl.git Download sqlcipher: Site: Workshop [fulinux@ubuntu ~]

Websphere installation and Enterprise Application Deployment [application cases] And websphere Application Cases Example of Websphere installation and Enterprise Application Deployment Environment Name Version Linux CentOS-5

Atitit. atitit. hb many2one relate hibernate multi-to-one association configuration..., hibernate configuration file Atitit. atitit. hb many2one relate hibernate multi-to-one association configuration ..   1. Many-to-one @ ManyToOne 1 1. @

The restoration after the MySQL database is deleted. In the morning, I accidentally deleted a database I just created yesterday! Fortunately, the log feature is enabled in mysql. The following describes how to restore a deleted database: First, save

ORACLE uses with as and hint materialize to optimize SQL to solve low FILTER efficiency and hintmaterializeZookeeper During project creation, a page uses SQL statements similar to the following to query data, I replaced the table name and field in

SSRS Fields cannot be used in page headers or footers, ssrsfooters Problem Environment: SSRS 2005 report development   The following error occurs when you try to use the Data Set field in the Page Header:   The value expression for textbox