Database Administrator

1. SQL server 2000 database connection method:Copy codeThe Code is as follows:Connection con;Public Connection getCon (){Try {Class. forName ("com. microsoft. jdbc. sqlserver. SQLServerDriver"); // load the driverCon = DriverManger. getConnection

After successful oracle installation, a default password is omitted, such as the user's password validity period and locking policy ..., by default, the oracle user password is valid for 180 days. The maximum number of failed logon attempts is 10

First Installation Mysql Mysql1: Use Default Configuration Root @ localhost usr] # groupadd mysql [Root @ localhost usr] # useradd-g mysql [Root @ localhost usr] # cd/usr/local [Root @ localhost local] # tar-zxvf mysql-5.5.9.tar.gz [Root @

Error description: 13/09/12 17:59:00 ERROR security. userGroupInformation: PriviledgedActionException as: leo cause: java. io. IOException: Failed to set permissions of path: \ tmp \ hadoop-leo \ mapred \ staging \ leo480143202 \. staging to

Experimental Environment] platform centos6.4IP allocation 192.168.30.101 node1 mysql-proxy192.168.30.102 node2 mysql master node 192.168.30.103 node3 mysql slave Node 192.168.30.104 node4 client Note:1. mysql5.52 has been compiled and installed on

This installation of RAC is a little rough ..... Prerequisites for installing a RAC Add NIC: Connection Method host-only Configure the ip Address: Node1Eth0: 192.168.0.2Eth1: 192.168.1.3Vip: 192.168.0.10Node2Eth0: 192.168.0.3Eth1: 192.168.1.4Vip: 192

I. basic information and concepts 1. ASM is an ORACLE automatic storage management software. It uses bare devices and ASM disks. Before using the software, you need to secure the ASM library driver for the corresponding platform. 2. ASM combines

Today, the flush tables with read lock command was used to solve Database Synchronization exceptions, so I learned about the lock table by the way. 1. FLUSH TABLES WITH READ LOCK This command is global read lock. After the command is executed, all

(I) striping There are two ways to strip ASM: coarse and fine-gained. AU is the smallest space allocation unit. The default value is 1 M. Each AU is composed of eight K strip spaces by default. In coarse striping, a disk corresponds to an

Job functions:Database Engineer/Administrator Job description:Job description:1. Responsible for database-related design and development and database performance optimization based on product requirements2. Works with software developers

The binlog function is enabled for mysql in the home decoration. The advantage of enabling this function is that it facilitates data recovery in the future, but the disadvantage is that log files are growing rapidly and will soon occupy the disk

 Several common Mysql errors and solutions: 1. Problem: mysql DNS Reverse Solution: skip-name-resolve   The error log has a similar warning: Click (here) to fold or open 120119 16:26:04 [Warning] IP address '192. 168.1.10 'cocould not be

In the morning, I got a call from the lead in the elevator and said that the app couldn't get up. I ran up and checked the information and found that the application interface had always reported a wrong login database user and password. After

Common Data Mining MethodsBasic Concepts Data Mining is fromMassive, incomplete, noisy, and fuzzyThe process of extracting potentially useful information and knowledge hidden in the data that people do not know beforehand. Specifically, as a broad

What is Redis? Two sentences can be summarized as follows:1. It is a completely open-source and free key-value memory database.2. It is generally considered as a data structure server, mainly because it has a wide range of data structures, such as

The new 10g ASM production database is coming soon. The following is a simple Backup recovery test before the release:1. perform backup first $ Rman target/@ full_bak. SQL Recovery Manager: Release 10.1.0.3.0-64bit Production Copyright (c) 1995,200 4

Iii. segment fragmentation When a database object is generated, a table or an index is used. The tablespace is specified by the user's default value or specified value. A segment generated in a tablespace is used to store object-related data. Before

A common database task archives records from one table to another. If you want to delete unnecessary records from the original table to reduce the table size, but may refer to these records in the future, you can archive records instead of deleting

How can I clear the Sybase master database logs when they are full? You can manage the master database by using the following methods. If you do not have enough space, you can consider resizing the master database. 1. In simple cases, dump trans

SQL SERVER Memory will increase constantly When the SQL Server database engine is in Microsoft®Windows NT®Or Windows®2000 when running, its default memory management behavior is not to get a specific amount of memory, but to get as much memory as