Database Administrator

(Direct file copy)I recently learned how to start Oracle databases, so I created a database for testing in Windows.After porting to Linux, we successfully transplanted Linux to Windows a few days ago. However, many problems may occur when porting

Sun Microsystems (NASDAQ: JAVA) released a new Sun system product for MySQL ), this is a set of solutions specifically designed to quickly change the economic effect of Web services, allowing enterprise customers to deploy basic MySQL-based Web

In WL_HOME/wl_server10.3/server/lib, find classes12.zip (jdbc driver of earlier versions) ojdbc. jar or ojdbc6.jar. View the META-INF/MANIFEST. MF in the package with the decompression tool $ More MANIFEST. MF Manifest-Version: 1.0

Multiple Oracle databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote database through the network, while the collaborative processing between servers It is

How to permanently delete an Oracle database to create a database with the same instance name and an oracle instance I chose the OMF method when creating the database today. The result file name is automatically named in Oracle. I cannot understand

Chapter 1 Securing Your Server and Network (6): configure the firewall for SQL Server access, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I

Slave slave test the importance of OLR in oracle 11g cluster Called an Oracle Local Registry (OLR): each node in a cluster has a local registry for node-specific resources Test 1: Simulate the loss of an olr exception: First, set the olr

During database operations, some data formats are irrelevant, that is, when it is non-relational, we will use non-relational databases, MongoDB is a distributed non-relational database written by C ++. Its Applications are mature, stable, and API

---- 1. Compile and install percona-xtrabackup Yum install cmake gcc-c ++ libaio-devel automake autoconf bzr \Bison libtool ncurses-devel zlib-devel libgcrypt-devel Wget

Oid is a hidden column of the system. Direct modification is not acceptable.Mysql = # update pg_class set oid = 99999 where oid = 73728;ERROR: cannot assign to system column "oid"LINE 1: update pg_class set oid = 99999 where oid = 73728; But we can

IntroductionThe data warehouse architecture is a branch of the IT architecture. As the core role of data in enterprises increases, the data warehouse architecture becomes increasingly important. The data warehouse architecture seems complicated

I. Constraints At the end of the previous article, I mentioned constraints, but I translated it into a qualifier, which is not very accurate. Here I should correct it first and translate it into constraints more appropriately. So what are

Oracle installation is a complex process. In Linux, AIX, and other operating system versions, the preparation process and time often exceed the installer and the database creation process. In addition, once a configuration item is incorrect,

My environment is like this: Win7 64-bit + Oracle 11g + PL/SQL 9.04 Since PL/SQL does not support 64-bit data at the moment, only Oracle client 32-bit data can be used, so you need to download it from the official website: Remember: you must

We all know that MySQL master-slave replication is transmitted in plain text, which is not allowed for some special businesses. Next we will try to build an SSL-based master-slave ReplicationEnvironment: RHEL5.8 SELinux disabled, iptables disabled,

Technical Architecture Design of the data warehouse system Author: Cheng Xiaoxu   Statement] Because the technical solutions described in this article are derived from online production systems, they will not provide complete and detailed technical

We recommend that you read and understand the following articles: ◆ Use a partition in a Microsoft SQL Server 2000 data warehouse-http://msdn.microsoft.com/library/default.asp? URL =/library/techart/PartitionsInDW.htm◆ SQL Server 2000 step by step

Over the past few years, many companies have streamlined their IT departments. Many database administrators (DBAs) have to manage a large amount of SQL Server databases. What's worse is that there is often no real DBA, but you can find someone to

Oracle online backup In Oracle, online backup requires database operations in ARCHIVELOG mode. In an online store, the database must be on 24x7. Therefore, it is impossible for users to back up the database offline without accessing the database.

INFORMIX databases are widely used relational databases. How to improve their application performance is a matter of concern. Especially with the increasing volume of data in databases and the increasing volume of transactions processed by