Database Administrator

OriginBecause the customer requested to deploy mssql server 2008 on the application, and we were used to developing server programs in Linux, we had the need to connect mssql server 2008 with python in linux. This demand is very difficult. We have

Oracle EBS is relatively large and has many modules. The abbreviations and full names of some modules are listed here. ABM-Activity Based ManagementAD-Applications DBAAHL-Oracle Advanced Service OnlineAK-Oracle Common Modules-AKALR-Oracle

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, the collaborative processing between servers is completely

DB2 auto-increment column test1. To change a column in a table to auto-increment, run the following command:Alter table alter column set not nullAlter table alter column set generated always as identity (start with 1, increment by 1)The above

Developers need to log on to the function, so they do not want to use a large database and directly use java to connect to access. Everything works on your machine, and direct url Connection and data source configuration are fine. Released to

Author: Qing Dujun Address: http://blog.csdn.net/qingdujun/article/details/36425825 When SQL Server 2008 + VS2010 uses code written in C # To restore the database, an error occurs: Error message: A transmission error occurs when sending a request

SQL Server 2008 database primary key auto-increment insert display value When you delete the table data in the database a few days ago at work, after the deletion, the newly added data does not get the id value of the original data (the table id is

Environment Settings...First, check your physical memory size. We recommend that you increase the memory size by 1 GB.# Grep MemTotal/proc/meminfo Check whether your swap partition size meets the requirements. Generally, it is twice the physical

Oracle Database Backup is encrypted. Encryption can protect Backup files and prevent backup data leakage.Oracle backup encryption mainly refers to RMAN encryption, and EXP/EXPDP encryption is not available. RMAN encryption mainly includes the

Preface:The earthdistance () function in postgreSQL is used in the project to calculate the distance between two points on the earth. There is too little Chinese information. I found a good English article, hope to help those who will use

Note: This is a new host that has not yet been created. If the database already exists, you need to perform the database refreshing operation! Environment: SUSE Linux Enterprise Server 11 sp1 (x86_64) Upgrade the Oracle database from 11.2.0.3.0 to 11

Local name configuration: The local name can access the required database or server information with a simple name, and the information is saved to tnsnames. ora. LOCALNAME: local nameADDRESS: server ADDRESSPROTOCOL: PROTOCOL usedHOST: IP

The AWR report in Oracle is currently the best performance analysis and diagnosis tool officially provided. With the help of a continuous snapshot analysis, we can quickly obtain the overall performance analysis indicators and locate the problem

1. Environment Requirement Description: The user has an oracle 10g Database on the Intranet and an oracle 9i database on the Internet. The user publishes information about talent recruitment through the Intranet. All information is stored in one

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,

This article will introduce the installation process of Oracle Database 9i in Open Unix 8. If you have experience installing Oracle, you can use the quick installation manual. If you have never installed Oracle databases before, from this article,

BKJIA: the majority of databases are composed of two completely different parts: the place where data is stored at the backend) and a user interface for connecting data components at the front end ). This architecture separates the user interface

Before recovery: 1. full closed backup Do not use shutdown abort to forcibly shut down the shutdown database), implement a file-level backup, back up all Oracle related files, including Windows system files, system status and Oracle program files

Charts, numbers, and graphs help you quickly understand and analyze large datasets. As the saying goes, "Never heard of anyone", because images can convey important summary and comparison information about data that is difficult to obtain from text